digraph G {
0 [labelType="html" label="<br><b>TakeOrderedAndProject</b><br><br>"];
subgraph cluster1 {
isCluster="true";
label="WholeStageCodegen (1)\n \nduration: 8 ms";
2 [labelType="html" label="<br><b>Project</b><br><br>"];
3 [labelType="html" label="<b>ColumnarToRow</b><br><br>number of output rows: 90<br>number of input batches: 1"];
}
4 [labelType="html" label="<b>Scan parquet </b><br><br>number of files read: 1<br>scan time: 2 ms<br>metadata time: 0 ms<br>size of files read: 6.1 KiB<br>number of output rows: 90"];
2->0;
3->2;
4->3;
}
5
TakeOrderedAndProject(limit=500000, orderBy=[COL_9D3497F7_C3BF_4CE7_856E_8E260100A87E#240148L DESC NULLS LAST], output=[COL_9964EE46_4F86_43D3_9C5E_D9B2699D7BC0#240147,COL_9D3497F7_C3BF_4CE7_856E_8E260100A87E#240148L,COL_B0855614_6410_47BF_B8DD_BFCF232D5CF8#240149,COL_124C0377_0FBF_47DF_8189_21D6F4424600#240150,COL_4D661425_D3A0_40C0_BDBF_19893D79C278#240151,COL_59E99D67_DF14_493D_9FAE_F54A998381C9#240152,COL_B72D85F7_7D20_4324_B80B_AE7716EFBBE0#240153])
Project [COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#240042 AS COL_9964EE46_4F86_43D3_9C5E_D9B2699D7BC0#240147, COL_59FA6040_6707_4B54_9108_CEDCF1D097AC#240043L AS COL_9D3497F7_C3BF_4CE7_856E_8E260100A87E#240148L, COL_B3ADA9F8_F901_4347_8D6C_53BF36F1C5E3#240044 AS COL_B0855614_6410_47BF_B8DD_BFCF232D5CF8#240149, COL_835DC3EC_D2DD_4BD1_8C40_CAF90D1E5F3A#240045 AS COL_124C0377_0FBF_47DF_8189_21D6F4424600#240150, COL_513BC31A_803D_4F0C_A2C6_FAA208673DBC#240046 AS COL_4D661425_D3A0_40C0_BDBF_19893D79C278#240151, COL_C014AE6B_2E55_4399_97E3_60F25D355E27#240047 AS COL_59E99D67_DF14_493D_9FAE_F54A998381C9#240152, COL_B236EC76_295F_4331_8EFA_561A109DE376#240048 AS COL_B72D85F7_7D20_4324_B80B_AE7716EFBBE0#240153]
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#240042,COL_59FA6040_6707_4B54_9108_CEDCF1D097AC#240043L,COL_B3ADA9F8_F901_4347_8D6C_53BF36F1C5E3#240044,COL_835DC3EC_D2DD_4BD1_8C40_CAF90D1E5F3A#240045,COL_513BC31A_803D_4F0C_A2C6_FAA208673DBC#240046,COL_C014AE6B_2E55_4399_97E3_60F25D355E27#240047,COL_B236EC76_295F_4331_8EFA_561A109DE376#240048] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/REPARTITION_GEO_405435], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19:string,COL_59FA6040_6707_4B54_9108_CEDCF1D097AC:b...
== Physical Plan ==
TakeOrderedAndProject (4)
+- * Project (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
(1) Scan parquet
Output [7]: [COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#240042, COL_59FA6040_6707_4B54_9108_CEDCF1D097AC#240043L, COL_B3ADA9F8_F901_4347_8D6C_53BF36F1C5E3#240044, COL_835DC3EC_D2DD_4BD1_8C40_CAF90D1E5F3A#240045, COL_513BC31A_803D_4F0C_A2C6_FAA208673DBC#240046, COL_C014AE6B_2E55_4399_97E3_60F25D355E27#240047, COL_B236EC76_295F_4331_8EFA_561A109DE376#240048]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/REPARTITION_GEO_405435]
ReadSchema: struct<COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19:string,COL_59FA6040_6707_4B54_9108_CEDCF1D097AC:bigint,COL_B3ADA9F8_F901_4347_8D6C_53BF36F1C5E3:string,COL_835DC3EC_D2DD_4BD1_8C40_CAF90D1E5F3A:string,COL_513BC31A_803D_4F0C_A2C6_FAA208673DBC:string,COL_C014AE6B_2E55_4399_97E3_60F25D355E27:string,COL_B236EC76_295F_4331_8EFA_561A109DE376:string>
(2) ColumnarToRow [codegen id : 1]
Input [7]: [COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#240042, COL_59FA6040_6707_4B54_9108_CEDCF1D097AC#240043L, COL_B3ADA9F8_F901_4347_8D6C_53BF36F1C5E3#240044, COL_835DC3EC_D2DD_4BD1_8C40_CAF90D1E5F3A#240045, COL_513BC31A_803D_4F0C_A2C6_FAA208673DBC#240046, COL_C014AE6B_2E55_4399_97E3_60F25D355E27#240047, COL_B236EC76_295F_4331_8EFA_561A109DE376#240048]
(3) Project [codegen id : 1]
Output [7]: [COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#240042 AS COL_9964EE46_4F86_43D3_9C5E_D9B2699D7BC0#240147, COL_59FA6040_6707_4B54_9108_CEDCF1D097AC#240043L AS COL_9D3497F7_C3BF_4CE7_856E_8E260100A87E#240148L, COL_B3ADA9F8_F901_4347_8D6C_53BF36F1C5E3#240044 AS COL_B0855614_6410_47BF_B8DD_BFCF232D5CF8#240149, COL_835DC3EC_D2DD_4BD1_8C40_CAF90D1E5F3A#240045 AS COL_124C0377_0FBF_47DF_8189_21D6F4424600#240150, COL_513BC31A_803D_4F0C_A2C6_FAA208673DBC#240046 AS COL_4D661425_D3A0_40C0_BDBF_19893D79C278#240151, COL_C014AE6B_2E55_4399_97E3_60F25D355E27#240047 AS COL_59E99D67_DF14_493D_9FAE_F54A998381C9#240152, COL_B236EC76_295F_4331_8EFA_561A109DE376#240048 AS COL_B72D85F7_7D20_4324_B80B_AE7716EFBBE0#240153]
Input [7]: [COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#240042, COL_59FA6040_6707_4B54_9108_CEDCF1D097AC#240043L, COL_B3ADA9F8_F901_4347_8D6C_53BF36F1C5E3#240044, COL_835DC3EC_D2DD_4BD1_8C40_CAF90D1E5F3A#240045, COL_513BC31A_803D_4F0C_A2C6_FAA208673DBC#240046, COL_C014AE6B_2E55_4399_97E3_60F25D355E27#240047, COL_B236EC76_295F_4331_8EFA_561A109DE376#240048]
(4) TakeOrderedAndProject
Input [7]: [COL_9964EE46_4F86_43D3_9C5E_D9B2699D7BC0#240147, COL_9D3497F7_C3BF_4CE7_856E_8E260100A87E#240148L, COL_B0855614_6410_47BF_B8DD_BFCF232D5CF8#240149, COL_124C0377_0FBF_47DF_8189_21D6F4424600#240150, COL_4D661425_D3A0_40C0_BDBF_19893D79C278#240151, COL_59E99D67_DF14_493D_9FAE_F54A998381C9#240152, COL_B72D85F7_7D20_4324_B80B_AE7716EFBBE0#240153]
Arguments: 500000, [COL_9D3497F7_C3BF_4CE7_856E_8E260100A87E#240148L DESC NULLS LAST], [COL_9964EE46_4F86_43D3_9C5E_D9B2699D7BC0#240147, COL_9D3497F7_C3BF_4CE7_856E_8E260100A87E#240148L, COL_B0855614_6410_47BF_B8DD_BFCF232D5CF8#240149, COL_124C0377_0FBF_47DF_8189_21D6F4424600#240150, COL_4D661425_D3A0_40C0_BDBF_19893D79C278#240151, COL_59E99D67_DF14_493D_9FAE_F54A998381C9#240152, COL_B72D85F7_7D20_4324_B80B_AE7716EFBBE0#240153]