== Parsed Logical Plan ==
Aggregate [count(1) AS count#75282L]
+- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#75166 AS COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#75172, COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#75167 AS COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#75173, COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#75168 AS COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#75174]
+- Filter isnotnull(COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#75168)
+- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#75160 AS COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#75166, COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#75161 AS COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#75167, COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#75162 AS COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#75168]
+- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#74843 AS COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#75160, COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#74949 AS COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#75161, COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#75053 AS COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#75162]
+- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#74843, COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#74949, col1#74945 AS COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#75053]
+- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#74843, col0#74944 AS COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#74949, col1#74945]
+- Project [COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#74543 AS COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#74843, col0#74944, col1#74945]
+- Generate stack(99, CMA1, COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#74544, CMA2, COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#74545, CMA3, COL_D1545230_AFDA_433F_954A_31EAAAD2A879#74546, CMA4, COL_DED65925_A059_456C_A467_6829CE5FC9F7#74547, CMA5, COL_2A8C00CF_80EC_49CE_8290_724207B64D34#74548, CMA6, COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#74549, CMA7, COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#74550, CMA8, COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#74551, CMA9, COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#74552, CMA10, COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#74553, CMA11, COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#74554, CMA12, ... 175 more fields), false, [col0#74944, col1#74945]
+- Project [COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#74143 AS COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#74543, COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#74144 AS COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#74544, COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#74145 AS COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#74545, COL_D1545230_AFDA_433F_954A_31EAAAD2A879#74146 AS COL_D1545230_AFDA_433F_954A_31EAAAD2A879#74546, COL_DED65925_A059_456C_A467_6829CE5FC9F7#74147 AS COL_DED65925_A059_456C_A467_6829CE5FC9F7#74547, COL_2A8C00CF_80EC_49CE_8290_724207B64D34#74148 AS COL_2A8C00CF_80EC_49CE_8290_724207B64D34#74548, COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#74149 AS COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#74549, COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#74150 AS COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#74550, COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#74151 AS COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#74551, COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#74152 AS COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#74552, COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#74153 AS COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#74553, COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#74154 AS COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#74554, COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#74155 AS COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#74555, COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#74156 AS COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#74556, COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#74157 AS COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#74557, COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#74158 AS COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#74558, COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#74159 AS COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#74559, COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#74160 AS COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#74560, COL_F4438D2A_C49B_49CF_8688_30C936AD9492#74161 AS COL_F4438D2A_C49B_49CF_8688_30C936AD9492#74561, COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#74162 AS COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#74562, COL_6A9162EB_9974_4518_8A3D_64591B01F18A#74163 AS COL_6A9162EB_9974_4518_8A3D_64591B01F18A#74563, COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#74164 AS COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#74564, COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#74165 AS COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#74565, COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#74166 AS COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#74566, ... 76 more fields]
+- Project [cast(UCD_141967__CODE_UCD#73642 as string) AS COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#74143, cast(UCD_141967__CMA1#73543 as string) AS COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#74144, cast(UCD_141967__CMA2#73554 as string) AS COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#74145, cast(UCD_141967__CMA3#73565 as string) AS COL_D1545230_AFDA_433F_954A_31EAAAD2A879#74146, cast(UCD_141967__CMA4#73576 as string) AS COL_DED65925_A059_456C_A467_6829CE5FC9F7#74147, cast(UCD_141967__CMA5#73587 as string) AS COL_2A8C00CF_80EC_49CE_8290_724207B64D34#74148, cast(UCD_141967__CMA6#73598 as string) AS COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#74149, cast(UCD_141967__CMA7#73609 as string) AS COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#74150, cast(UCD_141967__CMA8#73620 as string) AS COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#74151, cast(UCD_141967__CMA9#73631 as string) AS COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#74152, cast(UCD_141967__CMA10#73544 as string) AS COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#74153, cast(UCD_141967__CMA11#73545 as string) AS COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#74154, cast(UCD_141967__CMA12#73546 as string) AS COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#74155, cast(UCD_141967__CMA13#73547 as string) AS COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#74156, cast(UCD_141967__CMA14#73548 as string) AS COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#74157, cast(UCD_141967__CMA15#73549 as string) AS COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#74158, cast(UCD_141967__CMA16#73550 as string) AS COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#74159, cast(UCD_141967__CMA17#73551 as string) AS COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#74160, cast(UCD_141967__CMA18#73552 as string) AS COL_F4438D2A_C49B_49CF_8688_30C936AD9492#74161, cast(UCD_141967__CMA19#73553 as string) AS COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#74162, cast(UCD_141967__CMA20#73555 as string) AS COL_6A9162EB_9974_4518_8A3D_64591B01F18A#74163, cast(UCD_141967__CMA21#73556 as string) AS COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#74164, cast(UCD_141967__CMA22#73557 as string) AS COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#74165, cast(UCD_141967__CMA23#73558 as string) AS COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#74166, ... 76 more fields]
+- Project [_CMA1#72943 AS UCD_141967__CMA1#73543, _CMA10#72944 AS UCD_141967__CMA10#73544, _CMA11#72945 AS UCD_141967__CMA11#73545, _CMA12#72946 AS UCD_141967__CMA12#73546, _CMA13#72947 AS UCD_141967__CMA13#73547, _CMA14#72948 AS UCD_141967__CMA14#73548, _CMA15#72949 AS UCD_141967__CMA15#73549, _CMA16#72950 AS UCD_141967__CMA16#73550, _CMA17#72951 AS UCD_141967__CMA17#73551, _CMA18#72952 AS UCD_141967__CMA18#73552, _CMA19#72953 AS UCD_141967__CMA19#73553, _CMA2#72954 AS UCD_141967__CMA2#73554, _CMA20#72955 AS UCD_141967__CMA20#73555, _CMA21#72956 AS UCD_141967__CMA21#73556, _CMA22#72957 AS UCD_141967__CMA22#73557, _CMA23#72958 AS UCD_141967__CMA23#73558, _CMA24#72959 AS UCD_141967__CMA24#73559, _CMA25#72960 AS UCD_141967__CMA25#73560, _CMA26#72961 AS UCD_141967__CMA26#73561, _CMA27#72962 AS UCD_141967__CMA27#73562, _CMA28#72963 AS UCD_141967__CMA28#73563, _CMA29#72964 AS UCD_141967__CMA29#73564, _CMA3#72965 AS UCD_141967__CMA3#73565, _CMA30#72966 AS UCD_141967__CMA30#73566, ... 76 more fields]
+- SubqueryAlias UCD_141967118
+- Project [_CMA1#72943, _CMA10#72944, _CMA11#72945, _CMA12#72946, _CMA13#72947, _CMA14#72948, _CMA15#72949, _CMA16#72950, _CMA17#72951, _CMA18#72952, _CMA19#72953, _CMA2#72954, _CMA20#72955, _CMA21#72956, _CMA22#72957, _CMA23#72958, _CMA24#72959, _CMA25#72960, _CMA26#72961, _CMA27#72962, _CMA28#72963, _CMA29#72964, _CMA3#72965, _CMA30#72966, ... 76 more fields]
+- Project [CMA1#72644 AS _CMA1#72943, CMA10#72653 AS _CMA10#72944, CMA11#72654 AS _CMA11#72945, CMA12#72655 AS _CMA12#72946, CMA13#72656 AS _CMA13#72947, CMA14#72657 AS _CMA14#72948, CMA15#72658 AS _CMA15#72949, CMA16#72659 AS _CMA16#72950, CMA17#72660 AS _CMA17#72951, CMA18#72661 AS _CMA18#72952, CMA19#72662 AS _CMA19#72953, CMA2#72645 AS _CMA2#72954, CMA20#72663 AS _CMA20#72955, CMA21#72664 AS _CMA21#72956, CMA22#72665 AS _CMA22#72957, CMA23#72666 AS _CMA23#72958, CMA24#72667 AS _CMA24#72959, CMA25#72668 AS _CMA25#72960, CMA26#72669 AS _CMA26#72961, CMA27#72670 AS _CMA27#72962, CMA28#72671 AS _CMA28#72963, CMA29#72672 AS _CMA29#72964, CMA3#72646 AS _CMA3#72965, CMA30#72673 AS _CMA30#72966, ... 76 more fields]
+- Project [CODE_UCD#72643, CMA1#72644, CMA2#72645, CMA3#72646, CMA4#72647, CMA5#72648, CMA6#72649, CMA7#72650, CMA8#72651, CMA9#72652, CMA10#72653, CMA11#72654, CMA12#72655, CMA13#72656, CMA14#72657, CMA15#72658, CMA16#72659, CMA17#72660, CMA18#72661, CMA19#72662, CMA20#72663, CMA21#72664, CMA22#72665, CMA23#72666, ... 76 more fields]
+- Project [CODE_UCD#72343 AS CODE_UCD#72643, CMA1#72344 AS CMA1#72644, CMA2#72345 AS CMA2#72645, CMA3#72346 AS CMA3#72646, CMA4#72347 AS CMA4#72647, CMA5#72348 AS CMA5#72648, CMA6#72349 AS CMA6#72649, CMA7#72350 AS CMA7#72650, CMA8#72351 AS CMA8#72651, CMA9#72352 AS CMA9#72652, CMA10#72353 AS CMA10#72653, CMA11#72354 AS CMA11#72654, CMA12#72355 AS CMA12#72655, CMA13#72356 AS CMA13#72656, CMA14#72357 AS CMA14#72657, CMA15#72358 AS CMA15#72658, CMA16#72359 AS CMA16#72659, CMA17#72360 AS CMA17#72660, CMA18#72361 AS CMA18#72661, CMA19#72362 AS CMA19#72662, CMA20#72363 AS CMA20#72663, CMA21#72364 AS CMA21#72664, CMA22#72365 AS CMA22#72665, CMA23#72366 AS CMA23#72666, ... 76 more fields]
+- Relation[CODE_UCD#72343,CMA1#72344,CMA2#72345,CMA3#72346,CMA4#72347,CMA5#72348,CMA6#72349,CMA7#72350,CMA8#72351,CMA9#72352,CMA10#72353,CMA11#72354,CMA12#72355,CMA13#72356,CMA14#72357,CMA15#72358,CMA16#72359,CMA17#72360,CMA18#72361,CMA19#72362,CMA20#72363,CMA21#72364,CMA22#72365,CMA23#72366,... 76 more fields] parquet
== Analyzed Logical Plan ==
count: bigint
Aggregate [count(1) AS count#75282L]
+- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#75166 AS COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#75172, COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#75167 AS COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#75173, COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#75168 AS COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#75174]
+- Filter isnotnull(COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#75168)
+- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#75160 AS COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#75166, COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#75161 AS COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#75167, COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#75162 AS COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#75168]
+- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#74843 AS COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#75160, COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#74949 AS COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#75161, COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#75053 AS COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#75162]
+- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#74843, COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#74949, col1#74945 AS COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#75053]
+- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#74843, col0#74944 AS COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#74949, col1#74945]
+- Project [COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#74543 AS COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#74843, col0#74944, col1#74945]
+- Generate stack(99, CMA1, COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#74544, CMA2, COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#74545, CMA3, COL_D1545230_AFDA_433F_954A_31EAAAD2A879#74546, CMA4, COL_DED65925_A059_456C_A467_6829CE5FC9F7#74547, CMA5, COL_2A8C00CF_80EC_49CE_8290_724207B64D34#74548, CMA6, COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#74549, CMA7, COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#74550, CMA8, COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#74551, CMA9, COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#74552, CMA10, COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#74553, CMA11, COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#74554, CMA12, ... 175 more fields), false, [col0#74944, col1#74945]
+- Project [COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#74143 AS COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#74543, COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#74144 AS COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#74544, COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#74145 AS COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#74545, COL_D1545230_AFDA_433F_954A_31EAAAD2A879#74146 AS COL_D1545230_AFDA_433F_954A_31EAAAD2A879#74546, COL_DED65925_A059_456C_A467_6829CE5FC9F7#74147 AS COL_DED65925_A059_456C_A467_6829CE5FC9F7#74547, COL_2A8C00CF_80EC_49CE_8290_724207B64D34#74148 AS COL_2A8C00CF_80EC_49CE_8290_724207B64D34#74548, COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#74149 AS COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#74549, COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#74150 AS COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#74550, COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#74151 AS COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#74551, COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#74152 AS COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#74552, COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#74153 AS COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#74553, COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#74154 AS COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#74554, COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#74155 AS COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#74555, COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#74156 AS COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#74556, COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#74157 AS COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#74557, COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#74158 AS COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#74558, COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#74159 AS COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#74559, COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#74160 AS COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#74560, COL_F4438D2A_C49B_49CF_8688_30C936AD9492#74161 AS COL_F4438D2A_C49B_49CF_8688_30C936AD9492#74561, COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#74162 AS COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#74562, COL_6A9162EB_9974_4518_8A3D_64591B01F18A#74163 AS COL_6A9162EB_9974_4518_8A3D_64591B01F18A#74563, COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#74164 AS COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#74564, COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#74165 AS COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#74565, COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#74166 AS COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#74566, ... 76 more fields]
+- Project [cast(UCD_141967__CODE_UCD#73642 as string) AS COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#74143, cast(UCD_141967__CMA1#73543 as string) AS COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#74144, cast(UCD_141967__CMA2#73554 as string) AS COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#74145, cast(UCD_141967__CMA3#73565 as string) AS COL_D1545230_AFDA_433F_954A_31EAAAD2A879#74146, cast(UCD_141967__CMA4#73576 as string) AS COL_DED65925_A059_456C_A467_6829CE5FC9F7#74147, cast(UCD_141967__CMA5#73587 as string) AS COL_2A8C00CF_80EC_49CE_8290_724207B64D34#74148, cast(UCD_141967__CMA6#73598 as string) AS COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#74149, cast(UCD_141967__CMA7#73609 as string) AS COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#74150, cast(UCD_141967__CMA8#73620 as string) AS COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#74151, cast(UCD_141967__CMA9#73631 as string) AS COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#74152, cast(UCD_141967__CMA10#73544 as string) AS COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#74153, cast(UCD_141967__CMA11#73545 as string) AS COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#74154, cast(UCD_141967__CMA12#73546 as string) AS COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#74155, cast(UCD_141967__CMA13#73547 as string) AS COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#74156, cast(UCD_141967__CMA14#73548 as string) AS COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#74157, cast(UCD_141967__CMA15#73549 as string) AS COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#74158, cast(UCD_141967__CMA16#73550 as string) AS COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#74159, cast(UCD_141967__CMA17#73551 as string) AS COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#74160, cast(UCD_141967__CMA18#73552 as string) AS COL_F4438D2A_C49B_49CF_8688_30C936AD9492#74161, cast(UCD_141967__CMA19#73553 as string) AS COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#74162, cast(UCD_141967__CMA20#73555 as string) AS COL_6A9162EB_9974_4518_8A3D_64591B01F18A#74163, cast(UCD_141967__CMA21#73556 as string) AS COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#74164, cast(UCD_141967__CMA22#73557 as string) AS COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#74165, cast(UCD_141967__CMA23#73558 as string) AS COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#74166, ... 76 more fields]
+- Project [_CMA1#72943 AS UCD_141967__CMA1#73543, _CMA10#72944 AS UCD_141967__CMA10#73544, _CMA11#72945 AS UCD_141967__CMA11#73545, _CMA12#72946 AS UCD_141967__CMA12#73546, _CMA13#72947 AS UCD_141967__CMA13#73547, _CMA14#72948 AS UCD_141967__CMA14#73548, _CMA15#72949 AS UCD_141967__CMA15#73549, _CMA16#72950 AS UCD_141967__CMA16#73550, _CMA17#72951 AS UCD_141967__CMA17#73551, _CMA18#72952 AS UCD_141967__CMA18#73552, _CMA19#72953 AS UCD_141967__CMA19#73553, _CMA2#72954 AS UCD_141967__CMA2#73554, _CMA20#72955 AS UCD_141967__CMA20#73555, _CMA21#72956 AS UCD_141967__CMA21#73556, _CMA22#72957 AS UCD_141967__CMA22#73557, _CMA23#72958 AS UCD_141967__CMA23#73558, _CMA24#72959 AS UCD_141967__CMA24#73559, _CMA25#72960 AS UCD_141967__CMA25#73560, _CMA26#72961 AS UCD_141967__CMA26#73561, _CMA27#72962 AS UCD_141967__CMA27#73562, _CMA28#72963 AS UCD_141967__CMA28#73563, _CMA29#72964 AS UCD_141967__CMA29#73564, _CMA3#72965 AS UCD_141967__CMA3#73565, _CMA30#72966 AS UCD_141967__CMA30#73566, ... 76 more fields]
+- SubqueryAlias UCD_141967118
+- Project [_CMA1#72943, _CMA10#72944, _CMA11#72945, _CMA12#72946, _CMA13#72947, _CMA14#72948, _CMA15#72949, _CMA16#72950, _CMA17#72951, _CMA18#72952, _CMA19#72953, _CMA2#72954, _CMA20#72955, _CMA21#72956, _CMA22#72957, _CMA23#72958, _CMA24#72959, _CMA25#72960, _CMA26#72961, _CMA27#72962, _CMA28#72963, _CMA29#72964, _CMA3#72965, _CMA30#72966, ... 76 more fields]
+- Project [CMA1#72644 AS _CMA1#72943, CMA10#72653 AS _CMA10#72944, CMA11#72654 AS _CMA11#72945, CMA12#72655 AS _CMA12#72946, CMA13#72656 AS _CMA13#72947, CMA14#72657 AS _CMA14#72948, CMA15#72658 AS _CMA15#72949, CMA16#72659 AS _CMA16#72950, CMA17#72660 AS _CMA17#72951, CMA18#72661 AS _CMA18#72952, CMA19#72662 AS _CMA19#72953, CMA2#72645 AS _CMA2#72954, CMA20#72663 AS _CMA20#72955, CMA21#72664 AS _CMA21#72956, CMA22#72665 AS _CMA22#72957, CMA23#72666 AS _CMA23#72958, CMA24#72667 AS _CMA24#72959, CMA25#72668 AS _CMA25#72960, CMA26#72669 AS _CMA26#72961, CMA27#72670 AS _CMA27#72962, CMA28#72671 AS _CMA28#72963, CMA29#72672 AS _CMA29#72964, CMA3#72646 AS _CMA3#72965, CMA30#72673 AS _CMA30#72966, ... 76 more fields]
+- Project [CODE_UCD#72643, CMA1#72644, CMA2#72645, CMA3#72646, CMA4#72647, CMA5#72648, CMA6#72649, CMA7#72650, CMA8#72651, CMA9#72652, CMA10#72653, CMA11#72654, CMA12#72655, CMA13#72656, CMA14#72657, CMA15#72658, CMA16#72659, CMA17#72660, CMA18#72661, CMA19#72662, CMA20#72663, CMA21#72664, CMA22#72665, CMA23#72666, ... 76 more fields]
+- Project [CODE_UCD#72343 AS CODE_UCD#72643, CMA1#72344 AS CMA1#72644, CMA2#72345 AS CMA2#72645, CMA3#72346 AS CMA3#72646, CMA4#72347 AS CMA4#72647, CMA5#72348 AS CMA5#72648, CMA6#72349 AS CMA6#72649, CMA7#72350 AS CMA7#72650, CMA8#72351 AS CMA8#72651, CMA9#72352 AS CMA9#72652, CMA10#72353 AS CMA10#72653, CMA11#72354 AS CMA11#72654, CMA12#72355 AS CMA12#72655, CMA13#72356 AS CMA13#72656, CMA14#72357 AS CMA14#72657, CMA15#72358 AS CMA15#72658, CMA16#72359 AS CMA16#72659, CMA17#72360 AS CMA17#72660, CMA18#72361 AS CMA18#72661, CMA19#72362 AS CMA19#72662, CMA20#72363 AS CMA20#72663, CMA21#72364 AS CMA21#72664, CMA22#72365 AS CMA22#72665, CMA23#72366 AS CMA23#72666, ... 76 more fields]
+- Relation[CODE_UCD#72343,CMA1#72344,CMA2#72345,CMA3#72346,CMA4#72347,CMA5#72348,CMA6#72349,CMA7#72350,CMA8#72351,CMA9#72352,CMA10#72353,CMA11#72354,CMA12#72355,CMA13#72356,CMA14#72357,CMA15#72358,CMA16#72359,CMA17#72360,CMA18#72361,CMA19#72362,CMA20#72363,CMA21#72364,CMA22#72365,CMA23#72366,... 76 more fields] parquet
== Optimized Logical Plan ==
Aggregate [count(1) AS count#75282L]
+- Project
+- Filter isnotnull(col1#74945)
+- Generate stack(99, CMA1, COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#74544, CMA2, COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#74545, CMA3, COL_D1545230_AFDA_433F_954A_31EAAAD2A879#74546, CMA4, COL_DED65925_A059_456C_A467_6829CE5FC9F7#74547, CMA5, COL_2A8C00CF_80EC_49CE_8290_724207B64D34#74548, CMA6, COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#74549, CMA7, COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#74550, CMA8, COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#74551, CMA9, COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#74552, CMA10, COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#74553, CMA11, COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#74554, CMA12, ... 175 more fields), [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, ... 75 more fields], false, [col0#74944, col1#74945]
+- Project [CMA1#72344 AS COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#74544, CMA2#72345 AS COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#74545, CMA3#72346 AS COL_D1545230_AFDA_433F_954A_31EAAAD2A879#74546, CMA4#72347 AS COL_DED65925_A059_456C_A467_6829CE5FC9F7#74547, CMA5#72348 AS COL_2A8C00CF_80EC_49CE_8290_724207B64D34#74548, CMA6#72349 AS COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#74549, CMA7#72350 AS COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#74550, CMA8#72351 AS COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#74551, CMA9#72352 AS COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#74552, CMA10#72353 AS COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#74553, CMA11#72354 AS COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#74554, CMA12#72355 AS COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#74555, CMA13#72356 AS COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#74556, CMA14#72357 AS COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#74557, CMA15#72358 AS COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#74558, CMA16#72359 AS COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#74559, CMA17#72360 AS COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#74560, CMA18#72361 AS COL_F4438D2A_C49B_49CF_8688_30C936AD9492#74561, CMA19#72362 AS COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#74562, CMA20#72363 AS COL_6A9162EB_9974_4518_8A3D_64591B01F18A#74563, CMA21#72364 AS COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#74564, CMA22#72365 AS COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#74565, CMA23#72366 AS COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#74566, CMA24#72367 AS COL_54478F51_46AA_4AF8_8838_D4A60ACEFA22#74567, ... 75 more fields]
+- Relation[CODE_UCD#72343,CMA1#72344,CMA2#72345,CMA3#72346,CMA4#72347,CMA5#72348,CMA6#72349,CMA7#72350,CMA8#72351,CMA9#72352,CMA10#72353,CMA11#72354,CMA12#72355,CMA13#72356,CMA14#72357,CMA15#72358,CMA16#72359,CMA17#72360,CMA18#72361,CMA19#72362,CMA20#72363,CMA21#72364,CMA22#72365,CMA23#72366,... 76 more fields] parquet
== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- *(3) HashAggregate(keys=[], functions=[count(1)], output=[count#75282L])
+- ShuffleQueryStage 0
+- Exchange SinglePartition, true, [id=#10165]
+- *(2) HashAggregate(keys=[], functions=[partial_count(1)], output=[count#75811L])
+- *(2) Project
+- *(2) Filter isnotnull(col1#74945)
+- Generate stack(99, CMA1, COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#74544, CMA2, COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#74545, CMA3, COL_D1545230_AFDA_433F_954A_31EAAAD2A879#74546, CMA4, COL_DED65925_A059_456C_A467_6829CE5FC9F7#74547, CMA5, COL_2A8C00CF_80EC_49CE_8290_724207B64D34#74548, CMA6, COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#74549, CMA7, COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#74550, CMA8, COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#74551, CMA9, COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#74552, CMA10, COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#74553, CMA11, COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#74554, CMA12, ... 175 more fields), false, [col0#74944, col1#74945]
+- *(1) Project [CMA1#72344 AS COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#74544, CMA2#72345 AS COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#74545, CMA3#72346 AS COL_D1545230_AFDA_433F_954A_31EAAAD2A879#74546, CMA4#72347 AS COL_DED65925_A059_456C_A467_6829CE5FC9F7#74547, CMA5#72348 AS COL_2A8C00CF_80EC_49CE_8290_724207B64D34#74548, CMA6#72349 AS COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#74549, CMA7#72350 AS COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#74550, CMA8#72351 AS COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#74551, CMA9#72352 AS COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#74552, CMA10#72353 AS COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#74553, CMA11#72354 AS COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#74554, CMA12#72355 AS COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#74555, CMA13#72356 AS COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#74556, CMA14#72357 AS COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#74557, CMA15#72358 AS COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#74558, CMA16#72359 AS COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#74559, CMA17#72360 AS COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#74560, CMA18#72361 AS COL_F4438D2A_C49B_49CF_8688_30C936AD9492#74561, CMA19#72362 AS COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#74562, CMA20#72363 AS COL_6A9162EB_9974_4518_8A3D_64591B01F18A#74563, CMA21#72364 AS COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#74564, CMA22#72365 AS COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#74565, CMA23#72366 AS COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#74566, CMA24#72367 AS COL_54478F51_46AA_4AF8_8838_D4A60ACEFA22#74567, ... 75 more fields]
+- *(1) ColumnarToRow
+- FileScan parquet [CMA1#72344,CMA2#72345,CMA3#72346,CMA4#72347,CMA5#72348,CMA6#72349,CMA7#72350,CMA8#72351,CMA9#72352,CMA10#72353,CMA11#72354,CMA12#72355,CMA13#72356,CMA14#72357,CMA15#72358,CMA16#72359,CMA17#72360,CMA18#72361,CMA19#72362,CMA20#72363,CMA21#72364,CMA22#72365,CMA23#72366,CMA24#72367,... 75 more fields] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex[file:/data/input/depot/parquet/execution/FE8E7224_C2D1_4FC2_8E01_55A9110B067E/c..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<CMA1:string,CMA2:string,CMA3:string,CMA4:string,CMA5:string,CMA6:string,CMA7:string,CMA8:s...