SP1 - Details for Query 920

Submitted Time: 2026/02/24 09:37:29
Duration: 0.5 s
Succeeded Jobs: 1234 1235 1236 1237 1238 1239

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: 31 ms"; 2 [labelType="html" label="Filter number of output rows: 15"]; } 3 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 39 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: 15 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: 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: 29 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: 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: 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))\n16 ms (7 ms, 9 ms, 9 ms (stage 1689.0: task 2260))"; 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 1687.0: task 2259)) peak memory total (min, med, max (stageId: taskId)) 512.0 KiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 1687.0: task 2259)) 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, 2 ms (stage 1685.0: task 2255)) 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 1687.0: task 2259)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1687.0: task 2259)) 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 1685.0: task 2253)) 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 1685.0: task 2253))"]; subgraph cluster22 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n372 ms (27 ms, 86 ms, 96 ms (stage 1685.0: task 2257))"; 23 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 344 ms (22 ms, 82 ms, 91 ms (stage 1685.0: task 2257)) peak memory total (min, med, max (stageId: taskId)) 1536.0 KiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 1685.0: task 2253)) 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)) 245 ms (8 ms, 68 ms, 78 ms (stage 1685.0: task 2257)) 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#269251)), G24)) THEN false ELSE StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251)), G24) END AND (COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#269308L > 6))

WholeStageCodegen (6)

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

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

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288, 10), ENSURE_REQUIREMENTS, [plan_id=27704]

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

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

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_74CB5837_B051_4D74_88FC_80227199D913#269275, 10), ENSURE_REQUIREMENTS, [plan_id=27656]

Project [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, vers, LEFT) AS COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, vers, RIGHT) AS COL_C0071F45_39F2_4647_A05D_4CE10B360D89#269262, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, >, LEFT), ALL) AS COL_74CB5837_B051_4D74_88FC_80227199D913#269275, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, >, RIGHT), ALL) AS COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288]

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

WholeStageCodegen (3)

AQEShuffleRead coalesced

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

HashAggregate(keys=[COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#268702, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#268700, COL_447775BC_9753_403A_8C59_368E68ECF1A1#268701L], functions=[])

WholeStageCodegen (2)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#268702, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#268700, COL_447775BC_9753_403A_8C59_368E68ECF1A1#268701L, 10), ENSURE_REQUIREMENTS, [plan_id=27519]

HashAggregate(keys=[COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#268702, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#268700, COL_447775BC_9753_403A_8C59_368E68ECF1A1#268701L], functions=[])

Project [COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#267638 AS COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#268700, COL_08215A85_C797_468A_A885_85343F2B85C7#267641L AS COL_447775BC_9753_403A_8C59_368E68ECF1A1#268701L, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#267639 AS COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#268702]

Filter ((CASE WHEN isnull(((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#267586 >= 43.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#267586 <= 120.0))) THEN false ELSE ((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#267586 >= 43.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#267586 <= 120.0)) END AND isnotnull(str_remove_accent(upper(COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#267625)))) AND isnotnull(str_remove_accent(upper(COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#267626))))

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#267586,COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#267625,COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#267626,COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#267638,COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#267639,COL_08215A85_C797_468A_A885_85343F2B85C7#267641L] Batched: true, DataFilters: [CASE WHEN isnull(((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#267586 >= 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#267586, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#267625, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#267626, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#267638, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#267639, COL_08215A85_C797_468A_A885_85343F2B85C7#267641L]
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#267586, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#267625, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#267626, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#267638, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#267639, COL_08215A85_C797_468A_A885_85343F2B85C7#267641L]

(3) Filter [codegen id : 1]
Input [6]: [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#267586, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#267625, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#267626, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#267638, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#267639, COL_08215A85_C797_468A_A885_85343F2B85C7#267641L]
Condition : ((CASE WHEN isnull(((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#267586 >= 43.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#267586 <= 120.0))) THEN false ELSE ((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#267586 >= 43.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#267586 <= 120.0)) END AND isnotnull(str_remove_accent(upper(COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#267625)))) AND isnotnull(str_remove_accent(upper(COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#267626))))

(4) Project [codegen id : 1]
Output [3]: [COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#267638 AS COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#268700, COL_08215A85_C797_468A_A885_85343F2B85C7#267641L AS COL_447775BC_9753_403A_8C59_368E68ECF1A1#268701L, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#267639 AS COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#268702]
Input [6]: [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#267586, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#267625, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#267626, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#267638, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#267639, COL_08215A85_C797_468A_A885_85343F2B85C7#267641L]

(5) HashAggregate [codegen id : 1]
Input [3]: [COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#268700, COL_447775BC_9753_403A_8C59_368E68ECF1A1#268701L, COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#268702]
Keys [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#268702, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#268700, COL_447775BC_9753_403A_8C59_368E68ECF1A1#268701L]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#268702, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#268700, COL_447775BC_9753_403A_8C59_368E68ECF1A1#268701L]

(6) Exchange
Input [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#268702, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#268700, COL_447775BC_9753_403A_8C59_368E68ECF1A1#268701L]
Arguments: hashpartitioning(COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#268702, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#268700, COL_447775BC_9753_403A_8C59_368E68ECF1A1#268701L, 10), ENSURE_REQUIREMENTS, [plan_id=27519]

(7) ShuffleQueryStage
Output [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#268702, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#268700, COL_447775BC_9753_403A_8C59_368E68ECF1A1#268701L]
Arguments: 0

(8) AQEShuffleRead
Input [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#268702, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#268700, COL_447775BC_9753_403A_8C59_368E68ECF1A1#268701L]
Arguments: coalesced

(9) HashAggregate [codegen id : 2]
Input [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#268702, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#268700, COL_447775BC_9753_403A_8C59_368E68ECF1A1#268701L]
Keys [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#268702, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#268700, COL_447775BC_9753_403A_8C59_368E68ECF1A1#268701L]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#268702 AS COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#268700 AS COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_447775BC_9753_403A_8C59_368E68ECF1A1#268701L AS COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L]

(10) Exchange
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L]
Arguments: rangepartitioning(COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L DESC NULLS LAST, 10), ENSURE_REQUIREMENTS, [plan_id=27594]

(11) ShuffleQueryStage
Output [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L]
Arguments: 1

(12) AQEShuffleRead
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L]
Arguments: coalesced

(13) Sort [codegen id : 3]
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L]
Arguments: [COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L DESC NULLS LAST], true, 0

(14) Project [codegen id : 3]
Output [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, vers, LEFT) AS COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, vers, RIGHT) AS COL_C0071F45_39F2_4647_A05D_4CE10B360D89#269262, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, >, LEFT), ALL) AS COL_74CB5837_B051_4D74_88FC_80227199D913#269275, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, >, RIGHT), ALL) AS COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288]
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L]

(15) Exchange
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#269262, COL_74CB5837_B051_4D74_88FC_80227199D913#269275, COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288]
Arguments: hashpartitioning(COL_74CB5837_B051_4D74_88FC_80227199D913#269275, 10), ENSURE_REQUIREMENTS, [plan_id=27656]

(16) ShuffleQueryStage
Output [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#269262, COL_74CB5837_B051_4D74_88FC_80227199D913#269275, COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288]
Arguments: 2

(17) AQEShuffleRead
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#269262, COL_74CB5837_B051_4D74_88FC_80227199D913#269275, COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288]
Arguments: coalesced

(18) Sort [codegen id : 4]
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#269262, COL_74CB5837_B051_4D74_88FC_80227199D913#269275, COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288]
Arguments: [COL_74CB5837_B051_4D74_88FC_80227199D913#269275 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(19) Window
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#269262, COL_74CB5837_B051_4D74_88FC_80227199D913#269275, COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288]
Arguments: [count(1) windowspecdefinition(COL_74CB5837_B051_4D74_88FC_80227199D913#269275, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#269308L], [COL_74CB5837_B051_4D74_88FC_80227199D913#269275], [1 DESC NULLS LAST]

(20) Exchange
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#269262, COL_74CB5837_B051_4D74_88FC_80227199D913#269275, COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#269308L]
Arguments: hashpartitioning(COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288, 10), ENSURE_REQUIREMENTS, [plan_id=27704]

(21) ShuffleQueryStage
Output [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#269262, COL_74CB5837_B051_4D74_88FC_80227199D913#269275, COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#269308L]
Arguments: 3

(22) AQEShuffleRead
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#269262, COL_74CB5837_B051_4D74_88FC_80227199D913#269275, COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#269308L]
Arguments: coalesced

(23) Sort [codegen id : 5]
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#269262, COL_74CB5837_B051_4D74_88FC_80227199D913#269275, COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#269308L]
Arguments: [COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(24) Window
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#269262, COL_74CB5837_B051_4D74_88FC_80227199D913#269275, COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#269308L]
Arguments: [count(1) windowspecdefinition(COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#269339L], [COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288], [1 DESC NULLS LAST]

(25) Filter [codegen id : 6]
Input [9]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#269262, COL_74CB5837_B051_4D74_88FC_80227199D913#269275, COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#269308L, COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#269339L]
Condition : (CASE WHEN isnull(StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251)), G24)) THEN false ELSE StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251)), G24) END AND (COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#269308L > 6))

(26) Filter
Input [6]: [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#267586, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#267625, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#267626, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#267638, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#267639, COL_08215A85_C797_468A_A885_85343F2B85C7#267641L]
Condition : ((CASE WHEN isnull(((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#267586 >= 43.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#267586 <= 120.0))) THEN false ELSE ((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#267586 >= 43.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#267586 <= 120.0)) END AND isnotnull(str_remove_accent(upper(COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#267625)))) AND isnotnull(str_remove_accent(upper(COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#267626))))

(27) Project
Output [3]: [COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#267638 AS COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#268700, COL_08215A85_C797_468A_A885_85343F2B85C7#267641L AS COL_447775BC_9753_403A_8C59_368E68ECF1A1#268701L, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#267639 AS COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#268702]
Input [6]: [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#267586, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#267625, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#267626, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#267638, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#267639, COL_08215A85_C797_468A_A885_85343F2B85C7#267641L]

(28) HashAggregate
Input [3]: [COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#268700, COL_447775BC_9753_403A_8C59_368E68ECF1A1#268701L, COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#268702]
Keys [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#268702, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#268700, COL_447775BC_9753_403A_8C59_368E68ECF1A1#268701L]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#268702, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#268700, COL_447775BC_9753_403A_8C59_368E68ECF1A1#268701L]

(29) Exchange
Input [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#268702, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#268700, COL_447775BC_9753_403A_8C59_368E68ECF1A1#268701L]
Arguments: hashpartitioning(COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#268702, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#268700, COL_447775BC_9753_403A_8C59_368E68ECF1A1#268701L, 10), ENSURE_REQUIREMENTS, [plan_id=27467]

(30) HashAggregate
Input [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#268702, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#268700, COL_447775BC_9753_403A_8C59_368E68ECF1A1#268701L]
Keys [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#268702, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#268700, COL_447775BC_9753_403A_8C59_368E68ECF1A1#268701L]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#268702 AS COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#268700 AS COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_447775BC_9753_403A_8C59_368E68ECF1A1#268701L AS COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L]

(31) Exchange
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L]
Arguments: rangepartitioning(COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L DESC NULLS LAST, 10), ENSURE_REQUIREMENTS, [plan_id=27470]

(32) Sort
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L]
Arguments: [COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L DESC NULLS LAST], true, 0

(33) Project
Output [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, vers, LEFT) AS COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, vers, RIGHT) AS COL_C0071F45_39F2_4647_A05D_4CE10B360D89#269262, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, >, LEFT), ALL) AS COL_74CB5837_B051_4D74_88FC_80227199D913#269275, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, >, RIGHT), ALL) AS COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288]
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L]

(34) Exchange
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#269262, COL_74CB5837_B051_4D74_88FC_80227199D913#269275, COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288]
Arguments: hashpartitioning(COL_74CB5837_B051_4D74_88FC_80227199D913#269275, 10), ENSURE_REQUIREMENTS, [plan_id=27474]

(35) Sort
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#269262, COL_74CB5837_B051_4D74_88FC_80227199D913#269275, COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288]
Arguments: [COL_74CB5837_B051_4D74_88FC_80227199D913#269275 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(36) Window
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#269262, COL_74CB5837_B051_4D74_88FC_80227199D913#269275, COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288]
Arguments: [count(1) windowspecdefinition(COL_74CB5837_B051_4D74_88FC_80227199D913#269275, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#269308L], [COL_74CB5837_B051_4D74_88FC_80227199D913#269275], [1 DESC NULLS LAST]

(37) Exchange
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#269262, COL_74CB5837_B051_4D74_88FC_80227199D913#269275, COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#269308L]
Arguments: hashpartitioning(COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288, 10), ENSURE_REQUIREMENTS, [plan_id=27478]

(38) Sort
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#269262, COL_74CB5837_B051_4D74_88FC_80227199D913#269275, COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#269308L]
Arguments: [COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(39) Window
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#269262, COL_74CB5837_B051_4D74_88FC_80227199D913#269275, COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#269308L]
Arguments: [count(1) windowspecdefinition(COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#269339L], [COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288], [1 DESC NULLS LAST]

(40) Filter
Input [9]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#269262, COL_74CB5837_B051_4D74_88FC_80227199D913#269275, COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#269308L, COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#269339L]
Condition : (CASE WHEN isnull(StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251)), G24)) THEN false ELSE StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251)), G24) END AND (COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#269308L > 6))

(41) CollectLimit
Input [9]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#269262, COL_74CB5837_B051_4D74_88FC_80227199D913#269275, COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#269308L, COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#269339L]
Arguments: 500000

(42) AdaptiveSparkPlan
Output [9]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#269091, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#269092, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#269093L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#269251, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#269262, COL_74CB5837_B051_4D74_88FC_80227199D913#269275, COL_A566A02B_4004_4838_8B0D_30546A1991F2#269288, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#269308L, COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#269339L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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