DC2 - Details for Query 189

Details for Query 189

Submitted Time: 2025/11/17 10:02:31
Duration: 71 ms
Succeeded Jobs: 291

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" CollectLimit "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 0 ms"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label="Filter number of output rows: 1,500"]; } 4 [labelType="html" label="Generate number of output rows: 8,326"]; subgraph cluster5 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 0 ms"; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="ColumnarToRow number of output rows: 4,096 number of input batches: 1"]; } 8 [labelType="html" label="Scan parquet number of files read: 1 scan time: 11 ms metadata time: 0 ms size of files read: 509.3 KiB number of output rows: 4,096"]; 2->0; 3->2; 4->3; 6->4; 7->6; 8->7; }

CollectLimit 1500

Project [COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#79263 AS COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#79492, col1#79465 AS COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#79493]

Filter isnotnull(col1#79465)

WholeStageCodegen (2)

Generate stack(99, CMA1, COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#79264, CMA2, COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#79265, CMA3, COL_D1545230_AFDA_433F_954A_31EAAAD2A879#79266, CMA4, COL_DED65925_A059_456C_A467_6829CE5FC9F7#79267, CMA5, COL_2A8C00CF_80EC_49CE_8290_724207B64D34#79268, CMA6, COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#79269, CMA7, COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#79270, CMA8, COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#79271, CMA9, COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#79272, CMA10, COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#79273, CMA11, COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#79274, CMA12, ... 175 more fields), [COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#79263], false, [col0#79464, col1#79465]

Project [CODE_UCD#76825 AS COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#79263, CMA1#76826 AS COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#79264, CMA2#76827 AS COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#79265, CMA3#76828 AS COL_D1545230_AFDA_433F_954A_31EAAAD2A879#79266, CMA4#76829 AS COL_DED65925_A059_456C_A467_6829CE5FC9F7#79267, CMA5#76830 AS COL_2A8C00CF_80EC_49CE_8290_724207B64D34#79268, CMA6#76831 AS COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#79269, CMA7#76832 AS COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#79270, CMA8#76833 AS COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#79271, CMA9#76834 AS COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#79272, CMA10#76835 AS COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#79273, CMA11#76836 AS COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#79274, CMA12#76837 AS COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#79275, CMA13#76838 AS COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#79276, CMA14#76839 AS COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#79277, CMA15#76840 AS COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#79278, CMA16#76841 AS COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#79279, CMA17#76842 AS COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#79280, CMA18#76843 AS COL_F4438D2A_C49B_49CF_8688_30C936AD9492#79281, CMA19#76844 AS COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#79282, CMA20#76845 AS COL_6A9162EB_9974_4518_8A3D_64591B01F18A#79283, CMA21#76846 AS COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#79284, CMA22#76847 AS COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#79285, CMA23#76848 AS COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#79286, ... 76 more fields]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [CODE_UCD#76825,CMA1#76826,CMA2#76827,CMA3#76828,CMA4#76829,CMA5#76830,CMA6#76831,CMA7#76832,CMA8#76833,CMA9#76834,CMA10#76835,CMA11#76836,CMA12#76837,CMA13#76838,CMA14#76839,CMA15#76840,CMA16#76841,CMA17#76842,CMA18#76843,CMA19#76844,CMA20#76845,CMA21#76846,CMA22#76847,CMA23#76848,... 76 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<CODE_UCD:string,CMA1:string,CMA2:string,CMA3:string,CMA4:string,CMA5:string,CMA6:string,CM...

Details

== Parsed Logical Plan ==
GlobalLimit 1500
+- LocalLimit 1500
   +- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#79486 AS COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#79492, COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#79488 AS COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#79493]
      +- Filter isnotnull(COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#79488)
         +- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#79480 AS COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#79486, COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#79481 AS COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#79487, COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#79482 AS COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#79488]
            +- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#79463 AS COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#79480, COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#79469 AS COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#79481, COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#79473 AS COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#79482]
               +- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#79463, COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#79469, col1#79465 AS COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#79473]
                  +- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#79463, col0#79464 AS COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#79469, col1#79465]
                     +- Project [COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#79263 AS COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#79463, col0#79464, col1#79465]
                        +- Generate stack(99, CMA1, COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#79264, CMA2, COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#79265, CMA3, COL_D1545230_AFDA_433F_954A_31EAAAD2A879#79266, CMA4, COL_DED65925_A059_456C_A467_6829CE5FC9F7#79267, CMA5, COL_2A8C00CF_80EC_49CE_8290_724207B64D34#79268, CMA6, COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#79269, CMA7, COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#79270, CMA8, COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#79271, CMA9, COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#79272, CMA10, COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#79273, CMA11, COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#79274, CMA12, ... 175 more fields), false, [col0#79464, col1#79465]
                           +- Project [COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#79032 AS COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#79263, COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#79033 AS COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#79264, COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#79034 AS COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#79265, COL_D1545230_AFDA_433F_954A_31EAAAD2A879#79035 AS COL_D1545230_AFDA_433F_954A_31EAAAD2A879#79266, COL_DED65925_A059_456C_A467_6829CE5FC9F7#79036 AS COL_DED65925_A059_456C_A467_6829CE5FC9F7#79267, COL_2A8C00CF_80EC_49CE_8290_724207B64D34#79037 AS COL_2A8C00CF_80EC_49CE_8290_724207B64D34#79268, COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#79038 AS COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#79269, COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#79039 AS COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#79270, COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#79040 AS COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#79271, COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#79041 AS COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#79272, COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#79042 AS COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#79273, COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#79043 AS COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#79274, COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#79044 AS COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#79275, COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#79045 AS COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#79276, COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#79046 AS COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#79277, COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#79047 AS COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#79278, COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#79048 AS COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#79279, COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#79049 AS COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#79280, COL_F4438D2A_C49B_49CF_8688_30C936AD9492#79050 AS COL_F4438D2A_C49B_49CF_8688_30C936AD9492#79281, COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#79051 AS COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#79282, COL_6A9162EB_9974_4518_8A3D_64591B01F18A#79052 AS COL_6A9162EB_9974_4518_8A3D_64591B01F18A#79283, COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#79053 AS COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#79284, COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#79054 AS COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#79285, COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#79055 AS COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#79286, ... 76 more fields]
                              +- Project [cast(UCD_141967__CODE_UCD#78724 as string) AS COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#79032, cast(UCD_141967__CMA1#78625 as string) AS COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#79033, cast(UCD_141967__CMA2#78636 as string) AS COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#79034, cast(UCD_141967__CMA3#78647 as string) AS COL_D1545230_AFDA_433F_954A_31EAAAD2A879#79035, cast(UCD_141967__CMA4#78658 as string) AS COL_DED65925_A059_456C_A467_6829CE5FC9F7#79036, cast(UCD_141967__CMA5#78669 as string) AS COL_2A8C00CF_80EC_49CE_8290_724207B64D34#79037, cast(UCD_141967__CMA6#78680 as string) AS COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#79038, cast(UCD_141967__CMA7#78691 as string) AS COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#79039, cast(UCD_141967__CMA8#78702 as string) AS COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#79040, cast(UCD_141967__CMA9#78713 as string) AS COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#79041, cast(UCD_141967__CMA10#78626 as string) AS COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#79042, cast(UCD_141967__CMA11#78627 as string) AS COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#79043, cast(UCD_141967__CMA12#78628 as string) AS COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#79044, cast(UCD_141967__CMA13#78629 as string) AS COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#79045, cast(UCD_141967__CMA14#78630 as string) AS COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#79046, cast(UCD_141967__CMA15#78631 as string) AS COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#79047, cast(UCD_141967__CMA16#78632 as string) AS COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#79048, cast(UCD_141967__CMA17#78633 as string) AS COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#79049, cast(UCD_141967__CMA18#78634 as string) AS COL_F4438D2A_C49B_49CF_8688_30C936AD9492#79050, cast(UCD_141967__CMA19#78635 as string) AS COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#79051, cast(UCD_141967__CMA20#78637 as string) AS COL_6A9162EB_9974_4518_8A3D_64591B01F18A#79052, cast(UCD_141967__CMA21#78638 as string) AS COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#79053, cast(UCD_141967__CMA22#78639 as string) AS COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#79054, cast(UCD_141967__CMA23#78640 as string) AS COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#79055, ... 76 more fields]
                                 +- Project [_CMA1#77725 AS UCD_141967__CMA1#78625, _CMA10#77726 AS UCD_141967__CMA10#78626, _CMA11#77727 AS UCD_141967__CMA11#78627, _CMA12#77728 AS UCD_141967__CMA12#78628, _CMA13#77729 AS UCD_141967__CMA13#78629, _CMA14#77730 AS UCD_141967__CMA14#78630, _CMA15#77731 AS UCD_141967__CMA15#78631, _CMA16#77732 AS UCD_141967__CMA16#78632, _CMA17#77733 AS UCD_141967__CMA17#78633, _CMA18#77734 AS UCD_141967__CMA18#78634, _CMA19#77735 AS UCD_141967__CMA19#78635, _CMA2#77736 AS UCD_141967__CMA2#78636, _CMA20#77737 AS UCD_141967__CMA20#78637, _CMA21#77738 AS UCD_141967__CMA21#78638, _CMA22#77739 AS UCD_141967__CMA22#78639, _CMA23#77740 AS UCD_141967__CMA23#78640, _CMA24#77741 AS UCD_141967__CMA24#78641, _CMA25#77742 AS UCD_141967__CMA25#78642, _CMA26#77743 AS UCD_141967__CMA26#78643, _CMA27#77744 AS UCD_141967__CMA27#78644, _CMA28#77745 AS UCD_141967__CMA28#78645, _CMA29#77746 AS UCD_141967__CMA29#78646, _CMA3#77747 AS UCD_141967__CMA3#78647, _CMA30#77748 AS UCD_141967__CMA30#78648, ... 76 more fields]
                                    +- SubqueryAlias UCD_141967114
                                       +- Project [_CMA1#77725, _CMA10#77726, _CMA11#77727, _CMA12#77728, _CMA13#77729, _CMA14#77730, _CMA15#77731, _CMA16#77732, _CMA17#77733, _CMA18#77734, _CMA19#77735, _CMA2#77736, _CMA20#77737, _CMA21#77738, _CMA22#77739, _CMA23#77740, _CMA24#77741, _CMA25#77742, _CMA26#77743, _CMA27#77744, _CMA28#77745, _CMA29#77746, _CMA3#77747, _CMA30#77748, ... 76 more fields]
                                          +- Project [CMA1#77226 AS _CMA1#77725, CMA10#77235 AS _CMA10#77726, CMA11#77236 AS _CMA11#77727, CMA12#77237 AS _CMA12#77728, CMA13#77238 AS _CMA13#77729, CMA14#77239 AS _CMA14#77730, CMA15#77240 AS _CMA15#77731, CMA16#77241 AS _CMA16#77732, CMA17#77242 AS _CMA17#77733, CMA18#77243 AS _CMA18#77734, CMA19#77244 AS _CMA19#77735, CMA2#77227 AS _CMA2#77736, CMA20#77245 AS _CMA20#77737, CMA21#77246 AS _CMA21#77738, CMA22#77247 AS _CMA22#77739, CMA23#77248 AS _CMA23#77740, CMA24#77249 AS _CMA24#77741, CMA25#77250 AS _CMA25#77742, CMA26#77251 AS _CMA26#77743, CMA27#77252 AS _CMA27#77744, CMA28#77253 AS _CMA28#77745, CMA29#77254 AS _CMA29#77746, CMA3#77228 AS _CMA3#77747, CMA30#77255 AS _CMA30#77748, ... 76 more fields]
                                             +- Project [CODE_UCD#77225, CMA1#77226, CMA2#77227, CMA3#77228, CMA4#77229, CMA5#77230, CMA6#77231, CMA7#77232, CMA8#77233, CMA9#77234, CMA10#77235, CMA11#77236, CMA12#77237, CMA13#77238, CMA14#77239, CMA15#77240, CMA16#77241, CMA17#77242, CMA18#77243, CMA19#77244, CMA20#77245, CMA21#77246, CMA22#77247, CMA23#77248, ... 76 more fields]
                                                +- Project [CODE_UCD#76825 AS CODE_UCD#77225, CMA1#76826 AS CMA1#77226, CMA2#76827 AS CMA2#77227, CMA3#76828 AS CMA3#77228, CMA4#76829 AS CMA4#77229, CMA5#76830 AS CMA5#77230, CMA6#76831 AS CMA6#77231, CMA7#76832 AS CMA7#77232, CMA8#76833 AS CMA8#77233, CMA9#76834 AS CMA9#77234, CMA10#76835 AS CMA10#77235, CMA11#76836 AS CMA11#77236, CMA12#76837 AS CMA12#77237, CMA13#76838 AS CMA13#77238, CMA14#76839 AS CMA14#77239, CMA15#76840 AS CMA15#77240, CMA16#76841 AS CMA16#77241, CMA17#76842 AS CMA17#77242, CMA18#76843 AS CMA18#77243, CMA19#76844 AS CMA19#77244, CMA20#76845 AS CMA20#77245, CMA21#76846 AS CMA21#77246, CMA22#76847 AS CMA22#77247, CMA23#76848 AS CMA23#77248, ... 76 more fields]
                                                   +- Relation[CODE_UCD#76825,CMA1#76826,CMA2#76827,CMA3#76828,CMA4#76829,CMA5#76830,CMA6#76831,CMA7#76832,CMA8#76833,CMA9#76834,CMA10#76835,CMA11#76836,CMA12#76837,CMA13#76838,CMA14#76839,CMA15#76840,CMA16#76841,CMA17#76842,CMA18#76843,CMA19#76844,CMA20#76845,CMA21#76846,CMA22#76847,CMA23#76848,... 76 more fields] parquet

== Analyzed Logical Plan ==
COL_24A09A72_DFB3_4002_8CCB_2892C3419C84: string, COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F: string
GlobalLimit 1500
+- LocalLimit 1500
   +- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#79486 AS COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#79492, COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#79488 AS COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#79493]
      +- Filter isnotnull(COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#79488)
         +- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#79480 AS COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#79486, COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#79481 AS COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#79487, COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#79482 AS COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#79488]
            +- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#79463 AS COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#79480, COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#79469 AS COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#79481, COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#79473 AS COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#79482]
               +- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#79463, COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#79469, col1#79465 AS COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#79473]
                  +- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#79463, col0#79464 AS COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#79469, col1#79465]
                     +- Project [COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#79263 AS COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#79463, col0#79464, col1#79465]
                        +- Generate stack(99, CMA1, COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#79264, CMA2, COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#79265, CMA3, COL_D1545230_AFDA_433F_954A_31EAAAD2A879#79266, CMA4, COL_DED65925_A059_456C_A467_6829CE5FC9F7#79267, CMA5, COL_2A8C00CF_80EC_49CE_8290_724207B64D34#79268, CMA6, COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#79269, CMA7, COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#79270, CMA8, COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#79271, CMA9, COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#79272, CMA10, COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#79273, CMA11, COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#79274, CMA12, ... 175 more fields), false, [col0#79464, col1#79465]
                           +- Project [COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#79032 AS COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#79263, COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#79033 AS COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#79264, COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#79034 AS COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#79265, COL_D1545230_AFDA_433F_954A_31EAAAD2A879#79035 AS COL_D1545230_AFDA_433F_954A_31EAAAD2A879#79266, COL_DED65925_A059_456C_A467_6829CE5FC9F7#79036 AS COL_DED65925_A059_456C_A467_6829CE5FC9F7#79267, COL_2A8C00CF_80EC_49CE_8290_724207B64D34#79037 AS COL_2A8C00CF_80EC_49CE_8290_724207B64D34#79268, COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#79038 AS COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#79269, COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#79039 AS COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#79270, COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#79040 AS COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#79271, COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#79041 AS COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#79272, COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#79042 AS COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#79273, COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#79043 AS COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#79274, COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#79044 AS COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#79275, COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#79045 AS COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#79276, COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#79046 AS COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#79277, COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#79047 AS COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#79278, COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#79048 AS COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#79279, COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#79049 AS COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#79280, COL_F4438D2A_C49B_49CF_8688_30C936AD9492#79050 AS COL_F4438D2A_C49B_49CF_8688_30C936AD9492#79281, COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#79051 AS COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#79282, COL_6A9162EB_9974_4518_8A3D_64591B01F18A#79052 AS COL_6A9162EB_9974_4518_8A3D_64591B01F18A#79283, COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#79053 AS COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#79284, COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#79054 AS COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#79285, COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#79055 AS COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#79286, ... 76 more fields]
                              +- Project [cast(UCD_141967__CODE_UCD#78724 as string) AS COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#79032, cast(UCD_141967__CMA1#78625 as string) AS COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#79033, cast(UCD_141967__CMA2#78636 as string) AS COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#79034, cast(UCD_141967__CMA3#78647 as string) AS COL_D1545230_AFDA_433F_954A_31EAAAD2A879#79035, cast(UCD_141967__CMA4#78658 as string) AS COL_DED65925_A059_456C_A467_6829CE5FC9F7#79036, cast(UCD_141967__CMA5#78669 as string) AS COL_2A8C00CF_80EC_49CE_8290_724207B64D34#79037, cast(UCD_141967__CMA6#78680 as string) AS COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#79038, cast(UCD_141967__CMA7#78691 as string) AS COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#79039, cast(UCD_141967__CMA8#78702 as string) AS COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#79040, cast(UCD_141967__CMA9#78713 as string) AS COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#79041, cast(UCD_141967__CMA10#78626 as string) AS COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#79042, cast(UCD_141967__CMA11#78627 as string) AS COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#79043, cast(UCD_141967__CMA12#78628 as string) AS COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#79044, cast(UCD_141967__CMA13#78629 as string) AS COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#79045, cast(UCD_141967__CMA14#78630 as string) AS COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#79046, cast(UCD_141967__CMA15#78631 as string) AS COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#79047, cast(UCD_141967__CMA16#78632 as string) AS COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#79048, cast(UCD_141967__CMA17#78633 as string) AS COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#79049, cast(UCD_141967__CMA18#78634 as string) AS COL_F4438D2A_C49B_49CF_8688_30C936AD9492#79050, cast(UCD_141967__CMA19#78635 as string) AS COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#79051, cast(UCD_141967__CMA20#78637 as string) AS COL_6A9162EB_9974_4518_8A3D_64591B01F18A#79052, cast(UCD_141967__CMA21#78638 as string) AS COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#79053, cast(UCD_141967__CMA22#78639 as string) AS COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#79054, cast(UCD_141967__CMA23#78640 as string) AS COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#79055, ... 76 more fields]
                                 +- Project [_CMA1#77725 AS UCD_141967__CMA1#78625, _CMA10#77726 AS UCD_141967__CMA10#78626, _CMA11#77727 AS UCD_141967__CMA11#78627, _CMA12#77728 AS UCD_141967__CMA12#78628, _CMA13#77729 AS UCD_141967__CMA13#78629, _CMA14#77730 AS UCD_141967__CMA14#78630, _CMA15#77731 AS UCD_141967__CMA15#78631, _CMA16#77732 AS UCD_141967__CMA16#78632, _CMA17#77733 AS UCD_141967__CMA17#78633, _CMA18#77734 AS UCD_141967__CMA18#78634, _CMA19#77735 AS UCD_141967__CMA19#78635, _CMA2#77736 AS UCD_141967__CMA2#78636, _CMA20#77737 AS UCD_141967__CMA20#78637, _CMA21#77738 AS UCD_141967__CMA21#78638, _CMA22#77739 AS UCD_141967__CMA22#78639, _CMA23#77740 AS UCD_141967__CMA23#78640, _CMA24#77741 AS UCD_141967__CMA24#78641, _CMA25#77742 AS UCD_141967__CMA25#78642, _CMA26#77743 AS UCD_141967__CMA26#78643, _CMA27#77744 AS UCD_141967__CMA27#78644, _CMA28#77745 AS UCD_141967__CMA28#78645, _CMA29#77746 AS UCD_141967__CMA29#78646, _CMA3#77747 AS UCD_141967__CMA3#78647, _CMA30#77748 AS UCD_141967__CMA30#78648, ... 76 more fields]
                                    +- SubqueryAlias UCD_141967114
                                       +- Project [_CMA1#77725, _CMA10#77726, _CMA11#77727, _CMA12#77728, _CMA13#77729, _CMA14#77730, _CMA15#77731, _CMA16#77732, _CMA17#77733, _CMA18#77734, _CMA19#77735, _CMA2#77736, _CMA20#77737, _CMA21#77738, _CMA22#77739, _CMA23#77740, _CMA24#77741, _CMA25#77742, _CMA26#77743, _CMA27#77744, _CMA28#77745, _CMA29#77746, _CMA3#77747, _CMA30#77748, ... 76 more fields]
                                          +- Project [CMA1#77226 AS _CMA1#77725, CMA10#77235 AS _CMA10#77726, CMA11#77236 AS _CMA11#77727, CMA12#77237 AS _CMA12#77728, CMA13#77238 AS _CMA13#77729, CMA14#77239 AS _CMA14#77730, CMA15#77240 AS _CMA15#77731, CMA16#77241 AS _CMA16#77732, CMA17#77242 AS _CMA17#77733, CMA18#77243 AS _CMA18#77734, CMA19#77244 AS _CMA19#77735, CMA2#77227 AS _CMA2#77736, CMA20#77245 AS _CMA20#77737, CMA21#77246 AS _CMA21#77738, CMA22#77247 AS _CMA22#77739, CMA23#77248 AS _CMA23#77740, CMA24#77249 AS _CMA24#77741, CMA25#77250 AS _CMA25#77742, CMA26#77251 AS _CMA26#77743, CMA27#77252 AS _CMA27#77744, CMA28#77253 AS _CMA28#77745, CMA29#77254 AS _CMA29#77746, CMA3#77228 AS _CMA3#77747, CMA30#77255 AS _CMA30#77748, ... 76 more fields]
                                             +- Project [CODE_UCD#77225, CMA1#77226, CMA2#77227, CMA3#77228, CMA4#77229, CMA5#77230, CMA6#77231, CMA7#77232, CMA8#77233, CMA9#77234, CMA10#77235, CMA11#77236, CMA12#77237, CMA13#77238, CMA14#77239, CMA15#77240, CMA16#77241, CMA17#77242, CMA18#77243, CMA19#77244, CMA20#77245, CMA21#77246, CMA22#77247, CMA23#77248, ... 76 more fields]
                                                +- Project [CODE_UCD#76825 AS CODE_UCD#77225, CMA1#76826 AS CMA1#77226, CMA2#76827 AS CMA2#77227, CMA3#76828 AS CMA3#77228, CMA4#76829 AS CMA4#77229, CMA5#76830 AS CMA5#77230, CMA6#76831 AS CMA6#77231, CMA7#76832 AS CMA7#77232, CMA8#76833 AS CMA8#77233, CMA9#76834 AS CMA9#77234, CMA10#76835 AS CMA10#77235, CMA11#76836 AS CMA11#77236, CMA12#76837 AS CMA12#77237, CMA13#76838 AS CMA13#77238, CMA14#76839 AS CMA14#77239, CMA15#76840 AS CMA15#77240, CMA16#76841 AS CMA16#77241, CMA17#76842 AS CMA17#77242, CMA18#76843 AS CMA18#77243, CMA19#76844 AS CMA19#77244, CMA20#76845 AS CMA20#77245, CMA21#76846 AS CMA21#77246, CMA22#76847 AS CMA22#77247, CMA23#76848 AS CMA23#77248, ... 76 more fields]
                                                   +- Relation[CODE_UCD#76825,CMA1#76826,CMA2#76827,CMA3#76828,CMA4#76829,CMA5#76830,CMA6#76831,CMA7#76832,CMA8#76833,CMA9#76834,CMA10#76835,CMA11#76836,CMA12#76837,CMA13#76838,CMA14#76839,CMA15#76840,CMA16#76841,CMA17#76842,CMA18#76843,CMA19#76844,CMA20#76845,CMA21#76846,CMA22#76847,CMA23#76848,... 76 more fields] parquet

== Optimized Logical Plan ==
GlobalLimit 1500
+- LocalLimit 1500
   +- Project [COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#79263 AS COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#79492, col1#79465 AS COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#79493]
      +- Filter isnotnull(col1#79465)
         +- Generate stack(99, CMA1, COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#79264, CMA2, COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#79265, CMA3, COL_D1545230_AFDA_433F_954A_31EAAAD2A879#79266, CMA4, COL_DED65925_A059_456C_A467_6829CE5FC9F7#79267, CMA5, COL_2A8C00CF_80EC_49CE_8290_724207B64D34#79268, CMA6, COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#79269, CMA7, COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#79270, CMA8, COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#79271, CMA9, COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#79272, CMA10, COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#79273, CMA11, COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#79274, CMA12, ... 175 more fields), [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, ... 75 more fields], false, [col0#79464, col1#79465]
            +- Project [CODE_UCD#76825 AS COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#79263, CMA1#76826 AS COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#79264, CMA2#76827 AS COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#79265, CMA3#76828 AS COL_D1545230_AFDA_433F_954A_31EAAAD2A879#79266, CMA4#76829 AS COL_DED65925_A059_456C_A467_6829CE5FC9F7#79267, CMA5#76830 AS COL_2A8C00CF_80EC_49CE_8290_724207B64D34#79268, CMA6#76831 AS COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#79269, CMA7#76832 AS COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#79270, CMA8#76833 AS COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#79271, CMA9#76834 AS COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#79272, CMA10#76835 AS COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#79273, CMA11#76836 AS COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#79274, CMA12#76837 AS COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#79275, CMA13#76838 AS COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#79276, CMA14#76839 AS COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#79277, CMA15#76840 AS COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#79278, CMA16#76841 AS COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#79279, CMA17#76842 AS COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#79280, CMA18#76843 AS COL_F4438D2A_C49B_49CF_8688_30C936AD9492#79281, CMA19#76844 AS COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#79282, CMA20#76845 AS COL_6A9162EB_9974_4518_8A3D_64591B01F18A#79283, CMA21#76846 AS COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#79284, CMA22#76847 AS COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#79285, CMA23#76848 AS COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#79286, ... 76 more fields]
               +- Relation[CODE_UCD#76825,CMA1#76826,CMA2#76827,CMA3#76828,CMA4#76829,CMA5#76830,CMA6#76831,CMA7#76832,CMA8#76833,CMA9#76834,CMA10#76835,CMA11#76836,CMA12#76837,CMA13#76838,CMA14#76839,CMA15#76840,CMA16#76841,CMA17#76842,CMA18#76843,CMA19#76844,CMA20#76845,CMA21#76846,CMA22#76847,CMA23#76848,... 76 more fields] parquet

== Physical Plan ==
CollectLimit 1500
+- *(2) Project [COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#79263 AS COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#79492, col1#79465 AS COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#79493]
   +- *(2) Filter isnotnull(col1#79465)
      +- Generate stack(99, CMA1, COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#79264, CMA2, COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#79265, CMA3, COL_D1545230_AFDA_433F_954A_31EAAAD2A879#79266, CMA4, COL_DED65925_A059_456C_A467_6829CE5FC9F7#79267, CMA5, COL_2A8C00CF_80EC_49CE_8290_724207B64D34#79268, CMA6, COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#79269, CMA7, COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#79270, CMA8, COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#79271, CMA9, COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#79272, CMA10, COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#79273, CMA11, COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#79274, CMA12, ... 175 more fields), [COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#79263], false, [col0#79464, col1#79465]
         +- *(1) Project [CODE_UCD#76825 AS COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#79263, CMA1#76826 AS COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#79264, CMA2#76827 AS COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#79265, CMA3#76828 AS COL_D1545230_AFDA_433F_954A_31EAAAD2A879#79266, CMA4#76829 AS COL_DED65925_A059_456C_A467_6829CE5FC9F7#79267, CMA5#76830 AS COL_2A8C00CF_80EC_49CE_8290_724207B64D34#79268, CMA6#76831 AS COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#79269, CMA7#76832 AS COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#79270, CMA8#76833 AS COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#79271, CMA9#76834 AS COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#79272, CMA10#76835 AS COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#79273, CMA11#76836 AS COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#79274, CMA12#76837 AS COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#79275, CMA13#76838 AS COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#79276, CMA14#76839 AS COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#79277, CMA15#76840 AS COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#79278, CMA16#76841 AS COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#79279, CMA17#76842 AS COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#79280, CMA18#76843 AS COL_F4438D2A_C49B_49CF_8688_30C936AD9492#79281, CMA19#76844 AS COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#79282, CMA20#76845 AS COL_6A9162EB_9974_4518_8A3D_64591B01F18A#79283, CMA21#76846 AS COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#79284, CMA22#76847 AS COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#79285, CMA23#76848 AS COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#79286, ... 76 more fields]
            +- *(1) ColumnarToRow
               +- FileScan parquet [CODE_UCD#76825,CMA1#76826,CMA2#76827,CMA3#76828,CMA4#76829,CMA5#76830,CMA6#76831,CMA7#76832,CMA8#76833,CMA9#76834,CMA10#76835,CMA11#76836,CMA12#76837,CMA13#76838,CMA14#76839,CMA15#76840,CMA16#76841,CMA17#76842,CMA18#76843,CMA19#76844,CMA20#76845,CMA21#76846,CMA22#76847,CMA23#76848,... 76 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<CODE_UCD:string,CMA1:string,CMA2:string,CMA3:string,CMA4:string,CMA5:string,CMA6:string,CM...