You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by se...@apache.org on 2016/01/30 03:20:04 UTC
hive git commit: HIVE-12727 : refactor Hive strict checks to be more
granular,
allow order by no limit and no partition filter by default for now (Sergey
Shelukhin, reviewed by Xuefu Zhang) ADDENDUM2
Repository: hive
Updated Branches:
refs/heads/master cc32d881a -> 208ab3523
HIVE-12727 : refactor Hive strict checks to be more granular, allow order by no limit and no partition filter by default for now (Sergey Shelukhin, reviewed by Xuefu Zhang) ADDENDUM2
Project: http://git-wip-us.apache.org/repos/asf/hive/repo
Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/208ab352
Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/208ab352
Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/208ab352
Branch: refs/heads/master
Commit: 208ab352311a6cbbcd1f7fcd40964da2dbc6703d
Parents: cc32d88
Author: Sergey Shelukhin <se...@apache.org>
Authored: Fri Jan 29 18:14:14 2016 -0800
Committer: Sergey Shelukhin <se...@apache.org>
Committed: Fri Jan 29 18:14:34 2016 -0800
----------------------------------------------------------------------
ql/src/test/queries/clientpositive/perf/query12.q | 1 +
1 file changed, 1 insertion(+)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/hive/blob/208ab352/ql/src/test/queries/clientpositive/perf/query12.q
----------------------------------------------------------------------
diff --git a/ql/src/test/queries/clientpositive/perf/query12.q b/ql/src/test/queries/clientpositive/perf/query12.q
index 29976fc..034fa7b 100644
--- a/ql/src/test/queries/clientpositive/perf/query12.q
+++ b/ql/src/test/queries/clientpositive/perf/query12.q
@@ -1,2 +1,3 @@
set hive.cbo.enable=false;
explain select i_item_desc ,i_category ,i_class ,i_current_price ,i_item_id ,sum(ws_ext_sales_price) as itemrevenue ,sum(ws_ext_sales_price)*100/sum(sum(ws_ext_sales_price)) over (partition by i_class) as revenueratio from web_sales ,item ,date_dim where web_sales.ws_item_sk = item.i_item_sk and item.i_category in ('Jewelry', 'Sports', 'Books') and web_sales.ws_sold_date_sk = date_dim.d_date_sk and date_dim.d_date between '2001-01-12' and '2001-02-11' group by i_item_id ,i_item_desc ,i_category ,i_class ,i_current_price order by i_category ,i_class ,i_item_id ,i_item_desc ,revenueratio limit 100;
+set hive.cbo.enable=true;