SP1 - Details for Query 810

Submitted Time: 2026/02/24 09:34:37
Duration: 0.9 s
Succeeded Jobs: 1041 1042 1043 1044 1045 1046

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: 24 ms"; 2 [labelType="html" label="Filter number of output rows: 23"]; } 3 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 80 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: 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: 89 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: 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: 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: 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: 48 ms"; 14 [labelType="html" label=" Project "]; 15 [labelType="html" label="Sort sort time: 0 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))\n35 ms (11 ms, 24 ms, 24 ms (stage 1367.0: task 1923))"; 19 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 12 ms (4 ms, 8 ms, 8 ms (stage 1367.0: task 1923)) peak memory total (min, med, max (stageId: taskId)) 512.0 KiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 1369.0: task 1924)) 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)) 10 ms (1 ms, 1 ms, 2 ms (stage 1365.0: task 1920)) 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 1369.0: task 1924)) fetch wait time total (min, med, max (stageId: taskId)) 0 ms (0 ms, 0 ms, 0 ms (stage 1369.0: task 1924)) 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 1365.0: task 1917)) 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 1365.0: task 1917))"]; subgraph cluster22 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n756 ms (114 ms, 129 ms, 131 ms (stage 1365.0: task 1917))"; 23 [labelType="html" label="HashAggregate spill size: 0.0 B time in aggregation build total (min, med, max (stageId: taskId)) 459 ms (65 ms, 80 ms, 80 ms (stage 1365.0: task 1921)) peak memory total (min, med, max (stageId: taskId)) 1536.0 KiB (256.0 KiB, 256.0 KiB, 256.0 KiB (stage 1365.0: task 1922)) 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)) 44 ms (6 ms, 7 ms, 9 ms (stage 1365.0: task 1920)) 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#237828)), I80)) THEN false ELSE StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828)), I80) END AND (COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#237866L > 6))

WholeStageCodegen (6)

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

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

WholeStageCodegen (5)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846, 10), ENSURE_REQUIREMENTS, [plan_id=22869]

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

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

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_74CB5837_B051_4D74_88FC_80227199D913#237839, 10), ENSURE_REQUIREMENTS, [plan_id=22821]

Project [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, vers, LEFT) AS COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, vers, RIGHT) AS COL_C0071F45_39F2_4647_A05D_4CE10B360D89#237833, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, >, LEFT), ALL) AS COL_74CB5837_B051_4D74_88FC_80227199D913#237839, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, >, RIGHT), ALL) AS COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846]

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

WholeStageCodegen (3)

AQEShuffleRead coalesced

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

HashAggregate(keys=[COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#237568, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#237566, COL_447775BC_9753_403A_8C59_368E68ECF1A1#237567L], functions=[])

WholeStageCodegen (2)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#237568, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#237566, COL_447775BC_9753_403A_8C59_368E68ECF1A1#237567L, 10), ENSURE_REQUIREMENTS, [plan_id=22684]

HashAggregate(keys=[COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#237568, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#237566, COL_447775BC_9753_403A_8C59_368E68ECF1A1#237567L], functions=[])

Project [COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#237158 AS COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#237566, COL_08215A85_C797_468A_A885_85343F2B85C7#237161L AS COL_447775BC_9753_403A_8C59_368E68ECF1A1#237567L, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#237159 AS COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#237568]

Filter ((CASE WHEN isnull(((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#237106 >= 70.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#237106 <= 120.0))) THEN false ELSE ((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#237106 >= 70.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#237106 <= 120.0)) END AND isnotnull(str_remove_accent(upper(COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#237145)))) AND isnotnull(str_remove_accent(upper(COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#237146))))

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#237106,COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#237145,COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#237146,COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#237158,COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#237159,COL_08215A85_C797_468A_A885_85343F2B85C7#237161L] Batched: true, DataFilters: [CASE WHEN isnull(((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#237106 >= 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#237106, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#237145, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#237146, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#237158, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#237159, COL_08215A85_C797_468A_A885_85343F2B85C7#237161L]
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#237106, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#237145, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#237146, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#237158, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#237159, COL_08215A85_C797_468A_A885_85343F2B85C7#237161L]

(3) Filter [codegen id : 1]
Input [6]: [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#237106, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#237145, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#237146, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#237158, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#237159, COL_08215A85_C797_468A_A885_85343F2B85C7#237161L]
Condition : ((CASE WHEN isnull(((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#237106 >= 70.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#237106 <= 120.0))) THEN false ELSE ((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#237106 >= 70.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#237106 <= 120.0)) END AND isnotnull(str_remove_accent(upper(COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#237145)))) AND isnotnull(str_remove_accent(upper(COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#237146))))

(4) Project [codegen id : 1]
Output [3]: [COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#237158 AS COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#237566, COL_08215A85_C797_468A_A885_85343F2B85C7#237161L AS COL_447775BC_9753_403A_8C59_368E68ECF1A1#237567L, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#237159 AS COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#237568]
Input [6]: [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#237106, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#237145, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#237146, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#237158, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#237159, COL_08215A85_C797_468A_A885_85343F2B85C7#237161L]

(5) HashAggregate [codegen id : 1]
Input [3]: [COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#237566, COL_447775BC_9753_403A_8C59_368E68ECF1A1#237567L, COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#237568]
Keys [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#237568, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#237566, COL_447775BC_9753_403A_8C59_368E68ECF1A1#237567L]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#237568, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#237566, COL_447775BC_9753_403A_8C59_368E68ECF1A1#237567L]

(6) Exchange
Input [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#237568, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#237566, COL_447775BC_9753_403A_8C59_368E68ECF1A1#237567L]
Arguments: hashpartitioning(COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#237568, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#237566, COL_447775BC_9753_403A_8C59_368E68ECF1A1#237567L, 10), ENSURE_REQUIREMENTS, [plan_id=22684]

(7) ShuffleQueryStage
Output [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#237568, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#237566, COL_447775BC_9753_403A_8C59_368E68ECF1A1#237567L]
Arguments: 0

(8) AQEShuffleRead
Input [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#237568, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#237566, COL_447775BC_9753_403A_8C59_368E68ECF1A1#237567L]
Arguments: coalesced

(9) HashAggregate [codegen id : 2]
Input [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#237568, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#237566, COL_447775BC_9753_403A_8C59_368E68ECF1A1#237567L]
Keys [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#237568, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#237566, COL_447775BC_9753_403A_8C59_368E68ECF1A1#237567L]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#237568 AS COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#237566 AS COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_447775BC_9753_403A_8C59_368E68ECF1A1#237567L AS COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L]

(10) Exchange
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L]
Arguments: rangepartitioning(COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L DESC NULLS LAST, 10), ENSURE_REQUIREMENTS, [plan_id=22759]

(11) ShuffleQueryStage
Output [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L]
Arguments: 1

(12) AQEShuffleRead
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L]
Arguments: coalesced

(13) Sort [codegen id : 3]
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L]
Arguments: [COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L DESC NULLS LAST], true, 0

(14) Project [codegen id : 3]
Output [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, vers, LEFT) AS COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, vers, RIGHT) AS COL_C0071F45_39F2_4647_A05D_4CE10B360D89#237833, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, >, LEFT), ALL) AS COL_74CB5837_B051_4D74_88FC_80227199D913#237839, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, >, RIGHT), ALL) AS COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846]
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L]

(15) Exchange
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#237833, COL_74CB5837_B051_4D74_88FC_80227199D913#237839, COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846]
Arguments: hashpartitioning(COL_74CB5837_B051_4D74_88FC_80227199D913#237839, 10), ENSURE_REQUIREMENTS, [plan_id=22821]

(16) ShuffleQueryStage
Output [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#237833, COL_74CB5837_B051_4D74_88FC_80227199D913#237839, COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846]
Arguments: 2

(17) AQEShuffleRead
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#237833, COL_74CB5837_B051_4D74_88FC_80227199D913#237839, COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846]
Arguments: coalesced

(18) Sort [codegen id : 4]
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#237833, COL_74CB5837_B051_4D74_88FC_80227199D913#237839, COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846]
Arguments: [COL_74CB5837_B051_4D74_88FC_80227199D913#237839 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(19) Window
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#237833, COL_74CB5837_B051_4D74_88FC_80227199D913#237839, COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846]
Arguments: [count(1) windowspecdefinition(COL_74CB5837_B051_4D74_88FC_80227199D913#237839, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#237866L], [COL_74CB5837_B051_4D74_88FC_80227199D913#237839], [1 DESC NULLS LAST]

(20) Exchange
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#237833, COL_74CB5837_B051_4D74_88FC_80227199D913#237839, COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#237866L]
Arguments: hashpartitioning(COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846, 10), ENSURE_REQUIREMENTS, [plan_id=22869]

(21) ShuffleQueryStage
Output [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#237833, COL_74CB5837_B051_4D74_88FC_80227199D913#237839, COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#237866L]
Arguments: 3

(22) AQEShuffleRead
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#237833, COL_74CB5837_B051_4D74_88FC_80227199D913#237839, COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#237866L]
Arguments: coalesced

(23) Sort [codegen id : 5]
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#237833, COL_74CB5837_B051_4D74_88FC_80227199D913#237839, COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#237866L]
Arguments: [COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(24) Window
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#237833, COL_74CB5837_B051_4D74_88FC_80227199D913#237839, COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#237866L]
Arguments: [count(1) windowspecdefinition(COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#237910L], [COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846], [1 DESC NULLS LAST]

(25) Filter [codegen id : 6]
Input [9]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#237833, COL_74CB5837_B051_4D74_88FC_80227199D913#237839, COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#237866L, COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#237910L]
Condition : (CASE WHEN isnull(StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828)), I80)) THEN false ELSE StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828)), I80) END AND (COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#237866L > 6))

(26) Filter
Input [6]: [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#237106, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#237145, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#237146, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#237158, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#237159, COL_08215A85_C797_468A_A885_85343F2B85C7#237161L]
Condition : ((CASE WHEN isnull(((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#237106 >= 70.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#237106 <= 120.0))) THEN false ELSE ((COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#237106 >= 70.0) AND (COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#237106 <= 120.0)) END AND isnotnull(str_remove_accent(upper(COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#237145)))) AND isnotnull(str_remove_accent(upper(COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#237146))))

(27) Project
Output [3]: [COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#237158 AS COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#237566, COL_08215A85_C797_468A_A885_85343F2B85C7#237161L AS COL_447775BC_9753_403A_8C59_368E68ECF1A1#237567L, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#237159 AS COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#237568]
Input [6]: [COL_730E830A_DE0D_4568_81F4_ED74ECA509F0#237106, COL_68ABC630_B0FE_4524_AACD_A6B7EB5E7016#237145, COL_8DCDFE16_85E1_44B4_85E1_E1D2B4CC4268#237146, COL_641ECF5E_A0C9_4254_AA24_8ECD80D34AC2#237158, COL_C32CD6CE_0E17_4447_AAFF_961B06D2083E#237159, COL_08215A85_C797_468A_A885_85343F2B85C7#237161L]

(28) HashAggregate
Input [3]: [COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#237566, COL_447775BC_9753_403A_8C59_368E68ECF1A1#237567L, COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#237568]
Keys [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#237568, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#237566, COL_447775BC_9753_403A_8C59_368E68ECF1A1#237567L]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#237568, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#237566, COL_447775BC_9753_403A_8C59_368E68ECF1A1#237567L]

(29) Exchange
Input [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#237568, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#237566, COL_447775BC_9753_403A_8C59_368E68ECF1A1#237567L]
Arguments: hashpartitioning(COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#237568, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#237566, COL_447775BC_9753_403A_8C59_368E68ECF1A1#237567L, 10), ENSURE_REQUIREMENTS, [plan_id=22632]

(30) HashAggregate
Input [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#237568, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#237566, COL_447775BC_9753_403A_8C59_368E68ECF1A1#237567L]
Keys [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#237568, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#237566, COL_447775BC_9753_403A_8C59_368E68ECF1A1#237567L]
Functions: []
Aggregate Attributes: []
Results [3]: [COL_1C2B51C8_E3EA_4B18_AD4A_0167A0270030#237568 AS COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_60F6BA43_7D55_41A9_8EE8_E9F1DD8B576F#237566 AS COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_447775BC_9753_403A_8C59_368E68ECF1A1#237567L AS COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L]

(31) Exchange
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L]
Arguments: rangepartitioning(COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L DESC NULLS LAST, 10), ENSURE_REQUIREMENTS, [plan_id=22635]

(32) Sort
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L]
Arguments: [COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L DESC NULLS LAST], true, 0

(33) Project
Output [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, vers, LEFT) AS COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828, str_extract_by_str(COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, vers, RIGHT) AS COL_C0071F45_39F2_4647_A05D_4CE10B360D89#237833, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, >, LEFT), ALL) AS COL_74CB5837_B051_4D74_88FC_80227199D913#237839, str_remove_space(str_extract_by_str(COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, >, RIGHT), ALL) AS COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846]
Input [3]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L]

(34) Exchange
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#237833, COL_74CB5837_B051_4D74_88FC_80227199D913#237839, COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846]
Arguments: hashpartitioning(COL_74CB5837_B051_4D74_88FC_80227199D913#237839, 10), ENSURE_REQUIREMENTS, [plan_id=22639]

(35) Sort
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#237833, COL_74CB5837_B051_4D74_88FC_80227199D913#237839, COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846]
Arguments: [COL_74CB5837_B051_4D74_88FC_80227199D913#237839 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(36) Window
Input [7]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#237833, COL_74CB5837_B051_4D74_88FC_80227199D913#237839, COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846]
Arguments: [count(1) windowspecdefinition(COL_74CB5837_B051_4D74_88FC_80227199D913#237839, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#237866L], [COL_74CB5837_B051_4D74_88FC_80227199D913#237839], [1 DESC NULLS LAST]

(37) Exchange
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#237833, COL_74CB5837_B051_4D74_88FC_80227199D913#237839, COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#237866L]
Arguments: hashpartitioning(COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846, 10), ENSURE_REQUIREMENTS, [plan_id=22643]

(38) Sort
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#237833, COL_74CB5837_B051_4D74_88FC_80227199D913#237839, COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#237866L]
Arguments: [COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(39) Window
Input [8]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#237833, COL_74CB5837_B051_4D74_88FC_80227199D913#237839, COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#237866L]
Arguments: [count(1) windowspecdefinition(COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#237910L], [COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846], [1 DESC NULLS LAST]

(40) Filter
Input [9]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#237833, COL_74CB5837_B051_4D74_88FC_80227199D913#237839, COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#237866L, COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#237910L]
Condition : (CASE WHEN isnull(StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828)), I80)) THEN false ELSE StartsWith(str_remove_accent(upper(COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828)), I80) END AND (COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#237866L > 6))

(41) CollectLimit
Input [9]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#237833, COL_74CB5837_B051_4D74_88FC_80227199D913#237839, COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#237866L, COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#237910L]
Arguments: 500000

(42) AdaptiveSparkPlan
Output [9]: [COL_761D922A_3096_473B_B3CD_74702FAB0A37#237746, COL_EAB5145E_CEDF_4A7A_B5BC_1509E3E8FF4F#237747, COL_CF25CDD4_3147_4596_A092_3342AD5F9B7A#237748L, COL_5117BBC9_4718_44C7_BEEB_591691B1DC62#237828, COL_C0071F45_39F2_4647_A05D_4CE10B360D89#237833, COL_74CB5837_B051_4D74_88FC_80227199D913#237839, COL_A566A02B_4004_4838_8B0D_30546A1991F2#237846, COL_E61C2939_40E6_4F16_BD1D_8F36CEE8AD1A#237866L, COL_7ED45FF5_BCCF_4F91_A73F_41277C8490E2#237910L]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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