SP1 - Details for Query 924

Submitted Time: 2026/02/24 09:38:30
Duration: 0.5 s
Succeeded Jobs: 1244 1247 1248 1251 1252 1253

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: 22 ms"; 2 [labelType="html" label="Filter number of output rows: 7"]; } 3 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 30 ms"; 5 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 6 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 193.2 KiB number of coalesced partitions: 1"]; 7 [labelType="html" label="Exchange shuffle records written: 2,215 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: 2,215 local bytes read: 182.2 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: 628.0 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: 182.2 KiB"]; 8 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 13 ms"; 10 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 11 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 203.2 KiB number of coalesced partitions: 1"]; 12 [labelType="html" label="Exchange shuffle records written: 2,215 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: 2,215 local bytes read: 193.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: 610.7 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: 193.5 KiB"]; subgraph cluster13 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 22 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: 114.9 KiB number of coalesced partitions: 1"]; 17 [labelType="html" label="Exchange shuffle records written: 2,215 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: 2,215 local bytes read: 109.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: 298.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: 109.7 KiB"]; subgraph cluster18 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n14 ms (7 ms, 7 ms, 7 ms (stage 1712.0: task 2285))"; 19 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 7 ms (3 ms, 4 ms, 4 ms (stage 1710.0: task 2284)) peak memory total (min, med, max (stageId: taskId)) 512.0 KiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 1712.0: task 2285)) number of output rows: 4,430 number of sort fallback tasks: 0 avg hash probes per key: 0"]; } 20 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 144.4 KiB number of coalesced partitions: 1"]; 21 [labelType="html" label="Exchange shuffle records written: 2,215 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 12 ms (1 ms, 2 ms, 2 ms (stage 1706.0: task 2268)) 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: 4,430 local bytes read total (min, med, max (stageId: taskId)) 278.2 KiB (139.1 KiB, 139.1 KiB, 139.1 KiB (stage 1712.0: task 2285)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1712.0: task 2285)) 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)) 298.2 KiB (1112.0 B, 26.1 KiB, 195.0 KiB (stage 1706.0: task 2268)) 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)) 139.1 KiB (1083.0 B, 16.0 KiB, 79.2 KiB (stage 1706.0: task 2268))"]; subgraph cluster22 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n175 ms (24 ms, 31 ms, 34 ms (stage 1706.0: task 2272))"; 23 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 136 ms (19 ms, 22 ms, 30 ms (stage 1706.0: task 2272)) peak memory total (min, med, max (stageId: taskId)) 1536.0 KiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 1706.0: task 2269)) number of output rows: 2,215 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: 19,146"]; 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)) 75 ms (8 ms, 13 ms, 21 ms (stage 1706.0: task 2272)) 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#270342)), G24)) THEN false ELSE StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342)), G24) END AND (COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#270512L > 6))

WholeStageCodegen (6)

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

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

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360, 10), ENSURE_REQUIREMENTS, [plan_id=28102]

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

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

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_74CB5837_B051_4D74_88FC_80227199D913#270353, 10), ENSURE_REQUIREMENTS, [plan_id=28054]

Project [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, vers, LEFT) AS COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, vers, RIGHT) AS COL_C0071F45_39F2_4647_A05D_4CE10B360D89#270347, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, >, LEFT), ALL) AS COL_74CB5837_B051_4D74_88FC_80227199D913#270353, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, >, RIGHT), ALL) AS COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360]

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

WholeStageCodegen (3)

AQEShuffleRead coalesced

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

HashAggregate(keys=[COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#270082, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#270080, COL_447775BC_9753_403A_8C59_368E68ECF1A1#270081L], functions=[])

WholeStageCodegen (2)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#270082, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#270080, COL_447775BC_9753_403A_8C59_368E68ECF1A1#270081L, 10), ENSURE_REQUIREMENTS, [plan_id=27858]

HashAggregate(keys=[COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#270082, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#270080, COL_447775BC_9753_403A_8C59_368E68ECF1A1#270081L], functions=[])

Project [COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#269691 AS COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#270080, COL_08215A85_C797_468A_A885_85343F2B85C7#269694L AS COL_447775BC_9753_403A_8C59_368E68ECF1A1#270081L, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#269692 AS COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#270082]

Filter ((CASE WHEN isnull(((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#269639 >= 70.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#269639 <= 120.0))) THEN false ELSE ((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#269639 >= 70.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#269639 <= 120.0)) END AND isnotnull(str_remove_accent(upper(COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#269678)))) AND isnotnull(str_remove_accent(upper(COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#269679))))

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#269639,COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#269678,COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#269679,COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#269691,COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#269692,COL_08215A85_C797_468A_A885_85343F2B85C7#269694L] Batched: true, DataFilters: [CASE WHEN isnull(((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#269639 >= 70.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=628.0 KiB, rowCount=2.22E+3)
               +- Exchange (20)
                  +- Window (19)
                     +- * Sort (18)
                        +- AQEShuffleRead (17)
                           +- ShuffleQueryStage (16), Statistics(sizeInBytes=610.7 KiB, rowCount=2.22E+3)
                              +- Exchange (15)
                                 +- * Project (14)
                                    +- * Sort (13)
                                       +- AQEShuffleRead (12)
                                          +- ShuffleQueryStage (11), Statistics(sizeInBytes=298.2 KiB, rowCount=2.22E+3)
                                             +- Exchange (10)
                                                +- * HashAggregate (9)
                                                   +- AQEShuffleRead (8)
                                                      +- ShuffleQueryStage (7), Statistics(sizeInBytes=298.2 KiB, rowCount=2.22E+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#269639, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#269678, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#269679, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#269691, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#269692, COL_08215A85_C797_468A_A885_85343F2B85C7#269694L]
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#269639, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#269678, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#269679, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#269691, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#269692, COL_08215A85_C797_468A_A885_85343F2B85C7#269694L]

(3) Filter [codegen id : 1]
Input [6]: [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#269639, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#269678, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#269679, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#269691, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#269692, COL_08215A85_C797_468A_A885_85343F2B85C7#269694L]
Condition : ((CASE WHEN isnull(((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#269639 >= 70.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#269639 <= 120.0))) THEN false ELSE ((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#269639 >= 70.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#269639 <= 120.0)) END AND isnotnull(str_remove_accent(upper(COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#269678)))) AND isnotnull(str_remove_accent(upper(COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#269679))))

(4) Project [codegen id : 1]
Output [3]: [COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#269691 AS COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#270080, COL_08215A85_C797_468A_A885_85343F2B85C7#269694L AS COL_447775BC_9753_403A_8C59_368E68ECF1A1#270081L, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#269692 AS COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#270082]
Input [6]: [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#269639, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#269678, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#269679, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#269691, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#269692, COL_08215A85_C797_468A_A885_85343F2B85C7#269694L]

(5) HashAggregate [codegen id : 1]
Input [3]: [COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#270080, COL_447775BC_9753_403A_8C59_368E68ECF1A1#270081L, COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#270082]
Keys [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#270082, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#270080, COL_447775BC_9753_403A_8C59_368E68ECF1A1#270081L]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#270082, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#270080, COL_447775BC_9753_403A_8C59_368E68ECF1A1#270081L]

(6) Exchange
Input [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#270082, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#270080, COL_447775BC_9753_403A_8C59_368E68ECF1A1#270081L]
Arguments: hashpartitioning(COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#270082, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#270080, COL_447775BC_9753_403A_8C59_368E68ECF1A1#270081L, 10), ENSURE_REQUIREMENTS, [plan_id=27858]

(7) ShuffleQueryStage
Output [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#270082, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#270080, COL_447775BC_9753_403A_8C59_368E68ECF1A1#270081L]
Arguments: 0

(8) AQEShuffleRead
Input [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#270082, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#270080, COL_447775BC_9753_403A_8C59_368E68ECF1A1#270081L]
Arguments: coalesced

(9) HashAggregate [codegen id : 2]
Input [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#270082, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#270080, COL_447775BC_9753_403A_8C59_368E68ECF1A1#270081L]
Keys [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#270082, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#270080, COL_447775BC_9753_403A_8C59_368E68ECF1A1#270081L]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#270082 AS COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#270080 AS COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_447775BC_9753_403A_8C59_368E68ECF1A1#270081L AS COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L]

(10) Exchange
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L]
Arguments: rangepartitioning(COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L DESC NULLS LAST, 10), ENSURE_REQUIREMENTS, [plan_id=27989]

(11) ShuffleQueryStage
Output [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L]
Arguments: 1

(12) AQEShuffleRead
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L]
Arguments: coalesced

(13) Sort [codegen id : 3]
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L]
Arguments: [COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L DESC NULLS LAST], true, 0

(14) Project [codegen id : 3]
Output [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, vers, LEFT) AS COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, vers, RIGHT) AS COL_C0071F45_39F2_4647_A05D_4CE10B360D89#270347, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, >, LEFT), ALL) AS COL_74CB5837_B051_4D74_88FC_80227199D913#270353, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, >, RIGHT), ALL) AS COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360]
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L]

(15) Exchange
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#270347, COL_74CB5837_B051_4D74_88FC_80227199D913#270353, COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360]
Arguments: hashpartitioning(COL_74CB5837_B051_4D74_88FC_80227199D913#270353, 10), ENSURE_REQUIREMENTS, [plan_id=28054]

(16) ShuffleQueryStage
Output [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#270347, COL_74CB5837_B051_4D74_88FC_80227199D913#270353, COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360]
Arguments: 2

(17) AQEShuffleRead
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#270347, COL_74CB5837_B051_4D74_88FC_80227199D913#270353, COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360]
Arguments: coalesced

(18) Sort [codegen id : 4]
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#270347, COL_74CB5837_B051_4D74_88FC_80227199D913#270353, COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360]
Arguments: [COL_74CB5837_B051_4D74_88FC_80227199D913#270353 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(19) Window
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#270347, COL_74CB5837_B051_4D74_88FC_80227199D913#270353, COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360]
Arguments: [count(1) windowspecdefinition(COL_74CB5837_B051_4D74_88FC_80227199D913#270353, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#270512L], [COL_74CB5837_B051_4D74_88FC_80227199D913#270353], [1 DESC NULLS LAST]

(20) Exchange
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#270347, COL_74CB5837_B051_4D74_88FC_80227199D913#270353, COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#270512L]
Arguments: hashpartitioning(COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360, 10), ENSURE_REQUIREMENTS, [plan_id=28102]

(21) ShuffleQueryStage
Output [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#270347, COL_74CB5837_B051_4D74_88FC_80227199D913#270353, COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#270512L]
Arguments: 3

(22) AQEShuffleRead
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#270347, COL_74CB5837_B051_4D74_88FC_80227199D913#270353, COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#270512L]
Arguments: coalesced

(23) Sort [codegen id : 5]
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#270347, COL_74CB5837_B051_4D74_88FC_80227199D913#270353, COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#270512L]
Arguments: [COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(24) Window
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#270347, COL_74CB5837_B051_4D74_88FC_80227199D913#270353, COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#270512L]
Arguments: [count(1) windowspecdefinition(COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#270947L], [COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360], [1 DESC NULLS LAST]

(25) Filter [codegen id : 6]
Input [9]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#270347, COL_74CB5837_B051_4D74_88FC_80227199D913#270353, COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#270512L, COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#270947L]
Condition : (CASE WHEN isnull(StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342)), G24)) THEN false ELSE StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342)), G24) END AND (COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#270512L > 6))

(26) Filter
Input [6]: [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#269639, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#269678, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#269679, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#269691, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#269692, COL_08215A85_C797_468A_A885_85343F2B85C7#269694L]
Condition : ((CASE WHEN isnull(((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#269639 >= 70.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#269639 <= 120.0))) THEN false ELSE ((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#269639 >= 70.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#269639 <= 120.0)) END AND isnotnull(str_remove_accent(upper(COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#269678)))) AND isnotnull(str_remove_accent(upper(COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#269679))))

(27) Project
Output [3]: [COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#269691 AS COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#270080, COL_08215A85_C797_468A_A885_85343F2B85C7#269694L AS COL_447775BC_9753_403A_8C59_368E68ECF1A1#270081L, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#269692 AS COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#270082]
Input [6]: [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#269639, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#269678, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#269679, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#269691, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#269692, COL_08215A85_C797_468A_A885_85343F2B85C7#269694L]

(28) HashAggregate
Input [3]: [COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#270080, COL_447775BC_9753_403A_8C59_368E68ECF1A1#270081L, COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#270082]
Keys [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#270082, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#270080, COL_447775BC_9753_403A_8C59_368E68ECF1A1#270081L]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#270082, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#270080, COL_447775BC_9753_403A_8C59_368E68ECF1A1#270081L]

(29) Exchange
Input [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#270082, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#270080, COL_447775BC_9753_403A_8C59_368E68ECF1A1#270081L]
Arguments: hashpartitioning(COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#270082, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#270080, COL_447775BC_9753_403A_8C59_368E68ECF1A1#270081L, 10), ENSURE_REQUIREMENTS, [plan_id=27806]

(30) HashAggregate
Input [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#270082, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#270080, COL_447775BC_9753_403A_8C59_368E68ECF1A1#270081L]
Keys [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#270082, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#270080, COL_447775BC_9753_403A_8C59_368E68ECF1A1#270081L]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#270082 AS COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#270080 AS COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_447775BC_9753_403A_8C59_368E68ECF1A1#270081L AS COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L]

(31) Exchange
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L]
Arguments: rangepartitioning(COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L DESC NULLS LAST, 10), ENSURE_REQUIREMENTS, [plan_id=27809]

(32) Sort
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L]
Arguments: [COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L DESC NULLS LAST], true, 0

(33) Project
Output [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, vers, LEFT) AS COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, vers, RIGHT) AS COL_C0071F45_39F2_4647_A05D_4CE10B360D89#270347, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, >, LEFT), ALL) AS COL_74CB5837_B051_4D74_88FC_80227199D913#270353, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, >, RIGHT), ALL) AS COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360]
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L]

(34) Exchange
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#270347, COL_74CB5837_B051_4D74_88FC_80227199D913#270353, COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360]
Arguments: hashpartitioning(COL_74CB5837_B051_4D74_88FC_80227199D913#270353, 10), ENSURE_REQUIREMENTS, [plan_id=27813]

(35) Sort
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#270347, COL_74CB5837_B051_4D74_88FC_80227199D913#270353, COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360]
Arguments: [COL_74CB5837_B051_4D74_88FC_80227199D913#270353 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(36) Window
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#270347, COL_74CB5837_B051_4D74_88FC_80227199D913#270353, COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360]
Arguments: [count(1) windowspecdefinition(COL_74CB5837_B051_4D74_88FC_80227199D913#270353, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#270512L], [COL_74CB5837_B051_4D74_88FC_80227199D913#270353], [1 DESC NULLS LAST]

(37) Exchange
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#270347, COL_74CB5837_B051_4D74_88FC_80227199D913#270353, COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#270512L]
Arguments: hashpartitioning(COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360, 10), ENSURE_REQUIREMENTS, [plan_id=27817]

(38) Sort
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#270347, COL_74CB5837_B051_4D74_88FC_80227199D913#270353, COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#270512L]
Arguments: [COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(39) Window
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#270347, COL_74CB5837_B051_4D74_88FC_80227199D913#270353, COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#270512L]
Arguments: [count(1) windowspecdefinition(COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#270947L], [COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360], [1 DESC NULLS LAST]

(40) Filter
Input [9]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#270347, COL_74CB5837_B051_4D74_88FC_80227199D913#270353, COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#270512L, COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#270947L]
Condition : (CASE WHEN isnull(StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342)), G24)) THEN false ELSE StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342)), G24) END AND (COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#270512L > 6))

(41) CollectLimit
Input [9]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#270347, COL_74CB5837_B051_4D74_88FC_80227199D913#270353, COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#270512L, COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#270947L]
Arguments: 500000

(42) AdaptiveSparkPlan
Output [9]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#270260, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#270261, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#270262L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#270342, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#270347, COL_74CB5837_B051_4D74_88FC_80227199D913#270353, COL_A566A02B_4004_4838_8B0D_30546A1991F2#270360, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#270512L, COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#270947L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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