You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by xu...@apache.org on 2014/10/26 02:17:51 UTC
svn commit: r1634262 - in /hive/trunk/ql/src/test:
queries/clientpositive/skewjoinopt2.q
results/clientpositive/skewjoinopt2.q.out
Author: xuefu
Date: Sun Oct 26 01:17:51 2014
New Revision: 1634262
URL: http://svn.apache.org/r1634262
Log:
HIVE-8602: Add SORT_QUERY_RESULTS for skewjoinopt2 (Rui via Xuefu)
Modified:
hive/trunk/ql/src/test/queries/clientpositive/skewjoinopt2.q
hive/trunk/ql/src/test/results/clientpositive/skewjoinopt2.q.out
Modified: hive/trunk/ql/src/test/queries/clientpositive/skewjoinopt2.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/skewjoinopt2.q?rev=1634262&r1=1634261&r2=1634262&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/skewjoinopt2.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/skewjoinopt2.q Sun Oct 26 01:17:51 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/trunk/ql/src/test/results/clientpositive/skewjoinopt2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/skewjoinopt2.q.out?rev=1634262&r1=1634261&r2=1634262&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/skewjoinopt2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/skewjoinopt2.q.out Sun Oct 26 01:17:51 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