SP1 - Details for Query 840

Submitted Time: 2026/02/24 09:35:47
Duration: 0.6 s
Succeeded Jobs: 1091 1093 1094 1095 1096 1097

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 (6)\n \nduration: 33 ms"; 2 [labelType="html" label="Filter number of output rows: 0"]; } 3 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 43 ms"; 5 [labelType="html" label="Sort sort time: 1 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 6 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 280.7 KiB number of coalesced partitions: 1"]; 7 [labelType="html" label="Exchange shuffle records written: 3,280 local merged chunks fetched: 0 shuffle write time: 2 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: 3,280 local bytes read: 264.5 KiB 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: 939.5 KiB 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: 264.5 KiB"]; 8 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 17 ms"; 10 [labelType="html" label="Sort sort time: 1 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 11 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 304.2 KiB number of coalesced partitions: 1"]; 12 [labelType="html" label="Exchange shuffle records written: 3,280 local merged chunks fetched: 0 shuffle write time: 2 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: 3,280 local bytes read: 290.7 KiB 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: 913.9 KiB 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: 290.7 KiB"]; subgraph cluster13 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 23 ms"; 14 [labelType="html" label=" Project "]; 15 [labelType="html" label="Sort sort time: 1 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 16 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 173.8 KiB number of coalesced partitions: 1"]; 17 [labelType="html" label="Exchange shuffle records written: 3,280 local merged chunks fetched: 0 shuffle write time: 1 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: 3,280 local bytes read: 166.9 KiB 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: 446.2 KiB local merged bytes read: 0.0 B number of partitions: 7 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 166.9 KiB"]; subgraph cluster18 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n18 ms (8 ms, 10 ms, 10 ms (stage 1453.0: task 2014))"; 19 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 9 ms (4 ms, 5 ms, 5 ms (stage 1453.0: task 2014)) peak memory total (min, med, max (stageId: taskId)) 512.0 KiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 1451.0: task 2013)) number of output rows: 6,560 number of sort fallback tasks: 0 avg hash probes per key: 0"]; } 20 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 202.8 KiB number of coalesced partitions: 1"]; 21 [labelType="html" label="Exchange shuffle records written: 3,280 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 10 ms (1 ms, 1 ms, 1 ms (stage 1448.0: task 2008)) 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: 6,560 local bytes read total (min, med, max (stageId: taskId)) 385.6 KiB (192.8 KiB, 192.8 KiB, 192.8 KiB (stage 1451.0: task 2013)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1451.0: task 2013)) remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 12 remote merged chunks fetched: 0 remote blocks read: 0 data size total (min, med, max (stageId: taskId)) 446.2 KiB (1112.0 B, 28.7 KiB, 319.0 KiB (stage 1448.0: task 2006)) 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)) 192.8 KiB (1083.0 B, 17.5 KiB, 122.6 KiB (stage 1448.0: task 2006))"]; subgraph cluster22 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n815 ms (124 ms, 140 ms, 141 ms (stage 1448.0: task 2007))"; 23 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 727 ms (110 ms, 124 ms, 126 ms (stage 1448.0: task 2009)) peak memory total (min, med, max (stageId: taskId)) 1536.0 KiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 1448.0: task 2011)) number of output rows: 3,280 number of sort fallback tasks: 0 avg hash probes per key: 0"]; 24 [labelType="html" label=" Project "]; 25 [labelType="html" label="Filter number of output rows: 37,338"]; 26 [labelType="html" label="ColumnarToRow number of output rows: 81,008 number of input batches: 25"]; } 27 [labelType="html" label="Scan parquet number of files read: 12 scan time total (min, med, max (stageId: taskId)) 312 ms (6 ms, 73 ms, 77 ms (stage 1448.0: task 2010)) metadata time: 0 ms size of files read: 5.2 MiB number of output rows: 81,008"]; 2->0; 3->2; 5->3; 6->5; 7->6; 8->7; 10->8; 11->10; 12->11; 14->12; 15->14; 16->15; 17->16; 19->17; 20->19; 21->20; 23->21; 24->23; 25->24; 26->25; 27->26; }

AdaptiveSparkPlan isFinalPlan=true

Filter (CASE WHEN isnull(StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379)), Z6)) THEN false ELSE StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379)), Z6) END AND (COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#246436L > 6))

WholeStageCodegen (6)

Window [count(1) windowspecdefinition(COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#246467L], [COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403], [1 DESC NULLS LAST]

Sort [COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403, 10), ENSURE_REQUIREMENTS, [plan_id=24186]

Window [count(1) windowspecdefinition(COL_74CB5837_B051_4D74_88FC_80227199D913#246390, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#246436L], [COL_74CB5837_B051_4D74_88FC_80227199D913#246390], [1 DESC NULLS LAST]

Sort [COL_74CB5837_B051_4D74_88FC_80227199D913#246390 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_74CB5837_B051_4D74_88FC_80227199D913#246390, 10), ENSURE_REQUIREMENTS, [plan_id=24138]

Project [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, vers, LEFT) AS COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, vers, RIGHT) AS COL_C0071F45_39F2_4647_A05D_4CE10B360D89#246384, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, >, LEFT), ALL) AS COL_74CB5837_B051_4D74_88FC_80227199D913#246390, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, >, RIGHT), ALL) AS COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403]

Sort [COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L DESC NULLS LAST], true, 0

WholeStageCodegen (3)

AQEShuffleRead coalesced

Exchange rangepartitioning(COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L DESC NULLS LAST, 10), ENSURE_REQUIREMENTS, [plan_id=24076]

HashAggregate(keys=[COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#245940, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#245938, COL_447775BC_9753_403A_8C59_368E68ECF1A1#245939L], functions=[])

WholeStageCodegen (2)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#245940, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#245938, COL_447775BC_9753_403A_8C59_368E68ECF1A1#245939L, 10), ENSURE_REQUIREMENTS, [plan_id=23999]

HashAggregate(keys=[COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#245940, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#245938, COL_447775BC_9753_403A_8C59_368E68ECF1A1#245939L], functions=[])

Project [COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#245274 AS COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#245938, COL_08215A85_C797_468A_A885_85343F2B85C7#245277L AS COL_447775BC_9753_403A_8C59_368E68ECF1A1#245939L, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#245275 AS COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#245940]

Filter ((CASE WHEN isnull(((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#245222 >= 43.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#245222 <= 120.0))) THEN false ELSE ((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#245222 >= 43.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#245222 <= 120.0)) END AND isnotnull(str_remove_accent(upper(COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#245261)))) AND isnotnull(str_remove_accent(upper(COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#245262))))

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#245222,COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#245261,COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#245262,COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#245274,COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#245275,COL_08215A85_C797_468A_A885_85343F2B85C7#245277L] Batched: true, DataFilters: [CASE WHEN isnull(((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#245222 >= 43.0) AND (COL_730E830A_DE..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/PU_FICHIER_FICT_253787], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_730E830A_DE0D_4568_81F4_ED74ECA509F0:double,COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016:s...

Details

== Physical Plan ==
AdaptiveSparkPlan (42)
+- == Final Plan ==
   * Filter (25)
   +- Window (24)
      +- * Sort (23)
         +- AQEShuffleRead (22)
            +- ShuffleQueryStage (21), Statistics(sizeInBytes=939.5 KiB, rowCount=3.28E+3)
               +- Exchange (20)
                  +- Window (19)
                     +- * Sort (18)
                        +- AQEShuffleRead (17)
                           +- ShuffleQueryStage (16), Statistics(sizeInBytes=913.9 KiB, rowCount=3.28E+3)
                              +- Exchange (15)
                                 +- * Project (14)
                                    +- * Sort (13)
                                       +- AQEShuffleRead (12)
                                          +- ShuffleQueryStage (11), Statistics(sizeInBytes=446.2 KiB, rowCount=3.28E+3)
                                             +- Exchange (10)
                                                +- * HashAggregate (9)
                                                   +- AQEShuffleRead (8)
                                                      +- ShuffleQueryStage (7), Statistics(sizeInBytes=446.2 KiB, rowCount=3.28E+3)
                                                         +- Exchange (6)
                                                            +- * HashAggregate (5)
                                                               +- * Project (4)
                                                                  +- * Filter (3)
                                                                     +- * ColumnarToRow (2)
                                                                        +- Scan parquet  (1)
+- == Initial Plan ==
   CollectLimit (41)
   +- Filter (40)
      +- Window (39)
         +- Sort (38)
            +- Exchange (37)
               +- Window (36)
                  +- Sort (35)
                     +- Exchange (34)
                        +- Project (33)
                           +- Sort (32)
                              +- Exchange (31)
                                 +- HashAggregate (30)
                                    +- Exchange (29)
                                       +- HashAggregate (28)
                                          +- Project (27)
                                             +- Filter (26)
                                                +- Scan parquet  (1)


(1) Scan parquet 
Output [6]: [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#245222, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#245261, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#245262, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#245274, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#245275, COL_08215A85_C797_468A_A885_85343F2B85C7#245277L]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/PU_FICHIER_FICT_253787]
ReadSchema: struct<COL_730E830A_DE0D_4568_81F4_ED74ECA509F0:double,COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016:string,COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268:string,COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2:string,COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E:string,COL_08215A85_C797_468A_A885_85343F2B85C7:bigint>

(2) ColumnarToRow [codegen id : 1]
Input [6]: [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#245222, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#245261, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#245262, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#245274, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#245275, COL_08215A85_C797_468A_A885_85343F2B85C7#245277L]

(3) Filter [codegen id : 1]
Input [6]: [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#245222, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#245261, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#245262, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#245274, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#245275, COL_08215A85_C797_468A_A885_85343F2B85C7#245277L]
Condition : ((CASE WHEN isnull(((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#245222 >= 43.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#245222 <= 120.0))) THEN false ELSE ((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#245222 >= 43.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#245222 <= 120.0)) END AND isnotnull(str_remove_accent(upper(COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#245261)))) AND isnotnull(str_remove_accent(upper(COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#245262))))

(4) Project [codegen id : 1]
Output [3]: [COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#245274 AS COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#245938, COL_08215A85_C797_468A_A885_85343F2B85C7#245277L AS COL_447775BC_9753_403A_8C59_368E68ECF1A1#245939L, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#245275 AS COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#245940]
Input [6]: [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#245222, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#245261, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#245262, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#245274, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#245275, COL_08215A85_C797_468A_A885_85343F2B85C7#245277L]

(5) HashAggregate [codegen id : 1]
Input [3]: [COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#245938, COL_447775BC_9753_403A_8C59_368E68ECF1A1#245939L, COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#245940]
Keys [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#245940, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#245938, COL_447775BC_9753_403A_8C59_368E68ECF1A1#245939L]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#245940, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#245938, COL_447775BC_9753_403A_8C59_368E68ECF1A1#245939L]

(6) Exchange
Input [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#245940, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#245938, COL_447775BC_9753_403A_8C59_368E68ECF1A1#245939L]
Arguments: hashpartitioning(COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#245940, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#245938, COL_447775BC_9753_403A_8C59_368E68ECF1A1#245939L, 10), ENSURE_REQUIREMENTS, [plan_id=23999]

(7) ShuffleQueryStage
Output [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#245940, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#245938, COL_447775BC_9753_403A_8C59_368E68ECF1A1#245939L]
Arguments: 0

(8) AQEShuffleRead
Input [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#245940, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#245938, COL_447775BC_9753_403A_8C59_368E68ECF1A1#245939L]
Arguments: coalesced

(9) HashAggregate [codegen id : 2]
Input [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#245940, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#245938, COL_447775BC_9753_403A_8C59_368E68ECF1A1#245939L]
Keys [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#245940, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#245938, COL_447775BC_9753_403A_8C59_368E68ECF1A1#245939L]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#245940 AS COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#245938 AS COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_447775BC_9753_403A_8C59_368E68ECF1A1#245939L AS COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L]

(10) Exchange
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L]
Arguments: rangepartitioning(COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L DESC NULLS LAST, 10), ENSURE_REQUIREMENTS, [plan_id=24076]

(11) ShuffleQueryStage
Output [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L]
Arguments: 1

(12) AQEShuffleRead
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L]
Arguments: coalesced

(13) Sort [codegen id : 3]
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L]
Arguments: [COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L DESC NULLS LAST], true, 0

(14) Project [codegen id : 3]
Output [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, vers, LEFT) AS COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, vers, RIGHT) AS COL_C0071F45_39F2_4647_A05D_4CE10B360D89#246384, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, >, LEFT), ALL) AS COL_74CB5837_B051_4D74_88FC_80227199D913#246390, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, >, RIGHT), ALL) AS COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403]
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L]

(15) Exchange
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#246384, COL_74CB5837_B051_4D74_88FC_80227199D913#246390, COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403]
Arguments: hashpartitioning(COL_74CB5837_B051_4D74_88FC_80227199D913#246390, 10), ENSURE_REQUIREMENTS, [plan_id=24138]

(16) ShuffleQueryStage
Output [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#246384, COL_74CB5837_B051_4D74_88FC_80227199D913#246390, COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403]
Arguments: 2

(17) AQEShuffleRead
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#246384, COL_74CB5837_B051_4D74_88FC_80227199D913#246390, COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403]
Arguments: coalesced

(18) Sort [codegen id : 4]
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#246384, COL_74CB5837_B051_4D74_88FC_80227199D913#246390, COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403]
Arguments: [COL_74CB5837_B051_4D74_88FC_80227199D913#246390 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(19) Window
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#246384, COL_74CB5837_B051_4D74_88FC_80227199D913#246390, COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403]
Arguments: [count(1) windowspecdefinition(COL_74CB5837_B051_4D74_88FC_80227199D913#246390, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#246436L], [COL_74CB5837_B051_4D74_88FC_80227199D913#246390], [1 DESC NULLS LAST]

(20) Exchange
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#246384, COL_74CB5837_B051_4D74_88FC_80227199D913#246390, COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#246436L]
Arguments: hashpartitioning(COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403, 10), ENSURE_REQUIREMENTS, [plan_id=24186]

(21) ShuffleQueryStage
Output [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#246384, COL_74CB5837_B051_4D74_88FC_80227199D913#246390, COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#246436L]
Arguments: 3

(22) AQEShuffleRead
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#246384, COL_74CB5837_B051_4D74_88FC_80227199D913#246390, COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#246436L]
Arguments: coalesced

(23) Sort [codegen id : 5]
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#246384, COL_74CB5837_B051_4D74_88FC_80227199D913#246390, COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#246436L]
Arguments: [COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(24) Window
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#246384, COL_74CB5837_B051_4D74_88FC_80227199D913#246390, COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#246436L]
Arguments: [count(1) windowspecdefinition(COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#246467L], [COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403], [1 DESC NULLS LAST]

(25) Filter [codegen id : 6]
Input [9]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#246384, COL_74CB5837_B051_4D74_88FC_80227199D913#246390, COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#246436L, COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#246467L]
Condition : (CASE WHEN isnull(StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379)), Z6)) THEN false ELSE StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379)), Z6) END AND (COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#246436L > 6))

(26) Filter
Input [6]: [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#245222, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#245261, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#245262, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#245274, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#245275, COL_08215A85_C797_468A_A885_85343F2B85C7#245277L]
Condition : ((CASE WHEN isnull(((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#245222 >= 43.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#245222 <= 120.0))) THEN false ELSE ((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#245222 >= 43.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#245222 <= 120.0)) END AND isnotnull(str_remove_accent(upper(COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#245261)))) AND isnotnull(str_remove_accent(upper(COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#245262))))

(27) Project
Output [3]: [COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#245274 AS COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#245938, COL_08215A85_C797_468A_A885_85343F2B85C7#245277L AS COL_447775BC_9753_403A_8C59_368E68ECF1A1#245939L, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#245275 AS COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#245940]
Input [6]: [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#245222, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#245261, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#245262, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#245274, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#245275, COL_08215A85_C797_468A_A885_85343F2B85C7#245277L]

(28) HashAggregate
Input [3]: [COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#245938, COL_447775BC_9753_403A_8C59_368E68ECF1A1#245939L, COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#245940]
Keys [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#245940, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#245938, COL_447775BC_9753_403A_8C59_368E68ECF1A1#245939L]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#245940, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#245938, COL_447775BC_9753_403A_8C59_368E68ECF1A1#245939L]

(29) Exchange
Input [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#245940, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#245938, COL_447775BC_9753_403A_8C59_368E68ECF1A1#245939L]
Arguments: hashpartitioning(COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#245940, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#245938, COL_447775BC_9753_403A_8C59_368E68ECF1A1#245939L, 10), ENSURE_REQUIREMENTS, [plan_id=23947]

(30) HashAggregate
Input [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#245940, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#245938, COL_447775BC_9753_403A_8C59_368E68ECF1A1#245939L]
Keys [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#245940, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#245938, COL_447775BC_9753_403A_8C59_368E68ECF1A1#245939L]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#245940 AS COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#245938 AS COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_447775BC_9753_403A_8C59_368E68ECF1A1#245939L AS COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L]

(31) Exchange
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L]
Arguments: rangepartitioning(COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L DESC NULLS LAST, 10), ENSURE_REQUIREMENTS, [plan_id=23950]

(32) Sort
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L]
Arguments: [COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L DESC NULLS LAST], true, 0

(33) Project
Output [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, vers, LEFT) AS COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, vers, RIGHT) AS COL_C0071F45_39F2_4647_A05D_4CE10B360D89#246384, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, >, LEFT), ALL) AS COL_74CB5837_B051_4D74_88FC_80227199D913#246390, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, >, RIGHT), ALL) AS COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403]
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L]

(34) Exchange
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#246384, COL_74CB5837_B051_4D74_88FC_80227199D913#246390, COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403]
Arguments: hashpartitioning(COL_74CB5837_B051_4D74_88FC_80227199D913#246390, 10), ENSURE_REQUIREMENTS, [plan_id=23954]

(35) Sort
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#246384, COL_74CB5837_B051_4D74_88FC_80227199D913#246390, COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403]
Arguments: [COL_74CB5837_B051_4D74_88FC_80227199D913#246390 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(36) Window
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#246384, COL_74CB5837_B051_4D74_88FC_80227199D913#246390, COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403]
Arguments: [count(1) windowspecdefinition(COL_74CB5837_B051_4D74_88FC_80227199D913#246390, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#246436L], [COL_74CB5837_B051_4D74_88FC_80227199D913#246390], [1 DESC NULLS LAST]

(37) Exchange
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#246384, COL_74CB5837_B051_4D74_88FC_80227199D913#246390, COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#246436L]
Arguments: hashpartitioning(COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403, 10), ENSURE_REQUIREMENTS, [plan_id=23958]

(38) Sort
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#246384, COL_74CB5837_B051_4D74_88FC_80227199D913#246390, COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#246436L]
Arguments: [COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(39) Window
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#246384, COL_74CB5837_B051_4D74_88FC_80227199D913#246390, COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#246436L]
Arguments: [count(1) windowspecdefinition(COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#246467L], [COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403], [1 DESC NULLS LAST]

(40) Filter
Input [9]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#246384, COL_74CB5837_B051_4D74_88FC_80227199D913#246390, COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#246436L, COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#246467L]
Condition : (CASE WHEN isnull(StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379)), Z6)) THEN false ELSE StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379)), Z6) END AND (COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#246436L > 6))

(41) CollectLimit
Input [9]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#246384, COL_74CB5837_B051_4D74_88FC_80227199D913#246390, COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#246436L, COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#246467L]
Arguments: 500000

(42) AdaptiveSparkPlan
Output [9]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#246256, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#246257, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#246258L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#246379, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#246384, COL_74CB5837_B051_4D74_88FC_80227199D913#246390, COL_A566A02B_4004_4838_8B0D_30546A1991F2#246403, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#246436L, COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#246467L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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