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))\n79 ms (13 ms, 14 ms, 52 ms (stage 875.0: task 1174))";
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: 20,000<br>number of input batches: 5"];
}
5 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 3<br>scan time total (min, med, max (stageId: taskId))<br>45 ms (13 ms, 14 ms, 18 ms (stage 875.0: task 1174))<br>metadata time: 0 ms<br>size of files read: 496.9 KiB<br>number of output rows: 20,000"];
2->0;
3->2;
4->3;
5->4;
}
6
TakeOrderedAndProject(limit=500000, orderBy=[COL_E34B7FEB_6628_42D7_A4B0_6FF760CF68A5#141835 ASC NULLS FIRST,COL_FB1BCADE_777A_4748_A761_2C624E177133#141836 ASC NULLS FIRST,COL_2E5EFAB0_CA76_4B61_8F53_7F8E4477205F#141841 ASC NULLS FIRST], output=[COL_64505C12_4746_4DD1_8B3A_A252D296E117#141833,COL_5A96EAEA_F480_4917_97F0_353CD67E9CB1#141834,COL_E34B7FEB_6628_42D7_A4B0_6FF760CF68A5#141835,COL_FB1BCADE_777A_4748_A761_2C624E177133#141836,COL_15178F3F_DA4A_4E3C_8779_1691AF1D0B31#141837,COL_CFE9405A_9098_4F73_BA2E_B09D40F8EEB2#141838,COL_FEC0627E_0293_44F9_8FC9_449D3B8A386D#141839,COL_843C7AF4_6476_45E0_8880_909D00E908E8#141840,COL_2E5EFAB0_CA76_4B61_8F53_7F8E4477205F#141841,COL_C7431853_48B8_453C_811B_B4B529398DA2#141842,COL_A0E31BEA_702E_4ABE_8626_6A24300C2EA4#141843,COL_6A72DDE5_1B38_4F61_8393_D56B0421A20E#141844,COL_A6EC3329_C326_423E_8F5B_E34F3949F446#141845,COL_B675978B_AC93_41C1_9405_4EAB4C988087#141846,COL_8ADA2E09_4EA9_4B89_87AE_1D5F8E1648E7#141847,COL_57677CD0_173D_403B_A6DF_8FB13389A162#141848,COL_0D78AF02_6072_4A33_BDD7_98A052F43F38#141849,COL_7ED0F293_5BB0_44FC_A079_4F998D49BA4F#141850,COL_B66AB1C0_01E5_4EA9_9A5B_E48522533AA7#141851])
Project [COL_FF91BB18_29C6_416D_B9D6_CB8F4FFBE8AD#141454 AS COL_64505C12_4746_4DD1_8B3A_A252D296E117#141833, COL_3D0EC074_4DF9_4012_940E_AB0CB93CF701#141455 AS COL_5A96EAEA_F480_4917_97F0_353CD67E9CB1#141834, COL_0AD4FC79_7875_4743_8D86_693103C4F6DF#141456 AS COL_E34B7FEB_6628_42D7_A4B0_6FF760CF68A5#141835, COL_0E9EB8A9_EFCD_4145_912B_B22E9A996A08#141457 AS COL_FB1BCADE_777A_4748_A761_2C624E177133#141836, COL_8E340E3C_9278_4586_A6D7_EACB1B8F2332#141458 AS COL_15178F3F_DA4A_4E3C_8779_1691AF1D0B31#141837, COL_2DFC29A4_BF4D_4060_AB13_F84848B6A9EC#141459 AS COL_CFE9405A_9098_4F73_BA2E_B09D40F8EEB2#141838, COL_1A725DA8_876D_4BC1_B42A_AB69DB414725#141460 AS COL_FEC0627E_0293_44F9_8FC9_449D3B8A386D#141839, COL_CD701299_63B7_406D_9440_54BD0131A86B#141461 AS COL_843C7AF4_6476_45E0_8880_909D00E908E8#141840, COL_E1835BE2_4FDE_4905_B379_A3A83AAD3B31#141462 AS COL_2E5EFAB0_CA76_4B61_8F53_7F8E4477205F#141841, COL_D6826CBC_1D7A_47AB_846E_D442A882445E#141463 AS COL_C7431853_48B8_453C_811B_B4B529398DA2#141842, COL_ABA1200A_9BEA_462A_A92A_6F99C03905A0#141464 AS COL_A0E31BEA_702E_4ABE_8626_6A24300C2EA4#141843, COL_B89E53A9_1D2B_4FB0_96C5_C318E19ACCA9#141465 AS COL_6A72DDE5_1B38_4F61_8393_D56B0421A20E#141844, COL_3C5F522E_06E2_427D_A03B_392571FA6633#141466 AS COL_A6EC3329_C326_423E_8F5B_E34F3949F446#141845, COL_DEA68E22_029B_4CEF_82D7_485F0579BB7C#141467 AS COL_B675978B_AC93_41C1_9405_4EAB4C988087#141846, COL_7E86FF86_DADC_474A_826F_623478D442F6#141468 AS COL_8ADA2E09_4EA9_4B89_87AE_1D5F8E1648E7#141847, COL_62FA147A_D638_42C8_A6D8_0A120A4A2B03#141469 AS COL_57677CD0_173D_403B_A6DF_8FB13389A162#141848, COL_AAE43DCE_C5C7_4F02_890B_5E294A0FB848#141470 AS COL_0D78AF02_6072_4A33_BDD7_98A052F43F38#141849, COL_F4BE0FC9_F965_4A18_9D7C_F735F5C0F9C7#141471 AS COL_7ED0F293_5BB0_44FC_A079_4F998D49BA4F#141850, COL_B69B2310_3A87_437C_B292_E2D12FC12449#141472 AS COL_B66AB1C0_01E5_4EA9_9A5B_E48522533AA7#141851]
Filter (((COL_2DFC29A4_BF4D_4060_AB13_F84848B6A9EC#141459 <=> 350000055) AND (COL_B69B2310_3A87_437C_B292_E2D12FC12449#141472 <=> 2025-07)) AND (COL_D6826CBC_1D7A_47AB_846E_D442A882445E#141463 <=> nbrsa))
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_FF91BB18_29C6_416D_B9D6_CB8F4FFBE8AD#141454,COL_3D0EC074_4DF9_4012_940E_AB0CB93CF701#141455,COL_0AD4FC79_7875_4743_8D86_693103C4F6DF#141456,COL_0E9EB8A9_EFCD_4145_912B_B22E9A996A08#141457,COL_8E340E3C_9278_4586_A6D7_EACB1B8F2332#141458,COL_2DFC29A4_BF4D_4060_AB13_F84848B6A9EC#141459,COL_1A725DA8_876D_4BC1_B42A_AB69DB414725#141460,COL_CD701299_63B7_406D_9440_54BD0131A86B#141461,COL_E1835BE2_4FDE_4905_B379_A3A83AAD3B31#141462,COL_D6826CBC_1D7A_47AB_846E_D442A882445E#141463,COL_ABA1200A_9BEA_462A_A92A_6F99C03905A0#141464,COL_B89E53A9_1D2B_4FB0_96C5_C318E19ACCA9#141465,COL_3C5F522E_06E2_427D_A03B_392571FA6633#141466,COL_DEA68E22_029B_4CEF_82D7_485F0579BB7C#141467,COL_7E86FF86_DADC_474A_826F_623478D442F6#141468,COL_62FA147A_D638_42C8_A6D8_0A120A4A2B03#141469,COL_AAE43DCE_C5C7_4F02_890B_5E294A0FB848#141470,COL_F4BE0FC9_F965_4A18_9D7C_F735F5C0F9C7#141471,COL_B69B2310_3A87_437C_B292_E2D12FC12449#141472] Batched: true, DataFilters: [(COL_2DFC29A4_BF4D_4060_AB13_F84848B6A9EC#141459 <=> 350000055), (COL_B69B2310_3A87_437C_B292_E2..., Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/1_D_2_RTP_2_REP_307318], PartitionFilters: [], PushedFilters: [EqualNullSafe(COL_2DFC29A4_BF4D_4060_AB13_F84848B6A9EC,350000055), EqualNullSafe(COL_B69B2310_3A..., ReadSchema: struct<COL_FF91BB18_29C6_416D_B9D6_CB8F4FFBE8AD:string,COL_3D0EC074_4DF9_4012_940E_AB0CB93CF701:s...
== Physical Plan ==
TakeOrderedAndProject (5)
+- * Project (4)
+- * Filter (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
(1) Scan parquet
Output [19]: [COL_FF91BB18_29C6_416D_B9D6_CB8F4FFBE8AD#141454, COL_3D0EC074_4DF9_4012_940E_AB0CB93CF701#141455, COL_0AD4FC79_7875_4743_8D86_693103C4F6DF#141456, COL_0E9EB8A9_EFCD_4145_912B_B22E9A996A08#141457, COL_8E340E3C_9278_4586_A6D7_EACB1B8F2332#141458, COL_2DFC29A4_BF4D_4060_AB13_F84848B6A9EC#141459, COL_1A725DA8_876D_4BC1_B42A_AB69DB414725#141460, COL_CD701299_63B7_406D_9440_54BD0131A86B#141461, COL_E1835BE2_4FDE_4905_B379_A3A83AAD3B31#141462, COL_D6826CBC_1D7A_47AB_846E_D442A882445E#141463, COL_ABA1200A_9BEA_462A_A92A_6F99C03905A0#141464, COL_B89E53A9_1D2B_4FB0_96C5_C318E19ACCA9#141465, COL_3C5F522E_06E2_427D_A03B_392571FA6633#141466, COL_DEA68E22_029B_4CEF_82D7_485F0579BB7C#141467, COL_7E86FF86_DADC_474A_826F_623478D442F6#141468, COL_62FA147A_D638_42C8_A6D8_0A120A4A2B03#141469, COL_AAE43DCE_C5C7_4F02_890B_5E294A0FB848#141470, COL_F4BE0FC9_F965_4A18_9D7C_F735F5C0F9C7#141471, COL_B69B2310_3A87_437C_B292_E2D12FC12449#141472]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/1_D_2_RTP_2_REP_307318]
PushedFilters: [EqualNullSafe(COL_2DFC29A4_BF4D_4060_AB13_F84848B6A9EC,350000055), EqualNullSafe(COL_B69B2310_3A87_437C_B292_E2D12FC12449,2025-07), EqualNullSafe(COL_D6826CBC_1D7A_47AB_846E_D442A882445E,nbrsa)]
ReadSchema: struct<COL_FF91BB18_29C6_416D_B9D6_CB8F4FFBE8AD:string,COL_3D0EC074_4DF9_4012_940E_AB0CB93CF701:string,COL_0AD4FC79_7875_4743_8D86_693103C4F6DF:int,COL_0E9EB8A9_EFCD_4145_912B_B22E9A996A08:int,COL_8E340E3C_9278_4586_A6D7_EACB1B8F2332:string,COL_2DFC29A4_BF4D_4060_AB13_F84848B6A9EC:string,COL_1A725DA8_876D_4BC1_B42A_AB69DB414725:string,COL_CD701299_63B7_406D_9440_54BD0131A86B:string,COL_E1835BE2_4FDE_4905_B379_A3A83AAD3B31:int,COL_D6826CBC_1D7A_47AB_846E_D442A882445E:string,COL_ABA1200A_9BEA_462A_A92A_6F99C03905A0:int,COL_B89E53A9_1D2B_4FB0_96C5_C318E19ACCA9:int,COL_3C5F522E_06E2_427D_A03B_392571FA6633:double,COL_DEA68E22_029B_4CEF_82D7_485F0579BB7C:double,COL_7E86FF86_DADC_474A_826F_623478D442F6:string,COL_62FA147A_D638_42C8_A6D8_0A120A4A2B03:string,COL_AAE43DCE_C5C7_4F02_890B_5E294A0FB848:string,COL_F4BE0FC9_F965_4A18_9D7C_F735F5C0F9C7:string,COL_B69B2310_3A87_437C_B292_E2D12FC12449:string>
(2) ColumnarToRow [codegen id : 1]
Input [19]: [COL_FF91BB18_29C6_416D_B9D6_CB8F4FFBE8AD#141454, COL_3D0EC074_4DF9_4012_940E_AB0CB93CF701#141455, COL_0AD4FC79_7875_4743_8D86_693103C4F6DF#141456, COL_0E9EB8A9_EFCD_4145_912B_B22E9A996A08#141457, COL_8E340E3C_9278_4586_A6D7_EACB1B8F2332#141458, COL_2DFC29A4_BF4D_4060_AB13_F84848B6A9EC#141459, COL_1A725DA8_876D_4BC1_B42A_AB69DB414725#141460, COL_CD701299_63B7_406D_9440_54BD0131A86B#141461, COL_E1835BE2_4FDE_4905_B379_A3A83AAD3B31#141462, COL_D6826CBC_1D7A_47AB_846E_D442A882445E#141463, COL_ABA1200A_9BEA_462A_A92A_6F99C03905A0#141464, COL_B89E53A9_1D2B_4FB0_96C5_C318E19ACCA9#141465, COL_3C5F522E_06E2_427D_A03B_392571FA6633#141466, COL_DEA68E22_029B_4CEF_82D7_485F0579BB7C#141467, COL_7E86FF86_DADC_474A_826F_623478D442F6#141468, COL_62FA147A_D638_42C8_A6D8_0A120A4A2B03#141469, COL_AAE43DCE_C5C7_4F02_890B_5E294A0FB848#141470, COL_F4BE0FC9_F965_4A18_9D7C_F735F5C0F9C7#141471, COL_B69B2310_3A87_437C_B292_E2D12FC12449#141472]
(3) Filter [codegen id : 1]
Input [19]: [COL_FF91BB18_29C6_416D_B9D6_CB8F4FFBE8AD#141454, COL_3D0EC074_4DF9_4012_940E_AB0CB93CF701#141455, COL_0AD4FC79_7875_4743_8D86_693103C4F6DF#141456, COL_0E9EB8A9_EFCD_4145_912B_B22E9A996A08#141457, COL_8E340E3C_9278_4586_A6D7_EACB1B8F2332#141458, COL_2DFC29A4_BF4D_4060_AB13_F84848B6A9EC#141459, COL_1A725DA8_876D_4BC1_B42A_AB69DB414725#141460, COL_CD701299_63B7_406D_9440_54BD0131A86B#141461, COL_E1835BE2_4FDE_4905_B379_A3A83AAD3B31#141462, COL_D6826CBC_1D7A_47AB_846E_D442A882445E#141463, COL_ABA1200A_9BEA_462A_A92A_6F99C03905A0#141464, COL_B89E53A9_1D2B_4FB0_96C5_C318E19ACCA9#141465, COL_3C5F522E_06E2_427D_A03B_392571FA6633#141466, COL_DEA68E22_029B_4CEF_82D7_485F0579BB7C#141467, COL_7E86FF86_DADC_474A_826F_623478D442F6#141468, COL_62FA147A_D638_42C8_A6D8_0A120A4A2B03#141469, COL_AAE43DCE_C5C7_4F02_890B_5E294A0FB848#141470, COL_F4BE0FC9_F965_4A18_9D7C_F735F5C0F9C7#141471, COL_B69B2310_3A87_437C_B292_E2D12FC12449#141472]
Condition : (((COL_2DFC29A4_BF4D_4060_AB13_F84848B6A9EC#141459 <=> 350000055) AND (COL_B69B2310_3A87_437C_B292_E2D12FC12449#141472 <=> 2025-07)) AND (COL_D6826CBC_1D7A_47AB_846E_D442A882445E#141463 <=> nbrsa))
(4) Project [codegen id : 1]
Output [19]: [COL_FF91BB18_29C6_416D_B9D6_CB8F4FFBE8AD#141454 AS COL_64505C12_4746_4DD1_8B3A_A252D296E117#141833, COL_3D0EC074_4DF9_4012_940E_AB0CB93CF701#141455 AS COL_5A96EAEA_F480_4917_97F0_353CD67E9CB1#141834, COL_0AD4FC79_7875_4743_8D86_693103C4F6DF#141456 AS COL_E34B7FEB_6628_42D7_A4B0_6FF760CF68A5#141835, COL_0E9EB8A9_EFCD_4145_912B_B22E9A996A08#141457 AS COL_FB1BCADE_777A_4748_A761_2C624E177133#141836, COL_8E340E3C_9278_4586_A6D7_EACB1B8F2332#141458 AS COL_15178F3F_DA4A_4E3C_8779_1691AF1D0B31#141837, COL_2DFC29A4_BF4D_4060_AB13_F84848B6A9EC#141459 AS COL_CFE9405A_9098_4F73_BA2E_B09D40F8EEB2#141838, COL_1A725DA8_876D_4BC1_B42A_AB69DB414725#141460 AS COL_FEC0627E_0293_44F9_8FC9_449D3B8A386D#141839, COL_CD701299_63B7_406D_9440_54BD0131A86B#141461 AS COL_843C7AF4_6476_45E0_8880_909D00E908E8#141840, COL_E1835BE2_4FDE_4905_B379_A3A83AAD3B31#141462 AS COL_2E5EFAB0_CA76_4B61_8F53_7F8E4477205F#141841, COL_D6826CBC_1D7A_47AB_846E_D442A882445E#141463 AS COL_C7431853_48B8_453C_811B_B4B529398DA2#141842, COL_ABA1200A_9BEA_462A_A92A_6F99C03905A0#141464 AS COL_A0E31BEA_702E_4ABE_8626_6A24300C2EA4#141843, COL_B89E53A9_1D2B_4FB0_96C5_C318E19ACCA9#141465 AS COL_6A72DDE5_1B38_4F61_8393_D56B0421A20E#141844, COL_3C5F522E_06E2_427D_A03B_392571FA6633#141466 AS COL_A6EC3329_C326_423E_8F5B_E34F3949F446#141845, COL_DEA68E22_029B_4CEF_82D7_485F0579BB7C#141467 AS COL_B675978B_AC93_41C1_9405_4EAB4C988087#141846, COL_7E86FF86_DADC_474A_826F_623478D442F6#141468 AS COL_8ADA2E09_4EA9_4B89_87AE_1D5F8E1648E7#141847, COL_62FA147A_D638_42C8_A6D8_0A120A4A2B03#141469 AS COL_57677CD0_173D_403B_A6DF_8FB13389A162#141848, COL_AAE43DCE_C5C7_4F02_890B_5E294A0FB848#141470 AS COL_0D78AF02_6072_4A33_BDD7_98A052F43F38#141849, COL_F4BE0FC9_F965_4A18_9D7C_F735F5C0F9C7#141471 AS COL_7ED0F293_5BB0_44FC_A079_4F998D49BA4F#141850, COL_B69B2310_3A87_437C_B292_E2D12FC12449#141472 AS COL_B66AB1C0_01E5_4EA9_9A5B_E48522533AA7#141851]
Input [19]: [COL_FF91BB18_29C6_416D_B9D6_CB8F4FFBE8AD#141454, COL_3D0EC074_4DF9_4012_940E_AB0CB93CF701#141455, COL_0AD4FC79_7875_4743_8D86_693103C4F6DF#141456, COL_0E9EB8A9_EFCD_4145_912B_B22E9A996A08#141457, COL_8E340E3C_9278_4586_A6D7_EACB1B8F2332#141458, COL_2DFC29A4_BF4D_4060_AB13_F84848B6A9EC#141459, COL_1A725DA8_876D_4BC1_B42A_AB69DB414725#141460, COL_CD701299_63B7_406D_9440_54BD0131A86B#141461, COL_E1835BE2_4FDE_4905_B379_A3A83AAD3B31#141462, COL_D6826CBC_1D7A_47AB_846E_D442A882445E#141463, COL_ABA1200A_9BEA_462A_A92A_6F99C03905A0#141464, COL_B89E53A9_1D2B_4FB0_96C5_C318E19ACCA9#141465, COL_3C5F522E_06E2_427D_A03B_392571FA6633#141466, COL_DEA68E22_029B_4CEF_82D7_485F0579BB7C#141467, COL_7E86FF86_DADC_474A_826F_623478D442F6#141468, COL_62FA147A_D638_42C8_A6D8_0A120A4A2B03#141469, COL_AAE43DCE_C5C7_4F02_890B_5E294A0FB848#141470, COL_F4BE0FC9_F965_4A18_9D7C_F735F5C0F9C7#141471, COL_B69B2310_3A87_437C_B292_E2D12FC12449#141472]
(5) TakeOrderedAndProject
Input [19]: [COL_64505C12_4746_4DD1_8B3A_A252D296E117#141833, COL_5A96EAEA_F480_4917_97F0_353CD67E9CB1#141834, COL_E34B7FEB_6628_42D7_A4B0_6FF760CF68A5#141835, COL_FB1BCADE_777A_4748_A761_2C624E177133#141836, COL_15178F3F_DA4A_4E3C_8779_1691AF1D0B31#141837, COL_CFE9405A_9098_4F73_BA2E_B09D40F8EEB2#141838, COL_FEC0627E_0293_44F9_8FC9_449D3B8A386D#141839, COL_843C7AF4_6476_45E0_8880_909D00E908E8#141840, COL_2E5EFAB0_CA76_4B61_8F53_7F8E4477205F#141841, COL_C7431853_48B8_453C_811B_B4B529398DA2#141842, COL_A0E31BEA_702E_4ABE_8626_6A24300C2EA4#141843, COL_6A72DDE5_1B38_4F61_8393_D56B0421A20E#141844, COL_A6EC3329_C326_423E_8F5B_E34F3949F446#141845, COL_B675978B_AC93_41C1_9405_4EAB4C988087#141846, COL_8ADA2E09_4EA9_4B89_87AE_1D5F8E1648E7#141847, COL_57677CD0_173D_403B_A6DF_8FB13389A162#141848, COL_0D78AF02_6072_4A33_BDD7_98A052F43F38#141849, COL_7ED0F293_5BB0_44FC_A079_4F998D49BA4F#141850, COL_B66AB1C0_01E5_4EA9_9A5B_E48522533AA7#141851]
Arguments: 500000, [COL_E34B7FEB_6628_42D7_A4B0_6FF760CF68A5#141835 ASC NULLS FIRST, COL_FB1BCADE_777A_4748_A761_2C624E177133#141836 ASC NULLS FIRST, COL_2E5EFAB0_CA76_4B61_8F53_7F8E4477205F#141841 ASC NULLS FIRST], [COL_64505C12_4746_4DD1_8B3A_A252D296E117#141833, COL_5A96EAEA_F480_4917_97F0_353CD67E9CB1#141834, COL_E34B7FEB_6628_42D7_A4B0_6FF760CF68A5#141835, COL_FB1BCADE_777A_4748_A761_2C624E177133#141836, COL_15178F3F_DA4A_4E3C_8779_1691AF1D0B31#141837, COL_CFE9405A_9098_4F73_BA2E_B09D40F8EEB2#141838, COL_FEC0627E_0293_44F9_8FC9_449D3B8A386D#141839, COL_843C7AF4_6476_45E0_8880_909D00E908E8#141840, COL_2E5EFAB0_CA76_4B61_8F53_7F8E4477205F#141841, COL_C7431853_48B8_453C_811B_B4B529398DA2#141842, COL_A0E31BEA_702E_4ABE_8626_6A24300C2EA4#141843, COL_6A72DDE5_1B38_4F61_8393_D56B0421A20E#141844, COL_A6EC3329_C326_423E_8F5B_E34F3949F446#141845, COL_B675978B_AC93_41C1_9405_4EAB4C988087#141846, COL_8ADA2E09_4EA9_4B89_87AE_1D5F8E1648E7#141847, COL_57677CD0_173D_403B_A6DF_8FB13389A162#141848, COL_0D78AF02_6072_4A33_BDD7_98A052F43F38#141849, COL_7ED0F293_5BB0_44FC_A079_4F998D49BA4F#141850, COL_B66AB1C0_01E5_4EA9_9A5B_E48522533AA7#141851]