digraph G {
0 [labelType="html" label="<br><b>TakeOrderedAndProject</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 10 ms";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 808<br>number of input batches: 1"];
}
4 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 3 ms<br>metadata time: 0 ms<br>size of files read: 54.8 KiB<br>number of output rows: 808"];
2->0;
3->2;
4->3;
}
5
TakeOrderedAndProject(limit=500000, orderBy=[COL_D9DD366C_447A_4F2B_A4CB_A25189F2A2A4#258251 DESC NULLS LAST], output=[COL_1DDEBDC1_0028_4D2D_93B0_F0EDADA9F97D#258245,COL_D43C7967_229E_4195_9079_EB81398D5BF8#258246,COL_3EE4B175_BC09_40AC_B198_07BBE75282C1#258255,COL_340F4599_483E_47E1_A128_B490D104AC9A#258247L,COL_FE9FC736_6A51_4E69_A91D_47E96A22DE1E#258249L,COL_9E2B13A6_0F06_4C91_9D91_F33EF55FF9FE#258250,COL_D9DD366C_447A_4F2B_A4CB_A25189F2A2A4#258251,COL_EE354081_85F9_4991_8D07_5D3D9B0140FD#258252,COL_E2508EE6_26F0_4579_9ECA_C74DABB0DB31#258253,COL_70F19F9B_778B_466E_9850_31F3B2B5428C#258254])
Project [COL_DC1BE07F_0395_4CD6_8B1A_B946492A2FF1#258179 AS COL_1DDEBDC1_0028_4D2D_93B0_F0EDADA9F97D#258245, COL_9148CCE6_9B31_4D9E_A292_654849C0E26F#258180 AS COL_D43C7967_229E_4195_9079_EB81398D5BF8#258246, COL_2746F85D_27D9_41EC_82F5_7BC9603473E2#258181L AS COL_340F4599_483E_47E1_A128_B490D104AC9A#258247L, COL_C33B6C6B_EDE1_4223_8C3E_515DB0F371A0#258183L AS COL_FE9FC736_6A51_4E69_A91D_47E96A22DE1E#258249L, COL_DB72522D_2F47_42E8_8BB8_AABEEF6E6119#258184 AS COL_9E2B13A6_0F06_4C91_9D91_F33EF55FF9FE#258250, COL_A15D925F_27B6_4909_BA2A_6F3EAC21C9F1#258185 AS COL_D9DD366C_447A_4F2B_A4CB_A25189F2A2A4#258251, COL_6AF9FF92_282F_495E_9106_7F4665118623#258186 AS COL_EE354081_85F9_4991_8D07_5D3D9B0140FD#258252, COL_6081CEDD_0ADB_4FC5_9253_386AD36CA323#258187 AS COL_E2508EE6_26F0_4579_9ECA_C74DABB0DB31#258253, COL_83ABB9D2_B2AD_42E9_9B38_F316A254ABD3#258188 AS COL_70F19F9B_778B_466E_9850_31F3B2B5428C#258254, COL_AD6E3BD6_735B_4D77_A77F_A7C8F6976435#258189 AS COL_3EE4B175_BC09_40AC_B198_07BBE75282C1#258255]
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_DC1BE07F_0395_4CD6_8B1A_B946492A2FF1#258179,COL_9148CCE6_9B31_4D9E_A292_654849C0E26F#258180,COL_2746F85D_27D9_41EC_82F5_7BC9603473E2#258181L,COL_C33B6C6B_EDE1_4223_8C3E_515DB0F371A0#258183L,COL_DB72522D_2F47_42E8_8BB8_AABEEF6E6119#258184,COL_A15D925F_27B6_4909_BA2A_6F3EAC21C9F1#258185,COL_6AF9FF92_282F_495E_9106_7F4665118623#258186,COL_6081CEDD_0ADB_4FC5_9253_386AD36CA323#258187,COL_83ABB9D2_B2AD_42E9_9B38_F316A254ABD3#258188,COL_AD6E3BD6_735B_4D77_A77F_A7C8F6976435#258189] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/ETUDE_DP_FINAL__253854], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_DC1BE07F_0395_4CD6_8B1A_B946492A2FF1:string,COL_9148CCE6_9B31_4D9E_A292_654849C0E26F:s...
== Physical Plan ==
TakeOrderedAndProject (4)
+- * Project (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
(1) Scan parquet
Output [10]: [COL_DC1BE07F_0395_4CD6_8B1A_B946492A2FF1#258179, COL_9148CCE6_9B31_4D9E_A292_654849C0E26F#258180, COL_2746F85D_27D9_41EC_82F5_7BC9603473E2#258181L, COL_C33B6C6B_EDE1_4223_8C3E_515DB0F371A0#258183L, COL_DB72522D_2F47_42E8_8BB8_AABEEF6E6119#258184, COL_A15D925F_27B6_4909_BA2A_6F3EAC21C9F1#258185, COL_6AF9FF92_282F_495E_9106_7F4665118623#258186, COL_6081CEDD_0ADB_4FC5_9253_386AD36CA323#258187, COL_83ABB9D2_B2AD_42E9_9B38_F316A254ABD3#258188, COL_AD6E3BD6_735B_4D77_A77F_A7C8F6976435#258189]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/ETUDE_DP_FINAL__253854]
ReadSchema: struct<COL_DC1BE07F_0395_4CD6_8B1A_B946492A2FF1:string,COL_9148CCE6_9B31_4D9E_A292_654849C0E26F:string,COL_2746F85D_27D9_41EC_82F5_7BC9603473E2:bigint,COL_C33B6C6B_EDE1_4223_8C3E_515DB0F371A0:bigint,COL_DB72522D_2F47_42E8_8BB8_AABEEF6E6119:double,COL_A15D925F_27B6_4909_BA2A_6F3EAC21C9F1:int,COL_6AF9FF92_282F_495E_9106_7F4665118623:string,COL_6081CEDD_0ADB_4FC5_9253_386AD36CA323:string,COL_83ABB9D2_B2AD_42E9_9B38_F316A254ABD3:string,COL_AD6E3BD6_735B_4D77_A77F_A7C8F6976435:string>
(2) ColumnarToRow [codegen id : 1]
Input [10]: [COL_DC1BE07F_0395_4CD6_8B1A_B946492A2FF1#258179, COL_9148CCE6_9B31_4D9E_A292_654849C0E26F#258180, COL_2746F85D_27D9_41EC_82F5_7BC9603473E2#258181L, COL_C33B6C6B_EDE1_4223_8C3E_515DB0F371A0#258183L, COL_DB72522D_2F47_42E8_8BB8_AABEEF6E6119#258184, COL_A15D925F_27B6_4909_BA2A_6F3EAC21C9F1#258185, COL_6AF9FF92_282F_495E_9106_7F4665118623#258186, COL_6081CEDD_0ADB_4FC5_9253_386AD36CA323#258187, COL_83ABB9D2_B2AD_42E9_9B38_F316A254ABD3#258188, COL_AD6E3BD6_735B_4D77_A77F_A7C8F6976435#258189]
(3) Project [codegen id : 1]
Output [10]: [COL_DC1BE07F_0395_4CD6_8B1A_B946492A2FF1#258179 AS COL_1DDEBDC1_0028_4D2D_93B0_F0EDADA9F97D#258245, COL_9148CCE6_9B31_4D9E_A292_654849C0E26F#258180 AS COL_D43C7967_229E_4195_9079_EB81398D5BF8#258246, COL_2746F85D_27D9_41EC_82F5_7BC9603473E2#258181L AS COL_340F4599_483E_47E1_A128_B490D104AC9A#258247L, COL_C33B6C6B_EDE1_4223_8C3E_515DB0F371A0#258183L AS COL_FE9FC736_6A51_4E69_A91D_47E96A22DE1E#258249L, COL_DB72522D_2F47_42E8_8BB8_AABEEF6E6119#258184 AS COL_9E2B13A6_0F06_4C91_9D91_F33EF55FF9FE#258250, COL_A15D925F_27B6_4909_BA2A_6F3EAC21C9F1#258185 AS COL_D9DD366C_447A_4F2B_A4CB_A25189F2A2A4#258251, COL_6AF9FF92_282F_495E_9106_7F4665118623#258186 AS COL_EE354081_85F9_4991_8D07_5D3D9B0140FD#258252, COL_6081CEDD_0ADB_4FC5_9253_386AD36CA323#258187 AS COL_E2508EE6_26F0_4579_9ECA_C74DABB0DB31#258253, COL_83ABB9D2_B2AD_42E9_9B38_F316A254ABD3#258188 AS COL_70F19F9B_778B_466E_9850_31F3B2B5428C#258254, COL_AD6E3BD6_735B_4D77_A77F_A7C8F6976435#258189 AS COL_3EE4B175_BC09_40AC_B198_07BBE75282C1#258255]
Input [10]: [COL_DC1BE07F_0395_4CD6_8B1A_B946492A2FF1#258179, COL_9148CCE6_9B31_4D9E_A292_654849C0E26F#258180, COL_2746F85D_27D9_41EC_82F5_7BC9603473E2#258181L, COL_C33B6C6B_EDE1_4223_8C3E_515DB0F371A0#258183L, COL_DB72522D_2F47_42E8_8BB8_AABEEF6E6119#258184, COL_A15D925F_27B6_4909_BA2A_6F3EAC21C9F1#258185, COL_6AF9FF92_282F_495E_9106_7F4665118623#258186, COL_6081CEDD_0ADB_4FC5_9253_386AD36CA323#258187, COL_83ABB9D2_B2AD_42E9_9B38_F316A254ABD3#258188, COL_AD6E3BD6_735B_4D77_A77F_A7C8F6976435#258189]
(4) TakeOrderedAndProject
Input [10]: [COL_1DDEBDC1_0028_4D2D_93B0_F0EDADA9F97D#258245, COL_D43C7967_229E_4195_9079_EB81398D5BF8#258246, COL_340F4599_483E_47E1_A128_B490D104AC9A#258247L, COL_FE9FC736_6A51_4E69_A91D_47E96A22DE1E#258249L, COL_9E2B13A6_0F06_4C91_9D91_F33EF55FF9FE#258250, COL_D9DD366C_447A_4F2B_A4CB_A25189F2A2A4#258251, COL_EE354081_85F9_4991_8D07_5D3D9B0140FD#258252, COL_E2508EE6_26F0_4579_9ECA_C74DABB0DB31#258253, COL_70F19F9B_778B_466E_9850_31F3B2B5428C#258254, COL_3EE4B175_BC09_40AC_B198_07BBE75282C1#258255]
Arguments: 500000, [COL_D9DD366C_447A_4F2B_A4CB_A25189F2A2A4#258251 DESC NULLS LAST], [COL_1DDEBDC1_0028_4D2D_93B0_F0EDADA9F97D#258245, COL_D43C7967_229E_4195_9079_EB81398D5BF8#258246, COL_3EE4B175_BC09_40AC_B198_07BBE75282C1#258255, COL_340F4599_483E_47E1_A128_B490D104AC9A#258247L, COL_FE9FC736_6A51_4E69_A91D_47E96A22DE1E#258249L, COL_9E2B13A6_0F06_4C91_9D91_F33EF55FF9FE#258250, COL_D9DD366C_447A_4F2B_A4CB_A25189F2A2A4#258251, COL_EE354081_85F9_4991_8D07_5D3D9B0140FD#258252, COL_E2508EE6_26F0_4579_9ECA_C74DABB0DB31#258253, COL_70F19F9B_778B_466E_9850_31F3B2B5428C#258254]