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#267742 DESC NULLS LAST], output=[COL_1DDEBDC1_0028_4D2D_93B0_F0EDADA9F97D#267736,COL_D43C7967_229E_4195_9079_EB81398D5BF8#267737,COL_3EE4B175_BC09_40AC_B198_07BBE75282C1#267746,COL_340F4599_483E_47E1_A128_B490D104AC9A#267738L,COL_FE9FC736_6A51_4E69_A91D_47E96A22DE1E#267740L,COL_9E2B13A6_0F06_4C91_9D91_F33EF55FF9FE#267741,COL_D9DD366C_447A_4F2B_A4CB_A25189F2A2A4#267742,COL_EE354081_85F9_4991_8D07_5D3D9B0140FD#267743,COL_E2508EE6_26F0_4579_9ECA_C74DABB0DB31#267744,COL_70F19F9B_778B_466E_9850_31F3B2B5428C#267745])
Project [COL_DC1BE07F_0395_4CD6_8B1A_B946492A2FF1#267452 AS COL_1DDEBDC1_0028_4D2D_93B0_F0EDADA9F97D#267736, COL_9148CCE6_9B31_4D9E_A292_654849C0E26F#267453 AS COL_D43C7967_229E_4195_9079_EB81398D5BF8#267737, COL_2746F85D_27D9_41EC_82F5_7BC9603473E2#267454L AS COL_340F4599_483E_47E1_A128_B490D104AC9A#267738L, COL_C33B6C6B_EDE1_4223_8C3E_515DB0F371A0#267456L AS COL_FE9FC736_6A51_4E69_A91D_47E96A22DE1E#267740L, COL_DB72522D_2F47_42E8_8BB8_AABEEF6E6119#267457 AS COL_9E2B13A6_0F06_4C91_9D91_F33EF55FF9FE#267741, COL_A15D925F_27B6_4909_BA2A_6F3EAC21C9F1#267458 AS COL_D9DD366C_447A_4F2B_A4CB_A25189F2A2A4#267742, COL_6AF9FF92_282F_495E_9106_7F4665118623#267459 AS COL_EE354081_85F9_4991_8D07_5D3D9B0140FD#267743, COL_6081CEDD_0ADB_4FC5_9253_386AD36CA323#267460 AS COL_E2508EE6_26F0_4579_9ECA_C74DABB0DB31#267744, COL_83ABB9D2_B2AD_42E9_9B38_F316A254ABD3#267461 AS COL_70F19F9B_778B_466E_9850_31F3B2B5428C#267745, COL_AD6E3BD6_735B_4D77_A77F_A7C8F6976435#267462 AS COL_3EE4B175_BC09_40AC_B198_07BBE75282C1#267746]
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_DC1BE07F_0395_4CD6_8B1A_B946492A2FF1#267452,COL_9148CCE6_9B31_4D9E_A292_654849C0E26F#267453,COL_2746F85D_27D9_41EC_82F5_7BC9603473E2#267454L,COL_C33B6C6B_EDE1_4223_8C3E_515DB0F371A0#267456L,COL_DB72522D_2F47_42E8_8BB8_AABEEF6E6119#267457,COL_A15D925F_27B6_4909_BA2A_6F3EAC21C9F1#267458,COL_6AF9FF92_282F_495E_9106_7F4665118623#267459,COL_6081CEDD_0ADB_4FC5_9253_386AD36CA323#267460,COL_83ABB9D2_B2AD_42E9_9B38_F316A254ABD3#267461,COL_AD6E3BD6_735B_4D77_A77F_A7C8F6976435#267462] 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#267452, COL_9148CCE6_9B31_4D9E_A292_654849C0E26F#267453, COL_2746F85D_27D9_41EC_82F5_7BC9603473E2#267454L, COL_C33B6C6B_EDE1_4223_8C3E_515DB0F371A0#267456L, COL_DB72522D_2F47_42E8_8BB8_AABEEF6E6119#267457, COL_A15D925F_27B6_4909_BA2A_6F3EAC21C9F1#267458, COL_6AF9FF92_282F_495E_9106_7F4665118623#267459, COL_6081CEDD_0ADB_4FC5_9253_386AD36CA323#267460, COL_83ABB9D2_B2AD_42E9_9B38_F316A254ABD3#267461, COL_AD6E3BD6_735B_4D77_A77F_A7C8F6976435#267462]
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#267452, COL_9148CCE6_9B31_4D9E_A292_654849C0E26F#267453, COL_2746F85D_27D9_41EC_82F5_7BC9603473E2#267454L, COL_C33B6C6B_EDE1_4223_8C3E_515DB0F371A0#267456L, COL_DB72522D_2F47_42E8_8BB8_AABEEF6E6119#267457, COL_A15D925F_27B6_4909_BA2A_6F3EAC21C9F1#267458, COL_6AF9FF92_282F_495E_9106_7F4665118623#267459, COL_6081CEDD_0ADB_4FC5_9253_386AD36CA323#267460, COL_83ABB9D2_B2AD_42E9_9B38_F316A254ABD3#267461, COL_AD6E3BD6_735B_4D77_A77F_A7C8F6976435#267462]
(3) Project [codegen id : 1]
Output [10]: [COL_DC1BE07F_0395_4CD6_8B1A_B946492A2FF1#267452 AS COL_1DDEBDC1_0028_4D2D_93B0_F0EDADA9F97D#267736, COL_9148CCE6_9B31_4D9E_A292_654849C0E26F#267453 AS COL_D43C7967_229E_4195_9079_EB81398D5BF8#267737, COL_2746F85D_27D9_41EC_82F5_7BC9603473E2#267454L AS COL_340F4599_483E_47E1_A128_B490D104AC9A#267738L, COL_C33B6C6B_EDE1_4223_8C3E_515DB0F371A0#267456L AS COL_FE9FC736_6A51_4E69_A91D_47E96A22DE1E#267740L, COL_DB72522D_2F47_42E8_8BB8_AABEEF6E6119#267457 AS COL_9E2B13A6_0F06_4C91_9D91_F33EF55FF9FE#267741, COL_A15D925F_27B6_4909_BA2A_6F3EAC21C9F1#267458 AS COL_D9DD366C_447A_4F2B_A4CB_A25189F2A2A4#267742, COL_6AF9FF92_282F_495E_9106_7F4665118623#267459 AS COL_EE354081_85F9_4991_8D07_5D3D9B0140FD#267743, COL_6081CEDD_0ADB_4FC5_9253_386AD36CA323#267460 AS COL_E2508EE6_26F0_4579_9ECA_C74DABB0DB31#267744, COL_83ABB9D2_B2AD_42E9_9B38_F316A254ABD3#267461 AS COL_70F19F9B_778B_466E_9850_31F3B2B5428C#267745, COL_AD6E3BD6_735B_4D77_A77F_A7C8F6976435#267462 AS COL_3EE4B175_BC09_40AC_B198_07BBE75282C1#267746]
Input [10]: [COL_DC1BE07F_0395_4CD6_8B1A_B946492A2FF1#267452, COL_9148CCE6_9B31_4D9E_A292_654849C0E26F#267453, COL_2746F85D_27D9_41EC_82F5_7BC9603473E2#267454L, COL_C33B6C6B_EDE1_4223_8C3E_515DB0F371A0#267456L, COL_DB72522D_2F47_42E8_8BB8_AABEEF6E6119#267457, COL_A15D925F_27B6_4909_BA2A_6F3EAC21C9F1#267458, COL_6AF9FF92_282F_495E_9106_7F4665118623#267459, COL_6081CEDD_0ADB_4FC5_9253_386AD36CA323#267460, COL_83ABB9D2_B2AD_42E9_9B38_F316A254ABD3#267461, COL_AD6E3BD6_735B_4D77_A77F_A7C8F6976435#267462]
(4) TakeOrderedAndProject
Input [10]: [COL_1DDEBDC1_0028_4D2D_93B0_F0EDADA9F97D#267736, COL_D43C7967_229E_4195_9079_EB81398D5BF8#267737, COL_340F4599_483E_47E1_A128_B490D104AC9A#267738L, COL_FE9FC736_6A51_4E69_A91D_47E96A22DE1E#267740L, COL_9E2B13A6_0F06_4C91_9D91_F33EF55FF9FE#267741, COL_D9DD366C_447A_4F2B_A4CB_A25189F2A2A4#267742, COL_EE354081_85F9_4991_8D07_5D3D9B0140FD#267743, COL_E2508EE6_26F0_4579_9ECA_C74DABB0DB31#267744, COL_70F19F9B_778B_466E_9850_31F3B2B5428C#267745, COL_3EE4B175_BC09_40AC_B198_07BBE75282C1#267746]
Arguments: 500000, [COL_D9DD366C_447A_4F2B_A4CB_A25189F2A2A4#267742 DESC NULLS LAST], [COL_1DDEBDC1_0028_4D2D_93B0_F0EDADA9F97D#267736, COL_D43C7967_229E_4195_9079_EB81398D5BF8#267737, COL_3EE4B175_BC09_40AC_B198_07BBE75282C1#267746, COL_340F4599_483E_47E1_A128_B490D104AC9A#267738L, COL_FE9FC736_6A51_4E69_A91D_47E96A22DE1E#267740L, COL_9E2B13A6_0F06_4C91_9D91_F33EF55FF9FE#267741, COL_D9DD366C_447A_4F2B_A4CB_A25189F2A2A4#267742, COL_EE354081_85F9_4991_8D07_5D3D9B0140FD#267743, COL_E2508EE6_26F0_4579_9ECA_C74DABB0DB31#267744, COL_70F19F9B_778B_466E_9850_31F3B2B5428C#267745]