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: 7"];
4 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 4,519<br>number of input batches: 2"];
}
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: 79.8 KiB<br>number of output rows: 4,519"];
2->0;
3->2;
4->3;
5->4;
}
6
TakeOrderedAndProject(limit=500000, orderBy=[COL_31EFC9A8_5E6C_4D4D_B15F_E68F2E3693CE#138034 ASC NULLS FIRST], output=[COL_5D901C9E_98C5_4384_AE94_0E0E0A9A88A0#138032,COL_B395DCC4_9EDF_4E1C_8C90_E98F7EFAA8C0#138033,COL_31EFC9A8_5E6C_4D4D_B15F_E68F2E3693CE#138034,COL_3F609CDB_8DFC_4A9C_8795_F7C25E6782CA#138161,COL_BFCE39F8_E0D0_484E_A677_0897F79EC3E6#138162,COL_FCEF4905_018B_40FC_91E0_141623C1B8BB#138163,COL_D01526DE_1B63_4889_9F34_87EED1CF3786#138038,COL_8D847F1B_36FF_43A6_87DC_AB53080FE388#138039])
Project [COL_9CC6E14B_0B36_40EE_8BE3_D6FB9118CDB0#137912 AS COL_5D901C9E_98C5_4384_AE94_0E0E0A9A88A0#138032, COL_EEC71893_F83E_4386_B2F7_3627C3E022E6#137913 AS COL_B395DCC4_9EDF_4E1C_8C90_E98F7EFAA8C0#138033, COL_77CBA20F_6A8C_4D3A_BC59_D7CD174E7E8D#137914 AS COL_31EFC9A8_5E6C_4D4D_B15F_E68F2E3693CE#138034, COL_DE67D89B_227D_4F09_ABDA_D8B1C0A35A11#137915 AS COL_3F609CDB_8DFC_4A9C_8795_F7C25E6782CA#138035, COL_E42B0A67_021E_452C_86E9_748574B172EC#137916 AS COL_BFCE39F8_E0D0_484E_A677_0897F79EC3E6#138036, COL_C7E3A332_A3B0_48B4_A9AE_125FFC458E5C#137917 AS COL_FCEF4905_018B_40FC_91E0_141623C1B8BB#138037, COL_FB92781C_F249_40DA_B117_0DE95032AB70#137918 AS COL_D01526DE_1B63_4889_9F34_87EED1CF3786#138038, COL_40348DC0_F9CE_4A0A_82F6_73BBD17DCB0F#137921 AS COL_8D847F1B_36FF_43A6_87DC_AB53080FE388#138039]
Filter (((COL_9CC6E14B_0B36_40EE_8BE3_D6FB9118CDB0#137912 <=> 290000041) AND CASE WHEN isnull(StartsWith(COL_FB92781C_F249_40DA_B117_0DE95032AB70#137918, 2025)) THEN false ELSE StartsWith(COL_FB92781C_F249_40DA_B117_0DE95032AB70#137918, 2025) END) AND (COL_40348DC0_F9CE_4A0A_82F6_73BBD17DCB0F#137921 <=> O))
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_9CC6E14B_0B36_40EE_8BE3_D6FB9118CDB0#137912,COL_EEC71893_F83E_4386_B2F7_3627C3E022E6#137913,COL_77CBA20F_6A8C_4D3A_BC59_D7CD174E7E8D#137914,COL_DE67D89B_227D_4F09_ABDA_D8B1C0A35A11#137915,COL_E42B0A67_021E_452C_86E9_748574B172EC#137916,COL_C7E3A332_A3B0_48B4_A9AE_125FFC458E5C#137917,COL_FB92781C_F249_40DA_B117_0DE95032AB70#137918,COL_40348DC0_F9CE_4A0A_82F6_73BBD17DCB0F#137921] Batched: true, DataFilters: [(COL_9CC6E14B_0B36_40EE_8BE3_D6FB9118CDB0#137912 <=> 290000041), CASE WHEN isnull(StartsWith(COL..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/SEVERITE_REF_CO_306678], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_9CC6E14B_0B36_40EE_8BE3_D6FB9118CDB0,290000041), EqualNullSafe(COL_40348DC0_F9..., ReadSchema: struct<COL_9CC6E14B_0B36_40EE_8BE3_D6FB9118CDB0:string,COL_EEC71893_F83E_4386_B2F7_3627C3E022E6:s...
== Physical Plan ==
TakeOrderedAndProject (5)
+- * Project (4)
+- * Filter (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
(1) Scan parquet
Output [8]: [COL_9CC6E14B_0B36_40EE_8BE3_D6FB9118CDB0#137912, COL_EEC71893_F83E_4386_B2F7_3627C3E022E6#137913, COL_77CBA20F_6A8C_4D3A_BC59_D7CD174E7E8D#137914, COL_DE67D89B_227D_4F09_ABDA_D8B1C0A35A11#137915, COL_E42B0A67_021E_452C_86E9_748574B172EC#137916, COL_C7E3A332_A3B0_48B4_A9AE_125FFC458E5C#137917, COL_FB92781C_F249_40DA_B117_0DE95032AB70#137918, COL_40348DC0_F9CE_4A0A_82F6_73BBD17DCB0F#137921]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/SEVERITE_REF_CO_306678]
PushedFilters: [EqualNullSafe(COL_9CC6E14B_0B36_40EE_8BE3_D6FB9118CDB0,290000041), EqualNullSafe(COL_40348DC0_F9CE_4A0A_82F6_73BBD17DCB0F,O)]
ReadSchema: struct<COL_9CC6E14B_0B36_40EE_8BE3_D6FB9118CDB0:string,COL_EEC71893_F83E_4386_B2F7_3627C3E022E6:string,COL_77CBA20F_6A8C_4D3A_BC59_D7CD174E7E8D:string,COL_DE67D89B_227D_4F09_ABDA_D8B1C0A35A11:double,COL_E42B0A67_021E_452C_86E9_748574B172EC:double,COL_C7E3A332_A3B0_48B4_A9AE_125FFC458E5C:double,COL_FB92781C_F249_40DA_B117_0DE95032AB70:string,COL_40348DC0_F9CE_4A0A_82F6_73BBD17DCB0F:string>
(2) ColumnarToRow [codegen id : 1]
Input [8]: [COL_9CC6E14B_0B36_40EE_8BE3_D6FB9118CDB0#137912, COL_EEC71893_F83E_4386_B2F7_3627C3E022E6#137913, COL_77CBA20F_6A8C_4D3A_BC59_D7CD174E7E8D#137914, COL_DE67D89B_227D_4F09_ABDA_D8B1C0A35A11#137915, COL_E42B0A67_021E_452C_86E9_748574B172EC#137916, COL_C7E3A332_A3B0_48B4_A9AE_125FFC458E5C#137917, COL_FB92781C_F249_40DA_B117_0DE95032AB70#137918, COL_40348DC0_F9CE_4A0A_82F6_73BBD17DCB0F#137921]
(3) Filter [codegen id : 1]
Input [8]: [COL_9CC6E14B_0B36_40EE_8BE3_D6FB9118CDB0#137912, COL_EEC71893_F83E_4386_B2F7_3627C3E022E6#137913, COL_77CBA20F_6A8C_4D3A_BC59_D7CD174E7E8D#137914, COL_DE67D89B_227D_4F09_ABDA_D8B1C0A35A11#137915, COL_E42B0A67_021E_452C_86E9_748574B172EC#137916, COL_C7E3A332_A3B0_48B4_A9AE_125FFC458E5C#137917, COL_FB92781C_F249_40DA_B117_0DE95032AB70#137918, COL_40348DC0_F9CE_4A0A_82F6_73BBD17DCB0F#137921]
Condition : (((COL_9CC6E14B_0B36_40EE_8BE3_D6FB9118CDB0#137912 <=> 290000041) AND CASE WHEN isnull(StartsWith(COL_FB92781C_F249_40DA_B117_0DE95032AB70#137918, 2025)) THEN false ELSE StartsWith(COL_FB92781C_F249_40DA_B117_0DE95032AB70#137918, 2025) END) AND (COL_40348DC0_F9CE_4A0A_82F6_73BBD17DCB0F#137921 <=> O))
(4) Project [codegen id : 1]
Output [8]: [COL_9CC6E14B_0B36_40EE_8BE3_D6FB9118CDB0#137912 AS COL_5D901C9E_98C5_4384_AE94_0E0E0A9A88A0#138032, COL_EEC71893_F83E_4386_B2F7_3627C3E022E6#137913 AS COL_B395DCC4_9EDF_4E1C_8C90_E98F7EFAA8C0#138033, COL_77CBA20F_6A8C_4D3A_BC59_D7CD174E7E8D#137914 AS COL_31EFC9A8_5E6C_4D4D_B15F_E68F2E3693CE#138034, COL_DE67D89B_227D_4F09_ABDA_D8B1C0A35A11#137915 AS COL_3F609CDB_8DFC_4A9C_8795_F7C25E6782CA#138035, COL_E42B0A67_021E_452C_86E9_748574B172EC#137916 AS COL_BFCE39F8_E0D0_484E_A677_0897F79EC3E6#138036, COL_C7E3A332_A3B0_48B4_A9AE_125FFC458E5C#137917 AS COL_FCEF4905_018B_40FC_91E0_141623C1B8BB#138037, COL_FB92781C_F249_40DA_B117_0DE95032AB70#137918 AS COL_D01526DE_1B63_4889_9F34_87EED1CF3786#138038, COL_40348DC0_F9CE_4A0A_82F6_73BBD17DCB0F#137921 AS COL_8D847F1B_36FF_43A6_87DC_AB53080FE388#138039]
Input [8]: [COL_9CC6E14B_0B36_40EE_8BE3_D6FB9118CDB0#137912, COL_EEC71893_F83E_4386_B2F7_3627C3E022E6#137913, COL_77CBA20F_6A8C_4D3A_BC59_D7CD174E7E8D#137914, COL_DE67D89B_227D_4F09_ABDA_D8B1C0A35A11#137915, COL_E42B0A67_021E_452C_86E9_748574B172EC#137916, COL_C7E3A332_A3B0_48B4_A9AE_125FFC458E5C#137917, COL_FB92781C_F249_40DA_B117_0DE95032AB70#137918, COL_40348DC0_F9CE_4A0A_82F6_73BBD17DCB0F#137921]
(5) TakeOrderedAndProject
Input [8]: [COL_5D901C9E_98C5_4384_AE94_0E0E0A9A88A0#138032, COL_B395DCC4_9EDF_4E1C_8C90_E98F7EFAA8C0#138033, COL_31EFC9A8_5E6C_4D4D_B15F_E68F2E3693CE#138034, COL_3F609CDB_8DFC_4A9C_8795_F7C25E6782CA#138035, COL_BFCE39F8_E0D0_484E_A677_0897F79EC3E6#138036, COL_FCEF4905_018B_40FC_91E0_141623C1B8BB#138037, COL_D01526DE_1B63_4889_9F34_87EED1CF3786#138038, COL_8D847F1B_36FF_43A6_87DC_AB53080FE388#138039]
Arguments: 500000, [COL_31EFC9A8_5E6C_4D4D_B15F_E68F2E3693CE#138034 ASC NULLS FIRST], [COL_5D901C9E_98C5_4384_AE94_0E0E0A9A88A0#138032, COL_B395DCC4_9EDF_4E1C_8C90_E98F7EFAA8C0#138033, COL_31EFC9A8_5E6C_4D4D_B15F_E68F2E3693CE#138034, round(COL_3F609CDB_8DFC_4A9C_8795_F7C25E6782CA#138035, 3) AS COL_3F609CDB_8DFC_4A9C_8795_F7C25E6782CA#138161, round(COL_BFCE39F8_E0D0_484E_A677_0897F79EC3E6#138036, 3) AS COL_BFCE39F8_E0D0_484E_A677_0897F79EC3E6#138162, round(COL_FCEF4905_018B_40FC_91E0_141623C1B8BB#138037, 3) AS COL_FCEF4905_018B_40FC_91E0_141623C1B8BB#138163, COL_D01526DE_1B63_4889_9F34_87EED1CF3786#138038, COL_8D847F1B_36FF_43A6_87DC_AB53080FE388#138039]