┌─────────────────────────────────────────────────────────────────────┬───────┬────────┬─────────┬─────────┬───────────┐
│ Operation                                                           │ A-Cpu │ A-Rows │ E-Cost  │ E-Rows  │ E-Size    │
├─────────────────────────────────────────────────────────────────────┼───────┼────────┼─────────┼─────────┼───────────┤
│  -> ResultSet                                                       │       │        │         │         │           │
│    -> Sort ([row.supp_nation,row.cust_nation,row.l_year])           │       │        │         │         │           │
│      -> HashShuffle (KeyColumns: ["cust_nation","l_year","supp_nati │       │        │         │         │           │
│ on"], HashFunc: "HashV1")                                           │       │        │         │         │           │
│        -> Aggregate (GroupBy: [0,1,2], Aggregation: SUM, Phase: Int │       │        │         │         │           │
│ ermediate)                                                          │       │        │         │         │           │
│          -> Filter (n1.n_name == "FRANCE" AND n2.n_name == "GERMANY │       │        │ 7224083 │ 1200    │ 231984    │
│ " OR n1.n_name == "GERMANY" AND n2.n_name == "FRANCE")              │       │        │         │         │           │
│            -> InnerJoin (MapJoin) (lineitem_1.l_suppkey = supplier_ │       │        │ 7224083 │ 60012   │ 11599217  │
│ 1.s_suppkey)                                                        │       │        │         │         │           │
│              -> InnerJoin (Grace) (lineitem_1.l_orderkey = orders_1 │       │        │ 6660560 │ 300061  │ 33961392  │
│ .o_orderkey)                                                        │       │        │         │         │           │
│                -> HashShuffle (KeyColumns: ["l_orderkey"], HashFunc │       │        │         │         │           │
│ : "HashV1")                                                         │       │        │         │         │           │
│                  -> Filter (l_shipdate >= "9131" AND l_shipdate <=  │       │        │ 0       │ 1500304 │ 34630249  │
│ "9861", Pushdown: True)                                             │       │        │         │         │           │
│                    -> TableFullScan (Table: olap_yatests/tpch/s1/li │       │        │ 0       │ 6001215 │ 1.385e+08 │
│ neitem, Scan: Parallel, ReadRanges: ["l_orderkey (-∞, +∞)","l_linen │       │        │         │         │           │
│ umber (-∞, +∞)"], Path: /local/test_db/olap_yatests/tpch/s1/lineite │       │        │         │         │           │
│ m, ReadColumns: ["l_discount","l_extendedprice","l_orderkey","l_shi │       │        │         │         │           │
│ pdate","l_suppkey"])                                                │       │        │         │         │           │
│                -> HashShuffle (KeyColumns: ["orders_1.o_orderkey"], │       │        │         │         │           │
│  HashFunc: "HashV1")                                                │       │        │         │         │           │
│                  -> InnerJoin (Grace) (orders_1.o_custkey = custome │       │        │ 3060014 │ 300000  │ 27029869  │
│ r_1.c_custkey)                                                      │       │        │         │         │           │
│                    -> HashShuffle (KeyColumns: ["o_custkey"], HashF │       │        │         │         │           │
│ unc: "HashV1")                                                      │       │        │         │         │           │
│                      -> TableFullScan (Table: olap_yatests/tpch/s1/ │       │        │ 0       │ 1500000 │ 20167804  │
│ orders, Scan: Parallel, ReadRanges: ["o_orderkey (-∞, +∞)"], Path:  │       │        │         │         │           │
│ /local/test_db/olap_yatests/tpch/s1/orders, ReadColumns: ["o_custke │       │        │         │         │           │
│ y","o_orderkey"])                                                   │       │        │         │         │           │
│                    -> HashShuffle (KeyColumns: ["customer_1.c_custk │       │        │         │         │           │
│ ey"], HashFunc: "HashV1")                                           │       │        │         │         │           │
│                      -> InnerJoin (MapJoin) (customer_1.c_nationkey │       │        │ 270014  │ 30000   │ 2299631   │
│  = n2.n_nationkey)                                                  │       │        │         │         │           │
│                        -> TableFullScan (Table: olap_yatests/tpch/s │       │        │ 0       │ 150000  │ 4226154   │
│ 1/customer, Scan: Parallel, ReadRanges: ["c_custkey (-∞, +∞)"], Pat │       │        │         │         │           │
│ h: /local/test_db/olap_yatests/tpch/s1/customer, ReadColumns: ["c_c │       │        │         │         │           │
│ ustkey","c_nationkey"])                                             │       │        │         │         │           │
│                        -> Filter (n_name == "FRANCE" OR n_name == " │       │        │ 0       │ 5       │ 242       │
│ GERMANY", Pushdown: True)                                           │       │        │         │         │           │
│                          -> TableFullScan (Table: olap_yatests/tpch │       │        │ 0       │ 25      │ 1212      │
│ /s1/nation, Scan: Parallel, ReadRanges: ["n_nationkey (-∞, +∞)"], P │       │        │         │         │           │
│ ath: /local/test_db/olap_yatests/tpch/s1/nation, ReadColumns: ["n_n │       │        │         │         │           │
│ ame","n_nationkey"])                                                │       │        │         │         │           │
│              -> InnerJoin (MapJoin) (supplier_1.s_nationkey = n1.n_ │       │        │ 18014   │ 2000    │ 160199    │
│ nationkey)                                                          │       │        │         │         │           │
│                -> TableFullScan (Table: olap_yatests/tpch/s1/suppli │       │        │ 0       │ 10000   │ 316194    │
│ er, Scan: Parallel, ReadRanges: ["s_suppkey (-∞, +∞)"], Path: /loca │       │        │         │         │           │
│ l/test_db/olap_yatests/tpch/s1/supplier, ReadColumns: ["s_nationkey │       │        │         │         │           │
│ ","s_suppkey"])                                                     │       │        │         │         │           │
│                -> Filter (n_name == "FRANCE" OR n_name == "GERMANY" │       │        │ 0       │ 5       │ 242       │
│ , Pushdown: True)                                                   │       │        │         │         │           │
│                  -> TableFullScan (Table: olap_yatests/tpch/s1/nati │       │        │ 0       │ 25      │ 1212      │
│ on, Scan: Parallel, ReadRanges: ["n_nationkey (-∞, +∞)"], Path: /lo │       │        │         │         │           │
│ cal/test_db/olap_yatests/tpch/s1/nation, ReadColumns: ["n_name","n_ │       │        │         │         │           │
│ nationkey"])                                                        │       │        │         │         │           │
└─────────────────────────────────────────────────────────────────────┴───────┴────────┴─────────┴─────────┴───────────┘
