http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query39.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query39.q b/ql/src/test/queries/clientpositive/perf/query39.q index d3b981a..d3c806d 100644 --- a/ql/src/test/queries/clientpositive/perf/query39.q +++ b/ql/src/test/queries/clientpositive/perf/query39.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query39.tpl and seed 1327317894 -explain vectorization expression +-- start query 1 in stream 0 using template query39.tpl and seed 1327317894 +explain with inv as (select w_warehouse_name,w_warehouse_sk,i_item_sk,d_moy ,stdev,mean, case mean when 0 then null else stdev/mean end cov
http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query4.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query4.q b/ql/src/test/queries/clientpositive/perf/query4.q index dbd605e..631a464 100644 --- a/ql/src/test/queries/clientpositive/perf/query4.q +++ b/ql/src/test/queries/clientpositive/perf/query4.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query4.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query4.tpl and seed 1819994127 +explain with year_total as ( select c_customer_id customer_id ,c_first_name customer_first_name http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query40.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query40.q b/ql/src/test/queries/clientpositive/perf/query40.q index 8432546..61f5ad3 100644 --- a/ql/src/test/queries/clientpositive/perf/query40.q +++ b/ql/src/test/queries/clientpositive/perf/query40.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query40.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query40.tpl and seed 1819994127 +explain select w_state ,i_item_id http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query42.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query42.q b/ql/src/test/queries/clientpositive/perf/query42.q index b5c6f3f..6b8abe0 100644 --- a/ql/src/test/queries/clientpositive/perf/query42.q +++ b/ql/src/test/queries/clientpositive/perf/query42.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query42.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query42.tpl and seed 1819994127 +explain select dt.d_year ,item.i_category_id ,item.i_category http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query43.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query43.q b/ql/src/test/queries/clientpositive/perf/query43.q index a92e04b..ebdc69d 100644 --- a/ql/src/test/queries/clientpositive/perf/query43.q +++ b/ql/src/test/queries/clientpositive/perf/query43.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query43.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query43.tpl and seed 1819994127 +explain select s_store_name, s_store_id, sum(case when (d_day_name='Sunday') then ss_sales_price else null end) sun_sales, sum(case when (d_day_name='Monday') then ss_sales_price else null end) mon_sales, http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query44.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query44.q b/ql/src/test/queries/clientpositive/perf/query44.q index 0e8a999..712bbfb 100644 --- a/ql/src/test/queries/clientpositive/perf/query44.q +++ b/ql/src/test/queries/clientpositive/perf/query44.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query44.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query44.tpl and seed 1819994127 +explain select asceding.rnk, i1.i_product_name best_performing, i2.i_product_name worst_performing from(select * from (select item_sk,rank() over (order by rank_col asc) rnk http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query45.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query45.q b/ql/src/test/queries/clientpositive/perf/query45.q index 6e07969..4db3fb2 100644 --- a/ql/src/test/queries/clientpositive/perf/query45.q +++ b/ql/src/test/queries/clientpositive/perf/query45.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query45.tpl and seed 2031708268 -explain vectorization expression +-- start query 1 in stream 0 using template query45.tpl and seed 2031708268 +explain select ca_zip, ca_county, sum(ws_sales_price) from web_sales, customer, customer_address, date_dim, item where ws_bill_customer_sk = c_customer_sk http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query46.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query46.q b/ql/src/test/queries/clientpositive/perf/query46.q index 16473d5..46f8be3 100644 --- a/ql/src/test/queries/clientpositive/perf/query46.q +++ b/ql/src/test/queries/clientpositive/perf/query46.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query46.tpl and seed 803547492 -explain vectorization expression +-- start query 1 in stream 0 using template query46.tpl and seed 803547492 +explain select c_last_name ,c_first_name ,ca_city http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query47.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query47.q b/ql/src/test/queries/clientpositive/perf/query47.q index 82f79d7..5c26ba5 100644 --- a/ql/src/test/queries/clientpositive/perf/query47.q +++ b/ql/src/test/queries/clientpositive/perf/query47.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query47.tpl and seed 2031708268 -explain vectorization expression +-- start query 1 in stream 0 using template query47.tpl and seed 2031708268 +explain with v1 as( select i_category, i_brand, s_store_name, s_company_name, http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query48.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query48.q b/ql/src/test/queries/clientpositive/perf/query48.q index 5acdc37..cfff1d7 100644 --- a/ql/src/test/queries/clientpositive/perf/query48.q +++ b/ql/src/test/queries/clientpositive/perf/query48.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query48.tpl and seed 622697896 -explain vectorization expression +-- start query 1 in stream 0 using template query48.tpl and seed 622697896 +explain select sum (ss_quantity) from store_sales, store, customer_demographics, customer_address, date_dim where s_store_sk = ss_store_sk http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query49.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query49.q b/ql/src/test/queries/clientpositive/perf/query49.q index f7bd398..6c62e1f 100644 --- a/ql/src/test/queries/clientpositive/perf/query49.q +++ b/ql/src/test/queries/clientpositive/perf/query49.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query49.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query49.tpl and seed 1819994127 +explain select 'web' as channel ,web.item http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query5.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query5.q b/ql/src/test/queries/clientpositive/perf/query5.q index 024c5f1..bf61fb2 100644 --- a/ql/src/test/queries/clientpositive/perf/query5.q +++ b/ql/src/test/queries/clientpositive/perf/query5.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query5.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query5.tpl and seed 1819994127 +explain with ssr as (select s_store_id, sum(sales_price) as sales, http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query50.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query50.q b/ql/src/test/queries/clientpositive/perf/query50.q index 8a4cde2..0e2caf6 100644 --- a/ql/src/test/queries/clientpositive/perf/query50.q +++ b/ql/src/test/queries/clientpositive/perf/query50.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query50.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query50.tpl and seed 1819994127 +explain select s_store_name ,s_company_id http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query51.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query51.q b/ql/src/test/queries/clientpositive/perf/query51.q index 3389d31..9f90525 100644 --- a/ql/src/test/queries/clientpositive/perf/query51.q +++ b/ql/src/test/queries/clientpositive/perf/query51.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query51.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query51.tpl and seed 1819994127 +explain WITH web_v1 as ( select ws_item_sk item_sk, d_date, http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query52.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query52.q b/ql/src/test/queries/clientpositive/perf/query52.q index 80d43fb..1fee846 100644 --- a/ql/src/test/queries/clientpositive/perf/query52.q +++ b/ql/src/test/queries/clientpositive/perf/query52.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query52.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query52.tpl and seed 1819994127 +explain select dt.d_year ,item.i_brand_id brand_id ,item.i_brand brand http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query53.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query53.q b/ql/src/test/queries/clientpositive/perf/query53.q index cca02ca..0b81574 100644 --- a/ql/src/test/queries/clientpositive/perf/query53.q +++ b/ql/src/test/queries/clientpositive/perf/query53.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query53.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query53.tpl and seed 1819994127 +explain select * from (select i_manufact_id, sum(ss_sales_price) sum_sales, http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query54.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query54.q b/ql/src/test/queries/clientpositive/perf/query54.q index 0307d67..424f385 100644 --- a/ql/src/test/queries/clientpositive/perf/query54.q +++ b/ql/src/test/queries/clientpositive/perf/query54.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query54.tpl and seed 1930872976 -explain vectorization expression +-- start query 1 in stream 0 using template query54.tpl and seed 1930872976 +explain with my_customers as ( select distinct c_customer_sk , c_current_addr_sk http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query55.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query55.q b/ql/src/test/queries/clientpositive/perf/query55.q index 50e156c..f953f11 100644 --- a/ql/src/test/queries/clientpositive/perf/query55.q +++ b/ql/src/test/queries/clientpositive/perf/query55.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query55.tpl and seed 2031708268 -explain vectorization expression +-- start query 1 in stream 0 using template query55.tpl and seed 2031708268 +explain select i_brand_id brand_id, i_brand brand, sum(ss_ext_sales_price) ext_price from date_dim, store_sales, item http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query56.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query56.q b/ql/src/test/queries/clientpositive/perf/query56.q index 2edc02d..f3c8323 100644 --- a/ql/src/test/queries/clientpositive/perf/query56.q +++ b/ql/src/test/queries/clientpositive/perf/query56.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query56.tpl and seed 1951559352 -explain vectorization expression +-- start query 1 in stream 0 using template query56.tpl and seed 1951559352 +explain with ss as ( select i_item_id,sum(ss_ext_sales_price) total_sales from http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query57.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query57.q b/ql/src/test/queries/clientpositive/perf/query57.q index 12b0a04..4dc6e63 100644 --- a/ql/src/test/queries/clientpositive/perf/query57.q +++ b/ql/src/test/queries/clientpositive/perf/query57.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query57.tpl and seed 2031708268 -explain vectorization expression +-- start query 1 in stream 0 using template query57.tpl and seed 2031708268 +explain with v1 as( select i_category, i_brand, cc_name, http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query58.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query58.q b/ql/src/test/queries/clientpositive/perf/query58.q index 3d819d4..8d918ef 100644 --- a/ql/src/test/queries/clientpositive/perf/query58.q +++ b/ql/src/test/queries/clientpositive/perf/query58.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query58.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query58.tpl and seed 1819994127 +explain with ss_items as (select i_item_id item_id ,sum(ss_ext_sales_price) ss_item_rev http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query59.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query59.q b/ql/src/test/queries/clientpositive/perf/query59.q index 69bf2a5..0999653 100644 --- a/ql/src/test/queries/clientpositive/perf/query59.q +++ b/ql/src/test/queries/clientpositive/perf/query59.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query59.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query59.tpl and seed 1819994127 +explain with wss as (select d_week_seq, ss_store_sk, http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query6.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query6.q b/ql/src/test/queries/clientpositive/perf/query6.q index e34fc85..aabce52 100644 --- a/ql/src/test/queries/clientpositive/perf/query6.q +++ b/ql/src/test/queries/clientpositive/perf/query6.q @@ -1,11 +1,8 @@ set hive.auto.convert.join=true; set hive.tez.cartesian-product.enabled=true; set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query6.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query6.tpl and seed 1819994127 +explain select a.ca_state state, count(*) cnt from customer_address a ,customer c http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query60.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query60.q b/ql/src/test/queries/clientpositive/perf/query60.q index c2ced64..a5ab248 100644 --- a/ql/src/test/queries/clientpositive/perf/query60.q +++ b/ql/src/test/queries/clientpositive/perf/query60.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query60.tpl and seed 1930872976 -explain vectorization expression +-- start query 1 in stream 0 using template query60.tpl and seed 1930872976 +explain with ss as ( select i_item_id,sum(ss_ext_sales_price) total_sales http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query61.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query61.q b/ql/src/test/queries/clientpositive/perf/query61.q index 8ba4aec..edaf6f6 100644 --- a/ql/src/test/queries/clientpositive/perf/query61.q +++ b/ql/src/test/queries/clientpositive/perf/query61.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query61.tpl and seed 1930872976 -explain vectorization expression +-- start query 1 in stream 0 using template query61.tpl and seed 1930872976 +explain select promotions,total,cast(promotions as decimal(15,4))/cast(total as decimal(15,4))*100 from (select sum(ss_ext_sales_price) promotions http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query63.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query63.q b/ql/src/test/queries/clientpositive/perf/query63.q index de2c920..49e513c 100644 --- a/ql/src/test/queries/clientpositive/perf/query63.q +++ b/ql/src/test/queries/clientpositive/perf/query63.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query63.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query63.tpl and seed 1819994127 +explain select * from (select i_manager_id ,sum(ss_sales_price) sum_sales http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query64.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query64.q b/ql/src/test/queries/clientpositive/perf/query64.q index ae6264a..b069c2a 100644 --- a/ql/src/test/queries/clientpositive/perf/query64.q +++ b/ql/src/test/queries/clientpositive/perf/query64.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query64.tpl and seed 1220860970 -explain vectorization expression +-- start query 1 in stream 0 using template query64.tpl and seed 1220860970 +explain with cs_ui as (select cs_item_sk ,sum(cs_ext_list_price) as sale,sum(cr_refunded_cash+cr_reversed_charge+cr_store_credit) as refund http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query65.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query65.q b/ql/src/test/queries/clientpositive/perf/query65.q index 6c98b85..d5b53a2 100644 --- a/ql/src/test/queries/clientpositive/perf/query65.q +++ b/ql/src/test/queries/clientpositive/perf/query65.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query65.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query65.tpl and seed 1819994127 +explain select s_store_name, i_item_desc, http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query66.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query66.q b/ql/src/test/queries/clientpositive/perf/query66.q index a61f839..280bac8 100644 --- a/ql/src/test/queries/clientpositive/perf/query66.q +++ b/ql/src/test/queries/clientpositive/perf/query66.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query66.tpl and seed 2042478054 -explain vectorization expression +-- start query 1 in stream 0 using template query66.tpl and seed 2042478054 +explain select w_warehouse_name ,w_warehouse_sq_ft http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query67.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query67.q b/ql/src/test/queries/clientpositive/perf/query67.q index d17c9e7..c3ecf2a 100644 --- a/ql/src/test/queries/clientpositive/perf/query67.q +++ b/ql/src/test/queries/clientpositive/perf/query67.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query67.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query67.tpl and seed 1819994127 +explain select * from (select i_category ,i_class http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query68.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query68.q b/ql/src/test/queries/clientpositive/perf/query68.q index bd6bcb4..964dc8a 100644 --- a/ql/src/test/queries/clientpositive/perf/query68.q +++ b/ql/src/test/queries/clientpositive/perf/query68.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query68.tpl and seed 803547492 -explain vectorization expression +-- start query 1 in stream 0 using template query68.tpl and seed 803547492 +explain select c_last_name ,c_first_name ,ca_city http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query69.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query69.q b/ql/src/test/queries/clientpositive/perf/query69.q index 739fee9..ce2d19c 100644 --- a/ql/src/test/queries/clientpositive/perf/query69.q +++ b/ql/src/test/queries/clientpositive/perf/query69.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query69.tpl and seed 797269820 -explain vectorization expression +-- start query 1 in stream 0 using template query69.tpl and seed 797269820 +explain select cd_gender, cd_marital_status, http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query7.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query7.q b/ql/src/test/queries/clientpositive/perf/query7.q index 427c415..7bc1a00 100644 --- a/ql/src/test/queries/clientpositive/perf/query7.q +++ b/ql/src/test/queries/clientpositive/perf/query7.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query7.tpl and seed 1930872976 -explain vectorization expression +-- start query 1 in stream 0 using template query7.tpl and seed 1930872976 +explain select i_item_id, avg(ss_quantity) agg1, avg(ss_list_price) agg2, http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query70.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query70.q b/ql/src/test/queries/clientpositive/perf/query70.q index 153973d..7974976 100644 --- a/ql/src/test/queries/clientpositive/perf/query70.q +++ b/ql/src/test/queries/clientpositive/perf/query70.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query70.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query70.tpl and seed 1819994127 +explain select sum(ss_net_profit) as total_sum ,s_state http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query71.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query71.q b/ql/src/test/queries/clientpositive/perf/query71.q index 0c5afad..ea6548e 100644 --- a/ql/src/test/queries/clientpositive/perf/query71.q +++ b/ql/src/test/queries/clientpositive/perf/query71.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query71.tpl and seed 2031708268 -explain vectorization expression +-- start query 1 in stream 0 using template query71.tpl and seed 2031708268 +explain select i_brand_id brand_id, i_brand brand,t_hour,t_minute, sum(ext_price) ext_price from item, (select ws_ext_sales_price as ext_price, http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query72.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query72.q b/ql/src/test/queries/clientpositive/perf/query72.q index 8f69f01..20fbcb1 100644 --- a/ql/src/test/queries/clientpositive/perf/query72.q +++ b/ql/src/test/queries/clientpositive/perf/query72.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query72.tpl and seed 2031708268 -explain vectorization expression +-- start query 1 in stream 0 using template query72.tpl and seed 2031708268 +explain select i_item_desc ,w_warehouse_name ,d1.d_week_seq http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query73.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query73.q b/ql/src/test/queries/clientpositive/perf/query73.q index dbcf7fe..42ccaa1 100644 --- a/ql/src/test/queries/clientpositive/perf/query73.q +++ b/ql/src/test/queries/clientpositive/perf/query73.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query73.tpl and seed 1971067816 -explain vectorization expression +-- start query 1 in stream 0 using template query73.tpl and seed 1971067816 +explain select c_last_name ,c_first_name ,c_salutation http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query74.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query74.q b/ql/src/test/queries/clientpositive/perf/query74.q index 0b63984..b25db9c 100644 --- a/ql/src/test/queries/clientpositive/perf/query74.q +++ b/ql/src/test/queries/clientpositive/perf/query74.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query74.tpl and seed 1556717815 -explain vectorization expression +-- start query 1 in stream 0 using template query74.tpl and seed 1556717815 +explain with year_total as ( select c_customer_id customer_id ,c_first_name customer_first_name http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query75.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query75.q b/ql/src/test/queries/clientpositive/perf/query75.q index 798ecb3..ac1fc38 100644 --- a/ql/src/test/queries/clientpositive/perf/query75.q +++ b/ql/src/test/queries/clientpositive/perf/query75.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query75.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query75.tpl and seed 1819994127 +explain WITH all_sales AS ( SELECT d_year ,i_brand_id http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query76.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query76.q b/ql/src/test/queries/clientpositive/perf/query76.q index 63ced5e..ca943ce 100644 --- a/ql/src/test/queries/clientpositive/perf/query76.q +++ b/ql/src/test/queries/clientpositive/perf/query76.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query76.tpl and seed 2031708268 -explain vectorization expression +-- start query 1 in stream 0 using template query76.tpl and seed 2031708268 +explain select channel, col_name, d_year, d_qoy, i_category, COUNT(*) sales_cnt, SUM(ext_sales_price) sales_amt FROM ( SELECT 'store' as channel, 'ss_addr_sk' col_name, d_year, d_qoy, i_category, ss_ext_sales_price ext_sales_price FROM store_sales, item, date_dim http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query77.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query77.q b/ql/src/test/queries/clientpositive/perf/query77.q index 4a2a5f8..2857813 100644 --- a/ql/src/test/queries/clientpositive/perf/query77.q +++ b/ql/src/test/queries/clientpositive/perf/query77.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query77.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query77.tpl and seed 1819994127 +explain with ss as (select s_store_sk, sum(ss_ext_sales_price) as sales, http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query78.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query78.q b/ql/src/test/queries/clientpositive/perf/query78.q index cafd299..ca9e6d6 100644 --- a/ql/src/test/queries/clientpositive/perf/query78.q +++ b/ql/src/test/queries/clientpositive/perf/query78.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query78.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query78.tpl and seed 1819994127 +explain with ws as (select d_year AS ws_sold_year, ws_item_sk, ws_bill_customer_sk ws_customer_sk, http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query79.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query79.q b/ql/src/test/queries/clientpositive/perf/query79.q index 8cb2ae7..dfa7017 100644 --- a/ql/src/test/queries/clientpositive/perf/query79.q +++ b/ql/src/test/queries/clientpositive/perf/query79.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query79.tpl and seed 2031708268 -explain vectorization expression +-- start query 1 in stream 0 using template query79.tpl and seed 2031708268 +explain select c_last_name,c_first_name,substr(s_city,1,30),ss_ticket_number,amt,profit from http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query8.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query8.q b/ql/src/test/queries/clientpositive/perf/query8.q index 65b7d8d..cfce366 100644 --- a/ql/src/test/queries/clientpositive/perf/query8.q +++ b/ql/src/test/queries/clientpositive/perf/query8.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query8.tpl and seed 1766988859 -explain vectorization expression +-- start query 1 in stream 0 using template query8.tpl and seed 1766988859 +explain select s_store_name ,sum(ss_net_profit) from store_sales http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query80.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query80.q b/ql/src/test/queries/clientpositive/perf/query80.q index 200be64..651c5d7 100644 --- a/ql/src/test/queries/clientpositive/perf/query80.q +++ b/ql/src/test/queries/clientpositive/perf/query80.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query80.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query80.tpl and seed 1819994127 +explain with ssr as (select s_store_id as store_id, sum(ss_ext_sales_price) as sales, http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query81.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query81.q b/ql/src/test/queries/clientpositive/perf/query81.q index 31985db..fd072c3 100644 --- a/ql/src/test/queries/clientpositive/perf/query81.q +++ b/ql/src/test/queries/clientpositive/perf/query81.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query81.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query81.tpl and seed 1819994127 +explain with customer_total_return as (select cr_returning_customer_sk as ctr_customer_sk ,ca_state as ctr_state, http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query82.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query82.q b/ql/src/test/queries/clientpositive/perf/query82.q index fa299c0..9aec0cb 100644 --- a/ql/src/test/queries/clientpositive/perf/query82.q +++ b/ql/src/test/queries/clientpositive/perf/query82.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query82.tpl and seed 55585014 -explain vectorization expression +-- start query 1 in stream 0 using template query82.tpl and seed 55585014 +explain select i_item_id ,i_item_desc ,i_current_price http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query83.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query83.q b/ql/src/test/queries/clientpositive/perf/query83.q index 3825814..fd9184c 100644 --- a/ql/src/test/queries/clientpositive/perf/query83.q +++ b/ql/src/test/queries/clientpositive/perf/query83.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query83.tpl and seed 1930872976 -explain vectorization expression +-- start query 1 in stream 0 using template query83.tpl and seed 1930872976 +explain with sr_items as (select i_item_id item_id, sum(sr_return_quantity) sr_item_qty http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query84.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query84.q b/ql/src/test/queries/clientpositive/perf/query84.q index 58b302b..4ab5945 100644 --- a/ql/src/test/queries/clientpositive/perf/query84.q +++ b/ql/src/test/queries/clientpositive/perf/query84.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query84.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query84.tpl and seed 1819994127 +explain select c_customer_id as customer_id ,c_last_name || ', ' || c_first_name as customername from customer http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query85.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query85.q b/ql/src/test/queries/clientpositive/perf/query85.q index 11745b8..2e67e72 100644 --- a/ql/src/test/queries/clientpositive/perf/query85.q +++ b/ql/src/test/queries/clientpositive/perf/query85.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query85.tpl and seed 622697896 -explain vectorization expression +-- start query 1 in stream 0 using template query85.tpl and seed 622697896 +explain select substr(r_reason_desc,1,20) ,avg(ws_quantity) ,avg(wr_refunded_cash) http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query86.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query86.q b/ql/src/test/queries/clientpositive/perf/query86.q index 6b3ac9f..6670868 100644 --- a/ql/src/test/queries/clientpositive/perf/query86.q +++ b/ql/src/test/queries/clientpositive/perf/query86.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query86.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query86.tpl and seed 1819994127 +explain select sum(ws_net_paid) as total_sum ,i_category http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query87.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query87.q b/ql/src/test/queries/clientpositive/perf/query87.q index bbe5a86..e4562c2 100644 --- a/ql/src/test/queries/clientpositive/perf/query87.q +++ b/ql/src/test/queries/clientpositive/perf/query87.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query87.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query87.tpl and seed 1819994127 +explain select count(*) from ((select distinct c_last_name, c_first_name, d_date from store_sales, date_dim, customer http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query88.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query88.q b/ql/src/test/queries/clientpositive/perf/query88.q index 76d4b2a..265cc7c 100644 --- a/ql/src/test/queries/clientpositive/perf/query88.q +++ b/ql/src/test/queries/clientpositive/perf/query88.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query88.tpl and seed 318176889 -explain vectorization expression +-- start query 1 in stream 0 using template query88.tpl and seed 318176889 +explain select * from (select count(*) h8_30_to_9 http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query89.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query89.q b/ql/src/test/queries/clientpositive/perf/query89.q index f32faf2..3159229 100644 --- a/ql/src/test/queries/clientpositive/perf/query89.q +++ b/ql/src/test/queries/clientpositive/perf/query89.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query89.tpl and seed 1719819282 -explain vectorization expression +-- start query 1 in stream 0 using template query89.tpl and seed 1719819282 +explain select * from( select i_category, i_class, i_brand, http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query9.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query9.q b/ql/src/test/queries/clientpositive/perf/query9.q index aaaac7d..421f5e1 100644 --- a/ql/src/test/queries/clientpositive/perf/query9.q +++ b/ql/src/test/queries/clientpositive/perf/query9.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query9.tpl and seed 1490436826 -explain vectorization expression +-- start query 1 in stream 0 using template query9.tpl and seed 1490436826 +explain select case when (select count(*) from store_sales where ss_quantity between 1 and 20) > 409437 http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query90.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query90.q b/ql/src/test/queries/clientpositive/perf/query90.q index ad98005..d17cbc4 100644 --- a/ql/src/test/queries/clientpositive/perf/query90.q +++ b/ql/src/test/queries/clientpositive/perf/query90.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query90.tpl and seed 2031708268 -explain vectorization expression +-- start query 1 in stream 0 using template query90.tpl and seed 2031708268 +explain select cast(amc as decimal(15,4))/cast(pmc as decimal(15,4)) am_pm_ratio from ( select count(*) amc from web_sales, household_demographics , time_dim, web_page http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query91.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query91.q b/ql/src/test/queries/clientpositive/perf/query91.q index 03d5e56..79ca713 100644 --- a/ql/src/test/queries/clientpositive/perf/query91.q +++ b/ql/src/test/queries/clientpositive/perf/query91.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query91.tpl and seed 1930872976 -explain vectorization expression +-- start query 1 in stream 0 using template query91.tpl and seed 1930872976 +explain select cc_call_center_id Call_Center, cc_name Call_Center_Name, http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query92.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query92.q b/ql/src/test/queries/clientpositive/perf/query92.q index 5f2c7af..f26fa5e 100644 --- a/ql/src/test/queries/clientpositive/perf/query92.q +++ b/ql/src/test/queries/clientpositive/perf/query92.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query92.tpl and seed 2031708268 -explain vectorization expression +-- start query 1 in stream 0 using template query92.tpl and seed 2031708268 +explain select sum(ws_ext_discount_amt) as `Excess Discount Amount` from http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query93.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query93.q b/ql/src/test/queries/clientpositive/perf/query93.q index ec26a23..7f4a093 100644 --- a/ql/src/test/queries/clientpositive/perf/query93.q +++ b/ql/src/test/queries/clientpositive/perf/query93.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query93.tpl and seed 1200409435 -explain vectorization expression +-- start query 1 in stream 0 using template query93.tpl and seed 1200409435 +explain select ss_customer_sk ,sum(act_sales) sumsales from (select ss_item_sk http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query94.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query94.q b/ql/src/test/queries/clientpositive/perf/query94.q index 5fb6a23..18253fa 100644 --- a/ql/src/test/queries/clientpositive/perf/query94.q +++ b/ql/src/test/queries/clientpositive/perf/query94.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query94.tpl and seed 2031708268 -explain vectorization expression +-- start query 1 in stream 0 using template query94.tpl and seed 2031708268 +explain select count(distinct ws_order_number) as `order count` ,sum(ws_ext_ship_cost) as `total shipping cost` http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query95.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query95.q b/ql/src/test/queries/clientpositive/perf/query95.q index b84f4ec..e9024a8 100644 --- a/ql/src/test/queries/clientpositive/perf/query95.q +++ b/ql/src/test/queries/clientpositive/perf/query95.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query95.tpl and seed 2031708268 -explain vectorization expression +-- start query 1 in stream 0 using template query95.tpl and seed 2031708268 +explain with ws_wh as (select ws1.ws_order_number,ws1.ws_warehouse_sk wh1,ws2.ws_warehouse_sk wh2 from web_sales ws1,web_sales ws2 http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query96.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query96.q b/ql/src/test/queries/clientpositive/perf/query96.q index 48dc765..a306d6c 100644 --- a/ql/src/test/queries/clientpositive/perf/query96.q +++ b/ql/src/test/queries/clientpositive/perf/query96.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query96.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query96.tpl and seed 1819994127 +explain select count(*) from store_sales ,household_demographics http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query97.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query97.q b/ql/src/test/queries/clientpositive/perf/query97.q index fe89473..7203e52 100644 --- a/ql/src/test/queries/clientpositive/perf/query97.q +++ b/ql/src/test/queries/clientpositive/perf/query97.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query97.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query97.tpl and seed 1819994127 +explain with ssci as ( select ss_customer_sk customer_sk ,ss_item_sk item_sk http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query98.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query98.q b/ql/src/test/queries/clientpositive/perf/query98.q index 437286e..6168f2a 100644 --- a/ql/src/test/queries/clientpositive/perf/query98.q +++ b/ql/src/test/queries/clientpositive/perf/query98.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query98.tpl and seed 345591136 -explain vectorization expression +-- start query 1 in stream 0 using template query98.tpl and seed 345591136 +explain select i_item_desc ,i_category ,i_class http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/perf/query99.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/perf/query99.q b/ql/src/test/queries/clientpositive/perf/query99.q index 31bdb52..83be1d0 100644 --- a/ql/src/test/queries/clientpositive/perf/query99.q +++ b/ql/src/test/queries/clientpositive/perf/query99.q @@ -1,9 +1,6 @@ set hive.mapred.mode=nonstrict; -set hive.explain.user=false; -set hive.auto.convert.join=true; -set hive.fetch.task.conversion=none; --- start query 1 in stream 0 using template query99.tpl and seed 1819994127 -explain vectorization expression +-- start query 1 in stream 0 using template query99.tpl and seed 1819994127 +explain select substr(w_warehouse_name,1,20) ,sm_type http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/queries/clientpositive/query_result_fileformat.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/query_result_fileformat.q b/ql/src/test/queries/clientpositive/query_result_fileformat.q index a32f25f..a4c63e1 100644 --- a/ql/src/test/queries/clientpositive/query_result_fileformat.q +++ b/ql/src/test/queries/clientpositive/query_result_fileformat.q @@ -7,7 +7,7 @@ http://asdf' value from src limit 1; select * from nzhang_test1; select count(*) from nzhang_test1; -explain vectorization detail +explain select * from nzhang_test1 where key='key1'; select * from nzhang_test1 where key='key1'; @@ -18,7 +18,7 @@ select * from nzhang_test1; select count(*) from nzhang_test1; -explain vectorization detail +explain select * from nzhang_test1 where key='key1'; select * from nzhang_test1 where key='key1'; http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/results/clientpositive/llap/convert_decimal64_to_decimal.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/convert_decimal64_to_decimal.q.out b/ql/src/test/results/clientpositive/llap/convert_decimal64_to_decimal.q.out index 5a764cd..fddd2cb 100644 --- a/ql/src/test/results/clientpositive/llap/convert_decimal64_to_decimal.q.out +++ b/ql/src/test/results/clientpositive/llap/convert_decimal64_to_decimal.q.out @@ -181,7 +181,7 @@ STAGE PLANS: 0 _col0 (type: decimal(9,2)) 1 _col1 (type: decimal(9,2)) Map Join Vectorization: - bigTableKeyExpressions: ConvertDecimal64ToDecimal(col 3:decimal(9,2)/DECIMAL_64) -> 21:decimal(9,2) + bigTableKeyExpressions: ConvertDecimal64ToDecimal(col 3:decimal(9,2)/DECIMAL_64) -> 20:decimal(9,2) className: VectorMapJoinOperator native: false nativeConditionsMet: hive.mapjoin.optimized.hashtable IS true, hive.vectorized.execution.mapjoin.native.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true, One MapJoin Condition IS true, No nullsafe IS true, Small table vectorizes IS true @@ -229,7 +229,7 @@ STAGE PLANS: includeColumns: [3] dataColumns: float_col_1:float, varchar0037_col_2:varchar(37), decimal2912_col_3:decimal(29,12), decimal0801_col_4:decimal(8,1)/DECIMAL_64, timestamp_col_5:timestamp, boolean_col_6:boolean, string_col_7:string, tinyint_col_8:tinyint, boolean_col_9:boolean, decimal1614_col_10:decimal(16,14)/DECIMAL_64, boolean_col_11:boolean, float_col_12:float, char0116_col_13:char(116), boolean_col_14:boolean, string_col_15:string, double_col_16:double, string_col_17:string, bigint_col_18:bigint, int_col_19:int partitionColumnCount: 0 - scratchColumnTypeNames: [bigint, decimal(9,2)] + scratchColumnTypeNames: [decimal(9,2), bigint] Map 3 Map Operator Tree: TableScan http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/results/clientpositive/llap/vector_binary_join_groupby.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_binary_join_groupby.q.out b/ql/src/test/results/clientpositive/llap/vector_binary_join_groupby.q.out index 17a1e1e..6c461f0 100644 --- a/ql/src/test/results/clientpositive/llap/vector_binary_join_groupby.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_binary_join_groupby.q.out @@ -153,6 +153,7 @@ STAGE PLANS: 0 _col10 (type: binary) 1 _col10 (type: binary) Map Join Vectorization: + bigTableValueExpressions: ConvertDecimal64ToDecimal(col 9:decimal(4,2)/DECIMAL_64) -> 12:decimal(4,2) className: VectorMapJoinInnerStringOperator native: true nativeConditionsMet: hive.mapjoin.optimized.hashtable IS true, hive.vectorized.execution.mapjoin.native.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true, One MapJoin Condition IS true, No nullsafe IS true, Small table vectorizes IS true, Optimized Table and Supports Key Types IS true @@ -166,13 +167,13 @@ STAGE PLANS: Select Vectorization: className: VectorSelectOperator native: true - projectedOutputColumnNums: [22] - selectExpressions: VectorUDFAdaptor(hash(_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13,_col14,_col15,_col16,_col17,_col18,_col19,_col20,_col21)) -> 22:int + projectedOutputColumnNums: [23] + selectExpressions: VectorUDFAdaptor(hash(_col0,_col1,_col2,_col3,_col4,_col5,_col6,_col7,_col8,_col9,_col10,_col11,_col12,_col13,_col14,_col15,_col16,_col17,_col18,_col19,_col20,_col21)) -> 23:int Statistics: Num rows: 10000 Data size: 6819968 Basic stats: COMPLETE Column stats: COMPLETE Group By Operator aggregations: sum(_col0) Group By Vectorization: - aggregators: VectorUDAFSumLong(col 22:int) -> bigint + aggregators: VectorUDAFSumLong(col 23:int) -> bigint className: VectorGroupByOperator groupByMode: HASH native: false http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/results/clientpositive/llap/vector_case_when_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_case_when_1.q.out b/ql/src/test/results/clientpositive/llap/vector_case_when_1.q.out index 411d693..3ab6547 100644 --- a/ql/src/test/results/clientpositive/llap/vector_case_when_1.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_case_when_1.q.out @@ -524,7 +524,7 @@ STAGE PLANS: className: VectorSelectOperator native: true projectedOutputColumnNums: [4, 22, 24, 25, 26, 27, 28, 30, 31, 32, 33, 34, 36, 40, 42, 45, 46] - selectExpressions: IfExprStringScalarStringGroupColumn(col 17:boolean, val Singlecol 21:string)(children: LongColEqualLongScalar(col 4:int, val 1) -> 17:boolean, IfExprStringScalarStringGroupColumn(col 18:boolean, val Twocol 22:string)(children: LongColEqualLongScalar(col 4:int, val 2) -> 18:boolean, IfExprStringScalarStringGroupColumn(col 19:boolean, val Somecol 21:string)(children: LongColLessLongScalar(col 4:int, val 10) -> 19:boolean, IfExprStringScalarStringScalar(col 20:boolean, val Many, val Huge number)(children: LongColLessLongScalar(col 4:int, val 100) -> 20:boolean) -> 21:string) -> 22:string) -> 21:string) -> 22:string, IfExprStringScalarStringGroupColumn(col 17:boolean, val Singlecol 23:string)(children: LongColEqualLongScalar(col 4:int, val 1) -> 17:boolean, IfExprStringScalarStringGroupColumn(col 18:boolean, val Twocol 24:string)(children: LongColEqualLongScalar(col 4:int, val 2) -> 18:boolean, IfExprStringScalarStringGroupColumn(col 19:boolean , val Somecol 23:string)(children: LongColLessLongScalar(col 4:int, val 10) -> 19:boolean, IfExprColumnNull(col 20:boolean, col 21:string, null)(children: LongColLessLongScalar(col 4:int, val 100) -> 20:boolean, ConstantVectorExpression(val Many) -> 21:string) -> 23:string) -> 24:string) -> 23:string) -> 24:string, IfExprStringScalarStringGroupColumn(col 17:boolean, val Singlecol 23:string)(children: LongColEqualLongScalar(col 4:int, val 1) -> 17:boolean, IfExprStringScalarStringGroupColumn(col 18:boolean, val Twocol 25:string)(children: LongColEqualLongScalar(col 4:int, val 2) -> 18:boolean, IfExprStringScalarStringGroupColumn(col 19:boolean, val Somecol 23:string)(children: LongColLessLongScalar(col 4:int, val 10) -> 19:boolean, IfExprNullNull(null, null) -> 23:string) -> 25:string) -> 23:string) -> 25:string, IfExprLongColumnLongColumn(col 17:boolean, col 18:date, col 19:date)(children: StringGroupColEqualCharScalar(col 14:char(10), val SHIP) -> 17:boolean, VectorUDFDateAddColSca lar(col 10:date, val 10) -> 18:date, VectorUDFDateAddColScalar(col 10:date, val 5) -> 19:date) -> 26:date, IfExprDoubleColumnLongScalar(col 17:boolean, col 28:double, val 0)(children: StringGroupColEqualCharScalar(col 8:char(1), val N) -> 17:boolean, DoubleColMultiplyDoubleColumn(col 5:double, col 27:double)(children: DoubleScalarSubtractDoubleColumn(val 1.0, col 6:double) -> 27:double) -> 28:double) -> 27:double, IfExprDoubleColumnDoubleScalar(col 17:boolean, col 29:double, val 0.0)(children: StringGroupColEqualCharScalar(col 8:char(1), val N) -> 17:boolean, DoubleColMultiplyDoubleColumn(col 5:double, col 28:double)(children: DoubleScalarSubtractDoubleColumn(val 1.0, col 6:double) -> 28:double) -> 29:double) -> 28:double, IfExprNullColumn(col 17:boolean, null, col 48)(children: StringGroupColEqualStringScalar(col 13:string, val DELIVER IN PERSON)(children: col 13:varchar(20)) -> 17:boolean, ConvertDecimal64ToDecimal(col 7:decimal(10,2)/DECIMAL_64) -> 48:decimal(10,2)) -> 30:decimal (10,2), IfExprColumnNull(col 18:boolean, col 49:decimal(10,2), null)(children: StringGroupColEqualStringScalar(col 13:string, val TAKE BACK RETURN)(children: col 13:varchar(20)) -> 18:boolean, ConvertDecimal64ToDecimal(col 7:decimal(10,2)/DECIMAL_64) -> 49:decimal(10,2)) -> 31:decimal(10,2), VectorUDFAdaptor(if((CAST( l_shipinstruct AS STRING) = 'DELIVER IN PERSON'), 0, l_tax))(children: StringGroupColEqualStringScalar(col 13:string, val DELIVER IN PERSON)(children: col 13:varchar(20)) -> 19:boolean) -> 32:decimal(12,2), VectorUDFAdaptor(if((CAST( l_shipinstruct AS STRING) = 'TAKE BACK RETURN'), l_tax, 0))(children: StringGroupColEqualStringScalar(col 13:string, val TAKE BACK RETURN)(children: col 13:varchar(20)) -> 19:boolean) -> 33:decimal(12,2), IfExprDecimal64ScalarDecimal64Column(col 19:boolean, decimal64Val 0, decimalVal 0, col 7:decimal(1,0)/DECIMAL_64)(children: StringGroupColEqualStringScalar(col 13:string, val DELIVER IN PERSON)(children: col 13:varchar(20)) -> 19:boolean) -> 34:decimal(10,2)/DECIMAL_64, IfExprDecimal64ColumnDecimal64Scalar(col 35:boolean, col 7:decimal(10,2)/DECIMAL_64, decimal64Val 0, decimalVal 0)(children: StringGroupColEqualStringScalar(col 13:string, val TAKE BACK RETURN)(children: col 13:varchar(20)) -> 35:boolean) -> 36:decimal(10,2)/DECIMAL_64, IfExprTimestampColumnColumn(col 37:boolean, col 38:timestampcol 39:timestamp)(children: LongColGreaterLongScalar(col 1:int, val 30) -> 37:boolean, CastDateToTimestamp(col 12:date) -> 38:timestamp, CastDateToTimestamp(col 11:date) -> 39:timestamp) -> 40:timestamp, IfExprColumnNull(col 37:boolean, col 41:int, null)(children: LongColGreaterLongScalar(col 2:int, val 10000) -> 37:boolean, VectorUDFDateDiffColCol(col 12:date, col 11:date) -> 41:int) -> 42:int, IfExprNullColumn(col 43:boolean, null, col 44)(children: LongColGreaterLongScalar(col 2:int, val 10000) -> 43:boolean, VectorUDFDateDiffColCol(col 12:date, col 11:date) -> 44:int) -> 45:int, IfExprLongScalarLongScalar(col 47:boolean, val 14245, val 14609)(children: LongColGreaterLongScalar(col 46:int, val 100)(children: LongColModuloLongScalar(col 2:int, val 500) -> 46:int) -> 47:boolean) -> 46:date + selectExpressions: IfExprStringScalarStringGroupColumn(col 17:boolean, val Singlecol 21:string)(children: LongColEqualLongScalar(col 4:int, val 1) -> 17:boolean, IfExprStringScalarStringGroupColumn(col 18:boolean, val Twocol 22:string)(children: LongColEqualLongScalar(col 4:int, val 2) -> 18:boolean, IfExprStringScalarStringGroupColumn(col 19:boolean, val Somecol 21:string)(children: LongColLessLongScalar(col 4:int, val 10) -> 19:boolean, IfExprStringScalarStringScalar(col 20:boolean, val Many, val Huge number)(children: LongColLessLongScalar(col 4:int, val 100) -> 20:boolean) -> 21:string) -> 22:string) -> 21:string) -> 22:string, IfExprStringScalarStringGroupColumn(col 17:boolean, val Singlecol 23:string)(children: LongColEqualLongScalar(col 4:int, val 1) -> 17:boolean, IfExprStringScalarStringGroupColumn(col 18:boolean, val Twocol 24:string)(children: LongColEqualLongScalar(col 4:int, val 2) -> 18:boolean, IfExprStringScalarStringGroupColumn(col 19:boolean , val Somecol 23:string)(children: LongColLessLongScalar(col 4:int, val 10) -> 19:boolean, IfExprColumnNull(col 20:boolean, col 21:string, null)(children: LongColLessLongScalar(col 4:int, val 100) -> 20:boolean, ConstantVectorExpression(val Many) -> 21:string) -> 23:string) -> 24:string) -> 23:string) -> 24:string, IfExprStringScalarStringGroupColumn(col 17:boolean, val Singlecol 23:string)(children: LongColEqualLongScalar(col 4:int, val 1) -> 17:boolean, IfExprStringScalarStringGroupColumn(col 18:boolean, val Twocol 25:string)(children: LongColEqualLongScalar(col 4:int, val 2) -> 18:boolean, IfExprStringScalarStringGroupColumn(col 19:boolean, val Somecol 23:string)(children: LongColLessLongScalar(col 4:int, val 10) -> 19:boolean, IfExprNullNull(null, null) -> 23:string) -> 25:string) -> 23:string) -> 25:string, IfExprLongColumnLongColumn(col 17:boolean, col 18:date, col 19:date)(children: StringGroupColEqualCharScalar(col 14:char(10), val SHIP) -> 17:boolean, VectorUDFDateAddColSca lar(col 10:date, val 10) -> 18:date, VectorUDFDateAddColScalar(col 10:date, val 5) -> 19:date) -> 26:date, IfExprDoubleColumnLongScalar(col 17:boolean, col 28:double, val 0)(children: StringGroupColEqualCharScalar(col 8:char(1), val N) -> 17:boolean, DoubleColMultiplyDoubleColumn(col 5:double, col 27:double)(children: DoubleScalarSubtractDoubleColumn(val 1.0, col 6:double) -> 27:double) -> 28:double) -> 27:double, IfExprDoubleColumnDoubleScalar(col 17:boolean, col 29:double, val 0.0)(children: StringGroupColEqualCharScalar(col 8:char(1), val N) -> 17:boolean, DoubleColMultiplyDoubleColumn(col 5:double, col 28:double)(children: DoubleScalarSubtractDoubleColumn(val 1.0, col 6:double) -> 28:double) -> 29:double) -> 28:double, IfExprNullColumn(col 17:boolean, null, col 48)(children: StringGroupColEqualStringScalar(col 23:string, val DELIVER IN PERSON)(children: CastStringGroupToString(col 13:varchar(20)) -> 23:string) -> 17:boolean, ConvertDecimal64ToDecimal(col 7:decimal(10,2)/DECIMAL_ 64) -> 48:decimal(10,2)) -> 30:decimal(10,2), IfExprColumnNull(col 18:boolean, col 49:decimal(10,2), null)(children: StringGroupColEqualStringScalar(col 23:string, val TAKE BACK RETURN)(children: CastStringGroupToString(col 13:varchar(20)) -> 23:string) -> 18:boolean, ConvertDecimal64ToDecimal(col 7:decimal(10,2)/DECIMAL_64) -> 49:decimal(10,2)) -> 31:decimal(10,2), VectorUDFAdaptor(if((CAST( l_shipinstruct AS STRING) = 'DELIVER IN PERSON'), 0, l_tax))(children: StringGroupColEqualStringScalar(col 23:string, val DELIVER IN PERSON)(children: CastStringGroupToString(col 13:varchar(20)) -> 23:string) -> 19:boolean) -> 32:decimal(12,2), VectorUDFAdaptor(if((CAST( l_shipinstruct AS STRING) = 'TAKE BACK RETURN'), l_tax, 0))(children: StringGroupColEqualStringScalar(col 23:string, val TAKE BACK RETURN)(children: CastStringGroupToString(col 13:varchar(20)) -> 23:string) -> 19:boolean) -> 33:decimal(12,2), IfExprDecimal64ScalarDecimal64Column(col 19:boolean, decimal64Val 0, decimalVal 0, col 7:decimal(1,0)/DECIMAL_64)(children: StringGroupColEqualStringScalar(col 23:string, val DELIVER IN PERSON)(children: CastStringGroupToString(col 13:varchar(20)) -> 23:string) -> 19:boolean) -> 34:decimal(10,2)/DECIMAL_64, IfExprDecimal64ColumnDecimal64Scalar(col 35:boolean, col 7:decimal(10,2)/DECIMAL_64, decimal64Val 0, decimalVal 0)(children: StringGroupColEqualStringScalar(col 23:string, val TAKE BACK RETURN)(children: CastStringGroupToString(col 13:varchar(20)) -> 23:string) -> 35:boolean) -> 36:decimal(10,2)/DECIMAL_64, IfExprTimestampColumnColumn(col 37:boolean, col 38:timestampcol 39:timestamp)(children: LongColGreaterLongScalar(col 1:int, val 30) -> 37:boolean, CastDateToTimestamp(col 12:date) -> 38:timestamp, CastDateToTimestamp(col 11:date) -> 39:timestamp) -> 40:timestamp, IfExprColumnNull(col 37:boolean, col 41:int, null)(children: LongColGreaterLongScalar(col 2:int, val 10000) -> 37:boolean, VectorUDFDateDiffColCol(col 12:date, col 11:date) -> 41:int) -> 42:int, IfExpr NullColumn(col 43:boolean, null, col 44)(children: LongColGreaterLongScalar(col 2:int, val 10000) -> 43:boolean, VectorUDFDateDiffColCol(col 12:date, col 11:date) -> 44:int) -> 45:int, IfExprLongScalarLongScalar(col 47:boolean, val 14245, val 14609)(children: LongColGreaterLongScalar(col 46:int, val 100)(children: LongColModuloLongScalar(col 2:int, val 500) -> 46:int) -> 47:boolean) -> 46:date Statistics: Num rows: 101 Data size: 57327 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false @@ -856,8 +856,8 @@ STAGE PLANS: Select Vectorization: className: VectorSelectOperator native: true - projectedOutputColumnNums: [4, 27, 38, 48, 52, 54, 60, 62, 64, 66, 67, 68, 70, 74, 77, 80, 81] - selectExpressions: IfExprColumnCondExpr(col 17:boolean, col 18:stringcol 26:string)(children: LongColEqualLongScalar(col 4:int, val 1) -> 17:boolean, ConstantVectorExpression(val Single) -> 18:string, IfExprColumnCondExpr(col 19:boolean, col 20:stringcol 25:string)(children: LongColEqualLongScalar(col 4:int, val 2) -> 19:boolean, ConstantVectorExpression(val Two) -> 20:string, IfExprColumnCondExpr(col 21:boolean, col 22:stringcol 24:string)(children: LongColLessLongScalar(col 4:int, val 10) -> 21:boolean, ConstantVectorExpression(val Some) -> 22:string, IfExprStringScalarStringScalar(col 23:boolean, val Many, val Huge number)(children: LongColLessLongScalar(col 4:int, val 100) -> 23:boolean) -> 24:string) -> 25:string) -> 26:string) -> 27:string, IfExprColumnCondExpr(col 23:boolean, col 28:stringcol 37:string)(children: LongColEqualLongScalar(col 4:int, val 1) -> 23:boolean, ConstantVectorExpression(val Single) -> 28:string, IfExprColumnCondExpr(col 29:boolea n, col 30:stringcol 36:string)(children: LongColEqualLongScalar(col 4:int, val 2) -> 29:boolean, ConstantVectorExpression(val Two) -> 30:string, IfExprColumnCondExpr(col 31:boolean, col 32:stringcol 35:string)(children: LongColLessLongScalar(col 4:int, val 10) -> 31:boolean, ConstantVectorExpression(val Some) -> 32:string, IfExprColumnNull(col 33:boolean, col 34:string, null)(children: LongColLessLongScalar(col 4:int, val 100) -> 33:boolean, ConstantVectorExpression(val Many) -> 34:string) -> 35:string) -> 36:string) -> 37:string) -> 38:string, IfExprColumnCondExpr(col 39:boolean, col 40:stringcol 47:string)(children: LongColEqualLongScalar(col 4:int, val 1) -> 39:boolean, ConstantVectorExpression(val Single) -> 40:string, IfExprColumnCondExpr(col 41:boolean, col 42:stringcol 46:string)(children: LongColEqualLongScalar(col 4:int, val 2) -> 41:boolean, ConstantVectorExpression(val Two) -> 42:string, IfExprColumnCondExpr(col 43:boolean, col 44:stringcol 45:string)(children: LongColLes sLongScalar(col 4:int, val 10) -> 43:boolean, ConstantVectorExpression(val Some) -> 44:string, IfExprNullNull(null, null) -> 45:string) -> 46:string) -> 47:string) -> 48:string, IfExprCondExprCondExpr(col 49:boolean, col 50:datecol 51:date)(children: StringGroupColEqualCharScalar(col 14:char(10), val SHIP) -> 49:boolean, VectorUDFDateAddColScalar(col 10:date, val 10) -> 50:date, VectorUDFDateAddColScalar(col 10:date, val 5) -> 51:date) -> 52:date, IfExprDoubleColumnLongScalar(col 57:boolean, col 58:double, val 0)(children: StringGroupColEqualCharScalar(col 8:char(1), val N) -> 57:boolean, DoubleColMultiplyDoubleColumn(col 5:double, col 54:double)(children: DoubleScalarSubtractDoubleColumn(val 1.0, col 6:double) -> 54:double) -> 58:double) -> 54:double, IfExprCondExprColumn(col 57:boolean, col 59:double, col 58:double)(children: StringGroupColEqualCharScalar(col 8:char(1), val N) -> 57:boolean, DoubleColMultiplyDoubleColumn(col 5:double, col 58:double)(children: DoubleScalarSubtractD oubleColumn(val 1.0, col 6:double) -> 58:double) -> 59:double, ConstantVectorExpression(val 0.0) -> 58:double) -> 60:double, IfExprNullColumn(col 61:boolean, null, col 83)(children: StringGroupColEqualStringScalar(col 13:string, val DELIVER IN PERSON)(children: col 13:varchar(20)) -> 61:boolean, ConvertDecimal64ToDecimal(col 7:decimal(10,2)/DECIMAL_64) -> 83:decimal(10,2)) -> 62:decimal(10,2), IfExprColumnNull(col 63:boolean, col 84:decimal(10,2), null)(children: StringGroupColEqualStringScalar(col 13:string, val TAKE BACK RETURN)(children: col 13:varchar(20)) -> 63:boolean, ConvertDecimal64ToDecimal(col 7:decimal(10,2)/DECIMAL_64) -> 84:decimal(10,2)) -> 64:decimal(10,2), VectorUDFAdaptor(if((CAST( l_shipinstruct AS STRING) = 'DELIVER IN PERSON'), 0, l_tax))(children: StringGroupColEqualStringScalar(col 13:string, val DELIVER IN PERSON)(children: col 13:varchar(20)) -> 65:boolean) -> 66:decimal(12,2), VectorUDFAdaptor(if((CAST( l_shipinstruct AS STRING) = 'TAKE BACK RETURN'), l_tax , 0))(children: StringGroupColEqualStringScalar(col 13:string, val TAKE BACK RETURN)(children: col 13:varchar(20)) -> 65:boolean) -> 67:decimal(12,2), IfExprDecimal64ScalarDecimal64Column(col 65:boolean, decimal64Val 0, decimalVal 0, col 7:decimal(1,0)/DECIMAL_64)(children: StringGroupColEqualStringScalar(col 13:string, val DELIVER IN PERSON)(children: col 13:varchar(20)) -> 65:boolean) -> 68:decimal(10,2)/DECIMAL_64, IfExprDecimal64ColumnDecimal64Scalar(col 69:boolean, col 7:decimal(10,2)/DECIMAL_64, decimal64Val 0, decimalVal 0)(children: StringGroupColEqualStringScalar(col 13:string, val TAKE BACK RETURN)(children: col 13:varchar(20)) -> 69:boolean) -> 70:decimal(10,2)/DECIMAL_64, IfExprCondExprCondExpr(col 71:boolean, col 72:timestampcol 73:timestamp)(children: LongColGreaterLongScalar(col 1:int, val 30) -> 71:boolean, CastDateToTimestamp(col 12:date) -> 72:timestamp, CastDateToTimestamp(col 11:date) -> 73:timestamp) -> 74:timestamp, IfExprCondExprNull(col 75:boolean, col 76:int , null)(children: LongColGreaterLongScalar(col 2:int, val 10000) -> 75:boolean, VectorUDFDateDiffColCol(col 12:date, col 11:date) -> 76:int) -> 77:int, IfExprNullCondExpr(col 78:boolean, null, col 79:int)(children: LongColGreaterLongScalar(col 2:int, val 10000) -> 78:boolean, VectorUDFDateDiffColCol(col 12:date, col 11:date) -> 79:int) -> 80:int, IfExprLongScalarLongScalar(col 82:boolean, val 14245, val 14609)(children: LongColGreaterLongScalar(col 81:int, val 100)(children: LongColModuloLongScalar(col 2:int, val 500) -> 81:int) -> 82:boolean) -> 81:date + projectedOutputColumnNums: [4, 27, 38, 48, 52, 54, 60, 63, 65, 67, 68, 69, 71, 75, 78, 81, 82] + selectExpressions: IfExprColumnCondExpr(col 17:boolean, col 18:stringcol 26:string)(children: LongColEqualLongScalar(col 4:int, val 1) -> 17:boolean, ConstantVectorExpression(val Single) -> 18:string, IfExprColumnCondExpr(col 19:boolean, col 20:stringcol 25:string)(children: LongColEqualLongScalar(col 4:int, val 2) -> 19:boolean, ConstantVectorExpression(val Two) -> 20:string, IfExprColumnCondExpr(col 21:boolean, col 22:stringcol 24:string)(children: LongColLessLongScalar(col 4:int, val 10) -> 21:boolean, ConstantVectorExpression(val Some) -> 22:string, IfExprStringScalarStringScalar(col 23:boolean, val Many, val Huge number)(children: LongColLessLongScalar(col 4:int, val 100) -> 23:boolean) -> 24:string) -> 25:string) -> 26:string) -> 27:string, IfExprColumnCondExpr(col 23:boolean, col 28:stringcol 37:string)(children: LongColEqualLongScalar(col 4:int, val 1) -> 23:boolean, ConstantVectorExpression(val Single) -> 28:string, IfExprColumnCondExpr(col 29:boolea n, col 30:stringcol 36:string)(children: LongColEqualLongScalar(col 4:int, val 2) -> 29:boolean, ConstantVectorExpression(val Two) -> 30:string, IfExprColumnCondExpr(col 31:boolean, col 32:stringcol 35:string)(children: LongColLessLongScalar(col 4:int, val 10) -> 31:boolean, ConstantVectorExpression(val Some) -> 32:string, IfExprColumnNull(col 33:boolean, col 34:string, null)(children: LongColLessLongScalar(col 4:int, val 100) -> 33:boolean, ConstantVectorExpression(val Many) -> 34:string) -> 35:string) -> 36:string) -> 37:string) -> 38:string, IfExprColumnCondExpr(col 39:boolean, col 40:stringcol 47:string)(children: LongColEqualLongScalar(col 4:int, val 1) -> 39:boolean, ConstantVectorExpression(val Single) -> 40:string, IfExprColumnCondExpr(col 41:boolean, col 42:stringcol 46:string)(children: LongColEqualLongScalar(col 4:int, val 2) -> 41:boolean, ConstantVectorExpression(val Two) -> 42:string, IfExprColumnCondExpr(col 43:boolean, col 44:stringcol 45:string)(children: LongColLes sLongScalar(col 4:int, val 10) -> 43:boolean, ConstantVectorExpression(val Some) -> 44:string, IfExprNullNull(null, null) -> 45:string) -> 46:string) -> 47:string) -> 48:string, IfExprCondExprCondExpr(col 49:boolean, col 50:datecol 51:date)(children: StringGroupColEqualCharScalar(col 14:char(10), val SHIP) -> 49:boolean, VectorUDFDateAddColScalar(col 10:date, val 10) -> 50:date, VectorUDFDateAddColScalar(col 10:date, val 5) -> 51:date) -> 52:date, IfExprDoubleColumnLongScalar(col 57:boolean, col 58:double, val 0)(children: StringGroupColEqualCharScalar(col 8:char(1), val N) -> 57:boolean, DoubleColMultiplyDoubleColumn(col 5:double, col 54:double)(children: DoubleScalarSubtractDoubleColumn(val 1.0, col 6:double) -> 54:double) -> 58:double) -> 54:double, IfExprCondExprColumn(col 57:boolean, col 59:double, col 58:double)(children: StringGroupColEqualCharScalar(col 8:char(1), val N) -> 57:boolean, DoubleColMultiplyDoubleColumn(col 5:double, col 58:double)(children: DoubleScalarSubtractD oubleColumn(val 1.0, col 6:double) -> 58:double) -> 59:double, ConstantVectorExpression(val 0.0) -> 58:double) -> 60:double, IfExprNullColumn(col 62:boolean, null, col 84)(children: StringGroupColEqualStringScalar(col 61:string, val DELIVER IN PERSON)(children: CastStringGroupToString(col 13:varchar(20)) -> 61:string) -> 62:boolean, ConvertDecimal64ToDecimal(col 7:decimal(10,2)/DECIMAL_64) -> 84:decimal(10,2)) -> 63:decimal(10,2), IfExprColumnNull(col 64:boolean, col 85:decimal(10,2), null)(children: StringGroupColEqualStringScalar(col 61:string, val TAKE BACK RETURN)(children: CastStringGroupToString(col 13:varchar(20)) -> 61:string) -> 64:boolean, ConvertDecimal64ToDecimal(col 7:decimal(10,2)/DECIMAL_64) -> 85:decimal(10,2)) -> 65:decimal(10,2), VectorUDFAdaptor(if((CAST( l_shipinstruct AS STRING) = 'DELIVER IN PERSON'), 0, l_tax))(children: StringGroupColEqualStringScalar(col 61:string, val DELIVER IN PERSON)(children: CastStringGroupToString(col 13:varchar(20)) -> 61:string) -> 66:boolean) -> 67:decimal(12,2), VectorUDFAdaptor(if((CAST( l_shipinstruct AS STRING) = 'TAKE BACK RETURN'), l_tax, 0))(children: StringGroupColEqualStringScalar(col 61:string, val TAKE BACK RETURN)(children: CastStringGroupToString(col 13:varchar(20)) -> 61:string) -> 66:boolean) -> 68:decimal(12,2), IfExprDecimal64ScalarDecimal64Column(col 66:boolean, decimal64Val 0, decimalVal 0, col 7:decimal(1,0)/DECIMAL_64)(children: StringGroupColEqualStringScalar(col 61:string, val DELIVER IN PERSON)(children: CastStringGroupToString(col 13:varchar(20)) -> 61:string) -> 66:boolean) -> 69:decimal(10,2)/DECIMAL_64, IfExprDecimal64ColumnDecimal64Scalar(col 70:boolean, col 7:decimal(10,2)/DECIMAL_64, decimal64Val 0, decimalVal 0)(children: StringGroupColEqualStringScalar(col 61:string, val TAKE BACK RETURN)(children: CastStringGroupToString(col 13:varchar(20)) -> 61:string) -> 70:boolean) -> 71:decimal(10,2)/DECIMAL_64, IfExprCondExprCondExpr(col 72:boolean, col 73:timestampcol 74:timestamp)(chi ldren: LongColGreaterLongScalar(col 1:int, val 30) -> 72:boolean, CastDateToTimestamp(col 12:date) -> 73:timestamp, CastDateToTimestamp(col 11:date) -> 74:timestamp) -> 75:timestamp, IfExprCondExprNull(col 76:boolean, col 77:int, null)(children: LongColGreaterLongScalar(col 2:int, val 10000) -> 76:boolean, VectorUDFDateDiffColCol(col 12:date, col 11:date) -> 77:int) -> 78:int, IfExprNullCondExpr(col 79:boolean, null, col 80:int)(children: LongColGreaterLongScalar(col 2:int, val 10000) -> 79:boolean, VectorUDFDateDiffColCol(col 12:date, col 11:date) -> 80:int) -> 81:int, IfExprLongScalarLongScalar(col 83:boolean, val 14245, val 14609)(children: LongColGreaterLongScalar(col 82:int, val 100)(children: LongColModuloLongScalar(col 2:int, val 500) -> 82:int) -> 83:boolean) -> 82:date Statistics: Num rows: 101 Data size: 57327 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false @@ -885,7 +885,7 @@ STAGE PLANS: includeColumns: [1, 2, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14] dataColumns: l_orderkey:int, l_partkey:int, l_suppkey:int, l_linenumber:int, l_quantity:int, l_extendedprice:double, l_discount:double, l_tax:decimal(10,2)/DECIMAL_64, l_returnflag:char(1), l_linestatus:char(1), l_shipdate:date, l_commitdate:date, l_receiptdate:date, l_shipinstruct:varchar(20), l_shipmode:char(10), l_comment:string partitionColumnCount: 0 - scratchColumnTypeNames: [bigint, string, bigint, string, bigint, string, bigint, string, string, string, string, string, bigint, string, bigint, string, bigint, string, string, string, string, string, bigint, string, bigint, string, bigint, string, string, string, string, string, bigint, bigint, bigint, bigint, bigint, double, double, bigint, bigint, double, double, double, bigint, decimal(10,2), bigint, decimal(10,2), bigint, decimal(12,2), decimal(12,2), decimal(10,2)/DECIMAL_64, bigint, decimal(10,2)/DECIMAL_64, bigint, timestamp, timestamp, timestamp, bigint, bigint, bigint, bigint, bigint, bigint, bigint, bigint, decimal(10,2), decimal(10,2)] + scratchColumnTypeNames: [bigint, string, bigint, string, bigint, string, bigint, string, string, string, string, string, bigint, string, bigint, string, bigint, string, string, string, string, string, bigint, string, bigint, string, bigint, string, string, string, string, string, bigint, bigint, bigint, bigint, bigint, double, double, bigint, bigint, double, double, double, string, bigint, decimal(10,2), bigint, decimal(10,2), bigint, decimal(12,2), decimal(12,2), decimal(10,2)/DECIMAL_64, bigint, decimal(10,2)/DECIMAL_64, bigint, timestamp, timestamp, timestamp, bigint, bigint, bigint, bigint, bigint, bigint, bigint, bigint, decimal(10,2), decimal(10,2)] Stage: Stage-0 Fetch Operator http://git-wip-us.apache.org/repos/asf/hive/blob/142367d9/ql/src/test/results/clientpositive/llap/vector_char_mapjoin1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_char_mapjoin1.q.out b/ql/src/test/results/clientpositive/llap/vector_char_mapjoin1.q.out index 4ae125b..31b3807 100644 --- a/ql/src/test/results/clientpositive/llap/vector_char_mapjoin1.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_char_mapjoin1.q.out @@ -514,6 +514,7 @@ STAGE PLANS: Map-reduce partition columns: CAST( _col1 AS STRING) (type: string) Reduce Sink Vectorization: className: VectorReduceSinkStringOperator + keyExpressions: CastStringGroupToString(col 1:char(10)) -> 3:string native: true nativeConditionsMet: hive.vectorized.execution.reducesink.new.enabled IS true, hive.execution.engine tez IN [tez, spark] IS true, No PTF TopN IS true, No DISTINCT columns IS true, BinarySortableSerDe for keys IS true, LazyBinarySerDe for values IS true Statistics: Num rows: 3 Data size: 294 Basic stats: COMPLETE Column stats: NONE