digraph G {
0 [labelType="html" label="<br><b>TakeOrderedAndProject</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 12 ms";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<b>Filter</b><br><br>number of output rows: 1"];
4 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 2,892<br>number of input batches: 1"];
}
5 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 4 ms<br>metadata time: 0 ms<br>size of files read: 111.7 KiB<br>number of output rows: 2,892"];
2->0;
3->2;
4->3;
5->4;
}
6
TakeOrderedAndProject(limit=500000, orderBy=[COL_FADDBC30_5795_4E39_B7D6_6C046EC237B4#2307021 ASC NULLS FIRST,COL_16E2B0DB_21EB_47F3_8607_4ACB361FD5A5#2307023 ASC NULLS FIRST,COL_987B099C_02B6_49F6_85B4_8A364CC6E0AF#2307016 ASC NULLS FIRST,COL_55DE1A45_BCF6_4ADD_AB05_E6D5F2A65486#2307160 ASC NULLS FIRST], output=[COL_6E3824D4_DB9B_4DF9_AD57_6918690CA3AB#2307013,COL_7865A8BB_5A85_4E2D_B239_438D3FB8DD88#2307014,COL_CFF0A7AB_260D_4F3D_8C51_4D1738B3D824#2307015,COL_987B099C_02B6_49F6_85B4_8A364CC6E0AF#2307016,COL_3A63DE92_E3A8_47B3_B44F_0F34B9D2547C#2307017,COL_33EF1A52_8304_4C50_BD03_017E4797D89E#2307018,COL_72C50806_4E0D_466F_A2BD_6B2C2017B881#2307019,COL_541D478A_FC73_406F_ADDE_F2E0C8021B47#2307020,COL_FADDBC30_5795_4E39_B7D6_6C046EC237B4#2307021,COL_55DE1A45_BCF6_4ADD_AB05_E6D5F2A65486#2307160,COL_71253AB1_5F7B_4E94_82E4_3DEDD208E979#2307022,COL_16E2B0DB_21EB_47F3_8607_4ACB361FD5A5#2307023,COL_2C04E6A7_E0A4_4EC1_8B3D_CF9AD63A537F#2307024])
Project [COL_13692FE9_27FE_43A3_9877_314B5FA6981E#2306759 AS COL_6E3824D4_DB9B_4DF9_AD57_6918690CA3AB#2307013, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#2306760 AS COL_7865A8BB_5A85_4E2D_B239_438D3FB8DD88#2307014, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#2306761 AS COL_CFF0A7AB_260D_4F3D_8C51_4D1738B3D824#2307015, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#2306763 AS COL_987B099C_02B6_49F6_85B4_8A364CC6E0AF#2307016, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#2306759 AS COL_3A63DE92_E3A8_47B3_B44F_0F34B9D2547C#2307017, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#2306769 AS COL_33EF1A52_8304_4C50_BD03_017E4797D89E#2307018, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#2306762 AS COL_72C50806_4E0D_466F_A2BD_6B2C2017B881#2307019, COL_24B70AFC_A481_42F7_BC8F_E9E89DEC4255#2306764 AS COL_541D478A_FC73_406F_ADDE_F2E0C8021B47#2307020, COL_06545D41_928E_4A54_93BF_65904FCF81AA#2306765 AS COL_FADDBC30_5795_4E39_B7D6_6C046EC237B4#2307021, COL_E20E6071_1A49_495A_9004_23ED33C98669#2306770 AS COL_71253AB1_5F7B_4E94_82E4_3DEDD208E979#2307022, COL_493B3625_15CC_4C3E_B552_CFFC349A58D4#2306772 AS COL_16E2B0DB_21EB_47F3_8607_4ACB361FD5A5#2307023, COL_6348CDD7_7FF9_4337_B9DE_365982DB3BA3#2306771 AS COL_2C04E6A7_E0A4_4EC1_8B3D_CF9AD63A537F#2307024, str_concat(array(COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#2306763, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#2306762)) AS COL_55DE1A45_BCF6_4ADD_AB05_E6D5F2A65486#2307160]
Filter (COL_13692FE9_27FE_43A3_9877_314B5FA6981E#2306759 <=> 325154901)
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_13692FE9_27FE_43A3_9877_314B5FA6981E#2306759,COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#2306760,COL_1BE7C81D_C98B_4777_B767_B833588E5C16#2306761,COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#2306762,COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#2306763,COL_24B70AFC_A481_42F7_BC8F_E9E89DEC4255#2306764,COL_06545D41_928E_4A54_93BF_65904FCF81AA#2306765,COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#2306769,COL_E20E6071_1A49_495A_9004_23ED33C98669#2306770,COL_6348CDD7_7FF9_4337_B9DE_365982DB3BA3#2306771,COL_493B3625_15CC_4C3E_B552_CFFC349A58D4#2306772] Batched: true, DataFilters: [(COL_13692FE9_27FE_43A3_9877_314B5FA6981E#2306759 <=> 325154901)], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/06_COMPILATION__152291], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_13692FE9_27FE_43A3_9877_314B5FA6981E,325154901)], ReadSchema: struct<COL_13692FE9_27FE_43A3_9877_314B5FA6981E:string,COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA:s...
== Physical Plan ==
TakeOrderedAndProject (5)
+- * Project (4)
+- * Filter (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
(1) Scan parquet
Output [11]: [COL_13692FE9_27FE_43A3_9877_314B5FA6981E#2306759, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#2306760, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#2306761, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#2306762, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#2306763, COL_24B70AFC_A481_42F7_BC8F_E9E89DEC4255#2306764, COL_06545D41_928E_4A54_93BF_65904FCF81AA#2306765, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#2306769, COL_E20E6071_1A49_495A_9004_23ED33C98669#2306770, COL_6348CDD7_7FF9_4337_B9DE_365982DB3BA3#2306771, COL_493B3625_15CC_4C3E_B552_CFFC349A58D4#2306772]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/06_COMPILATION__152291]
PushedFilters: [EqualNullSafe(COL_13692FE9_27FE_43A3_9877_314B5FA6981E,325154901)]
ReadSchema: struct<COL_13692FE9_27FE_43A3_9877_314B5FA6981E:string,COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA:string,COL_1BE7C81D_C98B_4777_B767_B833588E5C16:string,COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7:string,COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E:string,COL_24B70AFC_A481_42F7_BC8F_E9E89DEC4255:string,COL_06545D41_928E_4A54_93BF_65904FCF81AA:string,COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6:double,COL_E20E6071_1A49_495A_9004_23ED33C98669:string,COL_6348CDD7_7FF9_4337_B9DE_365982DB3BA3:string,COL_493B3625_15CC_4C3E_B552_CFFC349A58D4:string>
(2) ColumnarToRow [codegen id : 1]
Input [11]: [COL_13692FE9_27FE_43A3_9877_314B5FA6981E#2306759, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#2306760, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#2306761, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#2306762, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#2306763, COL_24B70AFC_A481_42F7_BC8F_E9E89DEC4255#2306764, COL_06545D41_928E_4A54_93BF_65904FCF81AA#2306765, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#2306769, COL_E20E6071_1A49_495A_9004_23ED33C98669#2306770, COL_6348CDD7_7FF9_4337_B9DE_365982DB3BA3#2306771, COL_493B3625_15CC_4C3E_B552_CFFC349A58D4#2306772]
(3) Filter [codegen id : 1]
Input [11]: [COL_13692FE9_27FE_43A3_9877_314B5FA6981E#2306759, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#2306760, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#2306761, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#2306762, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#2306763, COL_24B70AFC_A481_42F7_BC8F_E9E89DEC4255#2306764, COL_06545D41_928E_4A54_93BF_65904FCF81AA#2306765, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#2306769, COL_E20E6071_1A49_495A_9004_23ED33C98669#2306770, COL_6348CDD7_7FF9_4337_B9DE_365982DB3BA3#2306771, COL_493B3625_15CC_4C3E_B552_CFFC349A58D4#2306772]
Condition : (COL_13692FE9_27FE_43A3_9877_314B5FA6981E#2306759 <=> 325154901)
(4) Project [codegen id : 1]
Output [13]: [COL_13692FE9_27FE_43A3_9877_314B5FA6981E#2306759 AS COL_6E3824D4_DB9B_4DF9_AD57_6918690CA3AB#2307013, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#2306760 AS COL_7865A8BB_5A85_4E2D_B239_438D3FB8DD88#2307014, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#2306761 AS COL_CFF0A7AB_260D_4F3D_8C51_4D1738B3D824#2307015, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#2306763 AS COL_987B099C_02B6_49F6_85B4_8A364CC6E0AF#2307016, COL_13692FE9_27FE_43A3_9877_314B5FA6981E#2306759 AS COL_3A63DE92_E3A8_47B3_B44F_0F34B9D2547C#2307017, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#2306769 AS COL_33EF1A52_8304_4C50_BD03_017E4797D89E#2307018, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#2306762 AS COL_72C50806_4E0D_466F_A2BD_6B2C2017B881#2307019, COL_24B70AFC_A481_42F7_BC8F_E9E89DEC4255#2306764 AS COL_541D478A_FC73_406F_ADDE_F2E0C8021B47#2307020, COL_06545D41_928E_4A54_93BF_65904FCF81AA#2306765 AS COL_FADDBC30_5795_4E39_B7D6_6C046EC237B4#2307021, COL_E20E6071_1A49_495A_9004_23ED33C98669#2306770 AS COL_71253AB1_5F7B_4E94_82E4_3DEDD208E979#2307022, COL_493B3625_15CC_4C3E_B552_CFFC349A58D4#2306772 AS COL_16E2B0DB_21EB_47F3_8607_4ACB361FD5A5#2307023, COL_6348CDD7_7FF9_4337_B9DE_365982DB3BA3#2306771 AS COL_2C04E6A7_E0A4_4EC1_8B3D_CF9AD63A537F#2307024, str_concat(array(COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#2306763, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#2306762)) AS COL_55DE1A45_BCF6_4ADD_AB05_E6D5F2A65486#2307160]
Input [11]: [COL_13692FE9_27FE_43A3_9877_314B5FA6981E#2306759, COL_2876989F_DEC1_40A8_860A_830E1DDD6BAA#2306760, COL_1BE7C81D_C98B_4777_B767_B833588E5C16#2306761, COL_F7E6B982_AE01_4D61_95F1_A194F4B50FB7#2306762, COL_11433D90_073E_4D4F_93EA_C1D4A3867F3E#2306763, COL_24B70AFC_A481_42F7_BC8F_E9E89DEC4255#2306764, COL_06545D41_928E_4A54_93BF_65904FCF81AA#2306765, COL_E38AB62F_E896_4A72_BE7E_515F8BC641C6#2306769, COL_E20E6071_1A49_495A_9004_23ED33C98669#2306770, COL_6348CDD7_7FF9_4337_B9DE_365982DB3BA3#2306771, COL_493B3625_15CC_4C3E_B552_CFFC349A58D4#2306772]
(5) TakeOrderedAndProject
Input [13]: [COL_6E3824D4_DB9B_4DF9_AD57_6918690CA3AB#2307013, COL_7865A8BB_5A85_4E2D_B239_438D3FB8DD88#2307014, COL_CFF0A7AB_260D_4F3D_8C51_4D1738B3D824#2307015, COL_987B099C_02B6_49F6_85B4_8A364CC6E0AF#2307016, COL_3A63DE92_E3A8_47B3_B44F_0F34B9D2547C#2307017, COL_33EF1A52_8304_4C50_BD03_017E4797D89E#2307018, COL_72C50806_4E0D_466F_A2BD_6B2C2017B881#2307019, COL_541D478A_FC73_406F_ADDE_F2E0C8021B47#2307020, COL_FADDBC30_5795_4E39_B7D6_6C046EC237B4#2307021, COL_71253AB1_5F7B_4E94_82E4_3DEDD208E979#2307022, COL_16E2B0DB_21EB_47F3_8607_4ACB361FD5A5#2307023, COL_2C04E6A7_E0A4_4EC1_8B3D_CF9AD63A537F#2307024, COL_55DE1A45_BCF6_4ADD_AB05_E6D5F2A65486#2307160]
Arguments: 500000, [COL_FADDBC30_5795_4E39_B7D6_6C046EC237B4#2307021 ASC NULLS FIRST, COL_16E2B0DB_21EB_47F3_8607_4ACB361FD5A5#2307023 ASC NULLS FIRST, COL_987B099C_02B6_49F6_85B4_8A364CC6E0AF#2307016 ASC NULLS FIRST, COL_55DE1A45_BCF6_4ADD_AB05_E6D5F2A65486#2307160 ASC NULLS FIRST], [COL_6E3824D4_DB9B_4DF9_AD57_6918690CA3AB#2307013, COL_7865A8BB_5A85_4E2D_B239_438D3FB8DD88#2307014, COL_CFF0A7AB_260D_4F3D_8C51_4D1738B3D824#2307015, COL_987B099C_02B6_49F6_85B4_8A364CC6E0AF#2307016, COL_3A63DE92_E3A8_47B3_B44F_0F34B9D2547C#2307017, COL_33EF1A52_8304_4C50_BD03_017E4797D89E#2307018, COL_72C50806_4E0D_466F_A2BD_6B2C2017B881#2307019, COL_541D478A_FC73_406F_ADDE_F2E0C8021B47#2307020, COL_FADDBC30_5795_4E39_B7D6_6C046EC237B4#2307021, COL_55DE1A45_BCF6_4ADD_AB05_E6D5F2A65486#2307160, COL_71253AB1_5F7B_4E94_82E4_3DEDD208E979#2307022, COL_16E2B0DB_21EB_47F3_8607_4ACB361FD5A5#2307023, COL_2C04E6A7_E0A4_4EC1_8B3D_CF9AD63A537F#2307024]