SP1 - Details for Query 830

Submitted Time: 2026/02/24 09:35:35
Duration: 0.8 s
Succeeded Jobs: 1074 1076 1077 1078 1079 1080

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: 56 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: 68 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: 400.8 KiB number of coalesced partitions: 1"]; 7 [labelType="html" label="Exchange shuffle records written: 4,857 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: 4,857 local bytes read: 386.8 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: 1410.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: 386.8 KiB"]; 8 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster9 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 25 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: 454.8 KiB number of coalesced partitions: 1"]; 12 [labelType="html" label="Exchange shuffle records written: 4,857 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: 4,857 local bytes read: 438.3 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: 1372.1 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: 438.3 KiB"]; subgraph cluster13 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 37 ms"; 14 [labelType="html" label=" Project "]; 15 [labelType="html" label="Sort sort time: 3 ms peak memory: 16.3 MiB spill size: 0.0 B"]; } 16 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 265.8 KiB number of coalesced partitions: 1"]; 17 [labelType="html" label="Exchange shuffle records written: 4,857 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: 4,857 local bytes read: 251.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: 669.6 KiB local merged bytes read: 0.0 B number of partitions: 6 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 251.7 KiB"]; subgraph cluster18 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: total (min, med, max (stageId: taskId))\n26 ms (11 ms, 15 ms, 15 ms (stage 1425.0: task 1984))"; 19 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 14 ms (7 ms, 7 ms, 7 ms (stage 1423.0: task 1983)) peak memory total (min, med, max (stageId: taskId)) 32.5 MiB (16.3 MiB, 16.3 MiB, 16.3 MiB (stage 1423.0: task 1983)) number of output rows: 9,714 number of sort fallback tasks: 0 avg hash probes per key (min, med, max (stageId: taskId)): (1, 1, 1 (stage 1423.0: task 1983))"]; } 20 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 297.1 KiB number of coalesced partitions: 1"]; 21 [labelType="html" label="Exchange shuffle records written: 4,857 local merged chunks fetched: 0 shuffle write time total (min, med, max (stageId: taskId)) 11 ms (1 ms, 1 ms, 2 ms (stage 1420.0: task 1977)) 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: 9,714 local bytes read total (min, med, max (stageId: taskId)) 564.4 KiB (282.2 KiB, 282.2 KiB, 282.2 KiB (stage 1423.0: task 1983)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1423.0: task 1983)) 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)) 669.6 KiB (1112.0 B, 32.3 KiB, 526.4 KiB (stage 1420.0: task 1976)) 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)) 282.2 KiB (1083.0 B, 19.1 KiB, 205.4 KiB (stage 1420.0: task 1976))"]; subgraph cluster22 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n1.3 s (197 ms, 216 ms, 225 ms (stage 1420.0: task 1976))"; 23 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 1.2 s (181 ms, 200 ms, 203 ms (stage 1420.0: task 1976)) peak memory total (min, med, max (stageId: taskId)) 17.5 MiB (256.0 KiB, 256.0 KiB, 16.3 MiB (stage 1420.0: task 1976)) number of output rows: 4,857 number of sort fallback tasks: 0 avg hash probes per key: 1"]; 24 [labelType="html" label=" Project "]; 25 [labelType="html" label="Filter number of output rows: 68,920"]; 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)) 40 ms (6 ms, 7 ms, 7 ms (stage 1420.0: task 1981)) 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#243292)), Z61)) THEN false ELSE StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292)), Z61) END AND (COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#243533L > 6))

WholeStageCodegen (6)

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

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

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483, 10), ENSURE_REQUIREMENTS, [plan_id=23747]

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

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

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_74CB5837_B051_4D74_88FC_80227199D913#243468, 10), ENSURE_REQUIREMENTS, [plan_id=23699]

Project [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, vers, LEFT) AS COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, vers, RIGHT) AS COL_C0071F45_39F2_4647_A05D_4CE10B360D89#243377, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, >, LEFT), ALL) AS COL_74CB5837_B051_4D74_88FC_80227199D913#243468, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, >, RIGHT), ALL) AS COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483]

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

WholeStageCodegen (3)

AQEShuffleRead coalesced

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

HashAggregate(keys=[COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#242343, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#242341, COL_447775BC_9753_403A_8C59_368E68ECF1A1#242342L], functions=[])

WholeStageCodegen (2)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#242343, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#242341, COL_447775BC_9753_403A_8C59_368E68ECF1A1#242342L, 10), ENSURE_REQUIREMENTS, [plan_id=23560]

HashAggregate(keys=[COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#242343, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#242341, COL_447775BC_9753_403A_8C59_368E68ECF1A1#242342L], functions=[])

Project [COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#241604 AS COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#242341, COL_08215A85_C797_468A_A885_85343F2B85C7#241607L AS COL_447775BC_9753_403A_8C59_368E68ECF1A1#242342L, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#241605 AS COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#242343]

Filter ((CASE WHEN isnull(((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#241552 >= 1.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#241552 <= 120.0))) THEN false ELSE ((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#241552 >= 1.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#241552 <= 120.0)) END AND isnotnull(str_remove_accent(upper(COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#241591)))) AND isnotnull(str_remove_accent(upper(COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#241592))))

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#241552,COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#241591,COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#241592,COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#241604,COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#241605,COL_08215A85_C797_468A_A885_85343F2B85C7#241607L] Batched: true, DataFilters: [CASE WHEN isnull(((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#241552 >= 1.0) AND (COL_730E830A_DE0..., 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=1410.0 KiB, rowCount=4.86E+3)
               +- Exchange (20)
                  +- Window (19)
                     +- * Sort (18)
                        +- AQEShuffleRead (17)
                           +- ShuffleQueryStage (16), Statistics(sizeInBytes=1372.1 KiB, rowCount=4.86E+3)
                              +- Exchange (15)
                                 +- * Project (14)
                                    +- * Sort (13)
                                       +- AQEShuffleRead (12)
                                          +- ShuffleQueryStage (11), Statistics(sizeInBytes=669.6 KiB, rowCount=4.86E+3)
                                             +- Exchange (10)
                                                +- * HashAggregate (9)
                                                   +- AQEShuffleRead (8)
                                                      +- ShuffleQueryStage (7), Statistics(sizeInBytes=669.6 KiB, rowCount=4.86E+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#241552, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#241591, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#241592, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#241604, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#241605, COL_08215A85_C797_468A_A885_85343F2B85C7#241607L]
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#241552, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#241591, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#241592, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#241604, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#241605, COL_08215A85_C797_468A_A885_85343F2B85C7#241607L]

(3) Filter [codegen id : 1]
Input [6]: [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#241552, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#241591, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#241592, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#241604, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#241605, COL_08215A85_C797_468A_A885_85343F2B85C7#241607L]
Condition : ((CASE WHEN isnull(((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#241552 >= 1.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#241552 <= 120.0))) THEN false ELSE ((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#241552 >= 1.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#241552 <= 120.0)) END AND isnotnull(str_remove_accent(upper(COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#241591)))) AND isnotnull(str_remove_accent(upper(COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#241592))))

(4) Project [codegen id : 1]
Output [3]: [COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#241604 AS COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#242341, COL_08215A85_C797_468A_A885_85343F2B85C7#241607L AS COL_447775BC_9753_403A_8C59_368E68ECF1A1#242342L, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#241605 AS COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#242343]
Input [6]: [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#241552, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#241591, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#241592, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#241604, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#241605, COL_08215A85_C797_468A_A885_85343F2B85C7#241607L]

(5) HashAggregate [codegen id : 1]
Input [3]: [COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#242341, COL_447775BC_9753_403A_8C59_368E68ECF1A1#242342L, COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#242343]
Keys [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#242343, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#242341, COL_447775BC_9753_403A_8C59_368E68ECF1A1#242342L]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#242343, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#242341, COL_447775BC_9753_403A_8C59_368E68ECF1A1#242342L]

(6) Exchange
Input [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#242343, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#242341, COL_447775BC_9753_403A_8C59_368E68ECF1A1#242342L]
Arguments: hashpartitioning(COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#242343, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#242341, COL_447775BC_9753_403A_8C59_368E68ECF1A1#242342L, 10), ENSURE_REQUIREMENTS, [plan_id=23560]

(7) ShuffleQueryStage
Output [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#242343, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#242341, COL_447775BC_9753_403A_8C59_368E68ECF1A1#242342L]
Arguments: 0

(8) AQEShuffleRead
Input [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#242343, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#242341, COL_447775BC_9753_403A_8C59_368E68ECF1A1#242342L]
Arguments: coalesced

(9) HashAggregate [codegen id : 2]
Input [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#242343, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#242341, COL_447775BC_9753_403A_8C59_368E68ECF1A1#242342L]
Keys [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#242343, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#242341, COL_447775BC_9753_403A_8C59_368E68ECF1A1#242342L]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#242343 AS COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#242341 AS COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_447775BC_9753_403A_8C59_368E68ECF1A1#242342L AS COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L]

(10) Exchange
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L]
Arguments: rangepartitioning(COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L DESC NULLS LAST, 10), ENSURE_REQUIREMENTS, [plan_id=23637]

(11) ShuffleQueryStage
Output [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L]
Arguments: 1

(12) AQEShuffleRead
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L]
Arguments: coalesced

(13) Sort [codegen id : 3]
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L]
Arguments: [COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L DESC NULLS LAST], true, 0

(14) Project [codegen id : 3]
Output [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, vers, LEFT) AS COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, vers, RIGHT) AS COL_C0071F45_39F2_4647_A05D_4CE10B360D89#243377, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, >, LEFT), ALL) AS COL_74CB5837_B051_4D74_88FC_80227199D913#243468, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, >, RIGHT), ALL) AS COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483]
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L]

(15) Exchange
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#243377, COL_74CB5837_B051_4D74_88FC_80227199D913#243468, COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483]
Arguments: hashpartitioning(COL_74CB5837_B051_4D74_88FC_80227199D913#243468, 10), ENSURE_REQUIREMENTS, [plan_id=23699]

(16) ShuffleQueryStage
Output [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#243377, COL_74CB5837_B051_4D74_88FC_80227199D913#243468, COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483]
Arguments: 2

(17) AQEShuffleRead
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#243377, COL_74CB5837_B051_4D74_88FC_80227199D913#243468, COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483]
Arguments: coalesced

(18) Sort [codegen id : 4]
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#243377, COL_74CB5837_B051_4D74_88FC_80227199D913#243468, COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483]
Arguments: [COL_74CB5837_B051_4D74_88FC_80227199D913#243468 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(19) Window
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#243377, COL_74CB5837_B051_4D74_88FC_80227199D913#243468, COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483]
Arguments: [count(1) windowspecdefinition(COL_74CB5837_B051_4D74_88FC_80227199D913#243468, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#243533L], [COL_74CB5837_B051_4D74_88FC_80227199D913#243468], [1 DESC NULLS LAST]

(20) Exchange
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#243377, COL_74CB5837_B051_4D74_88FC_80227199D913#243468, COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#243533L]
Arguments: hashpartitioning(COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483, 10), ENSURE_REQUIREMENTS, [plan_id=23747]

(21) ShuffleQueryStage
Output [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#243377, COL_74CB5837_B051_4D74_88FC_80227199D913#243468, COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#243533L]
Arguments: 3

(22) AQEShuffleRead
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#243377, COL_74CB5837_B051_4D74_88FC_80227199D913#243468, COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#243533L]
Arguments: coalesced

(23) Sort [codegen id : 5]
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#243377, COL_74CB5837_B051_4D74_88FC_80227199D913#243468, COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#243533L]
Arguments: [COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(24) Window
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#243377, COL_74CB5837_B051_4D74_88FC_80227199D913#243468, COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#243533L]
Arguments: [count(1) windowspecdefinition(COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#243594L], [COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483], [1 DESC NULLS LAST]

(25) Filter [codegen id : 6]
Input [9]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#243377, COL_74CB5837_B051_4D74_88FC_80227199D913#243468, COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#243533L, COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#243594L]
Condition : (CASE WHEN isnull(StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292)), Z61)) THEN false ELSE StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292)), Z61) END AND (COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#243533L > 6))

(26) Filter
Input [6]: [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#241552, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#241591, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#241592, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#241604, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#241605, COL_08215A85_C797_468A_A885_85343F2B85C7#241607L]
Condition : ((CASE WHEN isnull(((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#241552 >= 1.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#241552 <= 120.0))) THEN false ELSE ((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#241552 >= 1.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#241552 <= 120.0)) END AND isnotnull(str_remove_accent(upper(COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#241591)))) AND isnotnull(str_remove_accent(upper(COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#241592))))

(27) Project
Output [3]: [COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#241604 AS COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#242341, COL_08215A85_C797_468A_A885_85343F2B85C7#241607L AS COL_447775BC_9753_403A_8C59_368E68ECF1A1#242342L, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#241605 AS COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#242343]
Input [6]: [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#241552, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#241591, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#241592, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#241604, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#241605, COL_08215A85_C797_468A_A885_85343F2B85C7#241607L]

(28) HashAggregate
Input [3]: [COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#242341, COL_447775BC_9753_403A_8C59_368E68ECF1A1#242342L, COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#242343]
Keys [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#242343, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#242341, COL_447775BC_9753_403A_8C59_368E68ECF1A1#242342L]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#242343, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#242341, COL_447775BC_9753_403A_8C59_368E68ECF1A1#242342L]

(29) Exchange
Input [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#242343, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#242341, COL_447775BC_9753_403A_8C59_368E68ECF1A1#242342L]
Arguments: hashpartitioning(COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#242343, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#242341, COL_447775BC_9753_403A_8C59_368E68ECF1A1#242342L, 10), ENSURE_REQUIREMENTS, [plan_id=23508]

(30) HashAggregate
Input [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#242343, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#242341, COL_447775BC_9753_403A_8C59_368E68ECF1A1#242342L]
Keys [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#242343, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#242341, COL_447775BC_9753_403A_8C59_368E68ECF1A1#242342L]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#242343 AS COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#242341 AS COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_447775BC_9753_403A_8C59_368E68ECF1A1#242342L AS COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L]

(31) Exchange
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L]
Arguments: rangepartitioning(COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L DESC NULLS LAST, 10), ENSURE_REQUIREMENTS, [plan_id=23511]

(32) Sort
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L]
Arguments: [COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L DESC NULLS LAST], true, 0

(33) Project
Output [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, vers, LEFT) AS COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, vers, RIGHT) AS COL_C0071F45_39F2_4647_A05D_4CE10B360D89#243377, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, >, LEFT), ALL) AS COL_74CB5837_B051_4D74_88FC_80227199D913#243468, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, >, RIGHT), ALL) AS COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483]
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L]

(34) Exchange
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#243377, COL_74CB5837_B051_4D74_88FC_80227199D913#243468, COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483]
Arguments: hashpartitioning(COL_74CB5837_B051_4D74_88FC_80227199D913#243468, 10), ENSURE_REQUIREMENTS, [plan_id=23515]

(35) Sort
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#243377, COL_74CB5837_B051_4D74_88FC_80227199D913#243468, COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483]
Arguments: [COL_74CB5837_B051_4D74_88FC_80227199D913#243468 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(36) Window
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#243377, COL_74CB5837_B051_4D74_88FC_80227199D913#243468, COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483]
Arguments: [count(1) windowspecdefinition(COL_74CB5837_B051_4D74_88FC_80227199D913#243468, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#243533L], [COL_74CB5837_B051_4D74_88FC_80227199D913#243468], [1 DESC NULLS LAST]

(37) Exchange
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#243377, COL_74CB5837_B051_4D74_88FC_80227199D913#243468, COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#243533L]
Arguments: hashpartitioning(COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483, 10), ENSURE_REQUIREMENTS, [plan_id=23519]

(38) Sort
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#243377, COL_74CB5837_B051_4D74_88FC_80227199D913#243468, COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#243533L]
Arguments: [COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(39) Window
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#243377, COL_74CB5837_B051_4D74_88FC_80227199D913#243468, COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#243533L]
Arguments: [count(1) windowspecdefinition(COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#243594L], [COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483], [1 DESC NULLS LAST]

(40) Filter
Input [9]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#243377, COL_74CB5837_B051_4D74_88FC_80227199D913#243468, COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#243533L, COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#243594L]
Condition : (CASE WHEN isnull(StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292)), Z61)) THEN false ELSE StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292)), Z61) END AND (COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#243533L > 6))

(41) CollectLimit
Input [9]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#243377, COL_74CB5837_B051_4D74_88FC_80227199D913#243468, COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#243533L, COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#243594L]
Arguments: 500000

(42) AdaptiveSparkPlan
Output [9]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#242933, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#242934, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#242935L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#243292, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#243377, COL_74CB5837_B051_4D74_88FC_80227199D913#243468, COL_A566A02B_4004_4838_8B0D_30546A1991F2#243483, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#243533L, COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#243594L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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