┌───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┬───────┬────────┬────────┬────────┬─────────┐
│ Operation                                                                                                                                                                                                                                                                                 │ A-Cpu │ A-Rows │ E-Cost │ E-Rows │ E-Size  │
├───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┼───────┼────────┼────────┼────────┼─────────┤
│  -> ResultSet                                                                                                                                                                                                                                                                             │       │        │        │        │         │
│    -> Limit (Limit: 100)                                                                                                                                                                                                                                                                  │       │        │        │        │         │
│      -> TopSort (Limit: 100, TopSortBy: [Arg.s_1.s_acctbal,Arg.n.n_name,Arg.s_1.s_name,Arg.ps_1.ps_partkey])                                                                                                                                                                              │       │        │        │        │         │
│        -> InnerJoin (MapJoin) (ps_1.ps_suppkey = s_1.s_suppkey)                                                                                                                                                                                                                           │       │        │ 75750  │ 0      │ 0       │
│          -> InnerJoin (MapJoin) (ps_1.ps_partkey,ps_1.ps_supplycost = p.p_partkey,m.Min0)                                                                                                                                                                                                 │       │        │ 60750  │ 0      │ 0       │
│            -> TableFullScan (Table: olap_yatests/tpch/s1/partsupp, Scan: Parallel, ReadRanges: ["ps_partkey (-∞, +∞)","ps_suppkey (-∞, +∞)"], Path: /local/test_db/olap_yatests/tpch/s1/partsupp, ReadColumns: ["ps_partkey","ps_suppkey","ps_supplycost"])                               │       │        │ 0      │ 0      │ 0       │
│            -> InnerJoin (Grace) (p.p_partkey = m.ps.ps_partkey)                                                                                                                                                                                                                           │       │        │ 60750  │ 0      │ 0       │
│              -> Filter ((p_size == 15) AND (p_type LIKE "%BRASS"), Pushdown: True)                                                                                                                                                                                                        │       │        │ 0      │ 500    │ 21047   │
│                -> TableFullScan (Table: olap_yatests/tpch/s1/part, Scan: Parallel, ReadRanges: ["p_partkey (-∞, +∞)"], Path: /local/test_db/olap_yatests/tpch/s1/part, ReadColumns: ["p_mfgr","p_partkey","p_size","p_type"])                                                             │       │        │ 0      │ 10000  │ 420939  │
│              -> HashShuffle (KeyColumns: ["ps.ps_partkey"])                                                                                                                                                                                                                               │       │        │        │        │         │
│                -> Aggregate (Phase: Final)                                                                                                                                                                                                                                                │       │        │        │        │         │
│                  -> HashShuffle (KeyColumns: ["ps.ps_partkey"])                                                                                                                                                                                                                           │       │        │        │        │         │
│                    -> Aggregate (GroupBy: ps.ps_partkey, Aggregation: {MIN(ps.ps_supplycost)}, Phase: Intermediate)                                                                                                                                                                       │       │        │        │        │         │
│                      -> LeftSemiJoin (Grace) (ps.ps_suppkey = s_1.s_suppkey)                                                                                                                                                                                                              │       │        │ 60000  │ 0      │ 0       │
│                        -> HashShuffle (KeyColumns: ["ps_suppkey"])                                                                                                                                                                                                                        │       │        │        │        │         │
│                          -> TableFullScan (Table: olap_yatests/tpch/s1/partsupp, Scan: Parallel, ReadRanges: ["ps_partkey (-∞, +∞)","ps_suppkey (-∞, +∞)"], Path: /local/test_db/olap_yatests/tpch/s1/partsupp, ReadColumns: ["ps_partkey","ps_suppkey","ps_supplycost"])                 │       │        │ 0      │ 0      │ 0       │
│                        -> LeftSemiJoin (MapJoin) (s_1.s_nationkey = n.n_nationkey)                                                                                                                                                                                                        │       │        │ 30000  │ 10000  │ 1127704 │
│                          -> TableFullScan (Table: olap_yatests/tpch/s1/supplier, Scan: Parallel, ReadRanges: ["s_suppkey (-∞, +∞)"], Path: /local/test_db/olap_yatests/tpch/s1/supplier, ReadColumns: ["s_acctbal","s_address","s_comment","s_name","s_nationkey","s_phone","s_suppkey"]) │       │        │ 0      │ 10000  │ 1127704 │
│                          -> LeftSemiJoin (MapJoin) (n.n_regionkey = r.r_regionkey)                                                                                                                                                                                                        │       │        │ 0      │ 0      │ 0       │
│                            -> TableFullScan (Table: olap_yatests/tpch/s1/nation, Scan: Parallel, ReadRanges: ["n_nationkey (-∞, +∞)"], Path: /local/test_db/olap_yatests/tpch/s1/nation, ReadColumns: ["n_name","n_nationkey","n_regionkey"])                                             │       │        │ 0      │ 0      │ 0       │
│                            -> Filter (r_name == "EUROPE", Pushdown: True)                                                                                                                                                                                                                 │       │        │ 0      │ 0      │ 0       │
│                              -> TableFullScan (Table: olap_yatests/tpch/s1/region, Scan: Parallel, ReadRanges: ["r_regionkey (-∞, +∞)"], Path: /local/test_db/olap_yatests/tpch/s1/region, ReadColumns: ["r_name","r_regionkey"])                                                         │       │        │ 0      │ 0      │ 0       │
│          -> InnerJoin (MapJoin) (s_1.s_nationkey = n.n_nationkey)                                                                                                                                                                                                                         │       │        │ 15000  │ 0      │ 0       │
│            -> TableFullScan (Table: olap_yatests/tpch/s1/supplier, Scan: Parallel, ReadRanges: ["s_suppkey (-∞, +∞)"], Path: /local/test_db/olap_yatests/tpch/s1/supplier, ReadColumns: ["s_acctbal","s_address","s_comment","s_name","s_nationkey","s_phone","s_suppkey"])               │       │        │ 0      │ 10000  │ 1127704 │
│            -> LeftSemiJoin (MapJoin) (n.n_regionkey = r.r_regionkey)                                                                                                                                                                                                                      │       │        │ 0      │ 0      │ 0       │
│              -> TableFullScan (Table: olap_yatests/tpch/s1/nation, Scan: Parallel, ReadRanges: ["n_nationkey (-∞, +∞)"], Path: /local/test_db/olap_yatests/tpch/s1/nation, ReadColumns: ["n_name","n_nationkey","n_regionkey"])                                                           │       │        │ 0      │ 0      │ 0       │
│              -> Filter (r_name == "EUROPE", Pushdown: True)                                                                                                                                                                                                                               │       │        │ 0      │ 0      │ 0       │
│                -> TableFullScan (Table: olap_yatests/tpch/s1/region, Scan: Parallel, ReadRanges: ["r_regionkey (-∞, +∞)"], Path: /local/test_db/olap_yatests/tpch/s1/region, ReadColumns: ["r_name","r_regionkey"])                                                                       │       │        │ 0      │ 0      │ 0       │
└───────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┴───────┴────────┴────────┴────────┴─────────┘
