Author: xuefu
Date: Mon Oct 27 03:31:13 2014
New Revision: 1634441
URL: http://svn.apache.org/r1634441
Log:
HIVE-8602: Add SORT_QUERY_RESULTS for skewjoinopt2 (Rui via Xuefu) merged from
trunk r1634262
Modified:
hive/branches/spark/ (props changed)
hive/branches/spark/hbase-handler/pom.xml (props changed)
hive/branches/spark/ql/src/test/queries/clientpositive/skewjoinopt2.q
hive/branches/spark/ql/src/test/results/clientpositive/skewjoinopt2.q.out
Propchange: hive/branches/spark/
------------------------------------------------------------------------------
Merged /hive/trunk:r1634262
Propchange: hive/branches/spark/hbase-handler/pom.xml
------------------------------------------------------------------------------
Merged /hive/trunk/hbase-handler/pom.xml:r1634262
Modified: hive/branches/spark/ql/src/test/queries/clientpositive/skewjoinopt2.q
URL:
http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/queries/clientpositive/skewjoinopt2.q?rev=1634441&r1=1634440&r2=1634441&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/queries/clientpositive/skewjoinopt2.q
(original)
+++ hive/branches/spark/ql/src/test/queries/clientpositive/skewjoinopt2.q Mon
Oct 27 03:31:13 2014
@@ -1,6 +1,8 @@
set hive.mapred.supports.subdirectories=true;
set hive.optimize.skewjoin.compiletime = true;
+-- SORT_QUERY_RESULTS
+
CREATE TABLE T1(key STRING, val STRING)
SKEWED BY (key) ON ((2), (7)) STORED AS TEXTFILE;
Modified:
hive/branches/spark/ql/src/test/results/clientpositive/skewjoinopt2.q.out
URL:
http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/skewjoinopt2.q.out?rev=1634441&r1=1634440&r2=1634441&view=diff
==============================================================================
--- hive/branches/spark/ql/src/test/results/clientpositive/skewjoinopt2.q.out
(original)
+++ hive/branches/spark/ql/src/test/results/clientpositive/skewjoinopt2.q.out
Mon Oct 27 03:31:13 2014
@@ -1,9 +1,13 @@
-PREHOOK: query: CREATE TABLE T1(key STRING, val STRING)
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE T1(key STRING, val STRING)
SKEWED BY (key) ON ((2), (7)) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@T1
-POSTHOOK: query: CREATE TABLE T1(key STRING, val STRING)
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+CREATE TABLE T1(key STRING, val STRING)
SKEWED BY (key) ON ((2), (7)) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -359,9 +363,9 @@ POSTHOOK: Input: default@t2
2 12 NULL NULL
3 13 3 13
7 17 NULL NULL
-8 28 NULL NULL
8 18 8 18
8 18 8 18
+8 28 NULL NULL
PREHOOK: query: -- a group by at the end should not change anything
EXPLAIN
