digraph G {
0 [labelType="html" label="<br><b>AdaptiveSparkPlan</b><br><br>"];
1 [labelType="html" label="<b>Execute InsertIntoHadoopFsRelationCommand</b><br><br>task commit time: 1 ms<br>number of written files: 1<br>job commit time: 14 ms<br>number of output rows: 7<br>number of dynamic part: 0<br>written output: 3.3 KiB"];
2 [labelType="html" label="<br><b>WriteFiles</b><br><br>"];
subgraph cluster3 {
isCluster="true";
label="WholeStageCodegen (5)\n \nduration: 34 ms";
4 [labelType="html" label="<br><b>Project</b><br><br>"];
5 [labelType="html" label="<br><b>Project</b><br><br>"];
6 [labelType="html" label="<br><b>Project</b><br><br>"];
7 [labelType="html" label="<br><b>Project</b><br><br>"];
8 [labelType="html" label="<br><b>Project</b><br><br>"];
9 [labelType="html" label="<br><b>Project</b><br><br>"];
10 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 7"];
}
11 [labelType="html" label="<b>Window</b><br><br>spill size: 0.0 B"];
subgraph cluster12 {
isCluster="true";
label="WholeStageCodegen (4)\n \nduration: 126 ms";
13 [labelType="html" label="<b>Sort</b><br><br>sort time: 0 ms<br>peak memory: 16.1 MiB<br>spill size: 0.0 B"];
}
14 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 21.7 KiB<br>number of coalesced partitions: 1"];
15 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 1,455<br>local merged chunks fetched: 0<br>shuffle write time: 0 ms<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 1,455<br>local bytes read: 19.7 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 1<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size: 136.1 KiB<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written: 19.7 KiB"];
subgraph cluster16 {
isCluster="true";
label="WholeStageCodegen (3)\n \nduration: 4 ms";
17 [labelType="html" label="<br><b>Project</b><br><br>"];
}
18 [labelType="html" label="<b>Window</b><br><br>spill size: 0.0 B"];
subgraph cluster19 {
isCluster="true";
label="WholeStageCodegen (2)\n \nduration: 13 ms";
20 [labelType="html" label="<b>Sort</b><br><br>sort time: 0 ms<br>peak memory: 16.1 MiB<br>spill size: 0.0 B"];
}
21 [labelType="html" label="<b>AQEShuffleRead</b><br><br>number of partitions: 1<br>partition data size: 21.5 KiB<br>number of coalesced partitions: 1"];
22 [labelType="html" label="<b>Exchange</b><br><br>shuffle records written: 1,455<br>local merged chunks fetched: 0<br>shuffle write time: 1 ms<br>remote merged bytes read: 0.0 B<br>local merged blocks fetched: 0<br>corrupt merged block chunks: 0<br>remote merged reqs duration: 0 ms<br>remote merged blocks fetched: 0<br>records read: 1,455<br>local bytes read: 20.4 KiB<br>fetch wait time: 0 ms<br>remote bytes read: 0.0 B<br>merged fetch fallback count: 0<br>local blocks read: 1<br>remote merged chunks fetched: 0<br>remote blocks read: 0<br>data size: 102.0 KiB<br>local merged bytes read: 0.0 B<br>number of partitions: 10<br>remote reqs duration: 0 ms<br>remote bytes read to disk: 0.0 B<br>shuffle bytes written: 20.4 KiB"];
subgraph cluster23 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 24 ms";
24 [labelType="html" label="<br><b>Project</b><br><br>"];
25 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 1,455<br>number of input batches: 1"];
}
26 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 9 ms<br>metadata time: 0 ms<br>size of files read: 312.5 KiB<br>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;
}
27
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#230172L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167, COL_8057B77C_2D2A_45F4_B46B_267846CBC997#232458, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#232414, str_if_with_rule(CASE WHEN isnull(COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572) THEN false ELSE (COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572 <= 3) END, str_join(array(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540, €), ), str_if_with_rule(CASE WHEN isnull(((COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572 >= 4) AND (COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572 <= 6))) THEN false ELSE ((COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572 >= 4) AND (COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572 <= 6)) END, str_join(array(str_extract_middle(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540, 1, int_diff(array(COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572, 3))), str_extract(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540, RIGHT, 3), €, ), ), str_if_with_rule(CASE WHEN isnull(COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572) THEN false ELSE (COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572 > 6) END, str_join(array(str_extract_middle(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540, 1, int_diff(array(COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572, 6))), str_extract_middle(str_extract(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540, RIGHT, 6), 1, 3), str_extract(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540, RIGHT, 3), €, ), ), ))) AS COL_B48EE4DF_9CD6_4E2F_908E_7F131B2D4497#232810, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#232267, str_extract_middle(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, 1, 2) AS COL_4A3BE3E0_8706_45AF_A672_639EA10134CE#232812, str_extract_middle(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, 5, 100) AS COL_9140CD38_BB23_4D29_B56F_DA36C1AB6634#232813]
Project [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#232267, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#232414, COL_8057B77C_2D2A_45F4_B46B_267846CBC997#232458, COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540, str_size(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540) AS COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572]
Project [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#232267, str_if_with_rule(CASE WHEN isnull(COL_DA71D365_04CC_4409_939D_3415039D9980#232385) THEN false ELSE (COL_DA71D365_04CC_4409_939D_3415039D9980#232385 <= 3) END, str_join(array(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322, €), ), str_if_with_rule(CASE WHEN isnull(((COL_DA71D365_04CC_4409_939D_3415039D9980#232385 >= 4) AND (COL_DA71D365_04CC_4409_939D_3415039D9980#232385 <= 6))) THEN false ELSE ((COL_DA71D365_04CC_4409_939D_3415039D9980#232385 >= 4) AND (COL_DA71D365_04CC_4409_939D_3415039D9980#232385 <= 6)) END, str_join(array(str_extract_middle(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322, 1, int_diff(array(COL_DA71D365_04CC_4409_939D_3415039D9980#232385, 3))), str_extract(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322, RIGHT, 3), €, ), ), str_if_with_rule(CASE WHEN isnull(COL_DA71D365_04CC_4409_939D_3415039D9980#232385) THEN false ELSE (COL_DA71D365_04CC_4409_939D_3415039D9980#232385 > 6) END, str_join(array(str_extract_middle(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322, 1, int_diff(array(COL_DA71D365_04CC_4409_939D_3415039D9980#232385, 6))), str_extract_middle(str_extract(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322, RIGHT, 6), 1, 3), str_extract(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322, RIGHT, 3), €, ), ), ))) AS COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#232414, str_if_with_rule(isnotnull(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129), str_join(array(dec_to_str(COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#232127), %), ), ) AS COL_8057B77C_2D2A_45F4_B46B_267846CBC997#232458, str_extract_by_str(dec_to_str(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129), ., LEFT) AS COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540]
Project [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#232127, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#232267, COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322, str_size(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322) AS COL_DA71D365_04CC_4409_939D_3415039D9980#232385]
Project [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#232127, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167, str_if_with_rule(isnotnull(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129), str_join(array(dec_to_str(dec_round(dec_mult(array(dec_div(array(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129, COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#232130)), 100.0)), 2)), %), ), null) AS COL_D059B2EF_C479_49B5_8BD9_174193A57D69#232267, str_extract_by_str(dec_to_str(COL_35959880_BB9F_4A00_9A1F_6812432D358E#232126), .0, LEFT) AS COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322]
Project [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, round(COL_35959880_BB9F_4A00_9A1F_6812432D358E#227369, 0) AS COL_35959880_BB9F_4A00_9A1F_6812432D358E#232126, round(COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#228241, 2) AS COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#232127, round(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#229398, 0) AS COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129, round(COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#231333, 0) AS COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#232130, str_join(array(dec_to_str(dec_round(dec_mult(array(dec_div(array(COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L)), 100.0)), 2)), %), ) AS COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167]
Filter (COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#230794 <=> 1)
WholeStageCodegen (5)
Window [sum(COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#231333], [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=30425]
Project [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801, COL_35959880_BB9F_4A00_9A1F_6812432D358E#227369, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#228241, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#229398, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#230794]
WholeStageCodegen (3)
Window [sum(COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#226795) windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_35959880_BB9F_4A00_9A1F_6812432D358E#227369, avg(COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#226790) windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#228241, sum(COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801) windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#229398, count(1) windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, row_number() windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#230794], [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L], [1 DESC NULLS LAST]
Sort [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798 ASC NULLS FIRST, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
WholeStageCodegen (2)
AQEShuffleRead coalesced
Exchange hashpartitioning(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, 10), ENSURE_REQUIREMENTS, [plan_id=30329]
Project [COL_35375170_B542_49DE_AFA2_0A2D31967891#224911L AS COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#224916 AS COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#226790, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#224922 AS COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#226795, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#224925 AS COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#224918 AS COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801]
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_35375170_B542_49DE_AFA2_0A2D31967891#224911L,COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#224916,COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#224918,COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#224922,COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#224925] 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...
== 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#224911L, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#224916, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#224918, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#224922, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#224925]
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#224911L, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#224916, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#224918, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#224922, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#224925]
(3) Project [codegen id : 1]
Output [5]: [COL_35375170_B542_49DE_AFA2_0A2D31967891#224911L AS COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#224916 AS COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#226790, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#224922 AS COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#226795, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#224925 AS COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#224918 AS COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801]
Input [5]: [COL_35375170_B542_49DE_AFA2_0A2D31967891#224911L, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#224916, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#224918, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#224922, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#224925]
(4) Exchange
Input [5]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#226790, COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#226795, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801]
Arguments: hashpartitioning(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, 10), ENSURE_REQUIREMENTS, [plan_id=30329]
(5) ShuffleQueryStage
Output [5]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#226790, COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#226795, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801]
Arguments: 0
(6) AQEShuffleRead
Input [5]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#226790, COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#226795, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801]
Arguments: coalesced
(7) Sort [codegen id : 2]
Input [5]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#226790, COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#226795, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801]
Arguments: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798 ASC NULLS FIRST, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(8) Window
Input [5]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#226790, COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#226795, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801]
Arguments: [sum(COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#226795) windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_35959880_BB9F_4A00_9A1F_6812432D358E#227369, avg(COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#226790) windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#228241, sum(COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801) windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#229398, count(1) windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, row_number() windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#230794], [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L], [1 DESC NULLS LAST]
(9) Project [codegen id : 3]
Output [8]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801, COL_35959880_BB9F_4A00_9A1F_6812432D358E#227369, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#228241, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#229398, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#230794]
Input [10]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#226790, COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#226795, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801, COL_35959880_BB9F_4A00_9A1F_6812432D358E#227369, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#228241, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#229398, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#230794]
(10) Exchange
Input [8]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801, COL_35959880_BB9F_4A00_9A1F_6812432D358E#227369, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#228241, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#229398, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#230794]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=30425]
(11) ShuffleQueryStage
Output [8]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801, COL_35959880_BB9F_4A00_9A1F_6812432D358E#227369, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#228241, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#229398, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#230794]
Arguments: 1
(12) AQEShuffleRead
Input [8]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801, COL_35959880_BB9F_4A00_9A1F_6812432D358E#227369, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#228241, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#229398, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#230794]
Arguments: coalesced
(13) Sort [codegen id : 4]
Input [8]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801, COL_35959880_BB9F_4A00_9A1F_6812432D358E#227369, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#228241, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#229398, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#230794]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(14) Window
Input [8]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801, COL_35959880_BB9F_4A00_9A1F_6812432D358E#227369, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#228241, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#229398, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#230794]
Arguments: [sum(COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#231333], [1], [1 DESC NULLS LAST]
(15) Filter [codegen id : 5]
Input [9]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801, COL_35959880_BB9F_4A00_9A1F_6812432D358E#227369, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#228241, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#229398, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#230794, COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#231333]
Condition : (COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#230794 <=> 1)
(16) Project [codegen id : 5]
Output [7]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, round(COL_35959880_BB9F_4A00_9A1F_6812432D358E#227369, 0) AS COL_35959880_BB9F_4A00_9A1F_6812432D358E#232126, round(COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#228241, 2) AS COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#232127, round(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#229398, 0) AS COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129, round(COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#231333, 0) AS COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#232130, str_join(array(dec_to_str(dec_round(dec_mult(array(dec_div(array(COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L)), 100.0)), 2)), %), ) AS COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167]
Input [9]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801, COL_35959880_BB9F_4A00_9A1F_6812432D358E#227369, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#228241, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#229398, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#230794, COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#231333]
(17) Project [codegen id : 5]
Output [7]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#232127, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167, str_if_with_rule(isnotnull(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129), str_join(array(dec_to_str(dec_round(dec_mult(array(dec_div(array(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129, COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#232130)), 100.0)), 2)), %), ), null) AS COL_D059B2EF_C479_49B5_8BD9_174193A57D69#232267, str_extract_by_str(dec_to_str(COL_35959880_BB9F_4A00_9A1F_6812432D358E#232126), .0, LEFT) AS COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322]
Input [7]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_35959880_BB9F_4A00_9A1F_6812432D358E#232126, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#232127, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129, COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#232130, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167]
(18) Project [codegen id : 5]
Output [8]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#232127, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#232267, COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322, str_size(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322) AS COL_DA71D365_04CC_4409_939D_3415039D9980#232385]
Input [7]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#232127, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#232267, COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322]
(19) Project [codegen id : 5]
Output [7]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#232267, str_if_with_rule(CASE WHEN isnull(COL_DA71D365_04CC_4409_939D_3415039D9980#232385) THEN false ELSE (COL_DA71D365_04CC_4409_939D_3415039D9980#232385 <= 3) END, str_join(array(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322, €), ), str_if_with_rule(CASE WHEN isnull(((COL_DA71D365_04CC_4409_939D_3415039D9980#232385 >= 4) AND (COL_DA71D365_04CC_4409_939D_3415039D9980#232385 <= 6))) THEN false ELSE ((COL_DA71D365_04CC_4409_939D_3415039D9980#232385 >= 4) AND (COL_DA71D365_04CC_4409_939D_3415039D9980#232385 <= 6)) END, str_join(array(str_extract_middle(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322, 1, int_diff(array(COL_DA71D365_04CC_4409_939D_3415039D9980#232385, 3))), str_extract(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322, RIGHT, 3), €, ), ), str_if_with_rule(CASE WHEN isnull(COL_DA71D365_04CC_4409_939D_3415039D9980#232385) THEN false ELSE (COL_DA71D365_04CC_4409_939D_3415039D9980#232385 > 6) END, str_join(array(str_extract_middle(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322, 1, int_diff(array(COL_DA71D365_04CC_4409_939D_3415039D9980#232385, 6))), str_extract_middle(str_extract(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322, RIGHT, 6), 1, 3), str_extract(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322, RIGHT, 3), €, ), ), ))) AS COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#232414, str_if_with_rule(isnotnull(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129), str_join(array(dec_to_str(COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#232127), %), ), ) AS COL_8057B77C_2D2A_45F4_B46B_267846CBC997#232458, str_extract_by_str(dec_to_str(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129), ., LEFT) AS COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540]
Input [8]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#232127, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#232267, COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322, COL_DA71D365_04CC_4409_939D_3415039D9980#232385]
(20) Project [codegen id : 5]
Output [8]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#232267, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#232414, COL_8057B77C_2D2A_45F4_B46B_267846CBC997#232458, COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540, str_size(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540) AS COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572]
Input [7]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#232267, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#232414, COL_8057B77C_2D2A_45F4_B46B_267846CBC997#232458, COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540]
(21) Project [codegen id : 5]
Output [8]: [COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167, COL_8057B77C_2D2A_45F4_B46B_267846CBC997#232458, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#232414, str_if_with_rule(CASE WHEN isnull(COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572) THEN false ELSE (COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572 <= 3) END, str_join(array(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540, €), ), str_if_with_rule(CASE WHEN isnull(((COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572 >= 4) AND (COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572 <= 6))) THEN false ELSE ((COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572 >= 4) AND (COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572 <= 6)) END, str_join(array(str_extract_middle(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540, 1, int_diff(array(COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572, 3))), str_extract(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540, RIGHT, 3), €, ), ), str_if_with_rule(CASE WHEN isnull(COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572) THEN false ELSE (COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572 > 6) END, str_join(array(str_extract_middle(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540, 1, int_diff(array(COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572, 6))), str_extract_middle(str_extract(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540, RIGHT, 6), 1, 3), str_extract(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540, RIGHT, 3), €, ), ), ))) AS COL_B48EE4DF_9CD6_4E2F_908E_7F131B2D4497#232810, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#232267, str_extract_middle(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, 1, 2) AS COL_4A3BE3E0_8706_45AF_A672_639EA10134CE#232812, str_extract_middle(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, 5, 100) AS COL_9140CD38_BB23_4D29_B56F_DA36C1AB6634#232813]
Input [8]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#232267, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#232414, COL_8057B77C_2D2A_45F4_B46B_267846CBC997#232458, COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540, COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572]
(22) WriteFiles
Input [8]: [COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167, COL_8057B77C_2D2A_45F4_B46B_267846CBC997#232458, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#232414, COL_B48EE4DF_9CD6_4E2F_908E_7F131B2D4497#232810, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#232267, COL_4A3BE3E0_8706_45AF_A672_639EA10134CE#232812, COL_9140CD38_BB23_4D29_B56F_DA36C1AB6634#232813]
(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#224911L AS COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#224916 AS COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#226790, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#224922 AS COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#226795, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#224925 AS COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#224918 AS COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801]
Input [5]: [COL_35375170_B542_49DE_AFA2_0A2D31967891#224911L, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#224916, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#224918, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#224922, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#224925]
(25) Exchange
Input [5]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#226790, COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#226795, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801]
Arguments: hashpartitioning(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, 10), ENSURE_REQUIREMENTS, [plan_id=30293]
(26) Sort
Input [5]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#226790, COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#226795, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801]
Arguments: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798 ASC NULLS FIRST, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(27) Window
Input [5]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#226790, COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#226795, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801]
Arguments: [sum(COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#226795) windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_35959880_BB9F_4A00_9A1F_6812432D358E#227369, avg(COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#226790) windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#228241, sum(COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801) windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#229398, count(1) windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, row_number() windowspecdefinition(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, 1 DESC NULLS LAST, specifiedwindowframe(RowFrame, unboundedpreceding$(), currentrow$())) AS COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#230794], [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L], [1 DESC NULLS LAST]
(28) Project
Output [8]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801, COL_35959880_BB9F_4A00_9A1F_6812432D358E#227369, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#228241, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#229398, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#230794]
Input [10]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_8E1AF4BD_763E_4C82_ABA6_E19FBB7CA2CE#226790, COL_800B1FBD_D337_445F_9CB5_9E0A580F1BEF#226795, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801, COL_35959880_BB9F_4A00_9A1F_6812432D358E#227369, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#228241, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#229398, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#230794]
(29) Exchange
Input [8]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801, COL_35959880_BB9F_4A00_9A1F_6812432D358E#227369, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#228241, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#229398, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#230794]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=30298]
(30) Sort
Input [8]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801, COL_35959880_BB9F_4A00_9A1F_6812432D358E#227369, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#228241, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#229398, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#230794]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0
(31) Window
Input [8]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801, COL_35959880_BB9F_4A00_9A1F_6812432D358E#227369, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#228241, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#229398, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#230794]
Arguments: [sum(COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#231333], [1], [1 DESC NULLS LAST]
(32) Filter
Input [9]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801, COL_35959880_BB9F_4A00_9A1F_6812432D358E#227369, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#228241, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#229398, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#230794, COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#231333]
Condition : (COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#230794 <=> 1)
(33) Project
Output [7]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, round(COL_35959880_BB9F_4A00_9A1F_6812432D358E#227369, 0) AS COL_35959880_BB9F_4A00_9A1F_6812432D358E#232126, round(COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#228241, 2) AS COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#232127, round(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#229398, 0) AS COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129, round(COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#231333, 0) AS COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#232130, str_join(array(dec_to_str(dec_round(dec_mult(array(dec_div(array(COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L)), 100.0)), 2)), %), ) AS COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167]
Input [9]: [COL_5596880E_A840_4DB1_82BD_C6CCBEC2D354#226785L, COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_75EC1290_4D48_478F_A131_72DDF00ACEDF#226801, COL_35959880_BB9F_4A00_9A1F_6812432D358E#227369, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#228241, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#229398, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_02C65F1C_3355_408D_9D75_79C8BE6447DC#230794, COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#231333]
(34) Project
Output [7]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#232127, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167, str_if_with_rule(isnotnull(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129), str_join(array(dec_to_str(dec_round(dec_mult(array(dec_div(array(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129, COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#232130)), 100.0)), 2)), %), ), null) AS COL_D059B2EF_C479_49B5_8BD9_174193A57D69#232267, str_extract_by_str(dec_to_str(COL_35959880_BB9F_4A00_9A1F_6812432D358E#232126), .0, LEFT) AS COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322]
Input [7]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_35959880_BB9F_4A00_9A1F_6812432D358E#232126, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#232127, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129, COL_50C3548A_B04D_4E49_A288_E23A5D33D5B7#232130, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167]
(35) Project
Output [8]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#232127, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#232267, COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322, str_size(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322) AS COL_DA71D365_04CC_4409_939D_3415039D9980#232385]
Input [7]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#232127, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#232267, COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322]
(36) Project
Output [7]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#232267, str_if_with_rule(CASE WHEN isnull(COL_DA71D365_04CC_4409_939D_3415039D9980#232385) THEN false ELSE (COL_DA71D365_04CC_4409_939D_3415039D9980#232385 <= 3) END, str_join(array(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322, €), ), str_if_with_rule(CASE WHEN isnull(((COL_DA71D365_04CC_4409_939D_3415039D9980#232385 >= 4) AND (COL_DA71D365_04CC_4409_939D_3415039D9980#232385 <= 6))) THEN false ELSE ((COL_DA71D365_04CC_4409_939D_3415039D9980#232385 >= 4) AND (COL_DA71D365_04CC_4409_939D_3415039D9980#232385 <= 6)) END, str_join(array(str_extract_middle(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322, 1, int_diff(array(COL_DA71D365_04CC_4409_939D_3415039D9980#232385, 3))), str_extract(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322, RIGHT, 3), €, ), ), str_if_with_rule(CASE WHEN isnull(COL_DA71D365_04CC_4409_939D_3415039D9980#232385) THEN false ELSE (COL_DA71D365_04CC_4409_939D_3415039D9980#232385 > 6) END, str_join(array(str_extract_middle(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322, 1, int_diff(array(COL_DA71D365_04CC_4409_939D_3415039D9980#232385, 6))), str_extract_middle(str_extract(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322, RIGHT, 6), 1, 3), str_extract(COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322, RIGHT, 3), €, ), ), ))) AS COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#232414, str_if_with_rule(isnotnull(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129), str_join(array(dec_to_str(COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#232127), %), ), ) AS COL_8057B77C_2D2A_45F4_B46B_267846CBC997#232458, str_extract_by_str(dec_to_str(COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129), ., LEFT) AS COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540]
Input [8]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_ECE9025D_5C54_430F_B514_F1FD104C4D5B#232127, COL_D09BA5F9_4F48_465C_BCEA_AA6E392B965C#232129, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#232267, COL_F57782B5_7068_4AE5_B7D4_D3D657568762#232322, COL_DA71D365_04CC_4409_939D_3415039D9980#232385]
(37) Project
Output [8]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#232267, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#232414, COL_8057B77C_2D2A_45F4_B46B_267846CBC997#232458, COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540, str_size(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540) AS COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572]
Input [7]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#232267, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#232414, COL_8057B77C_2D2A_45F4_B46B_267846CBC997#232458, COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540]
(38) Project
Output [8]: [COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167, COL_8057B77C_2D2A_45F4_B46B_267846CBC997#232458, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#232414, str_if_with_rule(CASE WHEN isnull(COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572) THEN false ELSE (COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572 <= 3) END, str_join(array(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540, €), ), str_if_with_rule(CASE WHEN isnull(((COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572 >= 4) AND (COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572 <= 6))) THEN false ELSE ((COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572 >= 4) AND (COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572 <= 6)) END, str_join(array(str_extract_middle(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540, 1, int_diff(array(COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572, 3))), str_extract(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540, RIGHT, 3), €, ), ), str_if_with_rule(CASE WHEN isnull(COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572) THEN false ELSE (COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572 > 6) END, str_join(array(str_extract_middle(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540, 1, int_diff(array(COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572, 6))), str_extract_middle(str_extract(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540, RIGHT, 6), 1, 3), str_extract(COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540, RIGHT, 3), €, ), ), ))) AS COL_B48EE4DF_9CD6_4E2F_908E_7F131B2D4497#232810, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#232267, str_extract_middle(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, 1, 2) AS COL_4A3BE3E0_8706_45AF_A672_639EA10134CE#232812, str_extract_middle(COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, 5, 100) AS COL_9140CD38_BB23_4D29_B56F_DA36C1AB6634#232813]
Input [8]: [COL_5EE13883_1E9B_496D_861F_51600E94EA1E#226798, COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#232267, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#232414, COL_8057B77C_2D2A_45F4_B46B_267846CBC997#232458, COL_4FC5CD9B_2FBB_4A5B_A97B_6BE41C759777#232540, COL_44D05B44_A9EB_4648_892E_A15D4B624742#232572]
(39) WriteFiles
Input [8]: [COL_D4C45D4F_F7EE_45F0_9048_4C8750A1F9F9#230172L, COL_3F80393C_FAF9_4F55_95BE_B87A29F2A88A#232167, COL_8057B77C_2D2A_45F4_B46B_267846CBC997#232458, COL_08609E42_CBEF_4CCD_8CF7_D23828AAAE3C#232414, COL_B48EE4DF_9CD6_4E2F_908E_7F131B2D4497#232810, COL_D059B2EF_C479_49B5_8BD9_174193A57D69#232267, COL_4A3BE3E0_8706_45AF_A672_639EA10134CE#232812, COL_9140CD38_BB23_4D29_B56F_DA36C1AB6634#232813]
(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