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: 91<br>number of input batches: 1"];
}
5 [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.2 KiB<br>number of output rows: 91"];
2->0;
3->2;
4->3;
5->4;
}
6
TakeOrderedAndProject(limit=500000, orderBy=[COL_9D3497F7_C3BF_4CE7_856E_8E260100A87E#236202L DESC NULLS LAST], output=[COL_9964EE46_4F86_43D3_9C5E_D9B2699D7BC0#236201,COL_9D3497F7_C3BF_4CE7_856E_8E260100A87E#236202L,COL_B0855614_6410_47BF_B8DD_BFCF232D5CF8#236203,COL_124C0377_0FBF_47DF_8189_21D6F4424600#236204,COL_4D661425_D3A0_40C0_BDBF_19893D79C278#236205,COL_59E99D67_DF14_493D_9FAE_F54A998381C9#236206,COL_B72D85F7_7D20_4324_B80B_AE7716EFBBE0#236207])
Project [COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#236012 AS COL_9964EE46_4F86_43D3_9C5E_D9B2699D7BC0#236201, COL_59FA6040_6707_4B54_9108_CEDCF1D097AC#236013L AS COL_9D3497F7_C3BF_4CE7_856E_8E260100A87E#236202L, COL_B3ADA9F8_F901_4347_8D6C_53BF36F1C5E3#236014 AS COL_B0855614_6410_47BF_B8DD_BFCF232D5CF8#236203, COL_835DC3EC_D2DD_4BD1_8C40_CAF90D1E5F3A#236015 AS COL_124C0377_0FBF_47DF_8189_21D6F4424600#236204, COL_513BC31A_803D_4F0C_A2C6_FAA208673DBC#236016 AS COL_4D661425_D3A0_40C0_BDBF_19893D79C278#236205, COL_C014AE6B_2E55_4399_97E3_60F25D355E27#236017 AS COL_59E99D67_DF14_493D_9FAE_F54A998381C9#236206, COL_B236EC76_295F_4331_8EFA_561A109DE376#236018 AS COL_B72D85F7_7D20_4324_B80B_AE7716EFBBE0#236207]
Filter (((((CASE WHEN isnull(Contains(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#236012, MAISOSNS)) THEN false ELSE Contains(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#236012, MAISOSNS) END OR CASE WHEN isnull(Contains(COL_B3ADA9F8_F901_4347_8D6C_53BF36F1C5E3#236014, MAISOSNS)) THEN false ELSE Contains(COL_B3ADA9F8_F901_4347_8D6C_53BF36F1C5E3#236014, MAISOSNS) END) OR CASE WHEN isnull(Contains(COL_835DC3EC_D2DD_4BD1_8C40_CAF90D1E5F3A#236015, MAISOSNS)) THEN false ELSE Contains(COL_835DC3EC_D2DD_4BD1_8C40_CAF90D1E5F3A#236015, MAISOSNS) END) OR CASE WHEN isnull(Contains(COL_513BC31A_803D_4F0C_A2C6_FAA208673DBC#236016, MAISOSNS)) THEN false ELSE Contains(COL_513BC31A_803D_4F0C_A2C6_FAA208673DBC#236016, MAISOSNS) END) OR CASE WHEN isnull(Contains(COL_C014AE6B_2E55_4399_97E3_60F25D355E27#236017, MAISOSNS)) THEN false ELSE Contains(COL_C014AE6B_2E55_4399_97E3_60F25D355E27#236017, MAISOSNS) END) OR CASE WHEN isnull(Contains(COL_B236EC76_295F_4331_8EFA_561A109DE376#236018, MAISOSNS)) THEN false ELSE Contains(COL_B236EC76_295F_4331_8EFA_561A109DE376#236018, MAISOSNS) END)
ColumnarToRow
WholeStageCodegen (1)
FileScan parquet [COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#236012,COL_59FA6040_6707_4B54_9108_CEDCF1D097AC#236013L,COL_B3ADA9F8_F901_4347_8D6C_53BF36F1C5E3#236014,COL_835DC3EC_D2DD_4BD1_8C40_CAF90D1E5F3A#236015,COL_513BC31A_803D_4F0C_A2C6_FAA208673DBC#236016,COL_C014AE6B_2E55_4399_97E3_60F25D355E27#236017,COL_B236EC76_295F_4331_8EFA_561A109DE376#236018] Batched: true, DataFilters: [(((((CASE WHEN isnull(Contains(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#236012, MAISOSNS)) THEN ..., 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 (5)
+- * Project (4)
+- * Filter (3)
+- * ColumnarToRow (2)
+- Scan parquet (1)
(1) Scan parquet
Output [7]: [COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#236012, COL_59FA6040_6707_4B54_9108_CEDCF1D097AC#236013L, COL_B3ADA9F8_F901_4347_8D6C_53BF36F1C5E3#236014, COL_835DC3EC_D2DD_4BD1_8C40_CAF90D1E5F3A#236015, COL_513BC31A_803D_4F0C_A2C6_FAA208673DBC#236016, COL_C014AE6B_2E55_4399_97E3_60F25D355E27#236017, COL_B236EC76_295F_4331_8EFA_561A109DE376#236018]
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#236012, COL_59FA6040_6707_4B54_9108_CEDCF1D097AC#236013L, COL_B3ADA9F8_F901_4347_8D6C_53BF36F1C5E3#236014, COL_835DC3EC_D2DD_4BD1_8C40_CAF90D1E5F3A#236015, COL_513BC31A_803D_4F0C_A2C6_FAA208673DBC#236016, COL_C014AE6B_2E55_4399_97E3_60F25D355E27#236017, COL_B236EC76_295F_4331_8EFA_561A109DE376#236018]
(3) Filter [codegen id : 1]
Input [7]: [COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#236012, COL_59FA6040_6707_4B54_9108_CEDCF1D097AC#236013L, COL_B3ADA9F8_F901_4347_8D6C_53BF36F1C5E3#236014, COL_835DC3EC_D2DD_4BD1_8C40_CAF90D1E5F3A#236015, COL_513BC31A_803D_4F0C_A2C6_FAA208673DBC#236016, COL_C014AE6B_2E55_4399_97E3_60F25D355E27#236017, COL_B236EC76_295F_4331_8EFA_561A109DE376#236018]
Condition : (((((CASE WHEN isnull(Contains(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#236012, MAISOSNS)) THEN false ELSE Contains(COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#236012, MAISOSNS) END OR CASE WHEN isnull(Contains(COL_B3ADA9F8_F901_4347_8D6C_53BF36F1C5E3#236014, MAISOSNS)) THEN false ELSE Contains(COL_B3ADA9F8_F901_4347_8D6C_53BF36F1C5E3#236014, MAISOSNS) END) OR CASE WHEN isnull(Contains(COL_835DC3EC_D2DD_4BD1_8C40_CAF90D1E5F3A#236015, MAISOSNS)) THEN false ELSE Contains(COL_835DC3EC_D2DD_4BD1_8C40_CAF90D1E5F3A#236015, MAISOSNS) END) OR CASE WHEN isnull(Contains(COL_513BC31A_803D_4F0C_A2C6_FAA208673DBC#236016, MAISOSNS)) THEN false ELSE Contains(COL_513BC31A_803D_4F0C_A2C6_FAA208673DBC#236016, MAISOSNS) END) OR CASE WHEN isnull(Contains(COL_C014AE6B_2E55_4399_97E3_60F25D355E27#236017, MAISOSNS)) THEN false ELSE Contains(COL_C014AE6B_2E55_4399_97E3_60F25D355E27#236017, MAISOSNS) END) OR CASE WHEN isnull(Contains(COL_B236EC76_295F_4331_8EFA_561A109DE376#236018, MAISOSNS)) THEN false ELSE Contains(COL_B236EC76_295F_4331_8EFA_561A109DE376#236018, MAISOSNS) END)
(4) Project [codegen id : 1]
Output [7]: [COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#236012 AS COL_9964EE46_4F86_43D3_9C5E_D9B2699D7BC0#236201, COL_59FA6040_6707_4B54_9108_CEDCF1D097AC#236013L AS COL_9D3497F7_C3BF_4CE7_856E_8E260100A87E#236202L, COL_B3ADA9F8_F901_4347_8D6C_53BF36F1C5E3#236014 AS COL_B0855614_6410_47BF_B8DD_BFCF232D5CF8#236203, COL_835DC3EC_D2DD_4BD1_8C40_CAF90D1E5F3A#236015 AS COL_124C0377_0FBF_47DF_8189_21D6F4424600#236204, COL_513BC31A_803D_4F0C_A2C6_FAA208673DBC#236016 AS COL_4D661425_D3A0_40C0_BDBF_19893D79C278#236205, COL_C014AE6B_2E55_4399_97E3_60F25D355E27#236017 AS COL_59E99D67_DF14_493D_9FAE_F54A998381C9#236206, COL_B236EC76_295F_4331_8EFA_561A109DE376#236018 AS COL_B72D85F7_7D20_4324_B80B_AE7716EFBBE0#236207]
Input [7]: [COL_0ECF9D7D_F147_4277_9D72_C5085FD1AB19#236012, COL_59FA6040_6707_4B54_9108_CEDCF1D097AC#236013L, COL_B3ADA9F8_F901_4347_8D6C_53BF36F1C5E3#236014, COL_835DC3EC_D2DD_4BD1_8C40_CAF90D1E5F3A#236015, COL_513BC31A_803D_4F0C_A2C6_FAA208673DBC#236016, COL_C014AE6B_2E55_4399_97E3_60F25D355E27#236017, COL_B236EC76_295F_4331_8EFA_561A109DE376#236018]
(5) TakeOrderedAndProject
Input [7]: [COL_9964EE46_4F86_43D3_9C5E_D9B2699D7BC0#236201, COL_9D3497F7_C3BF_4CE7_856E_8E260100A87E#236202L, COL_B0855614_6410_47BF_B8DD_BFCF232D5CF8#236203, COL_124C0377_0FBF_47DF_8189_21D6F4424600#236204, COL_4D661425_D3A0_40C0_BDBF_19893D79C278#236205, COL_59E99D67_DF14_493D_9FAE_F54A998381C9#236206, COL_B72D85F7_7D20_4324_B80B_AE7716EFBBE0#236207]
Arguments: 500000, [COL_9D3497F7_C3BF_4CE7_856E_8E260100A87E#236202L DESC NULLS LAST], [COL_9964EE46_4F86_43D3_9C5E_D9B2699D7BC0#236201, COL_9D3497F7_C3BF_4CE7_856E_8E260100A87E#236202L, COL_B0855614_6410_47BF_B8DD_BFCF232D5CF8#236203, COL_124C0377_0FBF_47DF_8189_21D6F4424600#236204, COL_4D661425_D3A0_40C0_BDBF_19893D79C278#236205, COL_59E99D67_DF14_493D_9FAE_F54A998381C9#236206, COL_B72D85F7_7D20_4324_B80B_AE7716EFBBE0#236207]