digraph G {
0 [labelType="html" label="<br><b>TakeOrderedAndProject</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: total (min, med, max (stageId: taskId))\n358 ms (88 ms, 90 ms, 180 ms (stage 420.0: task 546))";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 72<br>number of input batches: 3"];
}
4 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 3<br>scan time total (min, med, max (stageId: taskId))<br>158 ms (37 ms, 40 ms, 81 ms (stage 420.0: task 546))<br>metadata time: 0 ms<br>size of files read: 4.5 MiB<br>number of output rows: 72"];
2->0;
3->2;
4->3;
}
5
TakeOrderedAndProject(limit=500000, orderBy=[COL_D6AD3668_C588_4935_B802_6258675055B9#61675 ASC NULLS FIRST,COL_C6184982_D47F_4FEA_BF51_0D4C27210CFA#61673 ASC NULLS FIRST], output=[COL_634829ED_FC95_49AE_A1E9_B0A852AE275B#61672,COL_C6184982_D47F_4FEA_BF51_0D4C27210CFA#61673,COL_41902539_A968_4A01_AC27_CCE9E57A8E79#61674,COL_D6AD3668_C588_4935_B802_6258675055B9#61675,COL_205E5940_8594_436A_BA97_B876BD29D623#61676L,COL_40023679_72B1_4831_A45E_FD410BC24EAE#61677L,COL_72420B6E_77E5_4149_B297_ABCFBB360843#61678,COL_F5836AD7_BAB5_4E14_AD36_DA7799BD34F5#61679,COL_F2869DFF_52B0_481D_9114_45F42A397D60#61719,COL_39410DF7_7815_4C32_A3A5_B5378C2138E5#61740])
Project [COL_34B0E8AF_7D89_4EF8_9CD2_411D5E9567E8#61375 AS COL_634829ED_FC95_49AE_A1E9_B0A852AE275B#61672, COL_0EFAFD75_A8DE_42EF_8A2B_87C19F240FF0#61376 AS COL_C6184982_D47F_4FEA_BF51_0D4C27210CFA#61673, COL_BD34C176_D5D8_497C_AC6E_1ECE0068FFA3#61377 AS COL_41902539_A968_4A01_AC27_CCE9E57A8E79#61674, COL_7AF626E8_FCD8_4B8C_A943_B5DADBED9CCA#61378 AS COL_D6AD3668_C588_4935_B802_6258675055B9#61675, COL_F12DD7DA_B08B_4647_A7E6_3700DCFB6EC4#61379L AS COL_205E5940_8594_436A_BA97_B876BD29D623#61676L, COL_26F7F298_D80E_44FB_97AF_8C0D8E2506A9#61380L AS COL_40023679_72B1_4831_A45E_FD410BC24EAE#61677L, COL_99AC6F6D_30FA_4B9E_BE0A_E9A17183A3C8#61381 AS COL_72420B6E_77E5_4149_B297_ABCFBB360843#61678, COL_CDD5C9A4_8615_49FF_8234_69A7030D5272#61382 AS COL_F5836AD7_BAB5_4E14_AD36_DA7799BD34F5#61679, str_concat(array(COL_7AF626E8_FCD8_4B8C_A943_B5DADBED9CCA#61378, - , COL_0EFAFD75_A8DE_42EF_8A2B_87C19F240FF0#61376)) AS COL_F2869DFF_52B0_481D_9114_45F42A397D60#61719, dec_operator(SOMME, array(COL_CDD5C9A4_8615_49FF_8234_69A7030D5272#61382, 100000.0)) AS COL_39410DF7_7815_4C32_A3A5_B5378C2138E5#61740]
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_34B0E8AF_7D89_4EF8_9CD2_411D5E9567E8#61375,COL_0EFAFD75_A8DE_42EF_8A2B_87C19F240FF0#61376,COL_BD34C176_D5D8_497C_AC6E_1ECE0068FFA3#61377,COL_7AF626E8_FCD8_4B8C_A943_B5DADBED9CCA#61378,COL_F12DD7DA_B08B_4647_A7E6_3700DCFB6EC4#61379L,COL_26F7F298_D80E_44FB_97AF_8C0D8E2506A9#61380L,COL_99AC6F6D_30FA_4B9E_BE0A_E9A17183A3C8#61381,COL_CDD5C9A4_8615_49FF_8234_69A7030D5272#61382] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/REPARTITION_REG_14502], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_34B0E8AF_7D89_4EF8_9CD2_411D5E9567E8:string,COL_0EFAFD75_A8DE_42EF_8A2B_87C19F240FF0:s...
== Physical Plan ==
TakeOrderedAndProject (4)
+- * Project (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
(1) Scan parquet
Output [8]: [COL_34B0E8AF_7D89_4EF8_9CD2_411D5E9567E8#61375, COL_0EFAFD75_A8DE_42EF_8A2B_87C19F240FF0#61376, COL_BD34C176_D5D8_497C_AC6E_1ECE0068FFA3#61377, COL_7AF626E8_FCD8_4B8C_A943_B5DADBED9CCA#61378, COL_F12DD7DA_B08B_4647_A7E6_3700DCFB6EC4#61379L, COL_26F7F298_D80E_44FB_97AF_8C0D8E2506A9#61380L, COL_99AC6F6D_30FA_4B9E_BE0A_E9A17183A3C8#61381, COL_CDD5C9A4_8615_49FF_8234_69A7030D5272#61382]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/REPARTITION_REG_14502]
ReadSchema: struct<COL_34B0E8AF_7D89_4EF8_9CD2_411D5E9567E8:string,COL_0EFAFD75_A8DE_42EF_8A2B_87C19F240FF0:string,COL_BD34C176_D5D8_497C_AC6E_1ECE0068FFA3:string,COL_7AF626E8_FCD8_4B8C_A943_B5DADBED9CCA:string,COL_F12DD7DA_B08B_4647_A7E6_3700DCFB6EC4:bigint,COL_26F7F298_D80E_44FB_97AF_8C0D8E2506A9:bigint,COL_99AC6F6D_30FA_4B9E_BE0A_E9A17183A3C8:double,COL_CDD5C9A4_8615_49FF_8234_69A7030D5272:double>
(2) ColumnarToRow [codegen id : 1]
Input [8]: [COL_34B0E8AF_7D89_4EF8_9CD2_411D5E9567E8#61375, COL_0EFAFD75_A8DE_42EF_8A2B_87C19F240FF0#61376, COL_BD34C176_D5D8_497C_AC6E_1ECE0068FFA3#61377, COL_7AF626E8_FCD8_4B8C_A943_B5DADBED9CCA#61378, COL_F12DD7DA_B08B_4647_A7E6_3700DCFB6EC4#61379L, COL_26F7F298_D80E_44FB_97AF_8C0D8E2506A9#61380L, COL_99AC6F6D_30FA_4B9E_BE0A_E9A17183A3C8#61381, COL_CDD5C9A4_8615_49FF_8234_69A7030D5272#61382]
(3) Project [codegen id : 1]
Output [10]: [COL_34B0E8AF_7D89_4EF8_9CD2_411D5E9567E8#61375 AS COL_634829ED_FC95_49AE_A1E9_B0A852AE275B#61672, COL_0EFAFD75_A8DE_42EF_8A2B_87C19F240FF0#61376 AS COL_C6184982_D47F_4FEA_BF51_0D4C27210CFA#61673, COL_BD34C176_D5D8_497C_AC6E_1ECE0068FFA3#61377 AS COL_41902539_A968_4A01_AC27_CCE9E57A8E79#61674, COL_7AF626E8_FCD8_4B8C_A943_B5DADBED9CCA#61378 AS COL_D6AD3668_C588_4935_B802_6258675055B9#61675, COL_F12DD7DA_B08B_4647_A7E6_3700DCFB6EC4#61379L AS COL_205E5940_8594_436A_BA97_B876BD29D623#61676L, COL_26F7F298_D80E_44FB_97AF_8C0D8E2506A9#61380L AS COL_40023679_72B1_4831_A45E_FD410BC24EAE#61677L, COL_99AC6F6D_30FA_4B9E_BE0A_E9A17183A3C8#61381 AS COL_72420B6E_77E5_4149_B297_ABCFBB360843#61678, COL_CDD5C9A4_8615_49FF_8234_69A7030D5272#61382 AS COL_F5836AD7_BAB5_4E14_AD36_DA7799BD34F5#61679, str_concat(array(COL_7AF626E8_FCD8_4B8C_A943_B5DADBED9CCA#61378, - , COL_0EFAFD75_A8DE_42EF_8A2B_87C19F240FF0#61376)) AS COL_F2869DFF_52B0_481D_9114_45F42A397D60#61719, dec_operator(SOMME, array(COL_CDD5C9A4_8615_49FF_8234_69A7030D5272#61382, 100000.0)) AS COL_39410DF7_7815_4C32_A3A5_B5378C2138E5#61740]
Input [8]: [COL_34B0E8AF_7D89_4EF8_9CD2_411D5E9567E8#61375, COL_0EFAFD75_A8DE_42EF_8A2B_87C19F240FF0#61376, COL_BD34C176_D5D8_497C_AC6E_1ECE0068FFA3#61377, COL_7AF626E8_FCD8_4B8C_A943_B5DADBED9CCA#61378, COL_F12DD7DA_B08B_4647_A7E6_3700DCFB6EC4#61379L, COL_26F7F298_D80E_44FB_97AF_8C0D8E2506A9#61380L, COL_99AC6F6D_30FA_4B9E_BE0A_E9A17183A3C8#61381, COL_CDD5C9A4_8615_49FF_8234_69A7030D5272#61382]
(4) TakeOrderedAndProject
Input [10]: [COL_634829ED_FC95_49AE_A1E9_B0A852AE275B#61672, COL_C6184982_D47F_4FEA_BF51_0D4C27210CFA#61673, COL_41902539_A968_4A01_AC27_CCE9E57A8E79#61674, COL_D6AD3668_C588_4935_B802_6258675055B9#61675, COL_205E5940_8594_436A_BA97_B876BD29D623#61676L, COL_40023679_72B1_4831_A45E_FD410BC24EAE#61677L, COL_72420B6E_77E5_4149_B297_ABCFBB360843#61678, COL_F5836AD7_BAB5_4E14_AD36_DA7799BD34F5#61679, COL_F2869DFF_52B0_481D_9114_45F42A397D60#61719, COL_39410DF7_7815_4C32_A3A5_B5378C2138E5#61740]
Arguments: 500000, [COL_D6AD3668_C588_4935_B802_6258675055B9#61675 ASC NULLS FIRST, COL_C6184982_D47F_4FEA_BF51_0D4C27210CFA#61673 ASC NULLS FIRST], [COL_634829ED_FC95_49AE_A1E9_B0A852AE275B#61672, COL_C6184982_D47F_4FEA_BF51_0D4C27210CFA#61673, COL_41902539_A968_4A01_AC27_CCE9E57A8E79#61674, COL_D6AD3668_C588_4935_B802_6258675055B9#61675, COL_205E5940_8594_436A_BA97_B876BD29D623#61676L, COL_40023679_72B1_4831_A45E_FD410BC24EAE#61677L, COL_72420B6E_77E5_4149_B297_ABCFBB360843#61678, COL_F5836AD7_BAB5_4E14_AD36_DA7799BD34F5#61679, COL_F2869DFF_52B0_481D_9114_45F42A397D60#61719, COL_39410DF7_7815_4C32_A3A5_B5378C2138E5#61740]