SP1 - Details for Query 441

Submitted Time: 2026/06/25 16:28:24
Duration: 0.4 s
Succeeded Jobs: 589 590 591

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; 1 [labelType="html" label="Execute InsertIntoHadoopFsRelationCommand task commit time: 1 ms number of written files: 1 job commit time: 15 ms number of output rows: 7 number of dynamic part: 0 written output: 3.3 KiB"]; 2 [labelType="html" label=" WriteFiles "]; subgraph cluster3 { isCluster="true"; label="WholeStageCodegen (5)\n \nduration: 38 ms"; 4 [labelType="html" label=" Project "]; 5 [labelType="html" label=" Project "]; 6 [labelType="html" label=" Project "]; 7 [labelType="html" label=" Project "]; 8 [labelType="html" label=" Project "]; 9 [labelType="html" label=" Project "]; 10 [labelType="html" label="Filter number of output rows: 7"]; } 11 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (4)\n \nduration: 128 ms"; 13 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 14 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 21.7 KiB number of coalesced partitions: 1"]; 15 [labelType="html" label="Exchange shuffle records written: 1,455 local merged chunks fetched: 0 shuffle write time: 0 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: 1,455 local bytes read: 19.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: 136.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: 19.7 KiB"]; subgraph cluster16 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 4 ms"; 17 [labelType="html" label=" Project "]; } 18 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster19 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 13 ms"; 20 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 21 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 21.5 KiB number of coalesced partitions: 1"]; 22 [labelType="html" label="Exchange shuffle records written: 1,455 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: 1,455 local bytes read: 20.4 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: 102.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: 20.4 KiB"]; subgraph cluster23 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 6 ms"; 24 [labelType="html" label=" Project "]; 25 [labelType="html" label="ColumnarToRow number of output rows: 1,455 number of input batches: 1"]; } 26 [labelType="html" label="Scan parquet number of files read: 1 scan time: 3 ms metadata time: 0 ms size of files read: 312.5 KiB number of output rows: 1,455"]; 1->0; 2->1; 4->2; 5->4; 6->5; 7->6; 8->7; 9->8; 10->9; 11->10; 13->11; 14->13; 15->14; 17->15; 18->17; 20->18; 21->20; 22->21; 24->22; 25->24; 26->25; }

AdaptiveSparkPlan isFinalPlan=true

Execute InsertIntoHadoopFsRelationCommand file:/data/output/cache/parquet/datablock/ANALYSE_PAR_TAU_405655, false, Parquet, [path=file:///data/output/cache/parquet/datablock/ANALYSE_PAR_TAU_405655], Overwrite, [COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A, COL_8057B77C_2D2A_45F4_B46B_267846CBC997, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C, COL_B48EE4DF_9CD6_4E2F_908E_7F131B2D4497, COL_D059B2EF_C479_49B5_8BD9_174193A57D69, COL_4A3BE3E0_8706_45AF_A672_639EA10134CE, COL_9140CD38_BB23_4D29_B56F_DA36C1AB6634]

WriteFiles

Project [COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819, COL_8057B77C_2D2A_45F4_B46B_267846CBC997#178879, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#178865, str_if_with_rule(CASE WHEN isnull(COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910) THEN false ELSE (COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910 <= 3) END, str_join(array(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894, €), ), str_if_with_rule(CASE WHEN isnull(((COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910 >= 4) AND (COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910 <= 6))) THEN false ELSE ((COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910 >= 4) AND (COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910 <= 6)) END, str_join(array(str_extract_middle(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894, 1, int_diff(array(COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910, 3))), str_extract(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894, RIGHT, 3), €, ), ), str_if_with_rule(CASE WHEN isnull(COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910) THEN false ELSE (COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910 > 6) END, str_join(array(str_extract_middle(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894, 1, int_diff(array(COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910, 6))), str_extract_middle(str_extract(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894, RIGHT, 6), 1, 3), str_extract(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894, RIGHT, 3), €, ), ), ))) AS COL_B48EE4DF_9CD6_4E2F_908E_7F131B2D4497#178988, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#178829, str_extract_middle(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, 1, 2) AS COL_4A3BE3E0_8706_45AF_A672_639EA10134CE#178990, str_extract_middle(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, 5, 100) AS COL_9140CD38_BB23_4D29_B56F_DA36C1AB6634#178991]

Project [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#178829, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#178865, COL_8057B77C_2D2A_45F4_B46B_267846CBC997#178879, COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894, str_size(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894) AS COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910]

Project [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#178829, str_if_with_rule(CASE WHEN isnull(COL_DA71D365_04CC_4409_939D_3415039D9980#178852) THEN false ELSE (COL_DA71D365_04CC_4409_939D_3415039D9980#178852 <= 3) END, str_join(array(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840, €), ), str_if_with_rule(CASE WHEN isnull(((COL_DA71D365_04CC_4409_939D_3415039D9980#178852 >= 4) AND (COL_DA71D365_04CC_4409_939D_3415039D9980#178852 <= 6))) THEN false ELSE ((COL_DA71D365_04CC_4409_939D_3415039D9980#178852 >= 4) AND (COL_DA71D365_04CC_4409_939D_3415039D9980#178852 <= 6)) END, str_join(array(str_extract_middle(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840, 1, int_diff(array(COL_DA71D365_04CC_4409_939D_3415039D9980#178852, 3))), str_extract(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840, RIGHT, 3), €, ), ), str_if_with_rule(CASE WHEN isnull(COL_DA71D365_04CC_4409_939D_3415039D9980#178852) THEN false ELSE (COL_DA71D365_04CC_4409_939D_3415039D9980#178852 > 6) END, str_join(array(str_extract_middle(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840, 1, int_diff(array(COL_DA71D365_04CC_4409_939D_3415039D9980#178852, 6))), str_extract_middle(str_extract(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840, RIGHT, 6), 1, 3), str_extract(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840, RIGHT, 3), €, ), ), ))) AS COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#178865, str_if_with_rule(isnotnull(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809), str_join(array(dec_to_str(COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#178807), %), ), ) AS COL_8057B77C_2D2A_45F4_B46B_267846CBC997#178879, str_extract_by_str(dec_to_str(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809), ., LEFT) AS COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894]

Project [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#178807, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819, str_if_with_rule(isnotnull(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809), str_join(array(dec_to_str(dec_round(dec_mult(array(dec_div(array(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809, COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#178810)), 100.0)), 2)), %), ), null) AS COL_D059B2EF_C479_49B5_8BD9_174193A57D69#178829, str_extract_by_str(dec_to_str(COL_35959880_BB9F_4A00_9A1F_6812432D358E#178806), .0, LEFT) AS COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840]

Project [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, round(COL_35959880_BB9F_4A00_9A1F_6812432D358E#177515, 0) AS COL_35959880_BB9F_4A00_9A1F_6812432D358E#178806, round(COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#177690, 2) AS COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#178807, round(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#177868, 0) AS COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809, round(COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#178419, 0) AS COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#178810, str_join(array(dec_to_str(dec_round(dec_mult(array(dec_div(array(COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L)), 100.0)), 2)), %), ) AS COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819]

Filter (COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#178234 <=> 1)

WholeStageCodegen (5)

Window [sum(COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#178419], [1], [1 DESC NULLS LAST]

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

WholeStageCodegen (4)

AQEShuffleRead coalesced

Exchange hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=23815]

Project [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399, COL_35959880_BB9F_4A00_9A1F_6812432D358E#177515, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#177690, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#177868, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#178234]

WholeStageCodegen (3)

Window [sum(COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#177393) windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_35959880_BB9F_4A00_9A1F_6812432D358E#177515, avg(COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#177388) windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#177690, sum(COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399) windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#177868, count(1) windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, row_number() windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#178234], [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L], [1 DESC NULLS LAST]

Sort [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396 ASC NULLS FIRST, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (2)

AQEShuffleRead coalesced

Exchange hashpartitioning(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, 10), ENSURE_REQUIREMENTS, [plan_id=23719]

Project [COL_35375170_B542_49DE_AFA2_0A2D31967891#176943L AS COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#176948 AS COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#177388, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#176954 AS COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#177393, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#176957 AS COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#176950 AS COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_35375170_B542_49DE_AFA2_0A2D31967891#176943L,COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#176948,COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#176950,COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#176954,COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#176957] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/MATCHING_ANALYS_405366], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_35375170_B542_49DE_AFA2_0A2D31967891:bigint,COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE:d...

Details

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


(1) Scan parquet 
Output [5]: [COL_35375170_B542_49DE_AFA2_0A2D31967891#176943L, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#176948, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#176950, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#176954, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#176957]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/MATCHING_ANALYS_405366]
ReadSchema: struct<COL_35375170_B542_49DE_AFA2_0A2D31967891:bigint,COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE:double,COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD:double,COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028:double,COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4:string>

(2) ColumnarToRow [codegen id : 1]
Input [5]: [COL_35375170_B542_49DE_AFA2_0A2D31967891#176943L, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#176948, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#176950, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#176954, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#176957]

(3) Project [codegen id : 1]
Output [5]: [COL_35375170_B542_49DE_AFA2_0A2D31967891#176943L AS COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#176948 AS COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#177388, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#176954 AS COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#177393, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#176957 AS COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#176950 AS COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399]
Input [5]: [COL_35375170_B542_49DE_AFA2_0A2D31967891#176943L, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#176948, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#176950, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#176954, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#176957]

(4) Exchange
Input [5]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#177388, COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#177393, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399]
Arguments: hashpartitioning(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, 10), ENSURE_REQUIREMENTS, [plan_id=23719]

(5) ShuffleQueryStage
Output [5]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#177388, COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#177393, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399]
Arguments: 0

(6) AQEShuffleRead
Input [5]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#177388, COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#177393, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399]
Arguments: coalesced

(7) Sort [codegen id : 2]
Input [5]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#177388, COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#177393, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399]
Arguments: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396 ASC NULLS FIRST, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(8) Window
Input [5]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#177388, COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#177393, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399]
Arguments: [sum(COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#177393) windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_35959880_BB9F_4A00_9A1F_6812432D358E#177515, avg(COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#177388) windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#177690, sum(COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399) windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#177868, count(1) windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, row_number() windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#178234], [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L], [1 DESC NULLS LAST]

(9) Project [codegen id : 3]
Output [8]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399, COL_35959880_BB9F_4A00_9A1F_6812432D358E#177515, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#177690, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#177868, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#178234]
Input [10]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#177388, COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#177393, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399, COL_35959880_BB9F_4A00_9A1F_6812432D358E#177515, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#177690, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#177868, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#178234]

(10) Exchange
Input [8]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399, COL_35959880_BB9F_4A00_9A1F_6812432D358E#177515, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#177690, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#177868, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#178234]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=23815]

(11) ShuffleQueryStage
Output [8]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399, COL_35959880_BB9F_4A00_9A1F_6812432D358E#177515, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#177690, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#177868, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#178234]
Arguments: 1

(12) AQEShuffleRead
Input [8]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399, COL_35959880_BB9F_4A00_9A1F_6812432D358E#177515, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#177690, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#177868, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#178234]
Arguments: coalesced

(13) Sort [codegen id : 4]
Input [8]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399, COL_35959880_BB9F_4A00_9A1F_6812432D358E#177515, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#177690, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#177868, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#178234]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(14) Window
Input [8]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399, COL_35959880_BB9F_4A00_9A1F_6812432D358E#177515, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#177690, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#177868, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#178234]
Arguments: [sum(COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#178419], [1], [1 DESC NULLS LAST]

(15) Filter [codegen id : 5]
Input [9]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399, COL_35959880_BB9F_4A00_9A1F_6812432D358E#177515, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#177690, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#177868, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#178234, COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#178419]
Condition : (COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#178234 <=> 1)

(16) Project [codegen id : 5]
Output [7]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, round(COL_35959880_BB9F_4A00_9A1F_6812432D358E#177515, 0) AS COL_35959880_BB9F_4A00_9A1F_6812432D358E#178806, round(COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#177690, 2) AS COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#178807, round(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#177868, 0) AS COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809, round(COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#178419, 0) AS COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#178810, str_join(array(dec_to_str(dec_round(dec_mult(array(dec_div(array(COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L)), 100.0)), 2)), %),  ) AS COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819]
Input [9]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399, COL_35959880_BB9F_4A00_9A1F_6812432D358E#177515, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#177690, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#177868, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#178234, COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#178419]

(17) Project [codegen id : 5]
Output [7]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#178807, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819, str_if_with_rule(isnotnull(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809), str_join(array(dec_to_str(dec_round(dec_mult(array(dec_div(array(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809, COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#178810)), 100.0)), 2)), %),  ), null) AS COL_D059B2EF_C479_49B5_8BD9_174193A57D69#178829, str_extract_by_str(dec_to_str(COL_35959880_BB9F_4A00_9A1F_6812432D358E#178806), .0, LEFT) AS COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840]
Input [7]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_35959880_BB9F_4A00_9A1F_6812432D358E#178806, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#178807, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809, COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#178810, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819]

(18) Project [codegen id : 5]
Output [8]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#178807, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#178829, COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840, str_size(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840) AS COL_DA71D365_04CC_4409_939D_3415039D9980#178852]
Input [7]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#178807, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#178829, COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840]

(19) Project [codegen id : 5]
Output [7]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#178829, str_if_with_rule(CASE WHEN isnull(COL_DA71D365_04CC_4409_939D_3415039D9980#178852) THEN false ELSE (COL_DA71D365_04CC_4409_939D_3415039D9980#178852 <= 3) END, str_join(array(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840, €),  ), str_if_with_rule(CASE WHEN isnull(((COL_DA71D365_04CC_4409_939D_3415039D9980#178852 >= 4) AND (COL_DA71D365_04CC_4409_939D_3415039D9980#178852 <= 6))) THEN false ELSE ((COL_DA71D365_04CC_4409_939D_3415039D9980#178852 >= 4) AND (COL_DA71D365_04CC_4409_939D_3415039D9980#178852 <= 6)) END, str_join(array(str_extract_middle(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840, 1, int_diff(array(COL_DA71D365_04CC_4409_939D_3415039D9980#178852, 3))), str_extract(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840, RIGHT, 3), €, ),  ), str_if_with_rule(CASE WHEN isnull(COL_DA71D365_04CC_4409_939D_3415039D9980#178852) THEN false ELSE (COL_DA71D365_04CC_4409_939D_3415039D9980#178852 > 6) END, str_join(array(str_extract_middle(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840, 1, int_diff(array(COL_DA71D365_04CC_4409_939D_3415039D9980#178852, 6))), str_extract_middle(str_extract(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840, RIGHT, 6), 1, 3), str_extract(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840, RIGHT, 3), €, ),  ), ))) AS COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#178865, str_if_with_rule(isnotnull(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809), str_join(array(dec_to_str(COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#178807), %),  ), ) AS COL_8057B77C_2D2A_45F4_B46B_267846CBC997#178879, str_extract_by_str(dec_to_str(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809), ., LEFT) AS COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894]
Input [8]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#178807, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#178829, COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840, COL_DA71D365_04CC_4409_939D_3415039D9980#178852]

(20) Project [codegen id : 5]
Output [8]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#178829, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#178865, COL_8057B77C_2D2A_45F4_B46B_267846CBC997#178879, COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894, str_size(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894) AS COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910]
Input [7]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#178829, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#178865, COL_8057B77C_2D2A_45F4_B46B_267846CBC997#178879, COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894]

(21) Project [codegen id : 5]
Output [8]: [COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819, COL_8057B77C_2D2A_45F4_B46B_267846CBC997#178879, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#178865, str_if_with_rule(CASE WHEN isnull(COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910) THEN false ELSE (COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910 <= 3) END, str_join(array(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894, €),  ), str_if_with_rule(CASE WHEN isnull(((COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910 >= 4) AND (COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910 <= 6))) THEN false ELSE ((COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910 >= 4) AND (COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910 <= 6)) END, str_join(array(str_extract_middle(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894, 1, int_diff(array(COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910, 3))), str_extract(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894, RIGHT, 3), €, ),  ), str_if_with_rule(CASE WHEN isnull(COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910) THEN false ELSE (COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910 > 6) END, str_join(array(str_extract_middle(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894, 1, int_diff(array(COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910, 6))), str_extract_middle(str_extract(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894, RIGHT, 6), 1, 3), str_extract(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894, RIGHT, 3), €, ),  ), ))) AS COL_B48EE4DF_9CD6_4E2F_908E_7F131B2D4497#178988, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#178829, str_extract_middle(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, 1, 2) AS COL_4A3BE3E0_8706_45AF_A672_639EA10134CE#178990, str_extract_middle(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, 5, 100) AS COL_9140CD38_BB23_4D29_B56F_DA36C1AB6634#178991]
Input [8]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#178829, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#178865, COL_8057B77C_2D2A_45F4_B46B_267846CBC997#178879, COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894, COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910]

(22) WriteFiles
Input [8]: [COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819, COL_8057B77C_2D2A_45F4_B46B_267846CBC997#178879, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#178865, COL_B48EE4DF_9CD6_4E2F_908E_7F131B2D4497#178988, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#178829, COL_4A3BE3E0_8706_45AF_A672_639EA10134CE#178990, COL_9140CD38_BB23_4D29_B56F_DA36C1AB6634#178991]

(23) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/ANALYSE_PAR_TAU_405655, false, Parquet, [path=file:///data/output/cache/parquet/datablock/ANALYSE_PAR_TAU_405655], Overwrite, [COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A, COL_8057B77C_2D2A_45F4_B46B_267846CBC997, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C, COL_B48EE4DF_9CD6_4E2F_908E_7F131B2D4497, COL_D059B2EF_C479_49B5_8BD9_174193A57D69, COL_4A3BE3E0_8706_45AF_A672_639EA10134CE, COL_9140CD38_BB23_4D29_B56F_DA36C1AB6634]

(24) Project
Output [5]: [COL_35375170_B542_49DE_AFA2_0A2D31967891#176943L AS COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#176948 AS COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#177388, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#176954 AS COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#177393, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#176957 AS COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#176950 AS COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399]
Input [5]: [COL_35375170_B542_49DE_AFA2_0A2D31967891#176943L, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#176948, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#176950, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#176954, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#176957]

(25) Exchange
Input [5]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#177388, COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#177393, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399]
Arguments: hashpartitioning(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, 10), ENSURE_REQUIREMENTS, [plan_id=23683]

(26) Sort
Input [5]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#177388, COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#177393, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399]
Arguments: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396 ASC NULLS FIRST, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(27) Window
Input [5]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#177388, COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#177393, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399]
Arguments: [sum(COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#177393) windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_35959880_BB9F_4A00_9A1F_6812432D358E#177515, avg(COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#177388) windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#177690, sum(COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399) windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#177868, count(1) windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, row_number() windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#178234], [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L], [1 DESC NULLS LAST]

(28) Project
Output [8]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399, COL_35959880_BB9F_4A00_9A1F_6812432D358E#177515, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#177690, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#177868, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#178234]
Input [10]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#177388, COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#177393, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399, COL_35959880_BB9F_4A00_9A1F_6812432D358E#177515, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#177690, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#177868, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#178234]

(29) Exchange
Input [8]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399, COL_35959880_BB9F_4A00_9A1F_6812432D358E#177515, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#177690, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#177868, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#178234]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=23688]

(30) Sort
Input [8]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399, COL_35959880_BB9F_4A00_9A1F_6812432D358E#177515, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#177690, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#177868, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#178234]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(31) Window
Input [8]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399, COL_35959880_BB9F_4A00_9A1F_6812432D358E#177515, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#177690, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#177868, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#178234]
Arguments: [sum(COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#178419], [1], [1 DESC NULLS LAST]

(32) Filter
Input [9]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399, COL_35959880_BB9F_4A00_9A1F_6812432D358E#177515, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#177690, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#177868, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#178234, COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#178419]
Condition : (COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#178234 <=> 1)

(33) Project
Output [7]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, round(COL_35959880_BB9F_4A00_9A1F_6812432D358E#177515, 0) AS COL_35959880_BB9F_4A00_9A1F_6812432D358E#178806, round(COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#177690, 2) AS COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#178807, round(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#177868, 0) AS COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809, round(COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#178419, 0) AS COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#178810, str_join(array(dec_to_str(dec_round(dec_mult(array(dec_div(array(COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L)), 100.0)), 2)), %),  ) AS COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819]
Input [9]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#177383L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#177399, COL_35959880_BB9F_4A00_9A1F_6812432D358E#177515, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#177690, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#177868, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#178234, COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#178419]

(34) Project
Output [7]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#178807, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819, str_if_with_rule(isnotnull(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809), str_join(array(dec_to_str(dec_round(dec_mult(array(dec_div(array(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809, COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#178810)), 100.0)), 2)), %),  ), null) AS COL_D059B2EF_C479_49B5_8BD9_174193A57D69#178829, str_extract_by_str(dec_to_str(COL_35959880_BB9F_4A00_9A1F_6812432D358E#178806), .0, LEFT) AS COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840]
Input [7]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_35959880_BB9F_4A00_9A1F_6812432D358E#178806, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#178807, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809, COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#178810, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819]

(35) Project
Output [8]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#178807, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#178829, COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840, str_size(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840) AS COL_DA71D365_04CC_4409_939D_3415039D9980#178852]
Input [7]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#178807, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#178829, COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840]

(36) Project
Output [7]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#178829, str_if_with_rule(CASE WHEN isnull(COL_DA71D365_04CC_4409_939D_3415039D9980#178852) THEN false ELSE (COL_DA71D365_04CC_4409_939D_3415039D9980#178852 <= 3) END, str_join(array(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840, €),  ), str_if_with_rule(CASE WHEN isnull(((COL_DA71D365_04CC_4409_939D_3415039D9980#178852 >= 4) AND (COL_DA71D365_04CC_4409_939D_3415039D9980#178852 <= 6))) THEN false ELSE ((COL_DA71D365_04CC_4409_939D_3415039D9980#178852 >= 4) AND (COL_DA71D365_04CC_4409_939D_3415039D9980#178852 <= 6)) END, str_join(array(str_extract_middle(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840, 1, int_diff(array(COL_DA71D365_04CC_4409_939D_3415039D9980#178852, 3))), str_extract(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840, RIGHT, 3), €, ),  ), str_if_with_rule(CASE WHEN isnull(COL_DA71D365_04CC_4409_939D_3415039D9980#178852) THEN false ELSE (COL_DA71D365_04CC_4409_939D_3415039D9980#178852 > 6) END, str_join(array(str_extract_middle(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840, 1, int_diff(array(COL_DA71D365_04CC_4409_939D_3415039D9980#178852, 6))), str_extract_middle(str_extract(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840, RIGHT, 6), 1, 3), str_extract(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840, RIGHT, 3), €, ),  ), ))) AS COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#178865, str_if_with_rule(isnotnull(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809), str_join(array(dec_to_str(COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#178807), %),  ), ) AS COL_8057B77C_2D2A_45F4_B46B_267846CBC997#178879, str_extract_by_str(dec_to_str(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809), ., LEFT) AS COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894]
Input [8]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#178807, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#178809, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#178829, COL_F57782B5_7068_4AE5_B7D4_D3D657568762#178840, COL_DA71D365_04CC_4409_939D_3415039D9980#178852]

(37) Project
Output [8]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#178829, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#178865, COL_8057B77C_2D2A_45F4_B46B_267846CBC997#178879, COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894, str_size(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894) AS COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910]
Input [7]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#178829, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#178865, COL_8057B77C_2D2A_45F4_B46B_267846CBC997#178879, COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894]

(38) Project
Output [8]: [COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819, COL_8057B77C_2D2A_45F4_B46B_267846CBC997#178879, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#178865, str_if_with_rule(CASE WHEN isnull(COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910) THEN false ELSE (COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910 <= 3) END, str_join(array(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894, €),  ), str_if_with_rule(CASE WHEN isnull(((COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910 >= 4) AND (COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910 <= 6))) THEN false ELSE ((COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910 >= 4) AND (COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910 <= 6)) END, str_join(array(str_extract_middle(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894, 1, int_diff(array(COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910, 3))), str_extract(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894, RIGHT, 3), €, ),  ), str_if_with_rule(CASE WHEN isnull(COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910) THEN false ELSE (COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910 > 6) END, str_join(array(str_extract_middle(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894, 1, int_diff(array(COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910, 6))), str_extract_middle(str_extract(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894, RIGHT, 6), 1, 3), str_extract(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894, RIGHT, 3), €, ),  ), ))) AS COL_B48EE4DF_9CD6_4E2F_908E_7F131B2D4497#178988, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#178829, str_extract_middle(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, 1, 2) AS COL_4A3BE3E0_8706_45AF_A672_639EA10134CE#178990, str_extract_middle(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, 5, 100) AS COL_9140CD38_BB23_4D29_B56F_DA36C1AB6634#178991]
Input [8]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#177396, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#178829, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#178865, COL_8057B77C_2D2A_45F4_B46B_267846CBC997#178879, COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#178894, COL_44D05B44_A9EB_4648_892E_A15D4B624742#178910]

(39) WriteFiles
Input [8]: [COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#178050L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#178819, COL_8057B77C_2D2A_45F4_B46B_267846CBC997#178879, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#178865, COL_B48EE4DF_9CD6_4E2F_908E_7F131B2D4497#178988, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#178829, COL_4A3BE3E0_8706_45AF_A672_639EA10134CE#178990, COL_9140CD38_BB23_4D29_B56F_DA36C1AB6634#178991]

(40) Execute InsertIntoHadoopFsRelationCommand
Input: []
Arguments: file:/data/output/cache/parquet/datablock/ANALYSE_PAR_TAU_405655, false, Parquet, [path=file:///data/output/cache/parquet/datablock/ANALYSE_PAR_TAU_405655], Overwrite, [COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A, COL_8057B77C_2D2A_45F4_B46B_267846CBC997, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C, COL_B48EE4DF_9CD6_4E2F_908E_7F131B2D4497, COL_D059B2EF_C479_49B5_8BD9_174193A57D69, COL_4A3BE3E0_8706_45AF_A672_639EA10134CE, COL_9140CD38_BB23_4D29_B56F_DA36C1AB6634]

(41) AdaptiveSparkPlan
Output: []
Arguments: isFinalPlan=true

SQL / DataFrame Properties

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