EVAL1_SPC1 - Details for Query 719

Submitted Time: 2026/02/20 13:34:54
Duration: 1 s
Succeeded Jobs: 884 886

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 (2)\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 local merged chunks fetched: 0 shuffle write time: 0 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 1 local bytes read: 85.0 B fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 120.0 B local merged bytes read: 0.0 B number of partitions: 1 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 85.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 106 ms"; 5 [labelType="html" label="HashAggregate time in aggregation build: 105 ms number of output rows: 1"]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label="Scan JDBCRelation((SELECT RAWTOHEX(VISIT_ID), RAWTOHEX(PATIENT_ID), \"IN_DATE\", \"OUT_DATE\", \"IN_MODE\", \"OUT_MODE\", \"IN_UNIT\", \"OUT_UNIT\", \"VISIT_TYPE\", \"CHAMP_PMSI\", \"UNIT_PATH\", \"EMERGENCY\", \"CANCELED\" FROM \"DTM_622\".\"VISIT\") x) [numPartitions=1] number of output rows: 717"]; } 2->0; 3->2; 5->3; 6->5; 7->6; }

AdaptiveSparkPlan isFinalPlan=true

HashAggregate(keys=[], functions=[count(COL_2D37A2DB_40AF_4056_B756_97C83B9AD5FC#109089), count(COL_C992DD47_AD26_4F62_B748_22E741771037#109090), count(COL_5C2A806C_2020_40CB_B947_459AFA5077A4#109091), count(COL_8D0DCF76_4096_40A7_8976_19153DFBAAE2#109092), count(COL_BFEFC15B_A723_414B_853B_FFA88398A37C#109093), count(COL_A3803123_BAB3_467D_B34A_CB32060F7F2E#109094), count(COL_850EAED1_1AEE_498B_B587_0008A3BE99B1#109095), count(COL_024A775C_C673_46D3_AB32_C1F7401A8355#109096), count(COL_AC8A8DDF_4EA5_4D38_8D20_8679312D7224#109097), count(COL_F70140D3_43C4_4FBD_ABE5_01001CF08A07#109098), count(COL_4F5542B0_47A6_499E_B900_FEBC09FDA3E1#109099), count(COL_A4355271_8DC7_4A9C_81AA_3E2855B22657#109100), count(COL_D0009226_9A17_4906_A60B_01C89CA97E39#109101), count(COL_D7C0574A_1493_44B6_8C66_458A8866E03E#109102)])

WholeStageCodegen (2)

Exchange SinglePartition, ENSURE_REQUIREMENTS, [plan_id=17196]

HashAggregate(keys=[], functions=[partial_count(COL_2D37A2DB_40AF_4056_B756_97C83B9AD5FC#109089), partial_count(COL_C992DD47_AD26_4F62_B748_22E741771037#109090), partial_count(COL_5C2A806C_2020_40CB_B947_459AFA5077A4#109091), partial_count(COL_8D0DCF76_4096_40A7_8976_19153DFBAAE2#109092), partial_count(COL_BFEFC15B_A723_414B_853B_FFA88398A37C#109093), partial_count(COL_A3803123_BAB3_467D_B34A_CB32060F7F2E#109094), partial_count(COL_850EAED1_1AEE_498B_B587_0008A3BE99B1#109095), partial_count(COL_024A775C_C673_46D3_AB32_C1F7401A8355#109096), partial_count(COL_AC8A8DDF_4EA5_4D38_8D20_8679312D7224#109097), partial_count(COL_F70140D3_43C4_4FBD_ABE5_01001CF08A07#109098), partial_count(COL_4F5542B0_47A6_499E_B900_FEBC09FDA3E1#109099), partial_count(COL_A4355271_8DC7_4A9C_81AA_3E2855B22657#109100), partial_count(COL_D0009226_9A17_4906_A60B_01C89CA97E39#109101), partial_count(COL_D7C0574A_1493_44B6_8C66_458A8866E03E#109102)])

Project [RAWTOHEX(VISIT_ID)#108900 AS COL_2D37A2DB_40AF_4056_B756_97C83B9AD5FC#109089, RAWTOHEX(PATIENT_ID)#108901 AS COL_C992DD47_AD26_4F62_B748_22E741771037#109090, IN_DATE#108902 AS COL_5C2A806C_2020_40CB_B947_459AFA5077A4#109091, OUT_DATE#108903 AS COL_8D0DCF76_4096_40A7_8976_19153DFBAAE2#109092, IN_MODE#108904 AS COL_BFEFC15B_A723_414B_853B_FFA88398A37C#109093, OUT_MODE#108905 AS COL_A3803123_BAB3_467D_B34A_CB32060F7F2E#109094, IN_UNIT#108906 AS COL_850EAED1_1AEE_498B_B587_0008A3BE99B1#109095, OUT_UNIT#108907 AS COL_024A775C_C673_46D3_AB32_C1F7401A8355#109096, VISIT_TYPE#108908 AS COL_AC8A8DDF_4EA5_4D38_8D20_8679312D7224#109097, CHAMP_PMSI#108909 AS COL_F70140D3_43C4_4FBD_ABE5_01001CF08A07#109098, UNIT_PATH#108910 AS COL_4F5542B0_47A6_499E_B900_FEBC09FDA3E1#109099, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, EMERGENCY#108911, 1, true, false, true) AS COL_A4355271_8DC7_4A9C_81AA_3E2855B22657#109100, cast(CANCELED#108912 as int) AS COL_D0009226_9A17_4906_A60B_01C89CA97E39#109101, str_encrypt(RAWTOHEX(VISIT_ID)#108900) AS COL_D7C0574A_1493_44B6_8C66_458A8866E03E#109102]

Scan JDBCRelation((SELECT RAWTOHEX(VISIT_ID), RAWTOHEX(PATIENT_ID), "IN_DATE", "OUT_DATE", "IN_MODE", "OUT_MODE", "IN_UNIT", "OUT_UNIT", "VISIT_TYPE", "CHAMP_PMSI", "UNIT_PATH", "EMERGENCY", "CANCELED" FROM "DTM_622"."VISIT") x) [numPartitions=1] [RAWTOHEX(VISIT_ID)#108900,RAWTOHEX(PATIENT_ID)#108901,IN_DATE#108902,OUT_DATE#108903,IN_MODE#108904,OUT_MODE#108905,IN_UNIT#108906,OUT_UNIT#108907,VISIT_TYPE#108908,CHAMP_PMSI#108909,UNIT_PATH#108910,EMERGENCY#108911,CANCELED#108912] PushedFilters: [], ReadSchema: struct<RAWTOHEX(VISIT_ID):string,RAWTOHEX(PATIENT_ID):string,IN_DATE:timestamp,OUT_DATE:timestamp...

WholeStageCodegen (1)

Details

== Physical Plan ==
AdaptiveSparkPlan (9)
+- == Final Plan ==
   * HashAggregate (6)
   +- ShuffleQueryStage (5), Statistics(sizeInBytes=120.0 B, rowCount=1)
      +- Exchange (4)
         +- * HashAggregate (3)
            +- * Project (2)
               +- * Scan JDBCRelation((SELECT RAWTOHEX(VISIT_ID), RAWTOHEX(PATIENT_ID), "IN_DATE", "OUT_DATE", "IN_MODE", "OUT_MODE", "IN_UNIT", "OUT_UNIT", "VISIT_TYPE", "CHAMP_PMSI", "UNIT_PATH", "EMERGENCY", "CANCELED" FROM "DTM_622"."VISIT") x) [numPartitions=1]  (1)
+- == Initial Plan ==
   HashAggregate (8)
   +- Exchange (7)
      +- HashAggregate (3)
         +- Project (2)
            +- Scan JDBCRelation((SELECT RAWTOHEX(VISIT_ID), RAWTOHEX(PATIENT_ID), "IN_DATE", "OUT_DATE", "IN_MODE", "OUT_MODE", "IN_UNIT", "OUT_UNIT", "VISIT_TYPE", "CHAMP_PMSI", "UNIT_PATH", "EMERGENCY", "CANCELED" FROM "DTM_622"."VISIT") x) [numPartitions=1]  (1)


(1) Scan JDBCRelation((SELECT RAWTOHEX(VISIT_ID), RAWTOHEX(PATIENT_ID), "IN_DATE", "OUT_DATE", "IN_MODE", "OUT_MODE", "IN_UNIT", "OUT_UNIT", "VISIT_TYPE", "CHAMP_PMSI", "UNIT_PATH", "EMERGENCY", "CANCELED" FROM "DTM_622"."VISIT") x) [numPartitions=1]  [codegen id : 1]
Output [13]: [RAWTOHEX(VISIT_ID)#108900, RAWTOHEX(PATIENT_ID)#108901, IN_DATE#108902, OUT_DATE#108903, IN_MODE#108904, OUT_MODE#108905, IN_UNIT#108906, OUT_UNIT#108907, VISIT_TYPE#108908, CHAMP_PMSI#108909, UNIT_PATH#108910, EMERGENCY#108911, CANCELED#108912]
ReadSchema: struct<RAWTOHEX(VISIT_ID):string,RAWTOHEX(PATIENT_ID):string,IN_DATE:timestamp,OUT_DATE:timestamp,IN_MODE:string,OUT_MODE:string,IN_UNIT:string,OUT_UNIT:string,VISIT_TYPE:string,CHAMP_PMSI:string,UNIT_PATH:string,EMERGENCY:string,CANCELED:decimal(1,0)>

(2) Project [codegen id : 1]
Output [14]: [RAWTOHEX(VISIT_ID)#108900 AS COL_2D37A2DB_40AF_4056_B756_97C83B9AD5FC#109089, RAWTOHEX(PATIENT_ID)#108901 AS COL_C992DD47_AD26_4F62_B748_22E741771037#109090, IN_DATE#108902 AS COL_5C2A806C_2020_40CB_B947_459AFA5077A4#109091, OUT_DATE#108903 AS COL_8D0DCF76_4096_40A7_8976_19153DFBAAE2#109092, IN_MODE#108904 AS COL_BFEFC15B_A723_414B_853B_FFA88398A37C#109093, OUT_MODE#108905 AS COL_A3803123_BAB3_467D_B34A_CB32060F7F2E#109094, IN_UNIT#108906 AS COL_850EAED1_1AEE_498B_B587_0008A3BE99B1#109095, OUT_UNIT#108907 AS COL_024A775C_C673_46D3_AB32_C1F7401A8355#109096, VISIT_TYPE#108908 AS COL_AC8A8DDF_4EA5_4D38_8D20_8679312D7224#109097, CHAMP_PMSI#108909 AS COL_F70140D3_43C4_4FBD_ABE5_01001CF08A07#109098, UNIT_PATH#108910 AS COL_4F5542B0_47A6_499E_B900_FEBC09FDA3E1#109099, staticinvoke(class org.apache.spark.sql.catalyst.util.CharVarcharCodegenUtils, StringType, readSidePadding, EMERGENCY#108911, 1, true, false, true) AS COL_A4355271_8DC7_4A9C_81AA_3E2855B22657#109100, cast(CANCELED#108912 as int) AS COL_D0009226_9A17_4906_A60B_01C89CA97E39#109101, str_encrypt(RAWTOHEX(VISIT_ID)#108900) AS COL_D7C0574A_1493_44B6_8C66_458A8866E03E#109102]
Input [13]: [RAWTOHEX(VISIT_ID)#108900, RAWTOHEX(PATIENT_ID)#108901, IN_DATE#108902, OUT_DATE#108903, IN_MODE#108904, OUT_MODE#108905, IN_UNIT#108906, OUT_UNIT#108907, VISIT_TYPE#108908, CHAMP_PMSI#108909, UNIT_PATH#108910, EMERGENCY#108911, CANCELED#108912]

(3) HashAggregate [codegen id : 1]
Input [14]: [COL_2D37A2DB_40AF_4056_B756_97C83B9AD5FC#109089, COL_C992DD47_AD26_4F62_B748_22E741771037#109090, COL_5C2A806C_2020_40CB_B947_459AFA5077A4#109091, COL_8D0DCF76_4096_40A7_8976_19153DFBAAE2#109092, COL_BFEFC15B_A723_414B_853B_FFA88398A37C#109093, COL_A3803123_BAB3_467D_B34A_CB32060F7F2E#109094, COL_850EAED1_1AEE_498B_B587_0008A3BE99B1#109095, COL_024A775C_C673_46D3_AB32_C1F7401A8355#109096, COL_AC8A8DDF_4EA5_4D38_8D20_8679312D7224#109097, COL_F70140D3_43C4_4FBD_ABE5_01001CF08A07#109098, COL_4F5542B0_47A6_499E_B900_FEBC09FDA3E1#109099, COL_A4355271_8DC7_4A9C_81AA_3E2855B22657#109100, COL_D0009226_9A17_4906_A60B_01C89CA97E39#109101, COL_D7C0574A_1493_44B6_8C66_458A8866E03E#109102]
Keys: []
Functions [14]: [partial_count(COL_2D37A2DB_40AF_4056_B756_97C83B9AD5FC#109089), partial_count(COL_C992DD47_AD26_4F62_B748_22E741771037#109090), partial_count(COL_5C2A806C_2020_40CB_B947_459AFA5077A4#109091), partial_count(COL_8D0DCF76_4096_40A7_8976_19153DFBAAE2#109092), partial_count(COL_BFEFC15B_A723_414B_853B_FFA88398A37C#109093), partial_count(COL_A3803123_BAB3_467D_B34A_CB32060F7F2E#109094), partial_count(COL_850EAED1_1AEE_498B_B587_0008A3BE99B1#109095), partial_count(COL_024A775C_C673_46D3_AB32_C1F7401A8355#109096), partial_count(COL_AC8A8DDF_4EA5_4D38_8D20_8679312D7224#109097), partial_count(COL_F70140D3_43C4_4FBD_ABE5_01001CF08A07#109098), partial_count(COL_4F5542B0_47A6_499E_B900_FEBC09FDA3E1#109099), partial_count(COL_A4355271_8DC7_4A9C_81AA_3E2855B22657#109100), partial_count(COL_D0009226_9A17_4906_A60B_01C89CA97E39#109101), partial_count(COL_D7C0574A_1493_44B6_8C66_458A8866E03E#109102)]
Aggregate Attributes [14]: [count#109203L, count#109204L, count#109205L, count#109206L, count#109207L, count#109208L, count#109209L, count#109210L, count#109211L, count#109212L, count#109213L, count#109214L, count#109215L, count#109216L]
Results [14]: [count#109217L, count#109218L, count#109219L, count#109220L, count#109221L, count#109222L, count#109223L, count#109224L, count#109225L, count#109226L, count#109227L, count#109228L, count#109229L, count#109230L]

(4) Exchange
Input [14]: [count#109217L, count#109218L, count#109219L, count#109220L, count#109221L, count#109222L, count#109223L, count#109224L, count#109225L, count#109226L, count#109227L, count#109228L, count#109229L, count#109230L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=17196]

(5) ShuffleQueryStage
Output [14]: [count#109217L, count#109218L, count#109219L, count#109220L, count#109221L, count#109222L, count#109223L, count#109224L, count#109225L, count#109226L, count#109227L, count#109228L, count#109229L, count#109230L]
Arguments: 0

(6) HashAggregate [codegen id : 2]
Input [14]: [count#109217L, count#109218L, count#109219L, count#109220L, count#109221L, count#109222L, count#109223L, count#109224L, count#109225L, count#109226L, count#109227L, count#109228L, count#109229L, count#109230L]
Keys: []
Functions [14]: [count(COL_2D37A2DB_40AF_4056_B756_97C83B9AD5FC#109089), count(COL_C992DD47_AD26_4F62_B748_22E741771037#109090), count(COL_5C2A806C_2020_40CB_B947_459AFA5077A4#109091), count(COL_8D0DCF76_4096_40A7_8976_19153DFBAAE2#109092), count(COL_BFEFC15B_A723_414B_853B_FFA88398A37C#109093), count(COL_A3803123_BAB3_467D_B34A_CB32060F7F2E#109094), count(COL_850EAED1_1AEE_498B_B587_0008A3BE99B1#109095), count(COL_024A775C_C673_46D3_AB32_C1F7401A8355#109096), count(COL_AC8A8DDF_4EA5_4D38_8D20_8679312D7224#109097), count(COL_F70140D3_43C4_4FBD_ABE5_01001CF08A07#109098), count(COL_4F5542B0_47A6_499E_B900_FEBC09FDA3E1#109099), count(COL_A4355271_8DC7_4A9C_81AA_3E2855B22657#109100), count(COL_D0009226_9A17_4906_A60B_01C89CA97E39#109101), count(COL_D7C0574A_1493_44B6_8C66_458A8866E03E#109102)]
Aggregate Attributes [14]: [count(COL_2D37A2DB_40AF_4056_B756_97C83B9AD5FC#109089)#109117L, count(COL_C992DD47_AD26_4F62_B748_22E741771037#109090)#109120L, count(COL_5C2A806C_2020_40CB_B947_459AFA5077A4#109091)#109123L, count(COL_8D0DCF76_4096_40A7_8976_19153DFBAAE2#109092)#109126L, count(COL_BFEFC15B_A723_414B_853B_FFA88398A37C#109093)#109129L, count(COL_A3803123_BAB3_467D_B34A_CB32060F7F2E#109094)#109132L, count(COL_850EAED1_1AEE_498B_B587_0008A3BE99B1#109095)#109135L, count(COL_024A775C_C673_46D3_AB32_C1F7401A8355#109096)#109138L, count(COL_AC8A8DDF_4EA5_4D38_8D20_8679312D7224#109097)#109141L, count(COL_F70140D3_43C4_4FBD_ABE5_01001CF08A07#109098)#109144L, count(COL_4F5542B0_47A6_499E_B900_FEBC09FDA3E1#109099)#109147L, count(COL_A4355271_8DC7_4A9C_81AA_3E2855B22657#109100)#109150L, count(COL_D0009226_9A17_4906_A60B_01C89CA97E39#109101)#109153L, count(COL_D7C0574A_1493_44B6_8C66_458A8866E03E#109102)#109156L]
Results [14]: [count(COL_2D37A2DB_40AF_4056_B756_97C83B9AD5FC#109089)#109117L AS COL_AB872E19_A86F_47CF_B546_C4BE4E4AB68D#109119L, count(COL_C992DD47_AD26_4F62_B748_22E741771037#109090)#109120L AS COL_C68B4952_B060_4E82_AA7C_3F323FC89384#109122L, count(COL_5C2A806C_2020_40CB_B947_459AFA5077A4#109091)#109123L AS COL_5DA152E4_ACCA_4B1C_A35B_D661F5DAF5CA#109125L, count(COL_8D0DCF76_4096_40A7_8976_19153DFBAAE2#109092)#109126L AS COL_550BA496_4B1E_44B5_AD21_138C09461CB0#109128L, count(COL_BFEFC15B_A723_414B_853B_FFA88398A37C#109093)#109129L AS COL_CADC065F_D427_4ECD_821B_25DDE4CE2E90#109131L, count(COL_A3803123_BAB3_467D_B34A_CB32060F7F2E#109094)#109132L AS COL_29870D9F_D340_4D3C_92C9_AECE15A8842C#109134L, count(COL_850EAED1_1AEE_498B_B587_0008A3BE99B1#109095)#109135L AS COL_3CB60FAE_68E4_4CAE_847B_90F231D04AF6#109137L, count(COL_024A775C_C673_46D3_AB32_C1F7401A8355#109096)#109138L AS COL_39B18140_2DEB_4356_8C08_A97128D010F5#109140L, count(COL_AC8A8DDF_4EA5_4D38_8D20_8679312D7224#109097)#109141L AS COL_F0F1960E_DC40_4DCF_9305_D7C990795D08#109143L, count(COL_F70140D3_43C4_4FBD_ABE5_01001CF08A07#109098)#109144L AS COL_A4781D34_9CD2_42CE_A3F1_93B334A290E2#109146L, count(COL_4F5542B0_47A6_499E_B900_FEBC09FDA3E1#109099)#109147L AS COL_71E8CCF3_9235_4D79_BB8C_2AD521977CD7#109149L, count(COL_A4355271_8DC7_4A9C_81AA_3E2855B22657#109100)#109150L AS COL_CFD8E606_555F_4779_A20E_87F976559015#109152L, count(COL_D0009226_9A17_4906_A60B_01C89CA97E39#109101)#109153L AS COL_9BB0E5ED_70C6_4E18_BB6A_549D4A9A113A#109155L, count(COL_D7C0574A_1493_44B6_8C66_458A8866E03E#109102)#109156L AS COL_DE5BA312_33DA_4484_B148_8269F3946135#109158L]

(7) Exchange
Input [14]: [count#109217L, count#109218L, count#109219L, count#109220L, count#109221L, count#109222L, count#109223L, count#109224L, count#109225L, count#109226L, count#109227L, count#109228L, count#109229L, count#109230L]
Arguments: SinglePartition, ENSURE_REQUIREMENTS, [plan_id=17187]

(8) HashAggregate
Input [14]: [count#109217L, count#109218L, count#109219L, count#109220L, count#109221L, count#109222L, count#109223L, count#109224L, count#109225L, count#109226L, count#109227L, count#109228L, count#109229L, count#109230L]
Keys: []
Functions [14]: [count(COL_2D37A2DB_40AF_4056_B756_97C83B9AD5FC#109089), count(COL_C992DD47_AD26_4F62_B748_22E741771037#109090), count(COL_5C2A806C_2020_40CB_B947_459AFA5077A4#109091), count(COL_8D0DCF76_4096_40A7_8976_19153DFBAAE2#109092), count(COL_BFEFC15B_A723_414B_853B_FFA88398A37C#109093), count(COL_A3803123_BAB3_467D_B34A_CB32060F7F2E#109094), count(COL_850EAED1_1AEE_498B_B587_0008A3BE99B1#109095), count(COL_024A775C_C673_46D3_AB32_C1F7401A8355#109096), count(COL_AC8A8DDF_4EA5_4D38_8D20_8679312D7224#109097), count(COL_F70140D3_43C4_4FBD_ABE5_01001CF08A07#109098), count(COL_4F5542B0_47A6_499E_B900_FEBC09FDA3E1#109099), count(COL_A4355271_8DC7_4A9C_81AA_3E2855B22657#109100), count(COL_D0009226_9A17_4906_A60B_01C89CA97E39#109101), count(COL_D7C0574A_1493_44B6_8C66_458A8866E03E#109102)]
Aggregate Attributes [14]: [count(COL_2D37A2DB_40AF_4056_B756_97C83B9AD5FC#109089)#109117L, count(COL_C992DD47_AD26_4F62_B748_22E741771037#109090)#109120L, count(COL_5C2A806C_2020_40CB_B947_459AFA5077A4#109091)#109123L, count(COL_8D0DCF76_4096_40A7_8976_19153DFBAAE2#109092)#109126L, count(COL_BFEFC15B_A723_414B_853B_FFA88398A37C#109093)#109129L, count(COL_A3803123_BAB3_467D_B34A_CB32060F7F2E#109094)#109132L, count(COL_850EAED1_1AEE_498B_B587_0008A3BE99B1#109095)#109135L, count(COL_024A775C_C673_46D3_AB32_C1F7401A8355#109096)#109138L, count(COL_AC8A8DDF_4EA5_4D38_8D20_8679312D7224#109097)#109141L, count(COL_F70140D3_43C4_4FBD_ABE5_01001CF08A07#109098)#109144L, count(COL_4F5542B0_47A6_499E_B900_FEBC09FDA3E1#109099)#109147L, count(COL_A4355271_8DC7_4A9C_81AA_3E2855B22657#109100)#109150L, count(COL_D0009226_9A17_4906_A60B_01C89CA97E39#109101)#109153L, count(COL_D7C0574A_1493_44B6_8C66_458A8866E03E#109102)#109156L]
Results [14]: [count(COL_2D37A2DB_40AF_4056_B756_97C83B9AD5FC#109089)#109117L AS COL_AB872E19_A86F_47CF_B546_C4BE4E4AB68D#109119L, count(COL_C992DD47_AD26_4F62_B748_22E741771037#109090)#109120L AS COL_C68B4952_B060_4E82_AA7C_3F323FC89384#109122L, count(COL_5C2A806C_2020_40CB_B947_459AFA5077A4#109091)#109123L AS COL_5DA152E4_ACCA_4B1C_A35B_D661F5DAF5CA#109125L, count(COL_8D0DCF76_4096_40A7_8976_19153DFBAAE2#109092)#109126L AS COL_550BA496_4B1E_44B5_AD21_138C09461CB0#109128L, count(COL_BFEFC15B_A723_414B_853B_FFA88398A37C#109093)#109129L AS COL_CADC065F_D427_4ECD_821B_25DDE4CE2E90#109131L, count(COL_A3803123_BAB3_467D_B34A_CB32060F7F2E#109094)#109132L AS COL_29870D9F_D340_4D3C_92C9_AECE15A8842C#109134L, count(COL_850EAED1_1AEE_498B_B587_0008A3BE99B1#109095)#109135L AS COL_3CB60FAE_68E4_4CAE_847B_90F231D04AF6#109137L, count(COL_024A775C_C673_46D3_AB32_C1F7401A8355#109096)#109138L AS COL_39B18140_2DEB_4356_8C08_A97128D010F5#109140L, count(COL_AC8A8DDF_4EA5_4D38_8D20_8679312D7224#109097)#109141L AS COL_F0F1960E_DC40_4DCF_9305_D7C990795D08#109143L, count(COL_F70140D3_43C4_4FBD_ABE5_01001CF08A07#109098)#109144L AS COL_A4781D34_9CD2_42CE_A3F1_93B334A290E2#109146L, count(COL_4F5542B0_47A6_499E_B900_FEBC09FDA3E1#109099)#109147L AS COL_71E8CCF3_9235_4D79_BB8C_2AD521977CD7#109149L, count(COL_A4355271_8DC7_4A9C_81AA_3E2855B22657#109100)#109150L AS COL_CFD8E606_555F_4779_A20E_87F976559015#109152L, count(COL_D0009226_9A17_4906_A60B_01C89CA97E39#109101)#109153L AS COL_9BB0E5ED_70C6_4E18_BB6A_549D4A9A113A#109155L, count(COL_D7C0574A_1493_44B6_8C66_458A8866E03E#109102)#109156L AS COL_DE5BA312_33DA_4484_B148_8269F3946135#109158L]

(9) AdaptiveSparkPlan
Output [14]: [COL_AB872E19_A86F_47CF_B546_C4BE4E4AB68D#109119L, COL_C68B4952_B060_4E82_AA7C_3F323FC89384#109122L, COL_5DA152E4_ACCA_4B1C_A35B_D661F5DAF5CA#109125L, COL_550BA496_4B1E_44B5_AD21_138C09461CB0#109128L, COL_CADC065F_D427_4ECD_821B_25DDE4CE2E90#109131L, COL_29870D9F_D340_4D3C_92C9_AECE15A8842C#109134L, COL_3CB60FAE_68E4_4CAE_847B_90F231D04AF6#109137L, COL_39B18140_2DEB_4356_8C08_A97128D010F5#109140L, COL_F0F1960E_DC40_4DCF_9305_D7C990795D08#109143L, COL_A4781D34_9CD2_42CE_A3F1_93B334A290E2#109146L, COL_71E8CCF3_9235_4D79_BB8C_2AD521977CD7#109149L, COL_CFD8E606_555F_4779_A20E_87F976559015#109152L, COL_9BB0E5ED_70C6_4E18_BB6A_549D4A9A113A#109155L, COL_DE5BA312_33DA_4484_B148_8269F3946135#109158L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

Name	Value
spark.sql.optimizer.nestedPredicatePushdown.supportedFileSources	parquet,orc,geoparquet