SP1 - Details for Query 221

Submitted Time: 2026/08/27 08:57:59
Duration: 0.5 s
Succeeded Jobs: 262 263

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

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label=" TakeOrderedAndProject "]; subgraph cluster2 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 14 ms"; 3 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build: 2 ms peak memory: 16.3 MiB number of output rows: 81 number of sort fallback tasks: 0 avg hash probes per key: 1"]; } 4 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 17.9 KiB number of coalesced partitions: 1"]; 5 [labelType="html" label="Exchange shuffle records written: 260 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 25 ms (2 ms, 5 ms, 8 ms (stage 371.0: task 470)) 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: 260 local bytes read: 17.1 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 5 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 24.6 KiB (4.1 KiB, 5.1 KiB, 5.6 KiB (stage 371.0: task 472)) local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written total (min, med, max (stageId: taskId)) 17.1 KiB (2.9 KiB, 3.6 KiB, 3.8 KiB (stage 371.0: task 469))"]; subgraph cluster6 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n429 ms (76 ms, 80 ms, 99 ms (stage 371.0: task 470))"; 7 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 62 ms (10 ms, 12 ms, 16 ms (stage 371.0: task 470)) peak memory total (min, med, max (stageId: taskId)) 1280.0 KiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 371.0: task 473)) number of output rows: 260 number of sort fallback tasks: 0 avg hash probes per key: 0"]; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label="Filter number of output rows: 4,038"]; 10 [labelType="html" label="ColumnarToRow number of output rows: 5,919 number of input batches: 5"]; } 11 [labelType="html" label="Scan parquet number of files read: 5 scan time total (min, med, max (stageId: taskId)) 26 ms (4 ms, 5 ms, 7 ms (stage 371.0: task 472)) metadata time: 0 ms size of files read: 88.8 KiB number of output rows: 5,919"]; 1->0; 3->1; 4->3; 5->4; 7->5; 8->7; 9->8; 10->9; 11->10; }

AdaptiveSparkPlan isFinalPlan=true

TakeOrderedAndProject(limit=500000, orderBy=[COL_16C813F0_61D6_449B_BA29_F63CA8A892C1#43330L DESC NULLS LAST], output=[COL_E5EC2FF8_B626_4684_987C_1C9A71390D2D#43269,COL_4C11BDF3_742A_40EF_8ECA_D91A13D1DE1E#43270,COL_07879775_345A_44D9_B3BB_832FEBC491AD#43271,COL_16C813F0_61D6_449B_BA29_F63CA8A892C1#43330L,COL_08D99AA7_BDCC_4335_BE54_A78312BB1A47#43272])

HashAggregate(keys=[COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046, COL_54C41EF5_CBEE_4CF2_9156_B99220DFB096#43052, COL_EADB3748_0541_473F_A1BE_234C1DE44242#43058, COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062], functions=[count(COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046)])

WholeStageCodegen (2)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046, COL_54C41EF5_CBEE_4CF2_9156_B99220DFB096#43052, COL_EADB3748_0541_473F_A1BE_234C1DE44242#43058, COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062, 10), ENSURE_REQUIREMENTS, [plan_id=8517]

HashAggregate(keys=[COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046, COL_54C41EF5_CBEE_4CF2_9156_B99220DFB096#43052, COL_EADB3748_0541_473F_A1BE_234C1DE44242#43058, knownfloatingpointnormalized(normalizenanandzero(COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062)) AS COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062], functions=[partial_count(COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046)])

Project [COL_837E71CE_F46B_4AD9_AC11_7F64C82B0E94#42751 AS COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046, COL_43AA8F54_454A_484E_80C7_3AD4D9D2CDC0#42754 AS COL_54C41EF5_CBEE_4CF2_9156_B99220DFB096#43052, COL_09B86704_65FE_437B_B8F5_DBBC01A6FA80#42757 AS COL_EADB3748_0541_473F_A1BE_234C1DE44242#43058, COL_1C6DC50B_F3EB_4AC3_A3E7_648EA4B25CE6#42759 AS COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062]

Filter NOT (str_remove_accent(upper(COL_023941C4_6DC9_4F47_BDB9_32BBA36217CD#42765)) <=> 2)

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_837E71CE_F46B_4AD9_AC11_7F64C82B0E94#42751,COL_43AA8F54_454A_484E_80C7_3AD4D9D2CDC0#42754,COL_09B86704_65FE_437B_B8F5_DBBC01A6FA80#42757,COL_1C6DC50B_F3EB_4AC3_A3E7_648EA4B25CE6#42759,COL_023941C4_6DC9_4F47_BDB9_32BBA36217CD#42765] Batched: true, DataFilters: [NOT (str_remove_accent(upper(COL_023941C4_6DC9_4F47_BDB9_32BBA36217CD#42765)) <=> 2)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/RHA_2021_CSARR__57211], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_837E71CE_F46B_4AD9_AC11_7F64C82B0E94:string,COL_43AA8F54_454A_484E_80C7_3AD4D9D2CDC0:s...

Details

== Physical Plan ==
AdaptiveSparkPlan (17)
+- == Final Plan ==
   TakeOrderedAndProject (10)
   +- * HashAggregate (9)
      +- AQEShuffleRead (8)
         +- ShuffleQueryStage (7), Statistics(sizeInBytes=24.6 KiB, rowCount=260)
            +- Exchange (6)
               +- * HashAggregate (5)
                  +- * Project (4)
                     +- * Filter (3)
                        +- * ColumnarToRow (2)
                           +- Scan parquet  (1)
+- == Initial Plan ==
   TakeOrderedAndProject (16)
   +- HashAggregate (15)
      +- Exchange (14)
         +- HashAggregate (13)
            +- Project (12)
               +- Filter (11)
                  +- Scan parquet  (1)


(1) Scan parquet 
Output [5]: [COL_837E71CE_F46B_4AD9_AC11_7F64C82B0E94#42751, COL_43AA8F54_454A_484E_80C7_3AD4D9D2CDC0#42754, COL_09B86704_65FE_437B_B8F5_DBBC01A6FA80#42757, COL_1C6DC50B_F3EB_4AC3_A3E7_648EA4B25CE6#42759, COL_023941C4_6DC9_4F47_BDB9_32BBA36217CD#42765]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/RHA_2021_CSARR__57211]
ReadSchema: struct<COL_837E71CE_F46B_4AD9_AC11_7F64C82B0E94:string,COL_43AA8F54_454A_484E_80C7_3AD4D9D2CDC0:string,COL_09B86704_65FE_437B_B8F5_DBBC01A6FA80:string,COL_1C6DC50B_F3EB_4AC3_A3E7_648EA4B25CE6:double,COL_023941C4_6DC9_4F47_BDB9_32BBA36217CD:string>

(2) ColumnarToRow [codegen id : 1]
Input [5]: [COL_837E71CE_F46B_4AD9_AC11_7F64C82B0E94#42751, COL_43AA8F54_454A_484E_80C7_3AD4D9D2CDC0#42754, COL_09B86704_65FE_437B_B8F5_DBBC01A6FA80#42757, COL_1C6DC50B_F3EB_4AC3_A3E7_648EA4B25CE6#42759, COL_023941C4_6DC9_4F47_BDB9_32BBA36217CD#42765]

(3) Filter [codegen id : 1]
Input [5]: [COL_837E71CE_F46B_4AD9_AC11_7F64C82B0E94#42751, COL_43AA8F54_454A_484E_80C7_3AD4D9D2CDC0#42754, COL_09B86704_65FE_437B_B8F5_DBBC01A6FA80#42757, COL_1C6DC50B_F3EB_4AC3_A3E7_648EA4B25CE6#42759, COL_023941C4_6DC9_4F47_BDB9_32BBA36217CD#42765]
Condition : NOT (str_remove_accent(upper(COL_023941C4_6DC9_4F47_BDB9_32BBA36217CD#42765)) <=> 2)

(4) Project [codegen id : 1]
Output [4]: [COL_837E71CE_F46B_4AD9_AC11_7F64C82B0E94#42751 AS COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046, COL_43AA8F54_454A_484E_80C7_3AD4D9D2CDC0#42754 AS COL_54C41EF5_CBEE_4CF2_9156_B99220DFB096#43052, COL_09B86704_65FE_437B_B8F5_DBBC01A6FA80#42757 AS COL_EADB3748_0541_473F_A1BE_234C1DE44242#43058, COL_1C6DC50B_F3EB_4AC3_A3E7_648EA4B25CE6#42759 AS COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062]
Input [5]: [COL_837E71CE_F46B_4AD9_AC11_7F64C82B0E94#42751, COL_43AA8F54_454A_484E_80C7_3AD4D9D2CDC0#42754, COL_09B86704_65FE_437B_B8F5_DBBC01A6FA80#42757, COL_1C6DC50B_F3EB_4AC3_A3E7_648EA4B25CE6#42759, COL_023941C4_6DC9_4F47_BDB9_32BBA36217CD#42765]

(5) HashAggregate [codegen id : 1]
Input [4]: [COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046, COL_54C41EF5_CBEE_4CF2_9156_B99220DFB096#43052, COL_EADB3748_0541_473F_A1BE_234C1DE44242#43058, COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062]
Keys [4]: [COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046, COL_54C41EF5_CBEE_4CF2_9156_B99220DFB096#43052, COL_EADB3748_0541_473F_A1BE_234C1DE44242#43058, knownfloatingpointnormalized(normalizenanandzero(COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062)) AS COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062]
Functions [1]: [partial_count(COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046)]
Aggregate Attributes [1]: [count#43601L]
Results [5]: [COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046, COL_54C41EF5_CBEE_4CF2_9156_B99220DFB096#43052, COL_EADB3748_0541_473F_A1BE_234C1DE44242#43058, COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062, count#43602L]

(6) Exchange
Input [5]: [COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046, COL_54C41EF5_CBEE_4CF2_9156_B99220DFB096#43052, COL_EADB3748_0541_473F_A1BE_234C1DE44242#43058, COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062, count#43602L]
Arguments: hashpartitioning(COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046, COL_54C41EF5_CBEE_4CF2_9156_B99220DFB096#43052, COL_EADB3748_0541_473F_A1BE_234C1DE44242#43058, COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062, 10), ENSURE_REQUIREMENTS, [plan_id=8517]

(7) ShuffleQueryStage
Output [5]: [COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046, COL_54C41EF5_CBEE_4CF2_9156_B99220DFB096#43052, COL_EADB3748_0541_473F_A1BE_234C1DE44242#43058, COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062, count#43602L]
Arguments: 0

(8) AQEShuffleRead
Input [5]: [COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046, COL_54C41EF5_CBEE_4CF2_9156_B99220DFB096#43052, COL_EADB3748_0541_473F_A1BE_234C1DE44242#43058, COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062, count#43602L]
Arguments: coalesced

(9) HashAggregate [codegen id : 2]
Input [5]: [COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046, COL_54C41EF5_CBEE_4CF2_9156_B99220DFB096#43052, COL_EADB3748_0541_473F_A1BE_234C1DE44242#43058, COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062, count#43602L]
Keys [4]: [COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046, COL_54C41EF5_CBEE_4CF2_9156_B99220DFB096#43052, COL_EADB3748_0541_473F_A1BE_234C1DE44242#43058, COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062]
Functions [1]: [count(COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046)]
Aggregate Attributes [1]: [count(COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046)#43322L]
Results [5]: [COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046 AS COL_E5EC2FF8_B626_4684_987C_1C9A71390D2D#43269, COL_54C41EF5_CBEE_4CF2_9156_B99220DFB096#43052 AS COL_4C11BDF3_742A_40EF_8ECA_D91A13D1DE1E#43270, COL_EADB3748_0541_473F_A1BE_234C1DE44242#43058 AS COL_07879775_345A_44D9_B3BB_832FEBC491AD#43271, COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062 AS COL_08D99AA7_BDCC_4335_BE54_A78312BB1A47#43272, count(COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046)#43322L AS COL_16C813F0_61D6_449B_BA29_F63CA8A892C1#43330L]

(10) TakeOrderedAndProject
Input [5]: [COL_E5EC2FF8_B626_4684_987C_1C9A71390D2D#43269, COL_4C11BDF3_742A_40EF_8ECA_D91A13D1DE1E#43270, COL_07879775_345A_44D9_B3BB_832FEBC491AD#43271, COL_08D99AA7_BDCC_4335_BE54_A78312BB1A47#43272, COL_16C813F0_61D6_449B_BA29_F63CA8A892C1#43330L]
Arguments: 500000, [COL_16C813F0_61D6_449B_BA29_F63CA8A892C1#43330L DESC NULLS LAST], [COL_E5EC2FF8_B626_4684_987C_1C9A71390D2D#43269, COL_4C11BDF3_742A_40EF_8ECA_D91A13D1DE1E#43270, COL_07879775_345A_44D9_B3BB_832FEBC491AD#43271, COL_16C813F0_61D6_449B_BA29_F63CA8A892C1#43330L, COL_08D99AA7_BDCC_4335_BE54_A78312BB1A47#43272]

(11) Filter
Input [5]: [COL_837E71CE_F46B_4AD9_AC11_7F64C82B0E94#42751, COL_43AA8F54_454A_484E_80C7_3AD4D9D2CDC0#42754, COL_09B86704_65FE_437B_B8F5_DBBC01A6FA80#42757, COL_1C6DC50B_F3EB_4AC3_A3E7_648EA4B25CE6#42759, COL_023941C4_6DC9_4F47_BDB9_32BBA36217CD#42765]
Condition : NOT (str_remove_accent(upper(COL_023941C4_6DC9_4F47_BDB9_32BBA36217CD#42765)) <=> 2)

(12) Project
Output [4]: [COL_837E71CE_F46B_4AD9_AC11_7F64C82B0E94#42751 AS COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046, COL_43AA8F54_454A_484E_80C7_3AD4D9D2CDC0#42754 AS COL_54C41EF5_CBEE_4CF2_9156_B99220DFB096#43052, COL_09B86704_65FE_437B_B8F5_DBBC01A6FA80#42757 AS COL_EADB3748_0541_473F_A1BE_234C1DE44242#43058, COL_1C6DC50B_F3EB_4AC3_A3E7_648EA4B25CE6#42759 AS COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062]
Input [5]: [COL_837E71CE_F46B_4AD9_AC11_7F64C82B0E94#42751, COL_43AA8F54_454A_484E_80C7_3AD4D9D2CDC0#42754, COL_09B86704_65FE_437B_B8F5_DBBC01A6FA80#42757, COL_1C6DC50B_F3EB_4AC3_A3E7_648EA4B25CE6#42759, COL_023941C4_6DC9_4F47_BDB9_32BBA36217CD#42765]

(13) HashAggregate
Input [4]: [COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046, COL_54C41EF5_CBEE_4CF2_9156_B99220DFB096#43052, COL_EADB3748_0541_473F_A1BE_234C1DE44242#43058, COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062]
Keys [4]: [COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046, COL_54C41EF5_CBEE_4CF2_9156_B99220DFB096#43052, COL_EADB3748_0541_473F_A1BE_234C1DE44242#43058, knownfloatingpointnormalized(normalizenanandzero(COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062)) AS COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062]
Functions [1]: [partial_count(COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046)]
Aggregate Attributes [1]: [count#43601L]
Results [5]: [COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046, COL_54C41EF5_CBEE_4CF2_9156_B99220DFB096#43052, COL_EADB3748_0541_473F_A1BE_234C1DE44242#43058, COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062, count#43602L]

(14) Exchange
Input [5]: [COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046, COL_54C41EF5_CBEE_4CF2_9156_B99220DFB096#43052, COL_EADB3748_0541_473F_A1BE_234C1DE44242#43058, COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062, count#43602L]
Arguments: hashpartitioning(COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046, COL_54C41EF5_CBEE_4CF2_9156_B99220DFB096#43052, COL_EADB3748_0541_473F_A1BE_234C1DE44242#43058, COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062, 10), ENSURE_REQUIREMENTS, [plan_id=8455]

(15) HashAggregate
Input [5]: [COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046, COL_54C41EF5_CBEE_4CF2_9156_B99220DFB096#43052, COL_EADB3748_0541_473F_A1BE_234C1DE44242#43058, COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062, count#43602L]
Keys [4]: [COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046, COL_54C41EF5_CBEE_4CF2_9156_B99220DFB096#43052, COL_EADB3748_0541_473F_A1BE_234C1DE44242#43058, COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062]
Functions [1]: [count(COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046)]
Aggregate Attributes [1]: [count(COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046)#43322L]
Results [5]: [COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046 AS COL_E5EC2FF8_B626_4684_987C_1C9A71390D2D#43269, COL_54C41EF5_CBEE_4CF2_9156_B99220DFB096#43052 AS COL_4C11BDF3_742A_40EF_8ECA_D91A13D1DE1E#43270, COL_EADB3748_0541_473F_A1BE_234C1DE44242#43058 AS COL_07879775_345A_44D9_B3BB_832FEBC491AD#43271, COL_94DFFD83_94F7_4572_AE5C_30DF927A7562#43062 AS COL_08D99AA7_BDCC_4335_BE54_A78312BB1A47#43272, count(COL_DD7F9735_9A4C_4308_AD7B_02A2A8E21D48#43046)#43322L AS COL_16C813F0_61D6_449B_BA29_F63CA8A892C1#43330L]

(16) TakeOrderedAndProject
Input [5]: [COL_E5EC2FF8_B626_4684_987C_1C9A71390D2D#43269, COL_4C11BDF3_742A_40EF_8ECA_D91A13D1DE1E#43270, COL_07879775_345A_44D9_B3BB_832FEBC491AD#43271, COL_08D99AA7_BDCC_4335_BE54_A78312BB1A47#43272, COL_16C813F0_61D6_449B_BA29_F63CA8A892C1#43330L]
Arguments: 500000, [COL_16C813F0_61D6_449B_BA29_F63CA8A892C1#43330L DESC NULLS LAST], [COL_E5EC2FF8_B626_4684_987C_1C9A71390D2D#43269, COL_4C11BDF3_742A_40EF_8ECA_D91A13D1DE1E#43270, COL_07879775_345A_44D9_B3BB_832FEBC491AD#43271, COL_16C813F0_61D6_449B_BA29_F63CA8A892C1#43330L, COL_08D99AA7_BDCC_4335_BE54_A78312BB1A47#43272]

(17) AdaptiveSparkPlan
Output [5]: [COL_E5EC2FF8_B626_4684_987C_1C9A71390D2D#43269, COL_4C11BDF3_742A_40EF_8ECA_D91A13D1DE1E#43270, COL_07879775_345A_44D9_B3BB_832FEBC491AD#43271, COL_16C813F0_61D6_449B_BA29_F63CA8A892C1#43330L, COL_08D99AA7_BDCC_4335_BE54_A78312BB1A47#43272]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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