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 2014/02/25 08:59:20 UTC
svn commit: r1571600 [25/46] - in /hive/branches/tez: ./
ant/src/org/apache/hadoop/hive/ant/
common/src/java/org/apache/hadoop/hive/common/
common/src/java/org/apache/hadoop/hive/common/type/
common/src/java/org/apache/hadoop/hive/conf/ common/src/java...
Modified: hive/branches/tez/ql/src/test/results/clientpositive/archive_excludeHadoop20.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/archive_excludeHadoop20.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/archive_excludeHadoop20.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/archive_excludeHadoop20.q.out Tue Feb 25 07:58:52 2014
@@ -12,8 +12,10 @@ POSTHOOK: query: drop table tstsrcpart
POSTHOOK: type: DROPTABLE
PREHOOK: query: create table tstsrc like src
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table tstsrc like src
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tstsrc
PREHOOK: query: insert overwrite table tstsrc select key, value from src
PREHOOK: type: QUERY
@@ -27,8 +29,10 @@ POSTHOOK: Lineage: tstsrc.key SIMPLE [(s
POSTHOOK: Lineage: tstsrc.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: create table tstsrcpart (key string, value string) partitioned by (ds string, hr string) clustered by (key) into 10 buckets
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table tstsrcpart (key string, value string) partitioned by (ds string, hr string) clustered by (key) into 10 buckets
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tstsrcpart
POSTHOOK: Lineage: tstsrc.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrc.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -277,10 +281,12 @@ PREHOOK: query: CREATE TABLE harbucket(k
PARTITIONED by (ds STRING)
CLUSTERED BY (key) INTO 10 BUCKETS
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE harbucket(key INT)
PARTITIONED by (ds STRING)
CLUSTERED BY (key) INTO 10 BUCKETS
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@harbucket
POSTHOOK: Lineage: tstsrc.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrc.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -433,9 +439,11 @@ POSTHOOK: Lineage: tstsrcpart PARTITION(
PREHOOK: query: CREATE TABLE old_name(key INT)
PARTITIONED by (ds STRING)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE old_name(key INT)
PARTITIONED by (ds STRING)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@old_name
POSTHOOK: Lineage: harbucket PARTITION(ds=1).key EXPRESSION [(tstsrc)tstsrc.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrc.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
Modified: hive/branches/tez/ql/src/test/results/clientpositive/archive_multi.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/archive_multi.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/archive_multi.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/archive_multi.q.out Tue Feb 25 07:58:52 2014
@@ -8,8 +8,10 @@ POSTHOOK: query: drop table tstsrcpart
POSTHOOK: type: DROPTABLE
PREHOOK: query: create table tstsrc like src
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table tstsrc like src
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tstsrc
PREHOOK: query: insert overwrite table tstsrc select key, value from src
PREHOOK: type: QUERY
@@ -23,8 +25,10 @@ POSTHOOK: Lineage: tstsrc.key SIMPLE [(s
POSTHOOK: Lineage: tstsrc.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: create table tstsrcpart like srcpart
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table tstsrcpart like srcpart
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tstsrcpart
POSTHOOK: Lineage: tstsrc.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrc.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Modified: hive/branches/tez/ql/src/test/results/clientpositive/authorization_1_sql_std.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/authorization_1_sql_std.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/authorization_1_sql_std.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/authorization_1_sql_std.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: create table src_autho_test (key STRING, value STRING)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table src_autho_test (key STRING, value STRING)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_autho_test
PREHOOK: query: set role ADMIN
PREHOOK: type: SHOW_ROLES
Modified: hive/branches/tez/ql/src/test/results/clientpositive/authorization_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/authorization_2.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/authorization_2.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/authorization_2.q.out Tue Feb 25 07:58:52 2014
@@ -2,10 +2,12 @@ PREHOOK: query: -- SORT_BEFORE_DIFF
create table authorization_part (key int, value string) partitioned by (ds string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- SORT_BEFORE_DIFF
create table authorization_part (key int, value string) partitioned by (ds string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@authorization_part
PREHOOK: query: create table src_auth_tmp as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
@@ -53,14 +55,14 @@ PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant user hive_test_user on table authorization_part
POSTHOOK: type: SHOW_GRANT
default authorization_part hive_test_user USER Create false -1 hive_test_user
-default authorization_part hive_test_user USER Update false -1 hive_test_user
default authorization_part hive_test_user USER Drop false -1 hive_test_user
+default authorization_part hive_test_user USER Update false -1 hive_test_user
PREHOOK: query: alter table authorization_part add partition (ds='2010')
PREHOOK: type: ALTERTABLE_ADDPARTS
-PREHOOK: Input: default@authorization_part
+PREHOOK: Output: default@authorization_part
POSTHOOK: query: alter table authorization_part add partition (ds='2010')
POSTHOOK: type: ALTERTABLE_ADDPARTS
-POSTHOOK: Input: default@authorization_part
+POSTHOOK: Output: default@authorization_part
POSTHOOK: Output: default@authorization_part@ds=2010
PREHOOK: query: show grant user hive_test_user on table authorization_part partition (ds='2010')
PREHOOK: type: SHOW_GRANT
@@ -225,14 +227,14 @@ POSTHOOK: type: SHOW_GRANT
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src_auth_tmp)src_auth_tmp.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src_auth_tmp)src_auth_tmp.FieldSchema(name:value, type:string, comment:null), ]
default authorization_part hive_test_user USER Create false -1 hive_test_user
-default authorization_part hive_test_user USER Update false -1 hive_test_user
default authorization_part hive_test_user USER Drop false -1 hive_test_user
+default authorization_part hive_test_user USER Update false -1 hive_test_user
PREHOOK: query: alter table authorization_part add partition (ds='2010')
PREHOOK: type: ALTERTABLE_ADDPARTS
-PREHOOK: Input: default@authorization_part
+PREHOOK: Output: default@authorization_part
POSTHOOK: query: alter table authorization_part add partition (ds='2010')
POSTHOOK: type: ALTERTABLE_ADDPARTS
-POSTHOOK: Input: default@authorization_part
+POSTHOOK: Output: default@authorization_part
POSTHOOK: Output: default@authorization_part@ds=2010
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src_auth_tmp)src_auth_tmp.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src_auth_tmp)src_auth_tmp.FieldSchema(name:value, type:string, comment:null), ]
@@ -296,9 +298,9 @@ POSTHOOK: Lineage: authorization_part PA
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src_auth_tmp)src_auth_tmp.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src_auth_tmp)src_auth_tmp.FieldSchema(name:value, type:string, comment:null), ]
default authorization_part hive_test_user USER Create false -1 hive_test_user
-default authorization_part hive_test_user USER Update false -1 hive_test_user
default authorization_part hive_test_user USER Drop false -1 hive_test_user
default authorization_part hive_test_user USER Select false -1 hive_test_user
+default authorization_part hive_test_user USER Update false -1 hive_test_user
PREHOOK: query: select key from authorization_part where ds='2010' order by key limit 20
PREHOOK: type: QUERY
PREHOOK: Input: default@authorization_part
@@ -352,8 +354,8 @@ POSTHOOK: Lineage: authorization_part PA
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src_auth_tmp)src_auth_tmp.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src_auth_tmp)src_auth_tmp.FieldSchema(name:value, type:string, comment:null), ]
default authorization_part hive_test_user USER Create false -1 hive_test_user
-default authorization_part hive_test_user USER Update false -1 hive_test_user
default authorization_part hive_test_user USER Drop false -1 hive_test_user
+default authorization_part hive_test_user USER Update false -1 hive_test_user
PREHOOK: query: show grant user hive_test_user on table authorization_part partition (ds='2010')
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant user hive_test_user on table authorization_part partition (ds='2010')
@@ -447,10 +449,10 @@ POSTHOOK: Lineage: authorization_part PA
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src_auth_tmp)src_auth_tmp.FieldSchema(name:value, type:string, comment:null), ]
PREHOOK: query: alter table authorization_part add partition (ds='2010')
PREHOOK: type: ALTERTABLE_ADDPARTS
-PREHOOK: Input: default@authorization_part
+PREHOOK: Output: default@authorization_part
POSTHOOK: query: alter table authorization_part add partition (ds='2010')
POSTHOOK: type: ALTERTABLE_ADDPARTS
-POSTHOOK: Input: default@authorization_part
+POSTHOOK: Output: default@authorization_part
POSTHOOK: Output: default@authorization_part@ds=2010
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src_auth_tmp)src_auth_tmp.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src_auth_tmp)src_auth_tmp.FieldSchema(name:value, type:string, comment:null), ]
@@ -677,10 +679,10 @@ POSTHOOK: Lineage: authorization_part PA
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src_auth_tmp)src_auth_tmp.FieldSchema(name:value, type:string, comment:null), ]
PREHOOK: query: alter table authorization_part add partition (ds='2010')
PREHOOK: type: ALTERTABLE_ADDPARTS
-PREHOOK: Input: default@authorization_part
+PREHOOK: Output: default@authorization_part
POSTHOOK: query: alter table authorization_part add partition (ds='2010')
POSTHOOK: type: ALTERTABLE_ADDPARTS
-POSTHOOK: Input: default@authorization_part
+POSTHOOK: Output: default@authorization_part
POSTHOOK: Output: default@authorization_part@ds=2010
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src_auth_tmp)src_auth_tmp.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src_auth_tmp)src_auth_tmp.FieldSchema(name:value, type:string, comment:null), ]
Modified: hive/branches/tez/ql/src/test/results/clientpositive/authorization_6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/authorization_6.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/authorization_6.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/authorization_6.q.out Tue Feb 25 07:58:52 2014
@@ -11,8 +11,10 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@src_auth_tmp
PREHOOK: query: create table authorization_part (key int, value string) partitioned by (ds string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table authorization_part (key int, value string) partitioned by (ds string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@authorization_part
PREHOOK: query: ALTER TABLE authorization_part SET TBLPROPERTIES ("PARTITION_LEVEL_PRIVILEGE"="TRUE")
PREHOOK: type: ALTERTABLE_PROPERTIES
@@ -160,8 +162,10 @@ POSTHOOK: Lineage: authorization_part PA
POSTHOOK: Lineage: authorization_part PARTITION(ds=2011).value SIMPLE [(src_auth_tmp)src_auth_tmp.FieldSchema(name:value, type:string, comment:null), ]
PREHOOK: query: create table authorization_part (key int, value string) partitioned by (ds string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table authorization_part (key int, value string) partitioned by (ds string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@authorization_part
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src_auth_tmp)src_auth_tmp.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src_auth_tmp)src_auth_tmp.FieldSchema(name:value, type:string, comment:null), ]
Modified: hive/branches/tez/ql/src/test/results/clientpositive/authorization_7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/authorization_7.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/authorization_7.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/authorization_7.q.out Tue Feb 25 07:58:52 2014
@@ -4,8 +4,10 @@ POSTHOOK: query: GRANT ALL TO USER hive_
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: CREATE TABLE src_authorization_7 (key int, value string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE src_authorization_7 (key int, value string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_authorization_7
PREHOOK: query: DESCRIBE src_authorization_7
PREHOOK: type: DESCTABLE
@@ -31,8 +33,10 @@ POSTHOOK: query: GRANT ALL TO GROUP hive
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: CREATE TABLE src_authorization_7 (key int, value string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE src_authorization_7 (key int, value string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_authorization_7
PREHOOK: query: DESCRIBE src_authorization_7
PREHOOK: type: DESCTABLE
Modified: hive/branches/tez/ql/src/test/results/clientpositive/authorization_8.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/authorization_8.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/authorization_8.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/authorization_8.q.out Tue Feb 25 07:58:52 2014
@@ -4,8 +4,10 @@ POSTHOOK: query: GRANT ALL TO USER hive_
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: CREATE TABLE tbl_j5jbymsx8e (key INT, value STRING) PARTITIONED BY (ds STRING)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE tbl_j5jbymsx8e (key INT, value STRING) PARTITIONED BY (ds STRING)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tbl_j5jbymsx8e
PREHOOK: query: CREATE VIEW view_j5jbymsx8e_1 as SELECT * FROM tbl_j5jbymsx8e
PREHOOK: type: CREATEVIEW
Modified: hive/branches/tez/ql/src/test/results/clientpositive/authorization_9.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/authorization_9.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/authorization_9.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/authorization_9.q.out Tue Feb 25 07:58:52 2014
@@ -2,10 +2,12 @@ PREHOOK: query: -- SORT_BEFORE_DIFF
create table dummy (key string, value string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- SORT_BEFORE_DIFF
create table dummy (key string, value string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dummy
PREHOOK: query: grant select on database default to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
Modified: hive/branches/tez/ql/src/test/results/clientpositive/authorization_create_table_owner_privs.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/authorization_create_table_owner_privs.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/authorization_create_table_owner_privs.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/authorization_create_table_owner_privs.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: create table create_table_creator_priv_test(i int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table create_table_creator_priv_test(i int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@create_table_creator_priv_test
PREHOOK: query: -- all privileges should have been set for user
Modified: hive/branches/tez/ql/src/test/results/clientpositive/authorization_grant_table_priv.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/authorization_grant_table_priv.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/authorization_grant_table_priv.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/authorization_grant_table_priv.q.out Tue Feb 25 07:58:52 2014
@@ -2,10 +2,12 @@ PREHOOK: query: -- current user has been
CREATE TABLE table_priv1(i int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- current user has been set (comment line before the set cmd is resulting in parse error!!)
CREATE TABLE table_priv1(i int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@table_priv1
PREHOOK: query: -- all privileges should have been set for user
Modified: hive/branches/tez/ql/src/test/results/clientpositive/authorization_revoke_table_priv.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/authorization_revoke_table_priv.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/authorization_revoke_table_priv.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/authorization_revoke_table_priv.q.out Tue Feb 25 07:58:52 2014
@@ -1,11 +1,13 @@
PREHOOK: query: -- current user has been set (comment line before the set cmd is resulting in parse error!!)
-CREATE TABLE table_priv_rev(i int)
+CREATE TABLE table_priv_rev(i int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- current user has been set (comment line before the set cmd is resulting in parse error!!)
-CREATE TABLE table_priv_rev(i int)
+CREATE TABLE table_priv_rev(i int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@table_priv_rev
PREHOOK: query: -- grant insert privilege to user2
GRANT INSERT ON table_priv_rev TO USER user2
@@ -148,3 +150,29 @@ PREHOOK: query: SHOW GRANT USER user2 ON
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv_rev
POSTHOOK: type: SHOW_GRANT
+PREHOOK: query: -- grant all followed by revoke all
+GRANT ALL ON table_priv_rev TO USER user2
+PREHOOK: type: GRANT_PRIVILEGE
+PREHOOK: Output: default@table_priv_rev
+POSTHOOK: query: -- grant all followed by revoke all
+GRANT ALL ON table_priv_rev TO USER user2
+POSTHOOK: type: GRANT_PRIVILEGE
+POSTHOOK: Output: default@table_priv_rev
+PREHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv_rev
+PREHOOK: type: SHOW_GRANT
+POSTHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv_rev
+POSTHOOK: type: SHOW_GRANT
+default table_priv_rev user2 USER DELETE false -1 user1
+default table_priv_rev user2 USER INSERT false -1 user1
+default table_priv_rev user2 USER SELECT false -1 user1
+default table_priv_rev user2 USER UPDATE false -1 user1
+PREHOOK: query: REVOKE ALL ON TABLE table_priv_rev FROM USER user2
+PREHOOK: type: REVOKE_PRIVILEGE
+PREHOOK: Output: default@table_priv_rev
+POSTHOOK: query: REVOKE ALL ON TABLE table_priv_rev FROM USER user2
+POSTHOOK: type: REVOKE_PRIVILEGE
+POSTHOOK: Output: default@table_priv_rev
+PREHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv_rev
+PREHOOK: type: SHOW_GRANT
+POSTHOOK: query: SHOW GRANT USER user2 ON TABLE table_priv_rev
+POSTHOOK: type: SHOW_GRANT
Modified: hive/branches/tez/ql/src/test/results/clientpositive/authorization_set_show_current_role.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/authorization_set_show_current_role.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/authorization_set_show_current_role.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/authorization_set_show_current_role.q.out Tue Feb 25 07:58:52 2014
@@ -44,8 +44,8 @@ PREHOOK: query: show current roles
PREHOOK: type: SHOW_ROLES
POSTHOOK: query: show current roles
POSTHOOK: type: SHOW_ROLES
-r1
PUBLIC
+r1
PREHOOK: query: set role ADMIN
PREHOOK: type: SHOW_ROLES
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_join1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_join1.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_join1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_join1.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest_j1(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest_j1(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest_j1
PREHOOK: query: explain
FROM src src1 JOIN src src2 ON (src1.key = src2.key)
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_join14_hadoop20.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_join14_hadoop20.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_join14_hadoop20.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_join14_hadoop20.q.out Tue Feb 25 07:58:52 2014
@@ -2,10 +2,12 @@ PREHOOK: query: -- INCLUDE_HADOOP_MAJOR_
CREATE TABLE dest1(c1 INT, c2 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- INCLUDE_HADOOP_MAJOR_VERSIONS(0.20, 0.20S)
CREATE TABLE dest1(c1 INT, c2 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: explain
FROM src JOIN srcpart ON src.key = srcpart.key AND srcpart.ds = '2008-04-08' and src.key > 100
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_join17.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_join17.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_join17.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_join17.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(key1 INT, value1 STRING, key2 INT, value2 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(key1 INT, value1 STRING, key2 INT, value2 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: explain
FROM src src1 JOIN src src2 ON (src1.key = src2.key)
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_join19.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_join19.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_join19.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_join19.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: explain
FROM srcpart src1 JOIN src src2 ON (src1.key = src2.key)
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_join2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_join2.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_join2.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_join2.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest_j2(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest_j2(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest_j2
PREHOOK: query: explain
FROM src src1 JOIN src src2 ON (src1.key = src2.key) JOIN src src3 ON (src1.key + src2.key = src3.key)
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_join24.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_join24.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_join24.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_join24.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: create table tst1(key STRING, cnt INT)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table tst1(key STRING, cnt INT)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tst1
PREHOOK: query: INSERT OVERWRITE TABLE tst1
SELECT a.key, count(1) FROM src a group by a.key
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_join25.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_join25.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_join25.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_join25.q.out Tue Feb 25 07:58:52 2014
@@ -1,9 +1,11 @@
PREHOOK: query: -- This test tests the scenario when the mapper dies. So, create a conditional task for the mapjoin
CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This test tests the scenario when the mapper dies. So, create a conditional task for the mapjoin
CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: FROM srcpart src1 JOIN src src2 ON (src1.key = src2.key)
INSERT OVERWRITE TABLE dest1 SELECT src1.key, src2.value
@@ -54,8 +56,10 @@ POSTHOOK: Lineage: dest1.value SIMPLE [(
407444119660
PREHOOK: query: CREATE TABLE dest_j2(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest_j2(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest_j2
POSTHOOK: Lineage: dest1.key EXPRESSION [(srcpart)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.value SIMPLE [(src)src2.FieldSchema(name:value, type:string, comment:default), ]
@@ -112,8 +116,10 @@ POSTHOOK: Lineage: dest_j2.value SIMPLE
33815990627
PREHOOK: query: CREATE TABLE dest_j1(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest_j1(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest_j1
POSTHOOK: Lineage: dest1.key EXPRESSION [(srcpart)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.value SIMPLE [(src)src2.FieldSchema(name:value, type:string, comment:default), ]
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_join26.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_join26.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_join26.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_join26.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest_j1(key INT, cnt INT)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest_j1(key INT, cnt INT)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest_j1
PREHOOK: query: EXPLAIN
INSERT OVERWRITE TABLE dest_j1
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_join3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_join3.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_join3.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_join3.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: explain
FROM src src1 JOIN src src2 ON (src1.key = src2.key) JOIN src src3 ON (src1.key = src3.key)
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_join32.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_join32.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_join32.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_join32.q.out Tue Feb 25 07:58:52 2014
@@ -1,14 +1,18 @@
PREHOOK: query: -- empty tables
create table studenttab10k (name string, age int, gpa double)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- empty tables
create table studenttab10k (name string, age int, gpa double)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@studenttab10k
PREHOOK: query: create table votertab10k (name string, age int, registration string, contributions float)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table votertab10k (name string, age int, registration string, contributions float)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@votertab10k
PREHOOK: query: explain select s.name, count(distinct registration)
from studenttab10k s join votertab10k v
@@ -111,14 +115,18 @@ POSTHOOK: Input: default@votertab10k
PREHOOK: query: -- smb
create table studenttab10k_smb (name string, age int, gpa double) clustered by (name) sorted by (name) into 2 buckets
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- smb
create table studenttab10k_smb (name string, age int, gpa double) clustered by (name) sorted by (name) into 2 buckets
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@studenttab10k_smb
PREHOOK: query: create table votertab10k_smb (name string, age int, registration string, contributions float) clustered by (name) sorted by (name) into 2 buckets
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table votertab10k_smb (name string, age int, registration string, contributions float) clustered by (name) sorted by (name) into 2 buckets
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@votertab10k_smb
PREHOOK: query: explain select s.name, count(distinct registration)
from studenttab10k_smb s join votertab10k_smb v
@@ -202,27 +210,35 @@ POSTHOOK: Input: default@votertab10k_smb
#### A masked pattern was here ####
PREHOOK: query: load data local inpath '../../data/files/empty1.txt' into table studenttab10k_smb
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@studenttab10k_smb
POSTHOOK: query: load data local inpath '../../data/files/empty1.txt' into table studenttab10k_smb
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@studenttab10k_smb
PREHOOK: query: load data local inpath '../../data/files/empty2.txt' into table studenttab10k_smb
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@studenttab10k_smb
POSTHOOK: query: load data local inpath '../../data/files/empty2.txt' into table studenttab10k_smb
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@studenttab10k_smb
PREHOOK: query: load data local inpath '../../data/files/empty1.txt' into table votertab10k_smb
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@votertab10k_smb
POSTHOOK: query: load data local inpath '../../data/files/empty1.txt' into table votertab10k_smb
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@votertab10k_smb
PREHOOK: query: load data local inpath '../../data/files/empty2.txt' into table votertab10k_smb
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@votertab10k_smb
POSTHOOK: query: load data local inpath '../../data/files/empty2.txt' into table votertab10k_smb
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@votertab10k_smb
PREHOOK: query: explain select s.name, count(distinct registration)
from studenttab10k_smb s join votertab10k_smb v
@@ -307,40 +323,52 @@ POSTHOOK: Input: default@votertab10k_smb
PREHOOK: query: -- smb + partitions
create table studenttab10k_part (name string, age int, gpa double) partitioned by (p string) clustered by (name) sorted by (name) into 2 buckets
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- smb + partitions
create table studenttab10k_part (name string, age int, gpa double) partitioned by (p string) clustered by (name) sorted by (name) into 2 buckets
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@studenttab10k_part
PREHOOK: query: create table votertab10k_part (name string, age int, registration string, contributions float) partitioned by (p string) clustered by (name) sorted by (name) into 2 buckets
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table votertab10k_part (name string, age int, registration string, contributions float) partitioned by (p string) clustered by (name) sorted by (name) into 2 buckets
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@votertab10k_part
PREHOOK: query: load data local inpath '../../data/files/empty1.txt' into table studenttab10k_part partition (p='foo')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@studenttab10k_part
POSTHOOK: query: load data local inpath '../../data/files/empty1.txt' into table studenttab10k_part partition (p='foo')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@studenttab10k_part
POSTHOOK: Output: default@studenttab10k_part@p=foo
PREHOOK: query: load data local inpath '../../data/files/empty2.txt' into table studenttab10k_part partition (p='foo')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@studenttab10k_part@p=foo
POSTHOOK: query: load data local inpath '../../data/files/empty2.txt' into table studenttab10k_part partition (p='foo')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@studenttab10k_part@p=foo
PREHOOK: query: load data local inpath '../../data/files/empty1.txt' into table votertab10k_part partition (p='foo')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@votertab10k_part
POSTHOOK: query: load data local inpath '../../data/files/empty1.txt' into table votertab10k_part partition (p='foo')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@votertab10k_part
POSTHOOK: Output: default@votertab10k_part@p=foo
PREHOOK: query: load data local inpath '../../data/files/empty2.txt' into table votertab10k_part partition (p='foo')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@votertab10k_part@p=foo
POSTHOOK: query: load data local inpath '../../data/files/empty2.txt' into table votertab10k_part partition (p='foo')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@votertab10k_part@p=foo
PREHOOK: query: explain select s.name, count(distinct registration)
from studenttab10k_part s join votertab10k_part v
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_join4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_join4.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_join4.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_join4.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: explain
FROM (
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_join5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_join5.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_join5.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_join5.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: explain
FROM (
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_join6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_join6.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_join6.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_join6.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: explain
FROM (
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_join7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_join7.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_join7.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_join7.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING, c5 INT, c6 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING, c5 INT, c6 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: explain
FROM (
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_join8.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_join8.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_join8.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_join8.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: explain
FROM (
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_join9.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_join9.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_join9.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_join9.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: explain
FROM srcpart src1 JOIN src src2 ON (src1.key = src2.key)
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_join_filters.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_join_filters.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_join_filters.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_join_filters.q.out Tue Feb 25 07:58:52 2014
@@ -1,13 +1,17 @@
PREHOOK: query: CREATE TABLE myinput1(key int, value int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE myinput1(key int, value int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@myinput1
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in3.txt' INTO TABLE myinput1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@myinput1
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in3.txt' INTO TABLE myinput1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@myinput1
PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value
PREHOOK: type: QUERY
@@ -245,37 +249,49 @@ POSTHOOK: Input: default@myinput1
3078400
PREHOOK: query: CREATE TABLE smb_input1(key int, value int) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE smb_input1(key int, value int) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@smb_input1
PREHOOK: query: CREATE TABLE smb_input2(key int, value int) CLUSTERED BY (value) SORTED BY (value) INTO 2 BUCKETS
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE smb_input2(key int, value int) CLUSTERED BY (value) SORTED BY (value) INTO 2 BUCKETS
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@smb_input2
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in1.txt' into table smb_input1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@smb_input1
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in1.txt' into table smb_input1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@smb_input1
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in2.txt' into table smb_input1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@smb_input1
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in2.txt' into table smb_input1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@smb_input1
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in1.txt' into table smb_input2
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@smb_input2
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in1.txt' into table smb_input2
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@smb_input2
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in2.txt' into table smb_input2
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@smb_input2
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in2.txt' into table smb_input2
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@smb_input2
PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value
PREHOOK: type: QUERY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_join_nulls.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_join_nulls.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_join_nulls.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_join_nulls.q.out Tue Feb 25 07:58:52 2014
@@ -1,13 +1,17 @@
PREHOOK: query: CREATE TABLE myinput1(key int, value int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE myinput1(key int, value int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@myinput1
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in1.txt' INTO TABLE myinput1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@myinput1
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in1.txt' INTO TABLE myinput1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@myinput1
PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b
PREHOOK: type: QUERY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out Tue Feb 25 07:58:52 2014
@@ -2,16 +2,20 @@ PREHOOK: query: -- HIVE-5056 RS has expr
create table testsrc ( `key` int,`val` string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- HIVE-5056 RS has expression list for values, but it's ignored in MapJoinProcessor
create table testsrc ( `key` int,`val` string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@testsrc
PREHOOK: query: load data local inpath '../../data/files/kv1.txt' overwrite into table testsrc
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@testsrc
POSTHOOK: query: load data local inpath '../../data/files/kv1.txt' overwrite into table testsrc
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@testsrc
PREHOOK: query: drop table if exists orderpayment_small
PREHOOK: type: DROPTABLE
@@ -19,8 +23,10 @@ POSTHOOK: query: drop table if exists or
POSTHOOK: type: DROPTABLE
PREHOOK: query: create table orderpayment_small (`dealid` int,`date` string,`time` string, `cityid` int, `userid` int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table orderpayment_small (`dealid` int,`date` string,`time` string, `cityid` int, `userid` int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@orderpayment_small
PREHOOK: query: insert overwrite table orderpayment_small select 748, '2011-03-24', '2011-03-24', 55 ,5372613 from testsrc tablesample (1 rows)
PREHOOK: type: QUERY
@@ -46,8 +52,10 @@ POSTHOOK: Lineage: orderpayment_small.ti
POSTHOOK: Lineage: orderpayment_small.userid SIMPLE []
PREHOOK: query: create table user_small( userid int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table user_small( userid int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@user_small
POSTHOOK: Lineage: orderpayment_small.cityid SIMPLE []
POSTHOOK: Lineage: orderpayment_small.date SIMPLE []
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_smb_mapjoin_14.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_smb_mapjoin_14.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_smb_mapjoin_14.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_smb_mapjoin_14.q.out Tue Feb 25 07:58:52 2014
@@ -1,12 +1,16 @@
PREHOOK: query: CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tbl1
PREHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tbl2
PREHOOK: query: insert overwrite table tbl1
select * from src where key < 10
@@ -1420,8 +1424,10 @@ POSTHOOK: Lineage: tbl2.value SIMPLE [(s
20
PREHOOK: query: CREATE TABLE dest1(key int, value string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(key int, value string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: tbl1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tbl1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -1429,8 +1435,10 @@ POSTHOOK: Lineage: tbl2.key EXPRESSION [
POSTHOOK: Lineage: tbl2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: CREATE TABLE dest2(key int, val1 string, val2 string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest2(key int, val1 string, val2 string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest2
POSTHOOK: Lineage: tbl1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tbl1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -1746,8 +1754,10 @@ POSTHOOK: Lineage: tbl2.key EXPRESSION [
POSTHOOK: Lineage: tbl2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: CREATE TABLE dest2(key int, cnt int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest2(key int, cnt int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest2
POSTHOOK: Lineage: dest1.key SIMPLE [(tbl1)a.FieldSchema(name:key, type:int, comment:null), ]
POSTHOOK: Lineage: dest1.value SIMPLE [(tbl1)a.FieldSchema(name:value, type:string, comment:null), ]
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out Tue Feb 25 07:58:52 2014
@@ -3,79 +3,103 @@ PREHOOK: query: -- small 1 part, 2 bucke
CREATE TABLE bucket_small (key string, value string) partitioned by (ds string)
CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- small 1 part, 2 bucket & big 2 part, 4 bucket
CREATE TABLE bucket_small (key string, value string) partitioned by (ds string)
CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@bucket_small
PREHOOK: query: load data local inpath '../../data/files/smallsrcsortbucket1outof4.txt' INTO TABLE bucket_small partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_small
POSTHOOK: query: load data local inpath '../../data/files/smallsrcsortbucket1outof4.txt' INTO TABLE bucket_small partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_small
POSTHOOK: Output: default@bucket_small@ds=2008-04-08
PREHOOK: query: load data local inpath '../../data/files/smallsrcsortbucket2outof4.txt' INTO TABLE bucket_small partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_small@ds=2008-04-08
POSTHOOK: query: load data local inpath '../../data/files/smallsrcsortbucket2outof4.txt' INTO TABLE bucket_small partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_small@ds=2008-04-08
PREHOOK: query: CREATE TABLE bucket_big (key string, value string) partitioned by (ds string) CLUSTERED BY (key) SORTED BY (key) INTO 4 BUCKETS STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE bucket_big (key string, value string) partitioned by (ds string) CLUSTERED BY (key) SORTED BY (key) INTO 4 BUCKETS STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@bucket_big
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket1outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket1outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big
POSTHOOK: Output: default@bucket_big@ds=2008-04-08
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket2outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big@ds=2008-04-08
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket2outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big@ds=2008-04-08
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket3outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big@ds=2008-04-08
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket3outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big@ds=2008-04-08
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket4outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big@ds=2008-04-08
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket4outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big@ds=2008-04-08
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket1outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket1outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big
POSTHOOK: Output: default@bucket_big@ds=2008-04-09
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket2outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big@ds=2008-04-09
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket2outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big@ds=2008-04-09
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket3outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big@ds=2008-04-09
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket3outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big@ds=2008-04-09
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket4outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big@ds=2008-04-09
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket4outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big@ds=2008-04-09
PREHOOK: query: -- Since size is being used to find the big table, the order of the tables in the join does not matter
explain extended select count(*) FROM bucket_small a JOIN bucket_big b ON a.key = b.key
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_10.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_10.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_10.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_10.q.out Tue Feb 25 07:58:52 2014
@@ -1,12 +1,16 @@
PREHOOK: query: CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tbl1
PREHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tbl2
PREHOOK: query: insert overwrite table tbl1
select * from src where key < 10
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_11.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_11.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_11.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_11.q.out Tue Feb 25 07:58:52 2014
@@ -2,78 +2,102 @@ PREHOOK: query: -- small 1 part, 2 bucke
CREATE TABLE bucket_small (key string, value string) partitioned by (ds string) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- small 1 part, 2 bucket & big 2 part, 4 bucket
CREATE TABLE bucket_small (key string, value string) partitioned by (ds string) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@bucket_small
PREHOOK: query: load data local inpath '../../data/files/smallsrcsortbucket1outof4.txt' INTO TABLE bucket_small partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_small
POSTHOOK: query: load data local inpath '../../data/files/smallsrcsortbucket1outof4.txt' INTO TABLE bucket_small partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_small
POSTHOOK: Output: default@bucket_small@ds=2008-04-08
PREHOOK: query: load data local inpath '../../data/files/smallsrcsortbucket2outof4.txt' INTO TABLE bucket_small partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_small@ds=2008-04-08
POSTHOOK: query: load data local inpath '../../data/files/smallsrcsortbucket2outof4.txt' INTO TABLE bucket_small partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_small@ds=2008-04-08
PREHOOK: query: CREATE TABLE bucket_big (key string, value string) partitioned by (ds string) CLUSTERED BY (key) INTO 4 BUCKETS STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE bucket_big (key string, value string) partitioned by (ds string) CLUSTERED BY (key) INTO 4 BUCKETS STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@bucket_big
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket1outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket1outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big
POSTHOOK: Output: default@bucket_big@ds=2008-04-08
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket2outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big@ds=2008-04-08
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket2outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big@ds=2008-04-08
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket3outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big@ds=2008-04-08
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket3outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big@ds=2008-04-08
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket4outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big@ds=2008-04-08
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket4outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big@ds=2008-04-08
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket1outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket1outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big
POSTHOOK: Output: default@bucket_big@ds=2008-04-09
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket2outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big@ds=2008-04-09
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket2outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big@ds=2008-04-09
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket3outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big@ds=2008-04-09
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket3outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big@ds=2008-04-09
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket4outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big@ds=2008-04-09
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket4outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big@ds=2008-04-09
PREHOOK: query: explain extended select count(*) FROM bucket_small a JOIN bucket_big b ON a.key = b.key
PREHOOK: type: QUERY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out Tue Feb 25 07:58:52 2014
@@ -3,105 +3,137 @@ PREHOOK: query: -- small 1 part, 2 bucke
CREATE TABLE bucket_small (key string, value string) partitioned by (ds string)
CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- small 1 part, 2 bucket & big 2 part, 4 bucket
CREATE TABLE bucket_small (key string, value string) partitioned by (ds string)
CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@bucket_small
PREHOOK: query: load data local inpath '../../data/files/smallsrcsortbucket1outof4.txt' INTO TABLE bucket_small partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_small
POSTHOOK: query: load data local inpath '../../data/files/smallsrcsortbucket1outof4.txt' INTO TABLE bucket_small partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_small
POSTHOOK: Output: default@bucket_small@ds=2008-04-08
PREHOOK: query: load data local inpath '../../data/files/smallsrcsortbucket2outof4.txt' INTO TABLE bucket_small partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_small@ds=2008-04-08
POSTHOOK: query: load data local inpath '../../data/files/smallsrcsortbucket2outof4.txt' INTO TABLE bucket_small partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_small@ds=2008-04-08
PREHOOK: query: CREATE TABLE bucket_big (key string, value string) partitioned by (ds string) CLUSTERED BY (key) SORTED BY (key) INTO 4 BUCKETS STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE bucket_big (key string, value string) partitioned by (ds string) CLUSTERED BY (key) SORTED BY (key) INTO 4 BUCKETS STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@bucket_big
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket1outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket1outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big
POSTHOOK: Output: default@bucket_big@ds=2008-04-08
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket2outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big@ds=2008-04-08
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket2outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big@ds=2008-04-08
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket3outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big@ds=2008-04-08
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket3outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big@ds=2008-04-08
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket4outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big@ds=2008-04-08
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket4outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big@ds=2008-04-08
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket1outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket1outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big
POSTHOOK: Output: default@bucket_big@ds=2008-04-09
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket2outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big@ds=2008-04-09
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket2outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big@ds=2008-04-09
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket3outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big@ds=2008-04-09
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket3outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big@ds=2008-04-09
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket4outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big@ds=2008-04-09
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket4outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big@ds=2008-04-09
PREHOOK: query: CREATE TABLE bucket_medium (key string, value string) partitioned by (ds string)
CLUSTERED BY (key) SORTED BY (key) INTO 3 BUCKETS STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE bucket_medium (key string, value string) partitioned by (ds string)
CLUSTERED BY (key) SORTED BY (key) INTO 3 BUCKETS STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@bucket_medium
PREHOOK: query: load data local inpath '../../data/files/smallsrcsortbucket1outof4.txt' INTO TABLE bucket_medium partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_medium
POSTHOOK: query: load data local inpath '../../data/files/smallsrcsortbucket1outof4.txt' INTO TABLE bucket_medium partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_medium
POSTHOOK: Output: default@bucket_medium@ds=2008-04-08
PREHOOK: query: load data local inpath '../../data/files/smallsrcsortbucket2outof4.txt' INTO TABLE bucket_medium partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_medium@ds=2008-04-08
POSTHOOK: query: load data local inpath '../../data/files/smallsrcsortbucket2outof4.txt' INTO TABLE bucket_medium partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_medium@ds=2008-04-08
PREHOOK: query: load data local inpath '../../data/files/smallsrcsortbucket3outof4.txt' INTO TABLE bucket_medium partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_medium@ds=2008-04-08
POSTHOOK: query: load data local inpath '../../data/files/smallsrcsortbucket3outof4.txt' INTO TABLE bucket_medium partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_medium@ds=2008-04-08
PREHOOK: query: explain extended select count(*) FROM bucket_small a JOIN bucket_medium b ON a.key = b.key JOIN bucket_big c ON c.key = b.key JOIN bucket_medium d ON c.key = b.key
PREHOOK: type: QUERY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_13.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_13.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_13.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_13.q.out Tue Feb 25 07:58:52 2014
@@ -1,12 +1,16 @@
PREHOOK: query: CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tbl1
PREHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tbl2
PREHOOK: query: insert overwrite table tbl1 select * from src where key < 10
PREHOOK: type: QUERY
@@ -32,8 +36,10 @@ POSTHOOK: Lineage: tbl2.key EXPRESSION [
POSTHOOK: Lineage: tbl2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: CREATE TABLE dest1(k1 int, k2 int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(k1 int, k2 int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: tbl1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tbl1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -41,8 +47,10 @@ POSTHOOK: Lineage: tbl2.key EXPRESSION [
POSTHOOK: Lineage: tbl2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: CREATE TABLE dest2(k1 string, k2 string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest2(k1 string, k2 string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest2
POSTHOOK: Lineage: tbl1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tbl1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_14.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_14.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_14.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_14.q.out Tue Feb 25 07:58:52 2014
@@ -1,12 +1,16 @@
PREHOOK: query: CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tbl1
PREHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tbl2
PREHOOK: query: insert overwrite table tbl1 select * from src where key < 20
PREHOOK: type: QUERY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_15.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_15.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_15.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/auto_sortmerge_join_15.q.out Tue Feb 25 07:58:52 2014
@@ -1,12 +1,16 @@
PREHOOK: query: CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tbl1
PREHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tbl2
PREHOOK: query: insert overwrite table tbl1 select * from src where key < 20
PREHOOK: type: QUERY