You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2013/11/05 08:01:58 UTC
svn commit: r1538880 [44/46] - in /hive/branches/tez: ./ ant/
ant/src/org/apache/hadoop/hive/ant/ beeline/
beeline/src/java/org/apache/hive/beeline/ beeline/src/main/
beeline/src/test/org/apache/hive/beeline/src/test/ cli/ common/
common/src/java/conf/...
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_remove_14.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_remove_14.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_remove_14.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_remove_14.q.out Tue Nov 5 07:01:32 2013
@@ -36,10 +36,10 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@outputTbl1
-PREHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
PREHOOK: Output: default@inputtbl1
-POSTHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_remove_15.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_remove_15.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_remove_15.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_remove_15.q.out Tue Nov 5 07:01:32 2013
@@ -34,10 +34,10 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as rcfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@outputTbl1
-PREHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
PREHOOK: Output: default@inputtbl1
-POSTHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_remove_16.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_remove_16.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_remove_16.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_remove_16.q.out Tue Nov 5 07:01:32 2013
@@ -32,10 +32,10 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as rcfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@outputTbl1
-PREHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
PREHOOK: Output: default@inputtbl1
-POSTHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_remove_17.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_remove_17.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_remove_17.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_remove_17.q.out Tue Nov 5 07:01:32 2013
@@ -28,10 +28,10 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as rcfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@outputTbl1
-PREHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
PREHOOK: Output: default@inputtbl1
-POSTHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_remove_18.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_remove_18.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_remove_18.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_remove_18.q.out Tue Nov 5 07:01:32 2013
@@ -32,10 +32,10 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@outputTbl1
-PREHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
PREHOOK: Output: default@inputtbl1
-POSTHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_remove_19.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_remove_19.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_remove_19.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_remove_19.q.out Tue Nov 5 07:01:32 2013
@@ -28,10 +28,10 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@outputTbl1
-PREHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
PREHOOK: Output: default@inputtbl1
-POSTHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_remove_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_remove_2.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_remove_2.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_remove_2.q.out Tue Nov 5 07:01:32 2013
@@ -30,10 +30,10 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@outputTbl1
-PREHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
PREHOOK: Output: default@inputtbl1
-POSTHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_remove_20.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_remove_20.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_remove_20.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_remove_20.q.out Tue Nov 5 07:01:32 2013
@@ -30,10 +30,10 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table outputTbl1(values bigint, key string) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@outputTbl1
-PREHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
PREHOOK: Output: default@inputtbl1
-POSTHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_remove_21.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_remove_21.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_remove_21.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_remove_21.q.out Tue Nov 5 07:01:32 2013
@@ -30,10 +30,10 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table outputTbl1(key string) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@outputTbl1
-PREHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
PREHOOK: Output: default@inputtbl1
-POSTHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_remove_22.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_remove_22.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_remove_22.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_remove_22.q.out Tue Nov 5 07:01:32 2013
@@ -28,10 +28,10 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table outputTbl1(key string, values bigint, values2 bigint) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@outputTbl1
-PREHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
PREHOOK: Output: default@inputtbl1
-POSTHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_remove_23.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_remove_23.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_remove_23.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_remove_23.q.out Tue Nov 5 07:01:32 2013
@@ -30,10 +30,10 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@outputTbl1
-PREHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
PREHOOK: Output: default@inputtbl1
-POSTHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_remove_24.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_remove_24.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_remove_24.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_remove_24.q.out Tue Nov 5 07:01:32 2013
@@ -26,10 +26,10 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table outputTbl1(key double, values bigint) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@outputTbl1
-PREHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
PREHOOK: Output: default@inputtbl1
-POSTHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: EXPLAIN
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_remove_3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_remove_3.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_remove_3.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_remove_3.q.out Tue Nov 5 07:01:32 2013
@@ -30,10 +30,10 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@outputTbl1
-PREHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
PREHOOK: Output: default@inputtbl1
-POSTHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_remove_4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_remove_4.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_remove_4.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_remove_4.q.out Tue Nov 5 07:01:32 2013
@@ -28,10 +28,10 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@outputTbl1
-PREHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
PREHOOK: Output: default@inputtbl1
-POSTHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_remove_5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_remove_5.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_remove_5.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_remove_5.q.out Tue Nov 5 07:01:32 2013
@@ -32,10 +32,10 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@outputTbl1
-PREHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
PREHOOK: Output: default@inputtbl1
-POSTHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_remove_6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_remove_6.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_remove_6.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_remove_6.q.out Tue Nov 5 07:01:32 2013
@@ -27,10 +27,10 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table outputTbl2(key string, values bigint) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@outputTbl2
-PREHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
PREHOOK: Output: default@inputtbl1
-POSTHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_remove_7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_remove_7.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_remove_7.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_remove_7.q.out Tue Nov 5 07:01:32 2013
@@ -32,10 +32,10 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@outputTbl1
-PREHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
PREHOOK: Output: default@inputtbl1
-POSTHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_remove_8.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_remove_8.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_remove_8.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_remove_8.q.out Tue Nov 5 07:01:32 2013
@@ -34,10 +34,10 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@outputTbl1
-PREHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
PREHOOK: Output: default@inputtbl1
-POSTHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_remove_9.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_remove_9.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_remove_9.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_remove_9.q.out Tue Nov 5 07:01:32 2013
@@ -32,10 +32,10 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@outputTbl1
-PREHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
PREHOOK: Output: default@inputtbl1
-POSTHOOK: query: load data local inpath '../data/files/T1.txt' into table inputTbl1
+POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
Modified: hive/branches/tez/ql/src/test/results/clientpositive/uniquejoin.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/uniquejoin.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/uniquejoin.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/uniquejoin.q.out Tue Nov 5 07:01:32 2013
@@ -13,22 +13,22 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE T3(key STRING, val STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@T3
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T1.txt' INTO TABLE T1
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/T1.txt' INTO TABLE T1
PREHOOK: type: LOAD
PREHOOK: Output: default@t1
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T1.txt' INTO TABLE T1
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/T1.txt' INTO TABLE T1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@t1
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T2.txt' INTO TABLE T2
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/T2.txt' INTO TABLE T2
PREHOOK: type: LOAD
PREHOOK: Output: default@t2
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T2.txt' INTO TABLE T2
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/T2.txt' INTO TABLE T2
POSTHOOK: type: LOAD
POSTHOOK: Output: default@t2
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T3.txt' INTO TABLE T3
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/T3.txt' INTO TABLE T3
PREHOOK: type: LOAD
PREHOOK: Output: default@t3
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/T3.txt' INTO TABLE T3
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/T3.txt' INTO TABLE T3
POSTHOOK: type: LOAD
POSTHOOK: Output: default@t3
PREHOOK: query: FROM UNIQUEJOIN PRESERVE T1 a (a.key), PRESERVE T2 b (b.key), PRESERVE T3 c (c.key)
Modified: hive/branches/tez/ql/src/test/results/clientpositive/unset_table_view_property.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/unset_table_view_property.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/unset_table_view_property.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/unset_table_view_property.q.out Tue Nov 5 07:01:32 2013
@@ -24,11 +24,13 @@ PREHOOK: type: SHOW_TBLPROPERTIES
POSTHOOK: query: SHOW TBLPROPERTIES testTable
POSTHOOK: type: SHOW_TBLPROPERTIES
+numFiles 0
#### A masked pattern was here ####
c 3
#### A masked pattern was here ####
a 1
#### A masked pattern was here ####
+totalSize 0
PREHOOK: query: -- UNSET all the properties
ALTER TABLE testTable UNSET TBLPROPERTIES ('a', 'c')
PREHOOK: type: ALTERTABLE_PROPERTIES
@@ -44,7 +46,9 @@ PREHOOK: type: SHOW_TBLPROPERTIES
POSTHOOK: query: SHOW TBLPROPERTIES testTable
POSTHOOK: type: SHOW_TBLPROPERTIES
+numFiles 0
#### A masked pattern was here ####
+totalSize 0
PREHOOK: query: ALTER TABLE testTable SET TBLPROPERTIES ('a'='1', 'c'='3', 'd'='4')
PREHOOK: type: ALTERTABLE_PROPERTIES
PREHOOK: Input: default@testtable
@@ -59,11 +63,13 @@ POSTHOOK: query: SHOW TBLPROPERTIES test
POSTHOOK: type: SHOW_TBLPROPERTIES
d 4
+numFiles 0
#### A masked pattern was here ####
c 3
#### A masked pattern was here ####
a 1
#### A masked pattern was here ####
+totalSize 0
PREHOOK: query: -- UNSET a subset of the properties
ALTER TABLE testTable UNSET TBLPROPERTIES ('a', 'd')
PREHOOK: type: ALTERTABLE_PROPERTIES
@@ -79,9 +85,11 @@ PREHOOK: type: SHOW_TBLPROPERTIES
POSTHOOK: query: SHOW TBLPROPERTIES testTable
POSTHOOK: type: SHOW_TBLPROPERTIES
+numFiles 0
#### A masked pattern was here ####
c 3
#### A masked pattern was here ####
+totalSize 0
PREHOOK: query: -- the same property being UNSET multiple times
ALTER TABLE testTable UNSET TBLPROPERTIES ('c', 'c', 'c')
PREHOOK: type: ALTERTABLE_PROPERTIES
@@ -97,7 +105,9 @@ PREHOOK: type: SHOW_TBLPROPERTIES
POSTHOOK: query: SHOW TBLPROPERTIES testTable
POSTHOOK: type: SHOW_TBLPROPERTIES
+numFiles 0
#### A masked pattern was here ####
+totalSize 0
PREHOOK: query: ALTER TABLE testTable SET TBLPROPERTIES ('a'='1', 'b' = '2', 'c'='3', 'd'='4')
PREHOOK: type: ALTERTABLE_PROPERTIES
PREHOOK: Input: default@testtable
@@ -112,12 +122,14 @@ POSTHOOK: query: SHOW TBLPROPERTIES test
POSTHOOK: type: SHOW_TBLPROPERTIES
d 4
+numFiles 0
#### A masked pattern was here ####
b 2
c 3
#### A masked pattern was here ####
a 1
#### A masked pattern was here ####
+totalSize 0
PREHOOK: query: -- UNSET a subset of the properties and some non-existed properties using IF EXISTS
ALTER TABLE testTable UNSET TBLPROPERTIES IF EXISTS ('b', 'd', 'b', 'f')
PREHOOK: type: ALTERTABLE_PROPERTIES
@@ -133,11 +145,13 @@ PREHOOK: type: SHOW_TBLPROPERTIES
POSTHOOK: query: SHOW TBLPROPERTIES testTable
POSTHOOK: type: SHOW_TBLPROPERTIES
+numFiles 0
#### A masked pattern was here ####
c 3
#### A masked pattern was here ####
a 1
#### A masked pattern was here ####
+totalSize 0
PREHOOK: query: -- UNSET a subset of the properties and some non-existed properties using IF EXISTS
ALTER TABLE testTable UNSET TBLPROPERTIES IF EXISTS ('b', 'd', 'c', 'f', 'x', 'y', 'z')
PREHOOK: type: ALTERTABLE_PROPERTIES
@@ -153,9 +167,11 @@ PREHOOK: type: SHOW_TBLPROPERTIES
POSTHOOK: query: SHOW TBLPROPERTIES testTable
POSTHOOK: type: SHOW_TBLPROPERTIES
+numFiles 0
#### A masked pattern was here ####
a 1
#### A masked pattern was here ####
+totalSize 0
PREHOOK: query: -- UNSET VIEW PROPERTIES
CREATE VIEW testView AS SELECT value FROM src WHERE key=86
PREHOOK: type: CREATEVIEW
Modified: hive/branches/tez/ql/src/test/results/clientpositive/varchar_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/varchar_1.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/varchar_1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/varchar_1.q.out Tue Nov 5 07:01:32 2013
@@ -17,11 +17,11 @@ POSTHOOK: query: create table varchar1_1
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@varchar1_1
PREHOOK: query: -- load from file
-load data local inpath '../data/files/srcbucket0.txt' overwrite into table varchar1
+load data local inpath '../../data/files/srcbucket0.txt' overwrite into table varchar1
PREHOOK: type: LOAD
PREHOOK: Output: default@varchar1
POSTHOOK: query: -- load from file
-load data local inpath '../data/files/srcbucket0.txt' overwrite into table varchar1
+load data local inpath '../../data/files/srcbucket0.txt' overwrite into table varchar1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@varchar1
PREHOOK: query: select * from varchar1 order by key, value limit 2
Modified: hive/branches/tez/ql/src/test/results/clientpositive/varchar_join1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/varchar_join1.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/varchar_join1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/varchar_join1.q.out Tue Nov 5 07:01:32 2013
@@ -43,22 +43,22 @@ POSTHOOK: query: create table varchar_j
)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@varchar_join1_str
-PREHOOK: query: load data local inpath '../data/files/vc1.txt' into table varchar_join1_vc1
+PREHOOK: query: load data local inpath '../../data/files/vc1.txt' into table varchar_join1_vc1
PREHOOK: type: LOAD
PREHOOK: Output: default@varchar_join1_vc1
-POSTHOOK: query: load data local inpath '../data/files/vc1.txt' into table varchar_join1_vc1
+POSTHOOK: query: load data local inpath '../../data/files/vc1.txt' into table varchar_join1_vc1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@varchar_join1_vc1
-PREHOOK: query: load data local inpath '../data/files/vc1.txt' into table varchar_join1_vc2
+PREHOOK: query: load data local inpath '../../data/files/vc1.txt' into table varchar_join1_vc2
PREHOOK: type: LOAD
PREHOOK: Output: default@varchar_join1_vc2
-POSTHOOK: query: load data local inpath '../data/files/vc1.txt' into table varchar_join1_vc2
+POSTHOOK: query: load data local inpath '../../data/files/vc1.txt' into table varchar_join1_vc2
POSTHOOK: type: LOAD
POSTHOOK: Output: default@varchar_join1_vc2
-PREHOOK: query: load data local inpath '../data/files/vc1.txt' into table varchar_join1_str
+PREHOOK: query: load data local inpath '../../data/files/vc1.txt' into table varchar_join1_str
PREHOOK: type: LOAD
PREHOOK: Output: default@varchar_join1_str
-POSTHOOK: query: load data local inpath '../data/files/vc1.txt' into table varchar_join1_str
+POSTHOOK: query: load data local inpath '../../data/files/vc1.txt' into table varchar_join1_str
POSTHOOK: type: LOAD
POSTHOOK: Output: default@varchar_join1_str
PREHOOK: query: -- Join varchar with same length varchar
Modified: hive/branches/tez/ql/src/test/results/clientpositive/varchar_serde.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/varchar_serde.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/varchar_serde.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/varchar_serde.q.out Tue Nov 5 07:01:32 2013
@@ -49,10 +49,10 @@ with serdeproperties (
stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@varchar_serde_regex
-PREHOOK: query: load data local inpath '../data/files/srcbucket0.txt' overwrite into table varchar_serde_regex
+PREHOOK: query: load data local inpath '../../data/files/srcbucket0.txt' overwrite into table varchar_serde_regex
PREHOOK: type: LOAD
PREHOOK: Output: default@varchar_serde_regex
-POSTHOOK: query: load data local inpath '../data/files/srcbucket0.txt' overwrite into table varchar_serde_regex
+POSTHOOK: query: load data local inpath '../../data/files/srcbucket0.txt' overwrite into table varchar_serde_regex
POSTHOOK: type: LOAD
POSTHOOK: Output: default@varchar_serde_regex
PREHOOK: query: select * from varchar_serde_regex limit 5
Modified: hive/branches/tez/ql/src/test/results/clientpositive/varchar_union1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/varchar_union1.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/varchar_union1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/varchar_union1.q.out Tue Nov 5 07:01:32 2013
@@ -43,22 +43,22 @@ POSTHOOK: query: create table varchar_u
)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@varchar_union1_str
-PREHOOK: query: load data local inpath '../data/files/vc1.txt' into table varchar_union1_vc1
+PREHOOK: query: load data local inpath '../../data/files/vc1.txt' into table varchar_union1_vc1
PREHOOK: type: LOAD
PREHOOK: Output: default@varchar_union1_vc1
-POSTHOOK: query: load data local inpath '../data/files/vc1.txt' into table varchar_union1_vc1
+POSTHOOK: query: load data local inpath '../../data/files/vc1.txt' into table varchar_union1_vc1
POSTHOOK: type: LOAD
POSTHOOK: Output: default@varchar_union1_vc1
-PREHOOK: query: load data local inpath '../data/files/vc1.txt' into table varchar_union1_vc2
+PREHOOK: query: load data local inpath '../../data/files/vc1.txt' into table varchar_union1_vc2
PREHOOK: type: LOAD
PREHOOK: Output: default@varchar_union1_vc2
-POSTHOOK: query: load data local inpath '../data/files/vc1.txt' into table varchar_union1_vc2
+POSTHOOK: query: load data local inpath '../../data/files/vc1.txt' into table varchar_union1_vc2
POSTHOOK: type: LOAD
POSTHOOK: Output: default@varchar_union1_vc2
-PREHOOK: query: load data local inpath '../data/files/vc1.txt' into table varchar_union1_str
+PREHOOK: query: load data local inpath '../../data/files/vc1.txt' into table varchar_union1_str
PREHOOK: type: LOAD
PREHOOK: Output: default@varchar_union1_str
-POSTHOOK: query: load data local inpath '../data/files/vc1.txt' into table varchar_union1_str
+POSTHOOK: query: load data local inpath '../../data/files/vc1.txt' into table varchar_union1_str
POSTHOOK: type: LOAD
POSTHOOK: Output: default@varchar_union1_str
PREHOOK: query: -- union varchar with same length varchar
Modified: hive/branches/tez/ql/src/test/results/clientpositive/vectorization_limit.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/vectorization_limit.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/vectorization_limit.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/vectorization_limit.q.out Tue Nov 5 07:01:32 2013
@@ -62,3 +62,628 @@ POSTHOOK: Input: default@alltypesorc
-1887561756 -8881.0
-1887561756 -2281.0
-1887561756 9531.0
+PREHOOK: query: -- HIVE-3562 Some limit can be pushed down to map stage - c/p parts from limit_pushdown
+
+explain
+select ctinyint,cdouble,csmallint from alltypesorc where ctinyint is not null order by ctinyint,cdouble limit 20
+PREHOOK: type: QUERY
+POSTHOOK: query: -- HIVE-3562 Some limit can be pushed down to map stage - c/p parts from limit_pushdown
+
+explain
+select ctinyint,cdouble,csmallint from alltypesorc where ctinyint is not null order by ctinyint,cdouble limit 20
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL ctinyint)) (TOK_SELEXPR (TOK_TABLE_OR_COL cdouble)) (TOK_SELEXPR (TOK_TABLE_OR_COL csmallint))) (TOK_WHERE (TOK_FUNCTION TOK_ISNOTNULL (TOK_TABLE_OR_COL ctinyint))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL ctinyint)) (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL cdouble))) (TOK_LIMIT 20)))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ alltypesorc
+ TableScan
+ alias: alltypesorc
+ Filter Operator
+ predicate:
+ expr: ctinyint is not null
+ type: boolean
+ Vectorized execution: true
+ Select Operator
+ expressions:
+ expr: ctinyint
+ type: tinyint
+ expr: cdouble
+ type: double
+ expr: csmallint
+ type: smallint
+ outputColumnNames: _col0, _col1, _col2
+ Vectorized execution: true
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: tinyint
+ expr: _col1
+ type: double
+ sort order: ++
+ tag: -1
+ TopN: 20
+ TopN Hash Memory Usage: 0.3
+ value expressions:
+ expr: _col0
+ type: tinyint
+ expr: _col1
+ type: double
+ expr: _col2
+ type: smallint
+ Vectorized execution: true
+ Reduce Operator Tree:
+ Extract
+ Limit
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: 20
+
+
+PREHOOK: query: select ctinyint,cdouble,csmallint from alltypesorc where ctinyint is not null order by ctinyint,cdouble limit 20
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select ctinyint,cdouble,csmallint from alltypesorc where ctinyint is not null order by ctinyint,cdouble limit 20
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+-64 -15920.0 -15920
+-64 -10462.0 -10462
+-64 -9842.0 -9842
+-64 -8080.0 -8080
+-64 -7196.0 -7196
+-64 -7196.0 -7196
+-64 -7196.0 -7196
+-64 -7196.0 -7196
+-64 -7196.0 -7196
+-64 -7196.0 -7196
+-64 -7196.0 -7196
+-64 -6907.0 -6907
+-64 -4803.0 -4803
+-64 -4040.0 -4040
+-64 -4018.0 -4018
+-64 -3586.0 -3586
+-64 -3097.0 -3097
+-64 -2919.0 -2919
+-64 -1600.0 -1600
+-64 -200.0 -200
+PREHOOK: query: -- deduped RS
+explain
+select ctinyint,avg(cdouble + 1) from alltypesorc group by ctinyint order by ctinyint limit 20
+PREHOOK: type: QUERY
+POSTHOOK: query: -- deduped RS
+explain
+select ctinyint,avg(cdouble + 1) from alltypesorc group by ctinyint order by ctinyint limit 20
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL ctinyint)) (TOK_SELEXPR (TOK_FUNCTION avg (+ (TOK_TABLE_OR_COL cdouble) 1)))) (TOK_GROUPBY (TOK_TABLE_OR_COL ctinyint)) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL ctinyint))) (TOK_LIMIT 20)))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ alltypesorc
+ TableScan
+ alias: alltypesorc
+ Select Operator
+ expressions:
+ expr: ctinyint
+ type: tinyint
+ expr: cdouble
+ type: double
+ outputColumnNames: ctinyint, cdouble
+ Vectorized execution: true
+ Group By Operator
+ aggregations:
+ expr: avg((cdouble + 1))
+ bucketGroup: false
+ keys:
+ expr: ctinyint
+ type: tinyint
+ mode: hash
+ outputColumnNames: _col0, _col1
+ Vectorized execution: true
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: tinyint
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: tinyint
+ tag: -1
+ TopN: 20
+ TopN Hash Memory Usage: 0.3
+ value expressions:
+ expr: _col1
+ type: struct<count:bigint,sum:double>
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
+ expr: avg(VALUE._col0)
+ bucketGroup: false
+ keys:
+ expr: KEY._col0
+ type: tinyint
+ mode: mergepartial
+ outputColumnNames: _col0, _col1
+ Select Operator
+ expressions:
+ expr: _col0
+ type: tinyint
+ expr: _col1
+ type: double
+ outputColumnNames: _col0, _col1
+ Limit
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: 20
+
+
+PREHOOK: query: select ctinyint,avg(cdouble + 1) from alltypesorc group by ctinyint order by ctinyint limit 20
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select ctinyint,avg(cdouble + 1) from alltypesorc group by ctinyint order by ctinyint limit 20
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+NULL 9370.0945309795
+-64 373.52941176470586
+-63 2178.7272727272725
+-62 245.69387755102042
+-61 914.3404255319149
+-60 1071.82
+-59 318.27272727272725
+-58 3483.2444444444445
+-57 1867.0535714285713
+-56 2595.818181818182
+-55 2385.595744680851
+-54 2712.7272727272725
+-53 -532.7567567567568
+-52 2810.705882352941
+-51 -96.46341463414635
+-50 -960.0192307692307
+-49 768.7659574468086
+-48 1672.909090909091
+-47 -574.6428571428571
+-46 3033.55
+PREHOOK: query: -- distincts
+explain
+select distinct(ctinyint) from alltypesorc limit 20
+PREHOOK: type: QUERY
+POSTHOOK: query: -- distincts
+explain
+select distinct(ctinyint) from alltypesorc limit 20
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECTDI (TOK_SELEXPR (TOK_TABLE_OR_COL ctinyint))) (TOK_LIMIT 20)))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ alltypesorc
+ TableScan
+ alias: alltypesorc
+ Select Operator
+ expressions:
+ expr: ctinyint
+ type: tinyint
+ outputColumnNames: ctinyint
+ Vectorized execution: true
+ Group By Operator
+ bucketGroup: false
+ keys:
+ expr: ctinyint
+ type: tinyint
+ mode: hash
+ outputColumnNames: _col0
+ Vectorized execution: true
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: tinyint
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: tinyint
+ tag: -1
+ TopN: 20
+ TopN Hash Memory Usage: 0.3
+ Reduce Operator Tree:
+ Group By Operator
+ bucketGroup: false
+ keys:
+ expr: KEY._col0
+ type: tinyint
+ mode: mergepartial
+ outputColumnNames: _col0
+ Select Operator
+ expressions:
+ expr: _col0
+ type: tinyint
+ outputColumnNames: _col0
+ Limit
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: 20
+
+
+PREHOOK: query: select distinct(ctinyint) from alltypesorc limit 20
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select distinct(ctinyint) from alltypesorc limit 20
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+NULL
+-64
+-63
+-62
+-61
+-60
+-59
+-58
+-57
+-56
+-55
+-54
+-53
+-52
+-51
+-50
+-49
+-48
+-47
+-46
+PREHOOK: query: explain
+select ctinyint, count(distinct(cdouble)) from alltypesorc group by ctinyint limit 20
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select ctinyint, count(distinct(cdouble)) from alltypesorc group by ctinyint limit 20
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL ctinyint)) (TOK_SELEXPR (TOK_FUNCTIONDI count (TOK_TABLE_OR_COL cdouble)))) (TOK_GROUPBY (TOK_TABLE_OR_COL ctinyint)) (TOK_LIMIT 20)))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ alltypesorc
+ TableScan
+ alias: alltypesorc
+ Select Operator
+ expressions:
+ expr: ctinyint
+ type: tinyint
+ expr: cdouble
+ type: double
+ outputColumnNames: ctinyint, cdouble
+ Vectorized execution: true
+ Group By Operator
+ aggregations:
+ expr: count(DISTINCT cdouble)
+ bucketGroup: false
+ keys:
+ expr: ctinyint
+ type: tinyint
+ expr: cdouble
+ type: double
+ mode: hash
+ outputColumnNames: _col0, _col1, _col2
+ Vectorized execution: true
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: tinyint
+ expr: _col1
+ type: double
+ sort order: ++
+ Map-reduce partition columns:
+ expr: _col0
+ type: tinyint
+ tag: -1
+ TopN: 20
+ TopN Hash Memory Usage: 0.3
+ value expressions:
+ expr: _col2
+ type: bigint
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
+ expr: count(DISTINCT KEY._col1:0._col0)
+ bucketGroup: false
+ keys:
+ expr: KEY._col0
+ type: tinyint
+ mode: mergepartial
+ outputColumnNames: _col0, _col1
+ Select Operator
+ expressions:
+ expr: _col0
+ type: tinyint
+ expr: _col1
+ type: bigint
+ outputColumnNames: _col0, _col1
+ Limit
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: 20
+
+
+PREHOOK: query: select ctinyint, count(distinct(cdouble)) from alltypesorc group by ctinyint limit 20
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select ctinyint, count(distinct(cdouble)) from alltypesorc group by ctinyint limit 20
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+NULL 19
+PREHOOK: query: -- limit zero
+explain
+select ctinyint,cdouble from alltypesorc order by ctinyint limit 0
+PREHOOK: type: QUERY
+POSTHOOK: query: -- limit zero
+explain
+select ctinyint,cdouble from alltypesorc order by ctinyint limit 0
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL ctinyint)) (TOK_SELEXPR (TOK_TABLE_OR_COL cdouble))) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL ctinyint))) (TOK_LIMIT 0)))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ alltypesorc
+ TableScan
+ alias: alltypesorc
+ Select Operator
+ expressions:
+ expr: ctinyint
+ type: tinyint
+ expr: cdouble
+ type: double
+ outputColumnNames: _col0, _col1
+ Vectorized execution: true
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: tinyint
+ sort order: +
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: tinyint
+ expr: _col1
+ type: double
+ Vectorized execution: true
+ Reduce Operator Tree:
+ Extract
+ Limit
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: 0
+
+
+PREHOOK: query: select ctinyint,cdouble from alltypesorc order by ctinyint limit 0
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select ctinyint,cdouble from alltypesorc order by ctinyint limit 0
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+PREHOOK: query: -- 2MR (applied to last RS)
+explain
+select cdouble, sum(ctinyint) as sum from alltypesorc where ctinyint is not null group by cdouble order by sum, cdouble limit 20
+PREHOOK: type: QUERY
+POSTHOOK: query: -- 2MR (applied to last RS)
+explain
+select cdouble, sum(ctinyint) as sum from alltypesorc where ctinyint is not null group by cdouble order by sum, cdouble limit 20
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL cdouble)) (TOK_SELEXPR (TOK_FUNCTION sum (TOK_TABLE_OR_COL ctinyint)) sum)) (TOK_WHERE (TOK_FUNCTION TOK_ISNOTNULL (TOK_TABLE_OR_COL ctinyint))) (TOK_GROUPBY (TOK_TABLE_OR_COL cdouble)) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL sum)) (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL cdouble))) (TOK_LIMIT 20)))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-2 depends on stages: Stage-1
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ alltypesorc
+ TableScan
+ alias: alltypesorc
+ Filter Operator
+ predicate:
+ expr: ctinyint is not null
+ type: boolean
+ Vectorized execution: true
+ Select Operator
+ expressions:
+ expr: cdouble
+ type: double
+ expr: ctinyint
+ type: tinyint
+ outputColumnNames: cdouble, ctinyint
+ Vectorized execution: true
+ Group By Operator
+ aggregations:
+ expr: sum(ctinyint)
+ bucketGroup: false
+ keys:
+ expr: cdouble
+ type: double
+ mode: hash
+ outputColumnNames: _col0, _col1
+ Vectorized execution: true
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: double
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: double
+ tag: -1
+ value expressions:
+ expr: _col1
+ type: bigint
+ Reduce Operator Tree:
+ Group By Operator
+ aggregations:
+ expr: sum(VALUE._col0)
+ bucketGroup: false
+ keys:
+ expr: KEY._col0
+ type: double
+ mode: mergepartial
+ outputColumnNames: _col0, _col1
+ Select Operator
+ expressions:
+ expr: _col0
+ type: double
+ expr: _col1
+ type: bigint
+ outputColumnNames: _col0, _col1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
+
+ Stage: Stage-2
+ Map Reduce
+ Alias -> Map Operator Tree:
+#### A masked pattern was here ####
+ TableScan
+ Reduce Output Operator
+ key expressions:
+ expr: _col1
+ type: bigint
+ expr: _col0
+ type: double
+ sort order: ++
+ tag: -1
+ TopN: 20
+ TopN Hash Memory Usage: 0.3
+ value expressions:
+ expr: _col0
+ type: double
+ expr: _col1
+ type: bigint
+ Reduce Operator Tree:
+ Extract
+ Limit
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: 20
+
+
+PREHOOK: query: select cdouble, sum(ctinyint) as sum from alltypesorc where ctinyint is not null group by cdouble order by sum, cdouble limit 20
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select cdouble, sum(ctinyint) as sum from alltypesorc where ctinyint is not null group by cdouble order by sum, cdouble limit 20
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+#### A masked pattern was here ####
+NULL -32768
+-7196.0 -2009
+15601.0 -1733
+4811.0 -115
+-11322.0 -101
+-1121.0 -89
+7705.0 -88
+3520.0 -86
+-8118.0 -80
+5241.0 -80
+-11492.0 -78
+9452.0 -76
+557.0 -75
+10496.0 -67
+-15920.0 -64
+-10462.0 -64
+-9842.0 -64
+-8080.0 -64
+-6907.0 -64
+-4803.0 -64
Modified: hive/branches/tez/ql/src/test/results/clientpositive/view.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/view.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/view.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/view.q.out Tue Nov 5 07:01:32 2013
@@ -13,11 +13,11 @@ POSTHOOK: query: CREATE TABLE table1 (ke
STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: db1@table1
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt'
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt'
OVERWRITE INTO TABLE table1
PREHOOK: type: LOAD
PREHOOK: Output: db1@table1
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt'
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt'
OVERWRITE INTO TABLE table1
POSTHOOK: type: LOAD
POSTHOOK: Output: db1@table1
@@ -28,11 +28,11 @@ POSTHOOK: query: CREATE TABLE table2 (ke
STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: db1@table2
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt'
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt'
OVERWRITE INTO TABLE table2
PREHOOK: type: LOAD
PREHOOK: Output: db1@table2
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt'
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt'
OVERWRITE INTO TABLE table2
POSTHOOK: type: LOAD
POSTHOOK: Output: db1@table2
Modified: hive/branches/tez/ql/src/test/results/clientpositive/view_cast.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/view_cast.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/view_cast.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/view_cast.q.out Tue Nov 5 07:01:32 2013
@@ -7,17 +7,17 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE IF NOT EXISTS atab (ks_uid BIGINT, sr_uid STRING, sr_id STRING, tstamp STRING, m_id STRING, act STRING, at_sr_uid STRING, tstamp_type STRING, original_m_id STRING, original_tstamp STRING, registered_flag TINYINT, at_ks_uid BIGINT) PARTITIONED BY (dt STRING,nt STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@atab
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/v1.txt' INTO TABLE atab PARTITION (dt='20130312', nt='tw')
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/v1.txt' INTO TABLE atab PARTITION (dt='20130312', nt='tw')
PREHOOK: type: LOAD
PREHOOK: Output: default@atab
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/v1.txt' INTO TABLE atab PARTITION (dt='20130312', nt='tw')
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/v1.txt' INTO TABLE atab PARTITION (dt='20130312', nt='tw')
POSTHOOK: type: LOAD
POSTHOOK: Output: default@atab
POSTHOOK: Output: default@atab@dt=20130312/nt=tw
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/v1.txt' INTO TABLE atab PARTITION (dt='20130311', nt='tw')
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/v1.txt' INTO TABLE atab PARTITION (dt='20130311', nt='tw')
PREHOOK: type: LOAD
PREHOOK: Output: default@atab
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/v1.txt' INTO TABLE atab PARTITION (dt='20130311', nt='tw')
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/v1.txt' INTO TABLE atab PARTITION (dt='20130311', nt='tw')
POSTHOOK: type: LOAD
POSTHOOK: Output: default@atab
POSTHOOK: Output: default@atab@dt=20130311/nt=tw
@@ -30,10 +30,10 @@ PREHOOK: type: CREATETABLE
POSTHOOK: query: CREATE TABLE mstab(ks_uid INT, csc INT) PARTITIONED BY (dt STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@mstab
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/v2.txt' INTO TABLE mstab PARTITION (dt='20130311')
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/v2.txt' INTO TABLE mstab PARTITION (dt='20130311')
PREHOOK: type: LOAD
PREHOOK: Output: default@mstab
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/v2.txt' INTO TABLE mstab PARTITION (dt='20130311')
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/v2.txt' INTO TABLE mstab PARTITION (dt='20130311')
POSTHOOK: type: LOAD
POSTHOOK: Output: default@mstab
POSTHOOK: Output: default@mstab@dt=20130311
Modified: hive/branches/tez/ql/src/test/results/clientpositive/windowing.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/windowing.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/windowing.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/windowing.q.out Tue Nov 5 07:01:32 2013
@@ -29,10 +29,10 @@ CREATE TABLE part(
)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@part
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table part
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part
PREHOOK: type: LOAD
PREHOOK: Output: default@part
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table part
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part
POSTHOOK: type: LOAD
POSTHOOK: Output: default@part
PREHOOK: query: -- 1. testWindowing
Modified: hive/branches/tez/ql/src/test/results/clientpositive/windowing_adjust_rowcontainer_sz.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/windowing_adjust_rowcontainer_sz.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/windowing_adjust_rowcontainer_sz.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/windowing_adjust_rowcontainer_sz.q.out Tue Nov 5 07:01:32 2013
@@ -29,10 +29,10 @@ CREATE TABLE part(
)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@part
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table part
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part
PREHOOK: type: LOAD
PREHOOK: Output: default@part
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table part
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part
POSTHOOK: type: LOAD
POSTHOOK: Output: default@part
PREHOOK: query: select p_mfgr, p_name, p_size,
Modified: hive/branches/tez/ql/src/test/results/clientpositive/windowing_columnPruning.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/windowing_columnPruning.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/windowing_columnPruning.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/windowing_columnPruning.q.out Tue Nov 5 07:01:32 2013
@@ -29,10 +29,10 @@ CREATE TABLE part(
)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@part
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table part
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part
PREHOOK: type: LOAD
PREHOOK: Output: default@part
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table part
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part
POSTHOOK: type: LOAD
POSTHOOK: Output: default@part
PREHOOK: query: -- 1. testQueryLevelPartitionColsNotInSelect
Modified: hive/branches/tez/ql/src/test/results/clientpositive/windowing_expressions.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/windowing_expressions.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/windowing_expressions.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/windowing_expressions.q.out Tue Nov 5 07:01:32 2013
@@ -29,10 +29,10 @@ CREATE TABLE part(
)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@part
-PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table part
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part
PREHOOK: type: LOAD
PREHOOK: Output: default@part
-POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/part_tiny.txt' overwrite into table part
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part
POSTHOOK: type: LOAD
POSTHOOK: Output: default@part
PREHOOK: query: drop table over10k
@@ -70,10 +70,10 @@ POSTHOOK: query: create table over10k(
fields terminated by '|'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@over10k
-PREHOOK: query: load data local inpath '../data/files/over10k' into table over10k
+PREHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
PREHOOK: type: LOAD
PREHOOK: Output: default@over10k
-POSTHOOK: query: load data local inpath '../data/files/over10k' into table over10k
+POSTHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
POSTHOOK: type: LOAD
POSTHOOK: Output: default@over10k
PREHOOK: query: select p_mfgr, p_retailprice, p_size,
Modified: hive/branches/tez/ql/src/test/results/clientpositive/windowing_multipartitioning.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/windowing_multipartitioning.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/windowing_multipartitioning.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/windowing_multipartitioning.q.out Tue Nov 5 07:01:32 2013
@@ -33,10 +33,10 @@ POSTHOOK: query: create table over10k(
fields terminated by '|'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@over10k
-PREHOOK: query: load data local inpath '../data/files/over10k' into table over10k
+PREHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
PREHOOK: type: LOAD
PREHOOK: Output: default@over10k
-POSTHOOK: query: load data local inpath '../data/files/over10k' into table over10k
+POSTHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
POSTHOOK: type: LOAD
POSTHOOK: Output: default@over10k
PREHOOK: query: select s, rank() over (partition by s order by si), sum(b) over (partition by s order by si) from over10k limit 100
Modified: hive/branches/tez/ql/src/test/results/clientpositive/windowing_navfn.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/windowing_navfn.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/windowing_navfn.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/windowing_navfn.q.out Tue Nov 5 07:01:32 2013
@@ -33,10 +33,10 @@ POSTHOOK: query: create table over10k(
fields terminated by '|'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@over10k
-PREHOOK: query: load data local inpath '../data/files/over10k' into table over10k
+PREHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
PREHOOK: type: LOAD
PREHOOK: Output: default@over10k
-POSTHOOK: query: load data local inpath '../data/files/over10k' into table over10k
+POSTHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
POSTHOOK: type: LOAD
POSTHOOK: Output: default@over10k
PREHOOK: query: select s, row_number() over (partition by d order by dec) from over10k limit 100
Modified: hive/branches/tez/ql/src/test/results/clientpositive/windowing_ntile.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/windowing_ntile.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/windowing_ntile.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/windowing_ntile.q.out Tue Nov 5 07:01:32 2013
@@ -33,10 +33,10 @@ POSTHOOK: query: create table over10k(
fields terminated by '|'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@over10k
-PREHOOK: query: load data local inpath '../data/files/over10k' into table over10k
+PREHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
PREHOOK: type: LOAD
PREHOOK: Output: default@over10k
-POSTHOOK: query: load data local inpath '../data/files/over10k' into table over10k
+POSTHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
POSTHOOK: type: LOAD
POSTHOOK: Output: default@over10k
PREHOOK: query: select i, ntile(10) over (partition by s order by i) from over10k limit 100
Modified: hive/branches/tez/ql/src/test/results/clientpositive/windowing_rank.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/windowing_rank.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/windowing_rank.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/windowing_rank.q.out Tue Nov 5 07:01:32 2013
@@ -33,10 +33,10 @@ POSTHOOK: query: create table over10k(
fields terminated by '|'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@over10k
-PREHOOK: query: load data local inpath '../data/files/over10k' into table over10k
+PREHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
PREHOOK: type: LOAD
PREHOOK: Output: default@over10k
-POSTHOOK: query: load data local inpath '../data/files/over10k' into table over10k
+POSTHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
POSTHOOK: type: LOAD
POSTHOOK: Output: default@over10k
PREHOOK: query: select s, rank() over (partition by f order by t) from over10k limit 100
Modified: hive/branches/tez/ql/src/test/results/clientpositive/windowing_udaf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/windowing_udaf.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/windowing_udaf.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/windowing_udaf.q.out Tue Nov 5 07:01:32 2013
@@ -33,10 +33,10 @@ POSTHOOK: query: create table over10k(
fields terminated by '|'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@over10k
-PREHOOK: query: load data local inpath '../data/files/over10k' into table over10k
+PREHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
PREHOOK: type: LOAD
PREHOOK: Output: default@over10k
-POSTHOOK: query: load data local inpath '../data/files/over10k' into table over10k
+POSTHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
POSTHOOK: type: LOAD
POSTHOOK: Output: default@over10k
PREHOOK: query: select s, min(i) over (partition by s) from over10k limit 100
Modified: hive/branches/tez/ql/src/test/results/clientpositive/windowing_windowspec.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/windowing_windowspec.q.out?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/windowing_windowspec.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/windowing_windowspec.q.out Tue Nov 5 07:01:32 2013
@@ -33,10 +33,10 @@ POSTHOOK: query: create table over10k(
fields terminated by '|'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@over10k
-PREHOOK: query: load data local inpath '../data/files/over10k' into table over10k
+PREHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
PREHOOK: type: LOAD
PREHOOK: Output: default@over10k
-POSTHOOK: query: load data local inpath '../data/files/over10k' into table over10k
+POSTHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
POSTHOOK: type: LOAD
POSTHOOK: Output: default@over10k
PREHOOK: query: select s, sum(b) over (partition by i order by s,b rows unbounded preceding) from over10k limit 100
Modified: hive/branches/tez/ql/src/test/results/compiler/plan/case_sensitivity.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/compiler/plan/case_sensitivity.q.xml?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/compiler/plan/case_sensitivity.q.xml (original)
+++ hive/branches/tez/ql/src/test/results/compiler/plan/case_sensitivity.q.xml Tue Nov 5 07:01:32 2013
@@ -640,10 +640,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>serialization.class</string>
<string>org.apache.hadoop.hive.serde2.thrift.test.Complex</string>
</void>
@@ -1371,10 +1367,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>serialization.class</string>
<string>org.apache.hadoop.hive.serde2.thrift.test.Complex</string>
</void>
@@ -1451,10 +1443,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>serialization.class</string>
<string>org.apache.hadoop.hive.serde2.thrift.test.Complex</string>
</void>
Modified: hive/branches/tez/ql/src/test/results/compiler/plan/cast1.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/compiler/plan/cast1.q.xml?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/compiler/plan/cast1.q.xml (original)
+++ hive/branches/tez/ql/src/test/results/compiler/plan/cast1.q.xml Tue Nov 5 07:01:32 2013
@@ -110,10 +110,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>bucket_count</string>
<string>-1</string>
</void>
@@ -1176,10 +1172,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>bucket_count</string>
<string>-1</string>
</void>
@@ -1252,10 +1244,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>bucket_count</string>
<string>-1</string>
</void>
Modified: hive/branches/tez/ql/src/test/results/compiler/plan/groupby1.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/compiler/plan/groupby1.q.xml?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/compiler/plan/groupby1.q.xml (original)
+++ hive/branches/tez/ql/src/test/results/compiler/plan/groupby1.q.xml Tue Nov 5 07:01:32 2013
@@ -257,10 +257,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>bucket_count</string>
<string>-1</string>
</void>
@@ -1077,10 +1073,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>bucket_count</string>
<string>-1</string>
</void>
@@ -1153,10 +1145,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>bucket_count</string>
<string>-1</string>
</void>
Modified: hive/branches/tez/ql/src/test/results/compiler/plan/groupby2.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/compiler/plan/groupby2.q.xml?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/compiler/plan/groupby2.q.xml (original)
+++ hive/branches/tez/ql/src/test/results/compiler/plan/groupby2.q.xml Tue Nov 5 07:01:32 2013
@@ -110,10 +110,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>bucket_count</string>
<string>-1</string>
</void>
@@ -1199,10 +1195,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>bucket_count</string>
<string>-1</string>
</void>
@@ -1275,10 +1267,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>bucket_count</string>
<string>-1</string>
</void>
Modified: hive/branches/tez/ql/src/test/results/compiler/plan/groupby3.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/compiler/plan/groupby3.q.xml?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/compiler/plan/groupby3.q.xml (original)
+++ hive/branches/tez/ql/src/test/results/compiler/plan/groupby3.q.xml Tue Nov 5 07:01:32 2013
@@ -110,10 +110,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>bucket_count</string>
<string>-1</string>
</void>
@@ -1414,10 +1410,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>bucket_count</string>
<string>-1</string>
</void>
@@ -1490,10 +1482,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>bucket_count</string>
<string>-1</string>
</void>
Modified: hive/branches/tez/ql/src/test/results/compiler/plan/groupby4.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/compiler/plan/groupby4.q.xml?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/compiler/plan/groupby4.q.xml (original)
+++ hive/branches/tez/ql/src/test/results/compiler/plan/groupby4.q.xml Tue Nov 5 07:01:32 2013
@@ -110,10 +110,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>bucket_count</string>
<string>-1</string>
</void>
@@ -821,10 +817,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>bucket_count</string>
<string>-1</string>
</void>
@@ -897,10 +889,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>bucket_count</string>
<string>-1</string>
</void>
Modified: hive/branches/tez/ql/src/test/results/compiler/plan/groupby5.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/compiler/plan/groupby5.q.xml?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/compiler/plan/groupby5.q.xml (original)
+++ hive/branches/tez/ql/src/test/results/compiler/plan/groupby5.q.xml Tue Nov 5 07:01:32 2013
@@ -110,10 +110,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>bucket_count</string>
<string>-1</string>
</void>
@@ -927,10 +923,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>bucket_count</string>
<string>-1</string>
</void>
@@ -1003,10 +995,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>bucket_count</string>
<string>-1</string>
</void>
Modified: hive/branches/tez/ql/src/test/results/compiler/plan/groupby6.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/compiler/plan/groupby6.q.xml?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/compiler/plan/groupby6.q.xml (original)
+++ hive/branches/tez/ql/src/test/results/compiler/plan/groupby6.q.xml Tue Nov 5 07:01:32 2013
@@ -110,10 +110,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>bucket_count</string>
<string>-1</string>
</void>
@@ -821,10 +817,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>bucket_count</string>
<string>-1</string>
</void>
@@ -897,10 +889,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>bucket_count</string>
<string>-1</string>
</void>
Modified: hive/branches/tez/ql/src/test/results/compiler/plan/input1.q.xml
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/compiler/plan/input1.q.xml?rev=1538880&r1=1538879&r2=1538880&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/compiler/plan/input1.q.xml (original)
+++ hive/branches/tez/ql/src/test/results/compiler/plan/input1.q.xml Tue Nov 5 07:01:32 2013
@@ -636,10 +636,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>bucket_count</string>
<string>-1</string>
</void>
@@ -1174,10 +1170,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>bucket_count</string>
<string>-1</string>
</void>
@@ -1250,10 +1242,6 @@
<string>0</string>
</void>
<void method="put">
- <string>numPartitions</string>
- <string>0</string>
- </void>
- <void method="put">
<string>bucket_count</string>
<string>-1</string>
</void>