DC2 - Details for Query 179

Details for Query 179

Submitted Time: 2025/11/17 10:01:39
Duration: 1.0 s
Succeeded Jobs: 280 282

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 0 ms"; 2 [labelType="html" label="HashAggregate time in aggregation build: 0 ms number of output rows: 1"]; } 3 [labelType="html" label="Exchange shuffle records written: 1 shuffle write time: 0 ms records read: 1 local bytes read: 59.0 B fetch wait time: 0 ms remote bytes read: 0.0 B local blocks read: 1 remote blocks read: 0 data size: 16.0 B remote bytes read to disk: 0.0 B shuffle bytes written: 59.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 848 ms"; 5 [labelType="html" label="HashAggregate time in aggregation build: 847 ms number of output rows: 1"]; 6 [labelType="html" label=" Project "]; } 7 [labelType="html" label="Generate number of output rows: 2,965,446"]; subgraph cluster8 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 854 ms"; 9 [labelType="html" label=" Project "]; 10 [labelType="html" label="ColumnarToRow number of output rows: 29,954 number of input batches: 8"]; } 11 [labelType="html" label="Scan parquet number of files read: 1 scan time: 23 ms metadata time: 0 ms size of files read: 509.3 KiB number of output rows: 29,954"]; 2->0; 3->2; 5->3; 6->5; 7->6; 9->7; 10->9; 11->10; }

AdaptiveSparkPlan isFinalPlan=true

HashAggregate(keys=[], functions=[count(1)])

WholeStageCodegen (3)

Exchange SinglePartition, true, [id=#10051]

HashAggregate(keys=[], functions=[partial_count(1)])

Project

WholeStageCodegen (2)

Generate stack(99, CMA1, COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#70186, CMA2, COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#70187, CMA3, COL_D1545230_AFDA_433F_954A_31EAAAD2A879#70188, CMA4, COL_DED65925_A059_456C_A467_6829CE5FC9F7#70189, CMA5, COL_2A8C00CF_80EC_49CE_8290_724207B64D34#70190, CMA6, COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#70191, CMA7, COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#70192, CMA8, COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#70193, CMA9, COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#70194, CMA10, COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#70195, CMA11, COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#70196, CMA12, ... 175 more fields), false, [col0#70386, col1#70387]

Project [CMA1#68686 AS COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#70186, CMA2#68687 AS COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#70187, CMA3#68688 AS COL_D1545230_AFDA_433F_954A_31EAAAD2A879#70188, CMA4#68689 AS COL_DED65925_A059_456C_A467_6829CE5FC9F7#70189, CMA5#68690 AS COL_2A8C00CF_80EC_49CE_8290_724207B64D34#70190, CMA6#68691 AS COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#70191, CMA7#68692 AS COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#70192, CMA8#68693 AS COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#70193, CMA9#68694 AS COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#70194, CMA10#68695 AS COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#70195, CMA11#68696 AS COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#70196, CMA12#68697 AS COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#70197, CMA13#68698 AS COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#70198, CMA14#68699 AS COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#70199, CMA15#68700 AS COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#70200, CMA16#68701 AS COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#70201, CMA17#68702 AS COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#70202, CMA18#68703 AS COL_F4438D2A_C49B_49CF_8688_30C936AD9492#70203, CMA19#68704 AS COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#70204, CMA20#68705 AS COL_6A9162EB_9974_4518_8A3D_64591B01F18A#70205, CMA21#68706 AS COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#70206, CMA22#68707 AS COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#70207, CMA23#68708 AS COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#70208, CMA24#68709 AS COL_54478F51_46AA_4AF8_8838_D4A60ACEFA22#70209, ... 75 more fields]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [CMA1#68686,CMA2#68687,CMA3#68688,CMA4#68689,CMA5#68690,CMA6#68691,CMA7#68692,CMA8#68693,CMA9#68694,CMA10#68695,CMA11#68696,CMA12#68697,CMA13#68698,CMA14#68699,CMA15#68700,CMA16#68701,CMA17#68702,CMA18#68703,CMA19#68704,CMA20#68705,CMA21#68706,CMA22#68707,CMA23#68708,CMA24#68709,... 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...

Details

== Parsed Logical Plan ==
Aggregate [count(1) AS count#70412L]
+- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#70385 AS COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#70402, COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#70391 AS COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#70403, COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#70395 AS COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#70404]
   +- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#70385, COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#70391, col1#70387 AS COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#70395]
      +- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#70385, col0#70386 AS COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#70391, col1#70387]
         +- Project [COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#70185 AS COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#70385, col0#70386, col1#70387]
            +- Generate stack(99, CMA1, COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#70186, CMA2, COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#70187, CMA3, COL_D1545230_AFDA_433F_954A_31EAAAD2A879#70188, CMA4, COL_DED65925_A059_456C_A467_6829CE5FC9F7#70189, CMA5, COL_2A8C00CF_80EC_49CE_8290_724207B64D34#70190, CMA6, COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#70191, CMA7, COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#70192, CMA8, COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#70193, CMA9, COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#70194, CMA10, COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#70195, CMA11, COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#70196, CMA12, ... 175 more fields), false, [col0#70386, col1#70387]
               +- Project [COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#69985 AS COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#70185, COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#69986 AS COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#70186, COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#69987 AS COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#70187, COL_D1545230_AFDA_433F_954A_31EAAAD2A879#69988 AS COL_D1545230_AFDA_433F_954A_31EAAAD2A879#70188, COL_DED65925_A059_456C_A467_6829CE5FC9F7#69989 AS COL_DED65925_A059_456C_A467_6829CE5FC9F7#70189, COL_2A8C00CF_80EC_49CE_8290_724207B64D34#69990 AS COL_2A8C00CF_80EC_49CE_8290_724207B64D34#70190, COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#69991 AS COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#70191, COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#69992 AS COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#70192, COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#69993 AS COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#70193, COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#69994 AS COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#70194, COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#69995 AS COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#70195, COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#69996 AS COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#70196, COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#69997 AS COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#70197, COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#69998 AS COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#70198, COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#69999 AS COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#70199, COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#70000 AS COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#70200, COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#70001 AS COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#70201, COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#70002 AS COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#70202, COL_F4438D2A_C49B_49CF_8688_30C936AD9492#70003 AS COL_F4438D2A_C49B_49CF_8688_30C936AD9492#70203, COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#70004 AS COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#70204, COL_6A9162EB_9974_4518_8A3D_64591B01F18A#70005 AS COL_6A9162EB_9974_4518_8A3D_64591B01F18A#70205, COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#70006 AS COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#70206, COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#70007 AS COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#70207, COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#70008 AS COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#70208, ... 76 more fields]
                  +- Project [cast(UCD_141967__CODE_UCD#69784 as string) AS COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#69985, cast(UCD_141967__CMA1#69685 as string) AS COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#69986, cast(UCD_141967__CMA2#69696 as string) AS COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#69987, cast(UCD_141967__CMA3#69707 as string) AS COL_D1545230_AFDA_433F_954A_31EAAAD2A879#69988, cast(UCD_141967__CMA4#69718 as string) AS COL_DED65925_A059_456C_A467_6829CE5FC9F7#69989, cast(UCD_141967__CMA5#69729 as string) AS COL_2A8C00CF_80EC_49CE_8290_724207B64D34#69990, cast(UCD_141967__CMA6#69740 as string) AS COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#69991, cast(UCD_141967__CMA7#69751 as string) AS COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#69992, cast(UCD_141967__CMA8#69762 as string) AS COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#69993, cast(UCD_141967__CMA9#69773 as string) AS COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#69994, cast(UCD_141967__CMA10#69686 as string) AS COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#69995, cast(UCD_141967__CMA11#69687 as string) AS COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#69996, cast(UCD_141967__CMA12#69688 as string) AS COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#69997, cast(UCD_141967__CMA13#69689 as string) AS COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#69998, cast(UCD_141967__CMA14#69690 as string) AS COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#69999, cast(UCD_141967__CMA15#69691 as string) AS COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#70000, cast(UCD_141967__CMA16#69692 as string) AS COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#70001, cast(UCD_141967__CMA17#69693 as string) AS COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#70002, cast(UCD_141967__CMA18#69694 as string) AS COL_F4438D2A_C49B_49CF_8688_30C936AD9492#70003, cast(UCD_141967__CMA19#69695 as string) AS COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#70004, cast(UCD_141967__CMA20#69697 as string) AS COL_6A9162EB_9974_4518_8A3D_64591B01F18A#70005, cast(UCD_141967__CMA21#69698 as string) AS COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#70006, cast(UCD_141967__CMA22#69699 as string) AS COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#70007, cast(UCD_141967__CMA23#69700 as string) AS COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#70008, ... 76 more fields]
                     +- Project [_CMA1#69285 AS UCD_141967__CMA1#69685, _CMA10#69286 AS UCD_141967__CMA10#69686, _CMA11#69287 AS UCD_141967__CMA11#69687, _CMA12#69288 AS UCD_141967__CMA12#69688, _CMA13#69289 AS UCD_141967__CMA13#69689, _CMA14#69290 AS UCD_141967__CMA14#69690, _CMA15#69291 AS UCD_141967__CMA15#69691, _CMA16#69292 AS UCD_141967__CMA16#69692, _CMA17#69293 AS UCD_141967__CMA17#69693, _CMA18#69294 AS UCD_141967__CMA18#69694, _CMA19#69295 AS UCD_141967__CMA19#69695, _CMA2#69296 AS UCD_141967__CMA2#69696, _CMA20#69297 AS UCD_141967__CMA20#69697, _CMA21#69298 AS UCD_141967__CMA21#69698, _CMA22#69299 AS UCD_141967__CMA22#69699, _CMA23#69300 AS UCD_141967__CMA23#69700, _CMA24#69301 AS UCD_141967__CMA24#69701, _CMA25#69302 AS UCD_141967__CMA25#69702, _CMA26#69303 AS UCD_141967__CMA26#69703, _CMA27#69304 AS UCD_141967__CMA27#69704, _CMA28#69305 AS UCD_141967__CMA28#69705, _CMA29#69306 AS UCD_141967__CMA29#69706, _CMA3#69307 AS UCD_141967__CMA3#69707, _CMA30#69308 AS UCD_141967__CMA30#69708, ... 76 more fields]
                        +- SubqueryAlias UCD_141967116
                           +- Project [_CMA1#69285, _CMA10#69286, _CMA11#69287, _CMA12#69288, _CMA13#69289, _CMA14#69290, _CMA15#69291, _CMA16#69292, _CMA17#69293, _CMA18#69294, _CMA19#69295, _CMA2#69296, _CMA20#69297, _CMA21#69298, _CMA22#69299, _CMA23#69300, _CMA24#69301, _CMA25#69302, _CMA26#69303, _CMA27#69304, _CMA28#69305, _CMA29#69306, _CMA3#69307, _CMA30#69308, ... 76 more fields]
                              +- Project [CMA1#68986 AS _CMA1#69285, CMA10#68995 AS _CMA10#69286, CMA11#68996 AS _CMA11#69287, CMA12#68997 AS _CMA12#69288, CMA13#68998 AS _CMA13#69289, CMA14#68999 AS _CMA14#69290, CMA15#69000 AS _CMA15#69291, CMA16#69001 AS _CMA16#69292, CMA17#69002 AS _CMA17#69293, CMA18#69003 AS _CMA18#69294, CMA19#69004 AS _CMA19#69295, CMA2#68987 AS _CMA2#69296, CMA20#69005 AS _CMA20#69297, CMA21#69006 AS _CMA21#69298, CMA22#69007 AS _CMA22#69299, CMA23#69008 AS _CMA23#69300, CMA24#69009 AS _CMA24#69301, CMA25#69010 AS _CMA25#69302, CMA26#69011 AS _CMA26#69303, CMA27#69012 AS _CMA27#69304, CMA28#69013 AS _CMA28#69305, CMA29#69014 AS _CMA29#69306, CMA3#68988 AS _CMA3#69307, CMA30#69015 AS _CMA30#69308, ... 76 more fields]
                                 +- Project [CODE_UCD#68985, CMA1#68986, CMA2#68987, CMA3#68988, CMA4#68989, CMA5#68990, CMA6#68991, CMA7#68992, CMA8#68993, CMA9#68994, CMA10#68995, CMA11#68996, CMA12#68997, CMA13#68998, CMA14#68999, CMA15#69000, CMA16#69001, CMA17#69002, CMA18#69003, CMA19#69004, CMA20#69005, CMA21#69006, CMA22#69007, CMA23#69008, ... 76 more fields]
                                    +- Project [CODE_UCD#68685 AS CODE_UCD#68985, CMA1#68686 AS CMA1#68986, CMA2#68687 AS CMA2#68987, CMA3#68688 AS CMA3#68988, CMA4#68689 AS CMA4#68989, CMA5#68690 AS CMA5#68990, CMA6#68691 AS CMA6#68991, CMA7#68692 AS CMA7#68992, CMA8#68693 AS CMA8#68993, CMA9#68694 AS CMA9#68994, CMA10#68695 AS CMA10#68995, CMA11#68696 AS CMA11#68996, CMA12#68697 AS CMA12#68997, CMA13#68698 AS CMA13#68998, CMA14#68699 AS CMA14#68999, CMA15#68700 AS CMA15#69000, CMA16#68701 AS CMA16#69001, CMA17#68702 AS CMA17#69002, CMA18#68703 AS CMA18#69003, CMA19#68704 AS CMA19#69004, CMA20#68705 AS CMA20#69005, CMA21#68706 AS CMA21#69006, CMA22#68707 AS CMA22#69007, CMA23#68708 AS CMA23#69008, ... 76 more fields]
                                       +- Relation[CODE_UCD#68685,CMA1#68686,CMA2#68687,CMA3#68688,CMA4#68689,CMA5#68690,CMA6#68691,CMA7#68692,CMA8#68693,CMA9#68694,CMA10#68695,CMA11#68696,CMA12#68697,CMA13#68698,CMA14#68699,CMA15#68700,CMA16#68701,CMA17#68702,CMA18#68703,CMA19#68704,CMA20#68705,CMA21#68706,CMA22#68707,CMA23#68708,... 76 more fields] parquet

== Analyzed Logical Plan ==
count: bigint
Aggregate [count(1) AS count#70412L]
+- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#70385 AS COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#70402, COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#70391 AS COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#70403, COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#70395 AS COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#70404]
   +- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#70385, COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#70391, col1#70387 AS COL_5DD1CAB3_4547_4D7D_91D7_9C9CCB7F689F#70395]
      +- Project [COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#70385, col0#70386 AS COL_7D7924D1_4635_4883_A172_4F7AD2451AEA#70391, col1#70387]
         +- Project [COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#70185 AS COL_24A09A72_DFB3_4002_8CCB_2892C3419C84#70385, col0#70386, col1#70387]
            +- Generate stack(99, CMA1, COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#70186, CMA2, COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#70187, CMA3, COL_D1545230_AFDA_433F_954A_31EAAAD2A879#70188, CMA4, COL_DED65925_A059_456C_A467_6829CE5FC9F7#70189, CMA5, COL_2A8C00CF_80EC_49CE_8290_724207B64D34#70190, CMA6, COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#70191, CMA7, COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#70192, CMA8, COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#70193, CMA9, COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#70194, CMA10, COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#70195, CMA11, COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#70196, CMA12, ... 175 more fields), false, [col0#70386, col1#70387]
               +- Project [COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#69985 AS COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#70185, COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#69986 AS COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#70186, COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#69987 AS COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#70187, COL_D1545230_AFDA_433F_954A_31EAAAD2A879#69988 AS COL_D1545230_AFDA_433F_954A_31EAAAD2A879#70188, COL_DED65925_A059_456C_A467_6829CE5FC9F7#69989 AS COL_DED65925_A059_456C_A467_6829CE5FC9F7#70189, COL_2A8C00CF_80EC_49CE_8290_724207B64D34#69990 AS COL_2A8C00CF_80EC_49CE_8290_724207B64D34#70190, COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#69991 AS COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#70191, COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#69992 AS COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#70192, COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#69993 AS COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#70193, COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#69994 AS COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#70194, COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#69995 AS COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#70195, COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#69996 AS COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#70196, COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#69997 AS COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#70197, COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#69998 AS COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#70198, COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#69999 AS COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#70199, COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#70000 AS COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#70200, COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#70001 AS COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#70201, COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#70002 AS COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#70202, COL_F4438D2A_C49B_49CF_8688_30C936AD9492#70003 AS COL_F4438D2A_C49B_49CF_8688_30C936AD9492#70203, COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#70004 AS COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#70204, COL_6A9162EB_9974_4518_8A3D_64591B01F18A#70005 AS COL_6A9162EB_9974_4518_8A3D_64591B01F18A#70205, COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#70006 AS COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#70206, COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#70007 AS COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#70207, COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#70008 AS COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#70208, ... 76 more fields]
                  +- Project [cast(UCD_141967__CODE_UCD#69784 as string) AS COL_1ED9324E_F2F3_4170_9BF4_6D06BD06089A#69985, cast(UCD_141967__CMA1#69685 as string) AS COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#69986, cast(UCD_141967__CMA2#69696 as string) AS COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#69987, cast(UCD_141967__CMA3#69707 as string) AS COL_D1545230_AFDA_433F_954A_31EAAAD2A879#69988, cast(UCD_141967__CMA4#69718 as string) AS COL_DED65925_A059_456C_A467_6829CE5FC9F7#69989, cast(UCD_141967__CMA5#69729 as string) AS COL_2A8C00CF_80EC_49CE_8290_724207B64D34#69990, cast(UCD_141967__CMA6#69740 as string) AS COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#69991, cast(UCD_141967__CMA7#69751 as string) AS COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#69992, cast(UCD_141967__CMA8#69762 as string) AS COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#69993, cast(UCD_141967__CMA9#69773 as string) AS COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#69994, cast(UCD_141967__CMA10#69686 as string) AS COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#69995, cast(UCD_141967__CMA11#69687 as string) AS COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#69996, cast(UCD_141967__CMA12#69688 as string) AS COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#69997, cast(UCD_141967__CMA13#69689 as string) AS COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#69998, cast(UCD_141967__CMA14#69690 as string) AS COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#69999, cast(UCD_141967__CMA15#69691 as string) AS COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#70000, cast(UCD_141967__CMA16#69692 as string) AS COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#70001, cast(UCD_141967__CMA17#69693 as string) AS COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#70002, cast(UCD_141967__CMA18#69694 as string) AS COL_F4438D2A_C49B_49CF_8688_30C936AD9492#70003, cast(UCD_141967__CMA19#69695 as string) AS COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#70004, cast(UCD_141967__CMA20#69697 as string) AS COL_6A9162EB_9974_4518_8A3D_64591B01F18A#70005, cast(UCD_141967__CMA21#69698 as string) AS COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#70006, cast(UCD_141967__CMA22#69699 as string) AS COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#70007, cast(UCD_141967__CMA23#69700 as string) AS COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#70008, ... 76 more fields]
                     +- Project [_CMA1#69285 AS UCD_141967__CMA1#69685, _CMA10#69286 AS UCD_141967__CMA10#69686, _CMA11#69287 AS UCD_141967__CMA11#69687, _CMA12#69288 AS UCD_141967__CMA12#69688, _CMA13#69289 AS UCD_141967__CMA13#69689, _CMA14#69290 AS UCD_141967__CMA14#69690, _CMA15#69291 AS UCD_141967__CMA15#69691, _CMA16#69292 AS UCD_141967__CMA16#69692, _CMA17#69293 AS UCD_141967__CMA17#69693, _CMA18#69294 AS UCD_141967__CMA18#69694, _CMA19#69295 AS UCD_141967__CMA19#69695, _CMA2#69296 AS UCD_141967__CMA2#69696, _CMA20#69297 AS UCD_141967__CMA20#69697, _CMA21#69298 AS UCD_141967__CMA21#69698, _CMA22#69299 AS UCD_141967__CMA22#69699, _CMA23#69300 AS UCD_141967__CMA23#69700, _CMA24#69301 AS UCD_141967__CMA24#69701, _CMA25#69302 AS UCD_141967__CMA25#69702, _CMA26#69303 AS UCD_141967__CMA26#69703, _CMA27#69304 AS UCD_141967__CMA27#69704, _CMA28#69305 AS UCD_141967__CMA28#69705, _CMA29#69306 AS UCD_141967__CMA29#69706, _CMA3#69307 AS UCD_141967__CMA3#69707, _CMA30#69308 AS UCD_141967__CMA30#69708, ... 76 more fields]
                        +- SubqueryAlias UCD_141967116
                           +- Project [_CMA1#69285, _CMA10#69286, _CMA11#69287, _CMA12#69288, _CMA13#69289, _CMA14#69290, _CMA15#69291, _CMA16#69292, _CMA17#69293, _CMA18#69294, _CMA19#69295, _CMA2#69296, _CMA20#69297, _CMA21#69298, _CMA22#69299, _CMA23#69300, _CMA24#69301, _CMA25#69302, _CMA26#69303, _CMA27#69304, _CMA28#69305, _CMA29#69306, _CMA3#69307, _CMA30#69308, ... 76 more fields]
                              +- Project [CMA1#68986 AS _CMA1#69285, CMA10#68995 AS _CMA10#69286, CMA11#68996 AS _CMA11#69287, CMA12#68997 AS _CMA12#69288, CMA13#68998 AS _CMA13#69289, CMA14#68999 AS _CMA14#69290, CMA15#69000 AS _CMA15#69291, CMA16#69001 AS _CMA16#69292, CMA17#69002 AS _CMA17#69293, CMA18#69003 AS _CMA18#69294, CMA19#69004 AS _CMA19#69295, CMA2#68987 AS _CMA2#69296, CMA20#69005 AS _CMA20#69297, CMA21#69006 AS _CMA21#69298, CMA22#69007 AS _CMA22#69299, CMA23#69008 AS _CMA23#69300, CMA24#69009 AS _CMA24#69301, CMA25#69010 AS _CMA25#69302, CMA26#69011 AS _CMA26#69303, CMA27#69012 AS _CMA27#69304, CMA28#69013 AS _CMA28#69305, CMA29#69014 AS _CMA29#69306, CMA3#68988 AS _CMA3#69307, CMA30#69015 AS _CMA30#69308, ... 76 more fields]
                                 +- Project [CODE_UCD#68985, CMA1#68986, CMA2#68987, CMA3#68988, CMA4#68989, CMA5#68990, CMA6#68991, CMA7#68992, CMA8#68993, CMA9#68994, CMA10#68995, CMA11#68996, CMA12#68997, CMA13#68998, CMA14#68999, CMA15#69000, CMA16#69001, CMA17#69002, CMA18#69003, CMA19#69004, CMA20#69005, CMA21#69006, CMA22#69007, CMA23#69008, ... 76 more fields]
                                    +- Project [CODE_UCD#68685 AS CODE_UCD#68985, CMA1#68686 AS CMA1#68986, CMA2#68687 AS CMA2#68987, CMA3#68688 AS CMA3#68988, CMA4#68689 AS CMA4#68989, CMA5#68690 AS CMA5#68990, CMA6#68691 AS CMA6#68991, CMA7#68692 AS CMA7#68992, CMA8#68693 AS CMA8#68993, CMA9#68694 AS CMA9#68994, CMA10#68695 AS CMA10#68995, CMA11#68696 AS CMA11#68996, CMA12#68697 AS CMA12#68997, CMA13#68698 AS CMA13#68998, CMA14#68699 AS CMA14#68999, CMA15#68700 AS CMA15#69000, CMA16#68701 AS CMA16#69001, CMA17#68702 AS CMA17#69002, CMA18#68703 AS CMA18#69003, CMA19#68704 AS CMA19#69004, CMA20#68705 AS CMA20#69005, CMA21#68706 AS CMA21#69006, CMA22#68707 AS CMA22#69007, CMA23#68708 AS CMA23#69008, ... 76 more fields]
                                       +- Relation[CODE_UCD#68685,CMA1#68686,CMA2#68687,CMA3#68688,CMA4#68689,CMA5#68690,CMA6#68691,CMA7#68692,CMA8#68693,CMA9#68694,CMA10#68695,CMA11#68696,CMA12#68697,CMA13#68698,CMA14#68699,CMA15#68700,CMA16#68701,CMA17#68702,CMA18#68703,CMA19#68704,CMA20#68705,CMA21#68706,CMA22#68707,CMA23#68708,... 76 more fields] parquet

== Optimized Logical Plan ==
Aggregate [count(1) AS count#70412L]
+- Project
   +- Generate stack(99, CMA1, COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#70186, CMA2, COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#70187, CMA3, COL_D1545230_AFDA_433F_954A_31EAAAD2A879#70188, CMA4, COL_DED65925_A059_456C_A467_6829CE5FC9F7#70189, CMA5, COL_2A8C00CF_80EC_49CE_8290_724207B64D34#70190, CMA6, COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#70191, CMA7, COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#70192, CMA8, COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#70193, CMA9, COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#70194, CMA10, COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#70195, CMA11, COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#70196, 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#70386, col1#70387]
      +- Project [CMA1#68686 AS COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#70186, CMA2#68687 AS COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#70187, CMA3#68688 AS COL_D1545230_AFDA_433F_954A_31EAAAD2A879#70188, CMA4#68689 AS COL_DED65925_A059_456C_A467_6829CE5FC9F7#70189, CMA5#68690 AS COL_2A8C00CF_80EC_49CE_8290_724207B64D34#70190, CMA6#68691 AS COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#70191, CMA7#68692 AS COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#70192, CMA8#68693 AS COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#70193, CMA9#68694 AS COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#70194, CMA10#68695 AS COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#70195, CMA11#68696 AS COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#70196, CMA12#68697 AS COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#70197, CMA13#68698 AS COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#70198, CMA14#68699 AS COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#70199, CMA15#68700 AS COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#70200, CMA16#68701 AS COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#70201, CMA17#68702 AS COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#70202, CMA18#68703 AS COL_F4438D2A_C49B_49CF_8688_30C936AD9492#70203, CMA19#68704 AS COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#70204, CMA20#68705 AS COL_6A9162EB_9974_4518_8A3D_64591B01F18A#70205, CMA21#68706 AS COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#70206, CMA22#68707 AS COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#70207, CMA23#68708 AS COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#70208, CMA24#68709 AS COL_54478F51_46AA_4AF8_8838_D4A60ACEFA22#70209, ... 75 more fields]
         +- Relation[CODE_UCD#68685,CMA1#68686,CMA2#68687,CMA3#68688,CMA4#68689,CMA5#68690,CMA6#68691,CMA7#68692,CMA8#68693,CMA9#68694,CMA10#68695,CMA11#68696,CMA12#68697,CMA13#68698,CMA14#68699,CMA15#68700,CMA16#68701,CMA17#68702,CMA18#68703,CMA19#68704,CMA20#68705,CMA21#68706,CMA22#68707,CMA23#68708,... 76 more fields] parquet

== Physical Plan ==
AdaptiveSparkPlan isFinalPlan=true
+- *(3) HashAggregate(keys=[], functions=[count(1)], output=[count#70412L])
   +- ShuffleQueryStage 0
      +- Exchange SinglePartition, true, [id=#10051]
         +- *(2) HashAggregate(keys=[], functions=[partial_count(1)], output=[count#70415L])
            +- *(2) Project
               +- Generate stack(99, CMA1, COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#70186, CMA2, COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#70187, CMA3, COL_D1545230_AFDA_433F_954A_31EAAAD2A879#70188, CMA4, COL_DED65925_A059_456C_A467_6829CE5FC9F7#70189, CMA5, COL_2A8C00CF_80EC_49CE_8290_724207B64D34#70190, CMA6, COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#70191, CMA7, COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#70192, CMA8, COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#70193, CMA9, COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#70194, CMA10, COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#70195, CMA11, COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#70196, CMA12, ... 175 more fields), false, [col0#70386, col1#70387]
                  +- *(1) Project [CMA1#68686 AS COL_9878EF9F_126D_453E_ABAC_8C257EB4323E#70186, CMA2#68687 AS COL_368BAC4D_F890_4CF6_B239_B1DE71925F7D#70187, CMA3#68688 AS COL_D1545230_AFDA_433F_954A_31EAAAD2A879#70188, CMA4#68689 AS COL_DED65925_A059_456C_A467_6829CE5FC9F7#70189, CMA5#68690 AS COL_2A8C00CF_80EC_49CE_8290_724207B64D34#70190, CMA6#68691 AS COL_3F6A74D7_8EF5_4B74_853F_C439CF9E2ACC#70191, CMA7#68692 AS COL_B2A019A3_5028_4EC5_9EDA_D4741312241F#70192, CMA8#68693 AS COL_8196E0CE_E64B_4DA2_8BBE_956F83A6AA1C#70193, CMA9#68694 AS COL_903B64A3_D24F_43E9_8155_B3BC2D9AE1E7#70194, CMA10#68695 AS COL_B81E783E_1CC4_45FE_96BB_6B8DE24F70B8#70195, CMA11#68696 AS COL_3445458F_3EF1_4126_902C_8B7D8FAC0C52#70196, CMA12#68697 AS COL_935A2F6D_2639_4B7C_A542_680C6D6FBE98#70197, CMA13#68698 AS COL_19DBEBA0_9836_4ACE_8B94_41FA00562116#70198, CMA14#68699 AS COL_20BF10B7_1115_4EB2_82A9_BA4A87AF0E3E#70199, CMA15#68700 AS COL_694D8112_A9D2_4C97_925B_BA6AB35132A7#70200, CMA16#68701 AS COL_1CC9B82B_EAA0_440C_9B54_8CEE13490197#70201, CMA17#68702 AS COL_06B11A8F_60C8_41B6_A99E_C3321F60B145#70202, CMA18#68703 AS COL_F4438D2A_C49B_49CF_8688_30C936AD9492#70203, CMA19#68704 AS COL_9FF7E5C1_8A75_4E2D_8639_AE0833FA4A76#70204, CMA20#68705 AS COL_6A9162EB_9974_4518_8A3D_64591B01F18A#70205, CMA21#68706 AS COL_0329E9F0_2F24_4D8B_A3B5_5F274313D91D#70206, CMA22#68707 AS COL_F5C258C9_22A3_4B57_AC14_7041012DB6F8#70207, CMA23#68708 AS COL_6944C9DE_0989_4573_B79A_7E4A3DC713D5#70208, CMA24#68709 AS COL_54478F51_46AA_4AF8_8838_D4A60ACEFA22#70209, ... 75 more fields]
                     +- *(1) ColumnarToRow
                        +- FileScan parquet [CMA1#68686,CMA2#68687,CMA3#68688,CMA4#68689,CMA5#68690,CMA6#68691,CMA7#68692,CMA8#68693,CMA9#68694,CMA10#68695,CMA11#68696,CMA12#68697,CMA13#68698,CMA14#68699,CMA15#68700,CMA16#68701,CMA17#68702,CMA18#68703,CMA19#68704,CMA20#68705,CMA21#68706,CMA22#68707,CMA23#68708,CMA24#68709,... 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...