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 <ser...@apache.org> Authored: Fri Jan 29 18:14:14 2016 -0800 Committer: Sergey Shelukhin <ser...@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;