You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by th...@apache.org on 2014/08/27 19:36:26 UTC
svn commit: r1620949 [2/4] - in /hive/trunk:
contrib/src/test/results/clientnegative/
contrib/src/test/results/clientpositive/
hbase-handler/src/test/results/negative/
itests/hive-unit/src/test/java/org/apache/hadoop/hive/ql/security/authorization/plug...
Modified: hive/trunk/ql/src/test/results/clientpositive/alter_skewed_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_skewed_table.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter_skewed_table.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter_skewed_table.q.out Wed Aug 27 17:36:23 2014
@@ -101,12 +101,11 @@ POSTHOOK: Output: database:skew_test
PREHOOK: query: create table skew_test.original2 (key STRING, value STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:skew_test
-PREHOOK: Output: skew_test@skew_test.original2
+PREHOOK: Output: skew_test@original2
POSTHOOK: query: create table skew_test.original2 (key STRING, value STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:skew_test
POSTHOOK: Output: skew_test@original2
-POSTHOOK: Output: skew_test@skew_test.original2
PREHOOK: query: describe formatted skew_test.original2
PREHOOK: type: DESCTABLE
PREHOOK: Input: skew_test@original2
@@ -196,12 +195,11 @@ POSTHOOK: Output: skew_test@original2
PREHOOK: query: create table skew_test.original3 (key STRING, value STRING) SKEWED BY (key, value) ON ((1,1),(5,6))
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:skew_test
-PREHOOK: Output: skew_test@skew_test.original3
+PREHOOK: Output: skew_test@original3
POSTHOOK: query: create table skew_test.original3 (key STRING, value STRING) SKEWED BY (key, value) ON ((1,1),(5,6))
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:skew_test
POSTHOOK: Output: skew_test@original3
-POSTHOOK: Output: skew_test@skew_test.original3
PREHOOK: query: describe formatted skew_test.original3
PREHOOK: type: DESCTABLE
PREHOOK: Input: skew_test@original3
Modified: hive/trunk/ql/src/test/results/clientpositive/alter_table_update_status.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_table_update_status.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter_table_update_status.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter_table_update_status.q.out Wed Aug 27 17:36:23 2014
@@ -1,9 +1,12 @@
PREHOOK: query: create table src_stat as select * from src1
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@src_stat
POSTHOOK: query: create table src_stat as select * from src1
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src1
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_stat
PREHOOK: query: create table src_stat_int (
key double,
Modified: hive/trunk/ql/src/test/results/clientpositive/alter_varchar1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_varchar1.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter_varchar1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter_varchar1.q.out Wed Aug 27 17:36:23 2014
@@ -10,12 +10,11 @@ POSTHOOK: type: CREATEDATABASE
POSTHOOK: Output: database:avc
PREHOOK: query: create table avc.alter_varchar_1 (key string, value string)
PREHOOK: type: CREATETABLE
-PREHOOK: Output: avc@avc.alter_varchar_1
+PREHOOK: Output: avc@alter_varchar_1
PREHOOK: Output: database:avc
POSTHOOK: query: create table avc.alter_varchar_1 (key string, value string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: avc@alter_varchar_1
-POSTHOOK: Output: avc@avc.alter_varchar_1
POSTHOOK: Output: database:avc
PREHOOK: query: insert overwrite table avc.alter_varchar_1
select key, value from src order by key limit 5
Modified: hive/trunk/ql/src/test/results/clientpositive/alter_view_as_select.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_view_as_select.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter_view_as_select.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter_view_as_select.q.out Wed Aug 27 17:36:23 2014
@@ -7,9 +7,12 @@ POSTHOOK: Output: database:tv
PREHOOK: query: CREATE VIEW tv.testView as SELECT * FROM srcpart
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@srcpart
+PREHOOK: Output: database:tv
+PREHOOK: Output: tv@testView
POSTHOOK: query: CREATE VIEW tv.testView as SELECT * FROM srcpart
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@srcpart
+POSTHOOK: Output: database:tv
POSTHOOK: Output: tv@testView
PREHOOK: query: DESCRIBE FORMATTED tv.testView
PREHOOK: type: DESCTABLE
@@ -48,9 +51,13 @@ View Expanded Text: SELECT `srcpart`.`k
PREHOOK: query: ALTER VIEW tv.testView AS SELECT value FROM src WHERE key=86
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:tv
+PREHOOK: Output: tv@testView
POSTHOOK: query: ALTER VIEW tv.testView AS SELECT value FROM src WHERE key=86
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:tv
+POSTHOOK: Output: tv@testView
POSTHOOK: Output: tv@testview
PREHOOK: query: DESCRIBE FORMATTED tv.testView
PREHOOK: type: DESCTABLE
@@ -90,6 +97,8 @@ ORDER BY key, value
LIMIT 10
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:tv
+PREHOOK: Output: tv@testView
POSTHOOK: query: ALTER VIEW tv.testView AS
SELECT * FROM src
WHERE key > 80 AND key < 100
@@ -97,6 +106,8 @@ ORDER BY key, value
LIMIT 10
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:tv
+POSTHOOK: Output: tv@testView
POSTHOOK: Output: tv@testview
PREHOOK: query: DESCRIBE FORMATTED tv.testView
PREHOOK: type: DESCTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/alter_view_rename.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_view_rename.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter_view_rename.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter_view_rename.q.out Wed Aug 27 17:36:23 2014
@@ -21,9 +21,12 @@ POSTHOOK: Output: default@invites
PREHOOK: query: CREATE VIEW tv1.view1 as SELECT * FROM invites
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@invites
+PREHOOK: Output: database:tv1
+PREHOOK: Output: tv1@view1
POSTHOOK: query: CREATE VIEW tv1.view1 as SELECT * FROM invites
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@invites
+POSTHOOK: Output: database:tv1
POSTHOOK: Output: tv1@view1
PREHOOK: query: DESCRIBE EXTENDED tv1.view1
PREHOOK: type: DESCTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/archive_multi.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/archive_multi.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/archive_multi.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/archive_multi.q.out Wed Aug 27 17:36:23 2014
@@ -6,11 +6,10 @@ POSTHOOK: type: CREATEDATABASE
POSTHOOK: Output: database:ac_test
PREHOOK: query: create table ac_test.tstsrc like default.src
PREHOOK: type: CREATETABLE
-PREHOOK: Output: ac_test@ac_test.tstsrc
+PREHOOK: Output: ac_test@tstsrc
PREHOOK: Output: database:ac_test
POSTHOOK: query: create table ac_test.tstsrc like default.src
POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: ac_test@ac_test.tstsrc
POSTHOOK: Output: ac_test@tstsrc
POSTHOOK: Output: database:ac_test
PREHOOK: query: insert overwrite table ac_test.tstsrc select key, value from default.src
@@ -25,11 +24,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 ac_test.tstsrcpart like default.srcpart
PREHOOK: type: CREATETABLE
-PREHOOK: Output: ac_test@ac_test.tstsrcpart
+PREHOOK: Output: ac_test@tstsrcpart
PREHOOK: Output: database:ac_test
POSTHOOK: query: create table ac_test.tstsrcpart like default.srcpart
POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: ac_test@ac_test.tstsrcpart
POSTHOOK: Output: ac_test@tstsrcpart
POSTHOOK: Output: database:ac_test
PREHOOK: query: insert overwrite table ac_test.tstsrcpart partition (ds='2008-04-08', hr='11')
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_1.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_1.q.out Wed Aug 27 17:36:23 2014
@@ -3,11 +3,14 @@ PREHOOK: query: -- SORT_BEFORE_DIFF
create table src_autho_test as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@src_autho_test
POSTHOOK: query: -- SORT_BEFORE_DIFF
create table src_autho_test as select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_autho_test
PREHOOK: query: --table grant to user
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_2.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_2.q.out Wed Aug 27 17:36:23 2014
@@ -13,9 +13,12 @@ POSTHOOK: Output: default@authorization_
PREHOOK: query: create table src_auth_tmp as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@src_auth_tmp
POSTHOOK: query: create table src_auth_tmp as select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_auth_tmp
PREHOOK: query: ALTER TABLE authorization_part SET TBLPROPERTIES ("PARTITION_LEVEL_PRIVILEGE"="TRUE")
PREHOOK: type: ALTERTABLE_PROPERTIES
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_3.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_3.q.out Wed Aug 27 17:36:23 2014
@@ -3,11 +3,14 @@ PREHOOK: query: -- SORT_BEFORE_DIFF
create table src_autho_test as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@src_autho_test
POSTHOOK: query: -- SORT_BEFORE_DIFF
create table src_autho_test as select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_autho_test
PREHOOK: query: grant drop on table src_autho_test to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_4.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_4.q.out Wed Aug 27 17:36:23 2014
@@ -3,11 +3,14 @@ PREHOOK: query: -- SORT_BEFORE_DIFF
create table src_autho_test as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@src_autho_test
POSTHOOK: query: -- SORT_BEFORE_DIFF
create table src_autho_test as select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_autho_test
PREHOOK: query: grant All on table src_autho_test to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_6.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_6.q.out Wed Aug 27 17:36:23 2014
@@ -3,11 +3,14 @@ PREHOOK: query: -- SORT_BEFORE_DIFF
create table src_auth_tmp as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@src_auth_tmp
POSTHOOK: query: -- SORT_BEFORE_DIFF
create table src_auth_tmp as select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_auth_tmp
PREHOOK: query: create table authorization_part (key int, value string) partitioned by (ds string)
PREHOOK: type: CREATETABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_8.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_8.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_8.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_8.q.out Wed Aug 27 17:36:23 2014
@@ -13,9 +13,12 @@ POSTHOOK: Output: default@tbl_j5jbymsx8e
PREHOOK: query: CREATE VIEW view_j5jbymsx8e_1 as SELECT * FROM tbl_j5jbymsx8e
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@tbl_j5jbymsx8e
+PREHOOK: Output: database:default
+PREHOOK: Output: default@view_j5jbymsx8e_1
POSTHOOK: query: CREATE VIEW view_j5jbymsx8e_1 as SELECT * FROM tbl_j5jbymsx8e
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@tbl_j5jbymsx8e
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@view_j5jbymsx8e_1
PREHOOK: query: DESCRIBE view_j5jbymsx8e_1
PREHOOK: type: DESCTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_cli_createtab.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_cli_createtab.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_cli_createtab.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_cli_createtab.q.out Wed Aug 27 17:36:23 2014
@@ -23,9 +23,12 @@ default t_cli hive_test_user USER UPDA
PREHOOK: query: create view v_cli (i) as select i from t_cli
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@t_cli
+PREHOOK: Output: database:default
+PREHOOK: Output: default@v_cli
POSTHOOK: query: create view v_cli (i) as select i from t_cli
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@t_cli
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@v_cli
PREHOOK: query: show grant user hive_test_user on v_cli
PREHOOK: type: SHOW_GRANT
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_create_temp_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_create_temp_table.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_create_temp_table.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_create_temp_table.q.out Wed Aug 27 17:36:23 2014
@@ -1,9 +1,12 @@
PREHOOK: query: create table authorization_create_temp_table_1 as select * from src limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@authorization_create_temp_table_1
POSTHOOK: query: create table authorization_create_temp_table_1 as select * from src limit 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@authorization_create_temp_table_1
PREHOOK: query: grant select on authorization_create_temp_table_1 to user user1
PREHOOK: type: GRANT_PRIVILEGE
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_owner_actions.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_owner_actions.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_owner_actions.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_owner_actions.q.out Wed Aug 27 17:36:23 2014
@@ -35,9 +35,12 @@ POSTHOOK: Output: default@t1
PREHOOK: query: create view vt1 as select * from t1
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@t1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@vt1
POSTHOOK: query: create view vt1 as select * from t1
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@t1
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@vt1
PREHOOK: query: drop view vt1
PREHOOK: type: DROPVIEW
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_view_sqlstd.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_view_sqlstd.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_view_sqlstd.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_view_sqlstd.q.out Wed Aug 27 17:36:23 2014
@@ -22,19 +22,25 @@ PREHOOK: query: -- protecting certain co
create view vt1 as select i,k from t1
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@t1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@vt1
POSTHOOK: query: -- protecting certain columns
create view vt1 as select i,k from t1
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@t1
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@vt1
PREHOOK: query: -- protecting certain rows
create view vt2 as select * from t1 where i > 1
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@t1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@vt2
POSTHOOK: query: -- protecting certain rows
create view vt2 as select * from t1 where i > 1
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@t1
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@vt2
PREHOOK: query: show grant user user1 on all
PREHOOK: type: SHOW_GRANT
Modified: hive/trunk/ql/src/test/results/clientpositive/autogen_colalias.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/autogen_colalias.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/autogen_colalias.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/autogen_colalias.q.out Wed Aug 27 17:36:23 2014
@@ -10,12 +10,15 @@ PREHOOK: query: create table dest_groupe
from src group by src.key
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@dest_grouped_old1
POSTHOOK: query: create table dest_grouped_old1 as select 1+1, 2+2 as zz, src.key, test_max(length(src.value)), count(src.value), sin(count(src.value)), count(sin(src.value)), unix_timestamp(), CAST(SUM(IF(value > 10, value, 1)) AS INT), if(src.key > 1,
1,
0)
from src group by src.key
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest_grouped_old1
PREHOOK: query: describe dest_grouped_old1
PREHOOK: type: DESCTABLE
@@ -36,9 +39,12 @@ _c9 int
PREHOOK: query: create table dest_grouped_old2 as select distinct src.key from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@dest_grouped_old2
POSTHOOK: query: create table dest_grouped_old2 as select distinct src.key from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest_grouped_old2
PREHOOK: query: describe dest_grouped_old2
PREHOOK: type: DESCTABLE
@@ -53,12 +59,15 @@ PREHOOK: query: create table dest_groupe
from src group by src.key
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@dest_grouped_new1
POSTHOOK: query: create table dest_grouped_new1 as select 1+1, 2+2 as zz, ((src.key % 2)+2)/2, test_max(length(src.value)), count(src.value), sin(count(src.value)), count(sin(src.value)), unix_timestamp(), CAST(SUM(IF(value > 10, value, 1)) AS INT), if(src.key > 10,
(src.key +5) % 2,
0)
from src group by src.key
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest_grouped_new1
PREHOOK: query: describe dest_grouped_new1
PREHOOK: type: DESCTABLE
@@ -79,9 +88,12 @@ if_src_key_10_src_ke_9 double
PREHOOK: query: create table dest_grouped_new2 as select distinct src.key from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@dest_grouped_new2
POSTHOOK: query: create table dest_grouped_new2 as select distinct src.key from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest_grouped_new2
PREHOOK: query: describe dest_grouped_new2
PREHOOK: type: DESCTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/char_nested_types.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/char_nested_types.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/char_nested_types.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/char_nested_types.q.out Wed Aug 27 17:36:23 2014
@@ -164,11 +164,14 @@ create table char_nested_cta as
select * from char_nested_struct
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@char_nested_struct
+PREHOOK: Output: database:default
+PREHOOK: Output: default@char_nested_cta
POSTHOOK: query: -- nested type with create table as
create table char_nested_cta as
select * from char_nested_struct
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@char_nested_struct
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@char_nested_cta
PREHOOK: query: describe char_nested_cta
PREHOOK: type: DESCTABLE
@@ -191,11 +194,14 @@ create table char_nested_view as
select * from char_nested_struct
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@char_nested_struct
+PREHOOK: Output: database:default
+PREHOOK: Output: default@char_nested_view
POSTHOOK: query: -- nested type with view
create table char_nested_view as
select * from char_nested_struct
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@char_nested_struct
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@char_nested_view
PREHOOK: query: describe char_nested_view
PREHOOK: type: DESCTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/colstats_all_nulls.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/colstats_all_nulls.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/colstats_all_nulls.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/colstats_all_nulls.q.out Wed Aug 27 17:36:23 2014
@@ -17,9 +17,12 @@ POSTHOOK: Output: default@src_null
PREHOOK: query: create table all_nulls as SELECT a, cast(a as double) as b, cast(a as decimal) as c FROM src_null where a is null limit 5
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src_null
+PREHOOK: Output: database:default
+PREHOOK: Output: default@all_nulls
POSTHOOK: query: create table all_nulls as SELECT a, cast(a as double) as b, cast(a as decimal) as c FROM src_null where a is null limit 5
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src_null
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@all_nulls
PREHOOK: query: analyze table all_nulls compute statistics for columns
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/create_big_view.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_big_view.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_big_view.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_big_view.q.out Wed Aug 27 17:36:23 2014
@@ -243,6 +243,8 @@ CREATE VIEW big_view AS SELECT
FROM src
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@big_view
POSTHOOK: query: -- Define a view with long SQL text to test metastore and other limits.
CREATE VIEW big_view AS SELECT
@@ -484,6 +486,7 @@ CREATE VIEW big_view AS SELECT
FROM src
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@big_view
PREHOOK: query: SELECT a FROM big_view
LIMIT 1
Modified: hive/trunk/ql/src/test/results/clientpositive/create_default_prop.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_default_prop.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_default_prop.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_default_prop.q.out Wed Aug 27 17:36:23 2014
@@ -35,9 +35,12 @@ a string
PREHOOK: query: CREATE TABLE table_p3 AS SELECT * FROM table_p1
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@table_p1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@table_p3
POSTHOOK: query: CREATE TABLE table_p3 AS SELECT * FROM table_p1
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@table_p1
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@table_p3
PREHOOK: query: DESC EXTENDED table_p3
PREHOOK: type: DESCTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/create_like_tbl_props.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_like_tbl_props.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_like_tbl_props.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_like_tbl_props.q.out Wed Aug 27 17:36:23 2014
@@ -181,11 +181,14 @@ PREHOOK: query: --Test that CREATE TALBE
CREATE VIEW test_view (key, value) AS SELECT * FROM src
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@test_view
POSTHOOK: query: --Test that CREATE TALBE LIKE on a view can take explicit table properties
CREATE VIEW test_view (key, value) AS SELECT * FROM src
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@test_view
PREHOOK: query: CREATE TABLE test_table4 LIKE test_view TBLPROPERTIES('key'='value')
PREHOOK: type: CREATETABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/create_like_view.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_like_view.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_like_view.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_like_view.q.out Wed Aug 27 17:36:23 2014
@@ -68,9 +68,12 @@ Storage Desc Params:
PREHOOK: query: CREATE VIEW view1 AS SELECT * FROM table1
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@table1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@view1
POSTHOOK: query: CREATE VIEW view1 AS SELECT * FROM table1
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@table1
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@view1
PREHOOK: query: CREATE TABLE table2 LIKE view1
PREHOOK: type: CREATETABLE
@@ -242,10 +245,13 @@ PREHOOK: query: -- check partitions
create view view1 partitioned on (ds, hr) as select * from srcpart
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@srcpart
+PREHOOK: Output: database:default
+PREHOOK: Output: default@view1
POSTHOOK: query: -- check partitions
create view view1 partitioned on (ds, hr) as select * from srcpart
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@srcpart
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@view1
PREHOOK: query: create table table1 like view1
PREHOOK: type: CREATETABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/create_or_replace_view.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_or_replace_view.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_or_replace_view.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_or_replace_view.q.out Wed Aug 27 17:36:23 2014
@@ -7,9 +7,12 @@ POSTHOOK: Output: database:vt
PREHOOK: query: create view vt.v as select * from srcpart
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@srcpart
+PREHOOK: Output: database:vt
+PREHOOK: Output: vt@v
POSTHOOK: query: create view vt.v as select * from srcpart
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@srcpart
+POSTHOOK: Output: database:vt
POSTHOOK: Output: vt@v
PREHOOK: query: describe formatted vt.v
PREHOOK: type: DESCTABLE
@@ -49,10 +52,13 @@ PREHOOK: query: -- modifying definition
create or replace view vt.v partitioned on (ds, hr) as select * from srcpart
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@srcpart
+PREHOOK: Output: database:vt
+PREHOOK: Output: vt@v
POSTHOOK: query: -- modifying definition of unpartitioned view
create or replace view vt.v partitioned on (ds, hr) as select * from srcpart
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@srcpart
+POSTHOOK: Output: database:vt
POSTHOOK: Output: vt@v
PREHOOK: query: alter view vt.v add partition (ds='2008-04-08',hr='11')
PREHOOK: type: ALTERTABLE_ADDPARTS
@@ -167,10 +173,13 @@ PREHOOK: query: -- altering partitioned
create or replace view vt.v partitioned on (ds, hr) as select value, ds, hr from srcpart
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@srcpart
+PREHOOK: Output: database:vt
+PREHOOK: Output: vt@v
POSTHOOK: query: -- altering partitioned view 1
create or replace view vt.v partitioned on (ds, hr) as select value, ds, hr from srcpart
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@srcpart
+POSTHOOK: Output: database:vt
POSTHOOK: Output: vt@v
PREHOOK: query: select * from vt.v where value='val_409' and ds='2008-04-08' and hr='11'
PREHOOK: type: QUERY
@@ -234,10 +243,13 @@ PREHOOK: query: -- altering partitioned
create or replace view vt.v partitioned on (ds, hr) as select key, value, ds, hr from srcpart
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@srcpart
+PREHOOK: Output: database:vt
+PREHOOK: Output: vt@v
POSTHOOK: query: -- altering partitioned view 2
create or replace view vt.v partitioned on (ds, hr) as select key, value, ds, hr from srcpart
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@srcpart
+POSTHOOK: Output: database:vt
POSTHOOK: Output: vt@v
PREHOOK: query: select * from vt.v where value='val_409' and ds='2008-04-08' and hr='11'
PREHOOK: type: QUERY
@@ -319,9 +331,12 @@ POSTHOOK: Output: default@srcpart_temp
PREHOOK: query: create view vt.v partitioned on (ds, hr) as select * from srcpart_temp
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@srcpart_temp
+PREHOOK: Output: database:vt
+PREHOOK: Output: vt@v
POSTHOOK: query: create view vt.v partitioned on (ds, hr) as select * from srcpart_temp
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@srcpart_temp
+POSTHOOK: Output: database:vt
POSTHOOK: Output: vt@v
PREHOOK: query: drop table srcpart_temp
PREHOOK: type: DROPTABLE
@@ -335,10 +350,13 @@ PREHOOK: query: -- vt.v is now invalid
create or replace view vt.v partitioned on (ds, hr) as select * from srcpart
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@srcpart
+PREHOOK: Output: database:vt
+PREHOOK: Output: vt@v
POSTHOOK: query: -- vt.v is now invalid
create or replace view vt.v partitioned on (ds, hr) as select * from srcpart
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@srcpart
+POSTHOOK: Output: database:vt
POSTHOOK: Output: vt@v
PREHOOK: query: describe formatted vt.v
PREHOOK: type: DESCTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/create_union_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_union_table.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_union_table.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_union_table.q.out Wed Aug 27 17:36:23 2014
@@ -15,7 +15,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: abc
+ name: default.abc
PREHOOK: query: create table abc(mydata uniontype<int,double,array<string>,struct<a:int,b:string>>,
strct struct<a:int, b:string, c:string>)
Modified: hive/trunk/ql/src/test/results/clientpositive/create_view.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_view.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_view.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_view.q.out Wed Aug 27 17:36:23 2014
@@ -86,27 +86,36 @@ POSTHOOK: Input: default@src
PREHOOK: query: CREATE VIEW view1 AS SELECT value FROM src WHERE key=86
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@view1
POSTHOOK: query: CREATE VIEW view1 AS SELECT value FROM src WHERE key=86
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@view1
PREHOOK: query: CREATE VIEW view2 AS SELECT * FROM src
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@view2
POSTHOOK: query: CREATE VIEW view2 AS SELECT * FROM src
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@view2
PREHOOK: query: CREATE VIEW view3(valoo)
TBLPROPERTIES ("fear" = "factor")
AS SELECT upper(value) FROM src WHERE key=86
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@view3
POSTHOOK: query: CREATE VIEW view3(valoo)
TBLPROPERTIES ("fear" = "factor")
AS SELECT upper(value) FROM src WHERE key=86
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@view3
PREHOOK: query: SELECT * from view1
PREHOOK: type: QUERY
@@ -159,8 +168,8 @@ STAGE PLANS:
Create View
or replace: false
columns: valoo string
- expanded text: SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `default`.`src` WHERE `src`.`key`=86) `view0`
- name: view0
+ expanded text: SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `default`.`src` WHERE `src`.`key`=86) `default.view0`
+ name: default.view0
original text: SELECT upper(value) FROM src WHERE key=86
PREHOOK: query: -- make sure EXPLAIN works with a query which references a view
@@ -354,7 +363,7 @@ Sort Columns: []
# View Information
View Original Text: SELECT upper(value) FROM src WHERE key=86
-View Expanded Text: SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `default`.`src` WHERE `src`.`key`=86) `view3`
+View Expanded Text: SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `default`.`src` WHERE `src`.`key`=86) `default.view3`
PREHOOK: query: ALTER VIEW view3 SET TBLPROPERTIES ("biggest" = "loser")
PREHOOK: type: ALTERVIEW_PROPERTIES
PREHOOK: Input: default@view3
@@ -404,7 +413,7 @@ Sort Columns: []
# View Information
View Original Text: SELECT upper(value) FROM src WHERE key=86
-View Expanded Text: SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `default`.`src` WHERE `src`.`key`=86) `view3`
+View Expanded Text: SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `default`.`src` WHERE `src`.`key`=86) `default.view3`
PREHOOK: query: CREATE TABLE table1 (key int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
@@ -470,9 +479,12 @@ POSTHOOK: Input: default@table1
PREHOOK: query: CREATE VIEW view4 AS SELECT * FROM table1
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@table1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@view4
POSTHOOK: query: CREATE VIEW view4 AS SELECT * FROM table1
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@table1
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@view4
PREHOOK: query: SELECT * FROM view4
PREHOOK: type: QUERY
@@ -540,11 +552,14 @@ FROM view4 v1 join view4 v2
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@table1
PREHOOK: Input: default@view4
+PREHOOK: Output: database:default
+PREHOOK: Output: default@view5
POSTHOOK: query: CREATE VIEW view5 AS SELECT v1.key as key1, v2.key as key2
FROM view4 v1 join view4 v2
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@table1
POSTHOOK: Input: default@view4
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@view5
Warning: Shuffle Join JOIN[6][tables = [v1, v2]] in Stage 'Stage-1:MAPRED' is a cross product
PREHOOK: query: SELECT * FROM view5
@@ -574,12 +589,15 @@ CREATE VIEW view6(valoo COMMENT 'I canno
SELECT upper(value) as blarg FROM src WHERE key=86
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@view6
POSTHOOK: query: -- verify that column name and comment in DDL portion
-- overrides column alias in SELECT
CREATE VIEW view6(valoo COMMENT 'I cannot spell') AS
SELECT upper(value) as blarg FROM src WHERE key=86
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@view6
PREHOOK: query: DESCRIBE view6
PREHOOK: type: DESCTABLE
@@ -596,6 +614,8 @@ ORDER BY key, value
LIMIT 10
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@view7
POSTHOOK: query: -- verify that ORDER BY and LIMIT are both supported in view def
CREATE VIEW view7 AS
SELECT * FROM src
@@ -604,6 +624,7 @@ ORDER BY key, value
LIMIT 10
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@view7
PREHOOK: query: SELECT * FROM view7
PREHOOK: type: QUERY
@@ -705,11 +726,14 @@ SELECT test_translate('abc', 'a', 'b')
FROM table1
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@table1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@view8
POSTHOOK: query: CREATE VIEW view8(c) AS
SELECT test_translate('abc', 'a', 'b')
FROM table1
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@table1
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@view8
PREHOOK: query: DESCRIBE EXTENDED view8
PREHOOK: type: DESCTABLE
@@ -721,7 +745,7 @@ c string
#### A masked pattern was here ####
FROM table1, viewExpandedText:SELECT `_c0` AS `c` FROM (SELECT `test_translate`('abc', 'a', 'b')
-FROM `default`.`table1`) `view8`, tableType:VIRTUAL_VIEW)
+FROM `default`.`table1`) `default.view8`, tableType:VIRTUAL_VIEW)
PREHOOK: query: DESCRIBE FORMATTED view8
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@view8
@@ -754,7 +778,7 @@ Sort Columns: []
View Original Text: SELECT test_translate('abc', 'a', 'b')
FROM table1
View Expanded Text: SELECT `_c0` AS `c` FROM (SELECT `test_translate`('abc', 'a', 'b')
-FROM `default`.`table1`) `view8`
+FROM `default`.`table1`) `default.view8`
PREHOOK: query: SELECT * FROM view8
PREHOOK: type: QUERY
PREHOOK: Input: default@table1
@@ -782,12 +806,15 @@ SELECT test_max(length(value))
FROM src
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@view9
POSTHOOK: query: -- disable map-side aggregation
CREATE VIEW view9(m) AS
SELECT test_max(length(value))
FROM src
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@view9
PREHOOK: query: DESCRIBE EXTENDED view9
PREHOOK: type: DESCTABLE
@@ -799,7 +826,7 @@ m int
#### A masked pattern was here ####
FROM src, viewExpandedText:SELECT `_c0` AS `m` FROM (SELECT `test_max`(length(`src`.`value`))
-FROM `default`.`src`) `view9`, tableType:VIRTUAL_VIEW)
+FROM `default`.`src`) `default.view9`, tableType:VIRTUAL_VIEW)
PREHOOK: query: DESCRIBE FORMATTED view9
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@view9
@@ -832,7 +859,7 @@ Sort Columns: []
View Original Text: SELECT test_max(length(value))
FROM src
View Expanded Text: SELECT `_c0` AS `m` FROM (SELECT `test_max`(length(`src`.`value`))
-FROM `default`.`src`) `view9`
+FROM `default`.`src`) `default.view9`
PREHOOK: query: SELECT * FROM view9
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -858,12 +885,15 @@ SELECT test_max(length(value))
FROM src
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@view9
POSTHOOK: query: -- enable map-side aggregation
CREATE VIEW view9(m) AS
SELECT test_max(length(value))
FROM src
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@view9
PREHOOK: query: DESCRIBE EXTENDED view9
PREHOOK: type: DESCTABLE
@@ -875,7 +905,7 @@ m int
#### A masked pattern was here ####
FROM src, viewExpandedText:SELECT `_c0` AS `m` FROM (SELECT `test_max`(length(`src`.`value`))
-FROM `default`.`src`) `view9`, tableType:VIRTUAL_VIEW)
+FROM `default`.`src`) `default.view9`, tableType:VIRTUAL_VIEW)
PREHOOK: query: DESCRIBE FORMATTED view9
PREHOOK: type: DESCTABLE
PREHOOK: Input: default@view9
@@ -908,7 +938,7 @@ Sort Columns: []
View Original Text: SELECT test_max(length(value))
FROM src
View Expanded Text: SELECT `_c0` AS `m` FROM (SELECT `test_max`(length(`src`.`value`))
-FROM `default`.`src`) `view9`
+FROM `default`.`src`) `default.view9`
PREHOOK: query: SELECT * FROM view9
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -925,11 +955,14 @@ CREATE VIEW view10 AS
SELECT slurp.* FROM (SELECT * FROM src WHERE key=86) slurp
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@view10
POSTHOOK: query: -- test usage of a subselect within a view
CREATE VIEW view10 AS
SELECT slurp.* FROM (SELECT * FROM src WHERE key=86) slurp
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@view10
PREHOOK: query: DESCRIBE EXTENDED view10
PREHOOK: type: DESCTABLE
@@ -999,11 +1032,14 @@ SELECT test_explode(array(1,2,3)) AS (bo
FROM table1
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@table1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@view11
POSTHOOK: query: CREATE VIEW view11 AS
SELECT test_explode(array(1,2,3)) AS (boom)
FROM table1
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@table1
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@view11
PREHOOK: query: DESCRIBE EXTENDED view11
PREHOOK: type: DESCTABLE
@@ -1067,11 +1103,14 @@ CREATE VIEW view12 AS
SELECT * FROM src LATERAL VIEW explode(array(1,2,3)) myTable AS myCol
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@view12
POSTHOOK: query: -- test usage of LATERAL within a view
CREATE VIEW view12 AS
SELECT * FROM src LATERAL VIEW explode(array(1,2,3)) myTable AS myCol
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@view12
PREHOOK: query: DESCRIBE EXTENDED view12
PREHOOK: type: DESCTABLE
@@ -1151,12 +1190,15 @@ SELECT s.key
FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 ON key) s
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@srcbucket
+PREHOOK: Output: database:default
+PREHOOK: Output: default@view13
POSTHOOK: query: -- test usage of TABLESAMPLE within a view
CREATE VIEW view13 AS
SELECT s.key
FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 ON key) s
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@srcbucket
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@view13
PREHOOK: query: DESCRIBE EXTENDED view13
PREHOOK: type: DESCTABLE
@@ -1240,6 +1282,8 @@ JOIN
ON (unionsrc1.key = unionsrc2.key)
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@view14
POSTHOOK: query: -- test usage of JOIN+UNION+AGG all within same view
CREATE VIEW view14 AS
SELECT unionsrc1.key as k1, unionsrc1.value as v1,
@@ -1254,6 +1298,7 @@ JOIN
ON (unionsrc1.key = unionsrc2.key)
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@view14
PREHOOK: query: DESCRIBE EXTENDED view14
PREHOOK: type: DESCTABLE
@@ -1379,6 +1424,8 @@ FROM src
GROUP BY key
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@view15
POSTHOOK: query: -- test usage of GROUP BY within view
CREATE VIEW view15 AS
SELECT key,COUNT(value) AS value_count
@@ -1386,6 +1433,7 @@ FROM src
GROUP BY key
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@view15
PREHOOK: query: DESCRIBE EXTENDED view15
PREHOOK: type: DESCTABLE
@@ -1467,12 +1515,15 @@ SELECT DISTINCT value
FROM src
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@view16
POSTHOOK: query: -- test usage of DISTINCT within view
CREATE VIEW view16 AS
SELECT DISTINCT value
FROM src
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@view16
PREHOOK: query: DESCRIBE EXTENDED view16
PREHOOK: type: DESCTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/create_view_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_view_partitioned.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_view_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_view_partitioned.q.out Wed Aug 27 17:36:23 2014
@@ -20,6 +20,8 @@ FROM src
WHERE key=86
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@vp1
POSTHOOK: query: -- test partitioned view definition
-- (underlying table is not actually partitioned)
CREATE VIEW vp1
@@ -30,6 +32,7 @@ FROM src
WHERE key=86
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@vp1
PREHOOK: query: DESCRIBE EXTENDED vp1
PREHOOK: type: DESCTABLE
@@ -245,6 +248,8 @@ PARTITIONED ON (hr)
AS SELECT * FROM srcpart WHERE key < 10
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@srcpart
+PREHOOK: Output: database:default
+PREHOOK: Output: default@vp2
POSTHOOK: query: -- test a partitioned view on top of an underlying partitioned table,
-- but with only a suffix of the partitioning columns
CREATE VIEW vp2
@@ -252,6 +257,7 @@ PARTITIONED ON (hr)
AS SELECT * FROM srcpart WHERE key < 10
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@srcpart
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@vp2
PREHOOK: query: DESCRIBE FORMATTED vp2
PREHOOK: type: DESCTABLE
@@ -355,6 +361,8 @@ FROM src
WHERE key=86
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@vp3
POSTHOOK: query: -- test a partitioned view where the PARTITIONED ON clause references
-- an imposed column name
CREATE VIEW vp3(k,v)
@@ -365,6 +373,7 @@ FROM src
WHERE key=86
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@vp3
PREHOOK: query: DESCRIBE FORMATTED vp3
PREHOOK: type: DESCTABLE
@@ -405,7 +414,7 @@ FROM src
WHERE key=86
View Expanded Text: SELECT `key` AS `k`, `value` AS `v` FROM (SELECT `src`.`key`, `src`.`value`
FROM `default`.`src`
-WHERE `src`.`key`=86) `vp3`
+WHERE `src`.`key`=86) `default.vp3`
PREHOOK: query: ALTER VIEW vp3
ADD PARTITION (v='val_86')
PREHOOK: type: ALTERTABLE_ADDPARTS
Modified: hive/trunk/ql/src/test/results/clientpositive/create_view_translate.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/create_view_translate.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/create_view_translate.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/create_view_translate.q.out Wed Aug 27 17:36:23 2014
@@ -9,9 +9,12 @@ POSTHOOK: type: DROPVIEW
PREHOOK: query: create view v as select cast(key as string) from src
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@v
POSTHOOK: query: create view v as select cast(key as string) from src
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@v
PREHOOK: query: describe formatted v
PREHOOK: type: DESCTABLE
@@ -49,11 +52,14 @@ PREHOOK: query: create view w as select
) a
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@w
POSTHOOK: query: create view w as select key, value from (
select key, value from src
) a
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@w
PREHOOK: query: describe formatted w
PREHOOK: type: DESCTABLE
@@ -135,15 +141,18 @@ STAGE PLANS:
or replace: false
columns: id int, _c1 string
expanded text: SELECT `items`.`id`, `items`.`info`['price'] FROM `default`.`items`
- name: priceview
+ name: default.priceview
original text: SELECT items.id, items.info['price'] FROM items
PREHOOK: query: CREATE VIEW priceview AS SELECT items.id, items.info['price'] FROM items
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@items
+PREHOOK: Output: database:default
+PREHOOK: Output: default@priceview
POSTHOOK: query: CREATE VIEW priceview AS SELECT items.id, items.info['price'] FROM items
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@items
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@priceview
PREHOOK: query: select * from priceview
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/cross_product_check_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/cross_product_check_1.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/cross_product_check_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/cross_product_check_1.q.out Wed Aug 27 17:36:23 2014
@@ -2,21 +2,27 @@ PREHOOK: query: create table A as
select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@A
POSTHOOK: query: create table A as
select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@A
PREHOOK: query: create table B as
select * from src
limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@B
POSTHOOK: query: create table B as
select * from src
limit 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@B
Warning: Shuffle Join JOIN[4][tables = [a, b]] in Stage 'Stage-1:MAPRED' is a cross product
PREHOOK: query: explain select * from A join B
Modified: hive/trunk/ql/src/test/results/clientpositive/cross_product_check_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/cross_product_check_2.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/cross_product_check_2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/cross_product_check_2.q.out Wed Aug 27 17:36:23 2014
@@ -2,21 +2,27 @@ PREHOOK: query: create table A as
select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@A
POSTHOOK: query: create table A as
select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@A
PREHOOK: query: create table B as
select * from src
limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@B
POSTHOOK: query: create table B as
select * from src
limit 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@B
Warning: Map Join MAPJOIN[7][bigTable=a] in task 'Stage-3:MAPRED' is a cross product
PREHOOK: query: explain select * from A join B
Modified: hive/trunk/ql/src/test/results/clientpositive/ctas.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ctas.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ctas.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ctas.q.out Wed Aug 27 17:36:23 2014
@@ -97,7 +97,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: nzhang_CTAS1
+ name: default.nzhang_CTAS1
Stage: Stage-3
Stats-Aggr Operator
@@ -105,9 +105,12 @@ STAGE PLANS:
PREHOOK: query: create table nzhang_CTAS1 as select key k, value from src sort by k, value limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@nzhang_CTAS1
POSTHOOK: query: create table nzhang_CTAS1 as select key k, value from src sort by k, value limit 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@nzhang_CTAS1
PREHOOK: query: select * from nzhang_CTAS1
PREHOOK: type: QUERY
@@ -242,7 +245,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: nzhang_ctas2
+ name: default.nzhang_ctas2
Stage: Stage-3
Stats-Aggr Operator
@@ -250,9 +253,12 @@ STAGE PLANS:
PREHOOK: query: create table nzhang_ctas2 as select * from src sort by key, value limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@nzhang_ctas2
POSTHOOK: query: create table nzhang_ctas2 as select * from src sort by key, value limit 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@nzhang_ctas2
PREHOOK: query: select * from nzhang_ctas2
PREHOOK: type: QUERY
@@ -387,7 +393,7 @@ STAGE PLANS:
input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
serde name: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- name: nzhang_ctas3
+ name: default.nzhang_ctas3
Stage: Stage-3
Stats-Aggr Operator
@@ -395,9 +401,12 @@ STAGE PLANS:
PREHOOK: query: create table nzhang_ctas3 row format serde "org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe" stored as RCFile as select key/2 half_key, concat(value, "_con") conb from src sort by half_key, conb limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@nzhang_ctas3
POSTHOOK: query: create table nzhang_ctas3 row format serde "org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe" stored as RCFile as select key/2 half_key, concat(value, "_con") conb from src sort by half_key, conb limit 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@nzhang_ctas3
PREHOOK: query: select * from nzhang_ctas3
PREHOOK: type: QUERY
@@ -598,7 +607,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: nzhang_ctas4
+ name: default.nzhang_ctas4
Stage: Stage-3
Stats-Aggr Operator
@@ -606,9 +615,12 @@ STAGE PLANS:
PREHOOK: query: create table nzhang_ctas4 row format delimited fields terminated by ',' stored as textfile as select key, value from src sort by key, value limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@nzhang_ctas4
POSTHOOK: query: create table nzhang_ctas4 row format delimited fields terminated by ',' stored as textfile as select key, value from src sort by key, value limit 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@nzhang_ctas4
PREHOOK: query: select * from nzhang_ctas4
PREHOOK: type: QUERY
@@ -897,7 +909,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: nzhang_ctas5
+ name: default.nzhang_ctas5
Stage: Stage-3
Stats-Aggr Operator
@@ -906,9 +918,12 @@ STAGE PLANS:
PREHOOK: query: create table nzhang_ctas5 row format delimited fields terminated by ',' lines terminated by '\012' stored as textfile as select key, value from src sort by key, value limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@nzhang_ctas5
POSTHOOK: query: create table nzhang_ctas5 row format delimited fields terminated by ',' lines terminated by '\012' stored as textfile as select key, value from src sort by key, value limit 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@nzhang_ctas5
PREHOOK: query: create table nzhang_ctas6 (key string, `to` string)
PREHOOK: type: CREATETABLE
@@ -931,7 +946,10 @@ POSTHOOK: Lineage: nzhang_ctas6.to SIMPL
PREHOOK: query: create table nzhang_ctas7 as select key, `to` from nzhang_ctas6
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@nzhang_ctas6
+PREHOOK: Output: database:default
+PREHOOK: Output: default@nzhang_ctas7
POSTHOOK: query: create table nzhang_ctas7 as select key, `to` from nzhang_ctas6
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@nzhang_ctas6
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@nzhang_ctas7
Modified: hive/trunk/ql/src/test/results/clientpositive/ctas_char.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ctas_char.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ctas_char.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ctas_char.q.out Wed Aug 27 17:36:23 2014
@@ -34,19 +34,25 @@ PREHOOK: query: -- create table as with
create table ctas_char_2 as select key, value from ctas_char_1
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@ctas_char_1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@ctas_char_2
POSTHOOK: query: -- create table as with char column
create table ctas_char_2 as select key, value from ctas_char_1
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@ctas_char_1
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@ctas_char_2
PREHOOK: query: -- view with char column
create view ctas_char_3 as select key, value from ctas_char_2
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@ctas_char_2
+PREHOOK: Output: database:default
+PREHOOK: Output: default@ctas_char_3
POSTHOOK: query: -- view with char column
create view ctas_char_3 as select key, value from ctas_char_2
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@ctas_char_2
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@ctas_char_3
PREHOOK: query: select key, value from ctas_char_1
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/ctas_colname.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ctas_colname.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ctas_colname.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ctas_colname.q.out Wed Aug 27 17:36:23 2014
@@ -72,7 +72,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: summary
+ name: default.summary
Stage: Stage-2
Stats-Aggr Operator
@@ -80,9 +80,12 @@ STAGE PLANS:
PREHOOK: query: create table summary as select *, sum(key), count(value) from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@summary
POSTHOOK: query: create table summary as select *, sum(key), count(value) from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@summary
PREHOOK: query: describe formatted summary
PREHOOK: type: DESCTABLE
@@ -189,7 +192,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: x4
+ name: default.x4
Stage: Stage-2
Stats-Aggr Operator
@@ -197,9 +200,12 @@ STAGE PLANS:
PREHOOK: query: create table x4 as select *, rank() over(partition by key order by value) as rr from src1
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@x4
POSTHOOK: query: create table x4 as select *, rank() over(partition by key order by value) as rr from src1
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src1
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@x4
PREHOOK: query: describe formatted x4
PREHOOK: type: DESCTABLE
@@ -354,7 +360,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: x5
+ name: default.x5
Stage: Stage-3
Stats-Aggr Operator
@@ -362,9 +368,12 @@ STAGE PLANS:
PREHOOK: query: create table x5 as select *, lead(key,1) over(partition by key order by value) as lead1 from src limit 20
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@x5
POSTHOOK: query: create table x5 as select *, lead(key,1) over(partition by key order by value) as lead1 from src limit 20
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@x5
PREHOOK: query: describe formatted x5
PREHOOK: type: DESCTABLE
@@ -497,7 +506,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: x6
+ name: default.x6
Stage: Stage-2
Stats-Aggr Operator
@@ -505,9 +514,12 @@ STAGE PLANS:
PREHOOK: query: create table x6 as select * from (select *, max(key) from src1) a
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@x6
POSTHOOK: query: create table x6 as select * from (select *, max(key) from src1) a
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src1
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@x6
PREHOOK: query: describe formatted x6
PREHOOK: type: DESCTABLE
@@ -619,7 +631,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: x7
+ name: default.x7
Stage: Stage-2
Stats-Aggr Operator
@@ -627,9 +639,12 @@ STAGE PLANS:
PREHOOK: query: create table x7 as select * from (select * from src group by key) a
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@x7
POSTHOOK: query: create table x7 as select * from (select * from src group by key) a
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@x7
PREHOOK: query: describe formatted x7
PREHOOK: type: DESCTABLE
@@ -1051,7 +1066,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: x8
+ name: default.x8
Stage: Stage-2
Stats-Aggr Operator
@@ -1059,9 +1074,12 @@ STAGE PLANS:
PREHOOK: query: create table x8 as select * from (select * from src group by key having key < 9) a
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@x8
POSTHOOK: query: create table x8 as select * from (select * from src group by key having key < 9) a
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@x8
PREHOOK: query: describe formatted x8
PREHOOK: type: DESCTABLE
@@ -1185,7 +1203,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: x9
+ name: default.x9
Stage: Stage-2
Stats-Aggr Operator
@@ -1193,9 +1211,12 @@ STAGE PLANS:
PREHOOK: query: create table x9 as select * from (select max(value),key from src group by key having key < 9 AND max(value) IS NOT NULL) a
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@x9
POSTHOOK: query: create table x9 as select * from (select max(value),key from src group by key having key < 9 AND max(value) IS NOT NULL) a
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@x9
PREHOOK: query: describe formatted x9
PREHOOK: type: DESCTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/ctas_date.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ctas_date.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ctas_date.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ctas_date.q.out Wed Aug 27 17:36:23 2014
@@ -39,26 +39,35 @@ PREHOOK: query: -- create table as with
create table ctas_date_2 as select key, value, dd, date '1980-12-12' from ctas_date_1
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@ctas_date_1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@ctas_date_2
POSTHOOK: query: -- create table as with date column
create table ctas_date_2 as select key, value, dd, date '1980-12-12' from ctas_date_1
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@ctas_date_1
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@ctas_date_2
PREHOOK: query: -- view with date column
create view ctas_date_3 as select * from ctas_date_2 where dd > date '2000-01-01'
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@ctas_date_2
+PREHOOK: Output: database:default
+PREHOOK: Output: default@ctas_date_3
POSTHOOK: query: -- view with date column
create view ctas_date_3 as select * from ctas_date_2 where dd > date '2000-01-01'
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@ctas_date_2
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@ctas_date_3
PREHOOK: query: create view ctas_date_4 as select * from ctas_date_2 where dd < date '2000-01-01'
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@ctas_date_2
+PREHOOK: Output: database:default
+PREHOOK: Output: default@ctas_date_4
POSTHOOK: query: create view ctas_date_4 as select * from ctas_date_2 where dd < date '2000-01-01'
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@ctas_date_2
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@ctas_date_4
PREHOOK: query: select key, value, dd, date '1980-12-12' from ctas_date_1
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out Wed Aug 27 17:36:23 2014
@@ -79,7 +79,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: table_db1
+ name: db1.table_db1
Stage: Stage-2
Stats-Aggr Operator
@@ -117,9 +117,12 @@ STAGE PLANS:
PREHOOK: query: CREATE TABLE table_db1 AS SELECT * FROM default.src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:db1
+PREHOOK: Output: db1@table_db1
POSTHOOK: query: CREATE TABLE table_db1 AS SELECT * FROM default.src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:db1
POSTHOOK: Output: db1@table_db1
PREHOOK: query: DESCRIBE FORMATTED table_db1
PREHOOK: type: DESCTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/ctas_varchar.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ctas_varchar.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ctas_varchar.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ctas_varchar.q.out Wed Aug 27 17:36:23 2014
@@ -34,19 +34,25 @@ PREHOOK: query: -- create table as with
create table ctas_varchar_2 as select key, value from ctas_varchar_1
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@ctas_varchar_1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@ctas_varchar_2
POSTHOOK: query: -- create table as with varchar column
create table ctas_varchar_2 as select key, value from ctas_varchar_1
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@ctas_varchar_1
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@ctas_varchar_2
PREHOOK: query: -- view with varchar column
create view ctas_varchar_3 as select key, value from ctas_varchar_2
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@ctas_varchar_2
+PREHOOK: Output: database:default
+PREHOOK: Output: default@ctas_varchar_3
POSTHOOK: query: -- view with varchar column
create view ctas_varchar_3 as select key, value from ctas_varchar_2
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@ctas_varchar_2
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@ctas_varchar_3
PREHOOK: query: select key, value from ctas_varchar_1
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/cte_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/cte_2.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/cte_2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/cte_2.q.out Wed Aug 27 17:36:23 2014
@@ -84,12 +84,15 @@ with q1 as ( select key from src where k
select * from q1
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@s2
POSTHOOK: query: -- ctas
create table s2 as
with q1 as ( select key from src where key = '4')
select * from q1
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@s2
PREHOOK: query: select * from s2
PREHOOK: type: QUERY
@@ -114,12 +117,15 @@ with q1 as ( select key from src where k
select * from q1
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@v1
POSTHOOK: query: -- view test
create view v1 as
with q1 as ( select key from src where key = '5')
select * from q1
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@v1
PREHOOK: query: select * from v1
PREHOOK: type: QUERY
@@ -148,12 +154,15 @@ with q1 as ( select key from src where k
select * from q1
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@v1
POSTHOOK: query: -- view test, name collision
create view v1 as
with q1 as ( select key from src where key = '5')
select * from q1
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@v1
PREHOOK: query: with q1 as ( select key from src where key = '4')
select * from v1
Modified: hive/trunk/ql/src/test/results/clientpositive/database.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/database.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/database.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/database.q.out Wed Aug 27 17:36:23 2014
@@ -585,13 +585,12 @@ CREATE TABLE db1.src(key STRING, value S
STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:db1
-PREHOOK: Output: db1@db1.src
+PREHOOK: Output: db1@src
POSTHOOK: query: -- CREATE foreign table
CREATE TABLE db1.src(key STRING, value STRING)
STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:db1
-POSTHOOK: Output: db1@db1.src
POSTHOOK: Output: db1@src
PREHOOK: query: -- LOAD into foreign table
LOAD DATA LOCAL INPATH '../../data/files/kv1.txt'
@@ -1121,14 +1120,13 @@ PARTITIONED BY (ds STRING, hr STRING)
STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:db1
-PREHOOK: Output: db1@db1.srcpart
+PREHOOK: Output: db1@srcpart
POSTHOOK: query: -- CREATE Partitioned foreign table
CREATE TABLE db1.srcpart(key STRING, value STRING)
PARTITIONED BY (ds STRING, hr STRING)
STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:db1
-POSTHOOK: Output: db1@db1.srcpart
POSTHOOK: Output: db1@srcpart
PREHOOK: query: -- LOAD data into Partitioned foreign table
LOAD DATA LOCAL INPATH '../../data/files/kv1.txt'
@@ -1305,22 +1303,28 @@ CREATE TABLE conflict_name AS
SELECT value FROM default.src WHERE key = 66
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:db2
+PREHOOK: Output: db2@conflict_name
POSTHOOK: query: -- CREATE TABLE AS SELECT from foreign table
CREATE TABLE conflict_name AS
SELECT value FROM default.src WHERE key = 66
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:db2
POSTHOOK: Output: db2@conflict_name
PREHOOK: query: -- CREATE foreign table
CREATE TABLE db1.conflict_name AS
SELECT value FROM db1.src WHERE key = 8
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: db1@src
+PREHOOK: Output: database:db1
+PREHOOK: Output: db1@conflict_name
POSTHOOK: query: -- CREATE foreign table
CREATE TABLE db1.conflict_name AS
SELECT value FROM db1.src WHERE key = 8
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: db1@src
+POSTHOOK: Output: database:db1
POSTHOOK: Output: db1@conflict_name
PREHOOK: query: -- query tables with the same names in different DBs
SELECT * FROM (
@@ -1407,12 +1411,11 @@ PREHOOK: query: -- CREATE TABLE LIKE
CREATE TABLE db2.src1 LIKE default.src
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:db2
-PREHOOK: Output: db2@db2.src1
+PREHOOK: Output: db2@src1
POSTHOOK: query: -- CREATE TABLE LIKE
CREATE TABLE db2.src1 LIKE default.src
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:db2
-POSTHOOK: Output: db2@db2.src1
POSTHOOK: Output: db2@src1
PREHOOK: query: USE db2
PREHOOK: type: SWITCHDATABASE
Modified: hive/trunk/ql/src/test/results/clientpositive/database_drop.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/database_drop.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/database_drop.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/database_drop.q.out Wed Aug 27 17:36:23 2014
@@ -50,9 +50,12 @@ POSTHOOK: Output: db5@temp_tbl
PREHOOK: query: CREATE VIEW temp_tbl_view AS SELECT * FROM temp_tbl
PREHOOK: type: CREATEVIEW
PREHOOK: Input: db5@temp_tbl
+PREHOOK: Output: database:db5
+PREHOOK: Output: db5@temp_tbl_view
POSTHOOK: query: CREATE VIEW temp_tbl_view AS SELECT * FROM temp_tbl
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: db5@temp_tbl
+POSTHOOK: Output: database:db5
POSTHOOK: Output: db5@temp_tbl_view
PREHOOK: query: CREATE INDEX idx1 ON TABLE temp_tbl(id) AS 'COMPACT' with DEFERRED REBUILD
PREHOOK: type: CREATEINDEX
@@ -95,9 +98,12 @@ POSTHOOK: Output: db5@temp_tbl2
PREHOOK: query: CREATE VIEW temp_tbl2_view AS SELECT * FROM temp_tbl2
PREHOOK: type: CREATEVIEW
PREHOOK: Input: db5@temp_tbl2
+PREHOOK: Output: database:db5
+PREHOOK: Output: db5@temp_tbl2_view
POSTHOOK: query: CREATE VIEW temp_tbl2_view AS SELECT * FROM temp_tbl2
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: db5@temp_tbl2
+POSTHOOK: Output: database:db5
POSTHOOK: Output: db5@temp_tbl2_view
#### A masked pattern was here ####
PREHOOK: type: CREATEINDEX
Modified: hive/trunk/ql/src/test/results/clientpositive/dbtxnmgr_ddl1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/dbtxnmgr_ddl1.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/dbtxnmgr_ddl1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/dbtxnmgr_ddl1.q.out Wed Aug 27 17:36:23 2014
@@ -59,9 +59,12 @@ POSTHOOK: Input: default@t1
PREHOOK: query: create table T3 as select * from T1
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@t1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@T3
POSTHOOK: query: create table T3 as select * from T1
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@t1
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@T3
PREHOOK: query: create table T4 (key char(10), val decimal(5,2), b int)
partitioned by (ds string)
@@ -221,9 +224,12 @@ POSTHOOK: Output: default@t4@ds=tomorrow
PREHOOK: query: create view V1 as select key from T1
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@t1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@V1
POSTHOOK: query: create view V1 as select key from T1
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@t1
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@V1
PREHOOK: query: alter view V1 set tblproperties ('test'='thisisatest')
PREHOOK: type: ALTERVIEW_PROPERTIES
Modified: hive/trunk/ql/src/test/results/clientpositive/dbtxnmgr_query5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/dbtxnmgr_query5.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/dbtxnmgr_query5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/dbtxnmgr_query5.q.out Wed Aug 27 17:36:23 2014
@@ -28,9 +28,12 @@ POSTHOOK: Output: foo@t1@ds=today
PREHOOK: query: create view V1 as select key from T1
PREHOOK: type: CREATEVIEW
PREHOOK: Input: foo@t1
+PREHOOK: Output: database:foo
+PREHOOK: Output: foo@V1
POSTHOOK: query: create view V1 as select key from T1
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: foo@t1
+POSTHOOK: Output: database:foo
POSTHOOK: Output: foo@V1
PREHOOK: query: show tables
PREHOOK: type: SHOWTABLES
Modified: hive/trunk/ql/src/test/results/clientpositive/decimal_6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/decimal_6.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/decimal_6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/decimal_6.q.out Wed Aug 27 17:36:23 2014
@@ -129,9 +129,12 @@ NULL
PREHOOK: query: CREATE TABLE DECIMAL_6_3 AS SELECT key + 5.5 AS k, value * 11 AS v from DECIMAL_6_1 ORDER BY v
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@decimal_6_1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@DECIMAL_6_3
POSTHOOK: query: CREATE TABLE DECIMAL_6_3 AS SELECT key + 5.5 AS k, value * 11 AS v from DECIMAL_6_1 ORDER BY v
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@decimal_6_1
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@DECIMAL_6_3
PREHOOK: query: desc DECIMAL_6_3
PREHOOK: type: DESCTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/decimal_serde.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/decimal_serde.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/decimal_serde.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/decimal_serde.q.out Wed Aug 27 17:36:23 2014
@@ -87,11 +87,14 @@ STORED AS RCFile AS
SELECT * FROM DECIMAL_TEXT
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@decimal_text
+PREHOOK: Output: database:default
+PREHOOK: Output: default@DECIMAL_RC
POSTHOOK: query: CREATE TABLE DECIMAL_RC
STORED AS RCFile AS
SELECT * FROM DECIMAL_TEXT
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@decimal_text
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@DECIMAL_RC
PREHOOK: query: CREATE TABLE DECIMAL_LAZY_COL
ROW FORMAT SERDE "org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe"
@@ -99,12 +102,15 @@ STORED AS RCFile AS
SELECT * FROM DECIMAL_RC
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@decimal_rc
+PREHOOK: Output: database:default
+PREHOOK: Output: default@DECIMAL_LAZY_COL
POSTHOOK: query: CREATE TABLE DECIMAL_LAZY_COL
ROW FORMAT SERDE "org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe"
STORED AS RCFile AS
SELECT * FROM DECIMAL_RC
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@decimal_rc
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@DECIMAL_LAZY_COL
PREHOOK: query: CREATE TABLE DECIMAL_SEQUENCE
ROW FORMAT DELIMITED
@@ -115,6 +121,8 @@ STORED AS SEQUENCEFILE AS
SELECT * FROM DECIMAL_LAZY_COL ORDER BY key
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@decimal_lazy_col
+PREHOOK: Output: database:default
+PREHOOK: Output: default@DECIMAL_SEQUENCE
POSTHOOK: query: CREATE TABLE DECIMAL_SEQUENCE
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\001'
@@ -124,6 +132,7 @@ STORED AS SEQUENCEFILE AS
SELECT * FROM DECIMAL_LAZY_COL ORDER BY key
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@decimal_lazy_col
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@DECIMAL_SEQUENCE
PREHOOK: query: SELECT * FROM DECIMAL_SEQUENCE ORDER BY key, value
PREHOOK: type: QUERY