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/25 23:56:14 UTC
svn commit: r1620472 [3/3] - in /hive/trunk:
hcatalog/core/src/main/java/org/apache/hive/hcatalog/cli/SemanticAnalysis/
hcatalog/core/src/test/java/org/apache/hive/hcatalog/cli/
ql/src/java/org/apache/hadoop/hive/ql/hooks/ ql/src/java/org/apache/hadoop...
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=1620472&r1=1620471&r2=1620472&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 Mon Aug 25 21:56:13 2014
@@ -1,3 +1,15 @@
+PREHOOK: query: CREATE DATABASE tv1
+PREHOOK: type: CREATEDATABASE
+PREHOOK: Output: database:tv1
+POSTHOOK: query: CREATE DATABASE tv1
+POSTHOOK: type: CREATEDATABASE
+POSTHOOK: Output: database:tv1
+PREHOOK: query: CREATE DATABASE tv2
+PREHOOK: type: CREATEDATABASE
+PREHOOK: Output: database:tv2
+POSTHOOK: query: CREATE DATABASE tv2
+POSTHOOK: type: CREATEDATABASE
+POSTHOOK: Output: database:tv2
PREHOOK: query: CREATE TABLE invites (foo INT, bar STRING) PARTITIONED BY (ds STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
@@ -6,53 +18,53 @@ POSTHOOK: query: CREATE TABLE invites (f
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@invites
-PREHOOK: query: CREATE VIEW view1 as SELECT * FROM invites
+PREHOOK: query: CREATE VIEW tv1.view1 as SELECT * FROM invites
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@invites
-POSTHOOK: query: CREATE VIEW view1 as SELECT * FROM invites
+POSTHOOK: query: CREATE VIEW tv1.view1 as SELECT * FROM invites
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@invites
-POSTHOOK: Output: default@view1
-PREHOOK: query: DESCRIBE EXTENDED view1
+POSTHOOK: Output: tv1@view1
+PREHOOK: query: DESCRIBE EXTENDED tv1.view1
PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@view1
-POSTHOOK: query: DESCRIBE EXTENDED view1
+PREHOOK: Input: tv1@view1
+POSTHOOK: query: DESCRIBE EXTENDED tv1.view1
POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@view1
+POSTHOOK: Input: tv1@view1
foo int
bar string
ds string
#### A masked pattern was here ####
-PREHOOK: query: ALTER VIEW view1 RENAME TO view2
+PREHOOK: query: ALTER VIEW tv1.view1 RENAME TO tv2.view2
PREHOOK: type: ALTERVIEW_RENAME
-PREHOOK: Input: default@view1
-PREHOOK: Output: default@view1
-POSTHOOK: query: ALTER VIEW view1 RENAME TO view2
+PREHOOK: Input: tv1@view1
+PREHOOK: Output: tv1@view1
+POSTHOOK: query: ALTER VIEW tv1.view1 RENAME TO tv2.view2
POSTHOOK: type: ALTERVIEW_RENAME
-POSTHOOK: Input: default@view1
-POSTHOOK: Output: default@view1
-POSTHOOK: Output: default@view2
-PREHOOK: query: DESCRIBE EXTENDED view2
+POSTHOOK: Input: tv1@view1
+POSTHOOK: Output: tv1@view1
+POSTHOOK: Output: tv2@view2
+PREHOOK: query: DESCRIBE EXTENDED tv2.view2
PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@view2
-POSTHOOK: query: DESCRIBE EXTENDED view2
+PREHOOK: Input: tv2@view2
+POSTHOOK: query: DESCRIBE EXTENDED tv2.view2
POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@view2
+POSTHOOK: Input: tv2@view2
foo int
bar string
ds string
#### A masked pattern was here ####
-PREHOOK: query: SELECT * FROM view2
+PREHOOK: query: SELECT * FROM tv2.view2
PREHOOK: type: QUERY
PREHOOK: Input: default@invites
-PREHOOK: Input: default@view2
+PREHOOK: Input: tv2@view2
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM view2
+POSTHOOK: query: SELECT * FROM tv2.view2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@invites
-POSTHOOK: Input: default@view2
+POSTHOOK: Input: tv2@view2
#### A masked pattern was here ####
PREHOOK: query: DROP TABLE invites
PREHOOK: type: DROPTABLE
@@ -62,11 +74,27 @@ POSTHOOK: query: DROP TABLE invites
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@invites
POSTHOOK: Output: default@invites
-PREHOOK: query: DROP VIEW view2
+PREHOOK: query: DROP VIEW tv2.view2
PREHOOK: type: DROPVIEW
-PREHOOK: Input: default@view2
-PREHOOK: Output: default@view2
-POSTHOOK: query: DROP VIEW view2
+PREHOOK: Input: tv2@view2
+PREHOOK: Output: tv2@view2
+POSTHOOK: query: DROP VIEW tv2.view2
POSTHOOK: type: DROPVIEW
-POSTHOOK: Input: default@view2
-POSTHOOK: Output: default@view2
+POSTHOOK: Input: tv2@view2
+POSTHOOK: Output: tv2@view2
+PREHOOK: query: DROP DATABASE tv1
+PREHOOK: type: DROPDATABASE
+PREHOOK: Input: database:tv1
+PREHOOK: Output: database:tv1
+POSTHOOK: query: DROP DATABASE tv1
+POSTHOOK: type: DROPDATABASE
+POSTHOOK: Input: database:tv1
+POSTHOOK: Output: database:tv1
+PREHOOK: query: DROP DATABASE tv2
+PREHOOK: type: DROPDATABASE
+PREHOOK: Input: database:tv2
+PREHOOK: Output: database:tv2
+POSTHOOK: query: DROP DATABASE tv2
+POSTHOOK: type: DROPDATABASE
+POSTHOOK: Input: database:tv2
+POSTHOOK: Output: database:tv2
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=1620472&r1=1620471&r2=1620472&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 Mon Aug 25 21:56:13 2014
@@ -1,161 +1,161 @@
-PREHOOK: query: drop table tstsrc
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tstsrc
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: drop table tstsrcpart
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tstsrcpart
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: create table tstsrc like src
+PREHOOK: query: create database ac_test
+PREHOOK: type: CREATEDATABASE
+PREHOOK: Output: database:ac_test
+POSTHOOK: query: create database ac_test
+POSTHOOK: type: CREATEDATABASE
+POSTHOOK: Output: database:ac_test
+PREHOOK: query: create table ac_test.tstsrc like default.src
PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@tstsrc
-POSTHOOK: query: create table tstsrc like src
+PREHOOK: Output: ac_test@ac_test.tstsrc
+PREHOOK: Output: database:ac_test
+POSTHOOK: query: create table ac_test.tstsrc like default.src
POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@tstsrc
-PREHOOK: query: insert overwrite table tstsrc select key, value from src
+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
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: default@tstsrc
-POSTHOOK: query: insert overwrite table tstsrc select key, value from src
+PREHOOK: Output: ac_test@tstsrc
+POSTHOOK: query: insert overwrite table ac_test.tstsrc select key, value from default.src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: default@tstsrc
+POSTHOOK: Output: ac_test@tstsrc
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), ]
-PREHOOK: query: create table tstsrcpart like srcpart
+PREHOOK: query: create table ac_test.tstsrcpart like default.srcpart
PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@tstsrcpart
-POSTHOOK: query: create table tstsrcpart like srcpart
+PREHOOK: Output: ac_test@ac_test.tstsrcpart
+PREHOOK: Output: database:ac_test
+POSTHOOK: query: create table ac_test.tstsrcpart like default.srcpart
POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@tstsrcpart
-PREHOOK: query: insert overwrite table tstsrcpart partition (ds='2008-04-08', hr='11')
-select key, value from srcpart where ds='2008-04-08' and hr='11'
+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')
+select key, value from default.srcpart where ds='2008-04-08' and hr='11'
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-PREHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=11
-POSTHOOK: query: insert overwrite table tstsrcpart partition (ds='2008-04-08', hr='11')
-select key, value from srcpart where ds='2008-04-08' and hr='11'
+PREHOOK: Output: ac_test@tstsrcpart@ds=2008-04-08/hr=11
+POSTHOOK: query: insert overwrite table ac_test.tstsrcpart partition (ds='2008-04-08', hr='11')
+select key, value from default.srcpart where ds='2008-04-08' and hr='11'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-POSTHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=11
+POSTHOOK: Output: ac_test@tstsrcpart@ds=2008-04-08/hr=11
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: insert overwrite table tstsrcpart partition (ds='2008-04-08', hr='12')
-select key, value from srcpart where ds='2008-04-08' and hr='12'
+PREHOOK: query: insert overwrite table ac_test.tstsrcpart partition (ds='2008-04-08', hr='12')
+select key, value from default.srcpart where ds='2008-04-08' and hr='12'
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-PREHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=12
-POSTHOOK: query: insert overwrite table tstsrcpart partition (ds='2008-04-08', hr='12')
-select key, value from srcpart where ds='2008-04-08' and hr='12'
+PREHOOK: Output: ac_test@tstsrcpart@ds=2008-04-08/hr=12
+POSTHOOK: query: insert overwrite table ac_test.tstsrcpart partition (ds='2008-04-08', hr='12')
+select key, value from default.srcpart where ds='2008-04-08' and hr='12'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-POSTHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=12
+POSTHOOK: Output: ac_test@tstsrcpart@ds=2008-04-08/hr=12
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-08,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: insert overwrite table tstsrcpart partition (ds='2008-04-09', hr='11')
-select key, value from srcpart where ds='2008-04-09' and hr='11'
+PREHOOK: query: insert overwrite table ac_test.tstsrcpart partition (ds='2008-04-09', hr='11')
+select key, value from default.srcpart where ds='2008-04-09' and hr='11'
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
-PREHOOK: Output: default@tstsrcpart@ds=2008-04-09/hr=11
-POSTHOOK: query: insert overwrite table tstsrcpart partition (ds='2008-04-09', hr='11')
-select key, value from srcpart where ds='2008-04-09' and hr='11'
+PREHOOK: Output: ac_test@tstsrcpart@ds=2008-04-09/hr=11
+POSTHOOK: query: insert overwrite table ac_test.tstsrcpart partition (ds='2008-04-09', hr='11')
+select key, value from default.srcpart where ds='2008-04-09' and hr='11'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
-POSTHOOK: Output: default@tstsrcpart@ds=2008-04-09/hr=11
+POSTHOOK: Output: ac_test@tstsrcpart@ds=2008-04-09/hr=11
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: insert overwrite table tstsrcpart partition (ds='2008-04-09', hr='12')
-select key, value from srcpart where ds='2008-04-09' and hr='12'
+PREHOOK: query: insert overwrite table ac_test.tstsrcpart partition (ds='2008-04-09', hr='12')
+select key, value from default.srcpart where ds='2008-04-09' and hr='12'
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-PREHOOK: Output: default@tstsrcpart@ds=2008-04-09/hr=12
-POSTHOOK: query: insert overwrite table tstsrcpart partition (ds='2008-04-09', hr='12')
-select key, value from srcpart where ds='2008-04-09' and hr='12'
+PREHOOK: Output: ac_test@tstsrcpart@ds=2008-04-09/hr=12
+POSTHOOK: query: insert overwrite table ac_test.tstsrcpart partition (ds='2008-04-09', hr='12')
+select key, value from default.srcpart where ds='2008-04-09' and hr='12'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
-POSTHOOK: Output: default@tstsrcpart@ds=2008-04-09/hr=12
+POSTHOOK: Output: ac_test@tstsrcpart@ds=2008-04-09/hr=12
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: -- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19)
SELECT SUM(hash(col)) FROM (SELECT transform(*) using 'tr "\t" "_"' AS col
-FROM (SELECT * FROM tstsrcpart WHERE ds='2008-04-08') subq1) subq2
+FROM (SELECT * FROM ac_test.tstsrcpart WHERE ds='2008-04-08') subq1) subq2
PREHOOK: type: QUERY
-PREHOOK: Input: default@tstsrcpart
-PREHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=11
-PREHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: ac_test@tstsrcpart
+PREHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=12
#### A masked pattern was here ####
POSTHOOK: query: -- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19)
SELECT SUM(hash(col)) FROM (SELECT transform(*) using 'tr "\t" "_"' AS col
-FROM (SELECT * FROM tstsrcpart WHERE ds='2008-04-08') subq1) subq2
+FROM (SELECT * FROM ac_test.tstsrcpart WHERE ds='2008-04-08') subq1) subq2
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@tstsrcpart
-POSTHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=11
-POSTHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: ac_test@tstsrcpart
+POSTHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=12
#### A masked pattern was here ####
48479881068
-PREHOOK: query: ALTER TABLE tstsrcpart ARCHIVE PARTITION (ds='2008-04-08')
+PREHOOK: query: ALTER TABLE ac_test.tstsrcpart ARCHIVE PARTITION (ds='2008-04-08')
PREHOOK: type: ALTERTABLE_ARCHIVE
-PREHOOK: Input: default@tstsrcpart
-PREHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=11
-PREHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=12
-POSTHOOK: query: ALTER TABLE tstsrcpart ARCHIVE PARTITION (ds='2008-04-08')
+PREHOOK: Input: ac_test@tstsrcpart
+PREHOOK: Output: ac_test@tstsrcpart@ds=2008-04-08/hr=11
+PREHOOK: Output: ac_test@tstsrcpart@ds=2008-04-08/hr=12
+POSTHOOK: query: ALTER TABLE ac_test.tstsrcpart ARCHIVE PARTITION (ds='2008-04-08')
POSTHOOK: type: ALTERTABLE_ARCHIVE
-POSTHOOK: Input: default@tstsrcpart
-POSTHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=11
-POSTHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: ac_test@tstsrcpart
+POSTHOOK: Output: ac_test@tstsrcpart@ds=2008-04-08/hr=11
+POSTHOOK: Output: ac_test@tstsrcpart@ds=2008-04-08/hr=12
PREHOOK: query: SELECT SUM(hash(col)) FROM (SELECT transform(*) using 'tr "\t" "_"' AS col
-FROM (SELECT * FROM tstsrcpart WHERE ds='2008-04-08') subq1) subq2
+FROM (SELECT * FROM ac_test.tstsrcpart WHERE ds='2008-04-08') subq1) subq2
PREHOOK: type: QUERY
-PREHOOK: Input: default@tstsrcpart
-PREHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=11
-PREHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: ac_test@tstsrcpart
+PREHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=12
#### A masked pattern was here ####
POSTHOOK: query: SELECT SUM(hash(col)) FROM (SELECT transform(*) using 'tr "\t" "_"' AS col
-FROM (SELECT * FROM tstsrcpart WHERE ds='2008-04-08') subq1) subq2
+FROM (SELECT * FROM ac_test.tstsrcpart WHERE ds='2008-04-08') subq1) subq2
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@tstsrcpart
-POSTHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=11
-POSTHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: ac_test@tstsrcpart
+POSTHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=12
#### A masked pattern was here ####
48479881068
-PREHOOK: query: SELECT key, count(1) FROM tstsrcpart WHERE ds='2008-04-08' AND hr='12' AND key='0' GROUP BY key
+PREHOOK: query: SELECT key, count(1) FROM ac_test.tstsrcpart WHERE ds='2008-04-08' AND hr='12' AND key='0' GROUP BY key
PREHOOK: type: QUERY
-PREHOOK: Input: default@tstsrcpart
-PREHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: ac_test@tstsrcpart
+PREHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=12
#### A masked pattern was here ####
-POSTHOOK: query: SELECT key, count(1) FROM tstsrcpart WHERE ds='2008-04-08' AND hr='12' AND key='0' GROUP BY key
+POSTHOOK: query: SELECT key, count(1) FROM ac_test.tstsrcpart WHERE ds='2008-04-08' AND hr='12' AND key='0' GROUP BY key
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@tstsrcpart
-POSTHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: ac_test@tstsrcpart
+POSTHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=12
#### A masked pattern was here ####
0 3
-PREHOOK: query: SELECT * FROM tstsrcpart a JOIN tstsrc b ON a.key=b.key
+PREHOOK: query: SELECT * FROM ac_test.tstsrcpart a JOIN ac_test.tstsrc b ON a.key=b.key
WHERE a.ds='2008-04-08' AND a.hr='12' AND a.key='0'
PREHOOK: type: QUERY
-PREHOOK: Input: default@tstsrc
-PREHOOK: Input: default@tstsrcpart
-PREHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: ac_test@tstsrc
+PREHOOK: Input: ac_test@tstsrcpart
+PREHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=12
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM tstsrcpart a JOIN tstsrc b ON a.key=b.key
+POSTHOOK: query: SELECT * FROM ac_test.tstsrcpart a JOIN ac_test.tstsrc b ON a.key=b.key
WHERE a.ds='2008-04-08' AND a.hr='12' AND a.key='0'
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@tstsrc
-POSTHOOK: Input: default@tstsrcpart
-POSTHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: ac_test@tstsrc
+POSTHOOK: Input: ac_test@tstsrcpart
+POSTHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=12
#### A masked pattern was here ####
0 val_0 2008-04-08 12 0 val_0
0 val_0 2008-04-08 12 0 val_0
@@ -166,28 +166,28 @@ POSTHOOK: Input: default@tstsrcpart@ds=2
0 val_0 2008-04-08 12 0 val_0
0 val_0 2008-04-08 12 0 val_0
0 val_0 2008-04-08 12 0 val_0
-PREHOOK: query: ALTER TABLE tstsrcpart UNARCHIVE PARTITION (ds='2008-04-08')
+PREHOOK: query: ALTER TABLE ac_test.tstsrcpart UNARCHIVE PARTITION (ds='2008-04-08')
PREHOOK: type: ALTERTABLE_UNARCHIVE
-PREHOOK: Input: default@tstsrcpart
-PREHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=11
-PREHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=12
-POSTHOOK: query: ALTER TABLE tstsrcpart UNARCHIVE PARTITION (ds='2008-04-08')
+PREHOOK: Input: ac_test@tstsrcpart
+PREHOOK: Output: ac_test@tstsrcpart@ds=2008-04-08/hr=11
+PREHOOK: Output: ac_test@tstsrcpart@ds=2008-04-08/hr=12
+POSTHOOK: query: ALTER TABLE ac_test.tstsrcpart UNARCHIVE PARTITION (ds='2008-04-08')
POSTHOOK: type: ALTERTABLE_UNARCHIVE
-POSTHOOK: Input: default@tstsrcpart
-POSTHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=11
-POSTHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: ac_test@tstsrcpart
+POSTHOOK: Output: ac_test@tstsrcpart@ds=2008-04-08/hr=11
+POSTHOOK: Output: ac_test@tstsrcpart@ds=2008-04-08/hr=12
PREHOOK: query: SELECT SUM(hash(col)) FROM (SELECT transform(*) using 'tr "\t" "_"' AS col
-FROM (SELECT * FROM tstsrcpart WHERE ds='2008-04-08') subq1) subq2
+FROM (SELECT * FROM ac_test.tstsrcpart WHERE ds='2008-04-08') subq1) subq2
PREHOOK: type: QUERY
-PREHOOK: Input: default@tstsrcpart
-PREHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=11
-PREHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=12
+PREHOOK: Input: ac_test@tstsrcpart
+PREHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=11
+PREHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=12
#### A masked pattern was here ####
POSTHOOK: query: SELECT SUM(hash(col)) FROM (SELECT transform(*) using 'tr "\t" "_"' AS col
-FROM (SELECT * FROM tstsrcpart WHERE ds='2008-04-08') subq1) subq2
+FROM (SELECT * FROM ac_test.tstsrcpart WHERE ds='2008-04-08') subq1) subq2
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@tstsrcpart
-POSTHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=11
-POSTHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=12
+POSTHOOK: Input: ac_test@tstsrcpart
+POSTHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=11
+POSTHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=12
#### A masked pattern was here ####
48479881068
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=1620472&r1=1620471&r2=1620472&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 Mon Aug 25 21:56:13 2014
@@ -1,20 +1,22 @@
-PREHOOK: query: drop view v
-PREHOOK: type: DROPVIEW
-POSTHOOK: query: drop view v
-POSTHOOK: type: DROPVIEW
-PREHOOK: query: create view v as select * from srcpart
+PREHOOK: query: create database vt
+PREHOOK: type: CREATEDATABASE
+PREHOOK: Output: database:vt
+POSTHOOK: query: create database vt
+POSTHOOK: type: CREATEDATABASE
+POSTHOOK: Output: database:vt
+PREHOOK: query: create view vt.v as select * from srcpart
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@srcpart
-POSTHOOK: query: create view v as select * from srcpart
+POSTHOOK: query: create view vt.v as select * from srcpart
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@srcpart
-POSTHOOK: Output: default@v
-PREHOOK: query: describe formatted v
+POSTHOOK: Output: vt@v
+PREHOOK: query: describe formatted vt.v
PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@v
-POSTHOOK: query: describe formatted v
+PREHOOK: Input: vt@v
+POSTHOOK: query: describe formatted vt.v
POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@v
+POSTHOOK: Input: vt@v
# col_name data_type comment
key string
@@ -23,7 +25,7 @@ ds string
hr string
# Detailed Table Information
-Database: default
+Database: vt
#### A masked pattern was here ####
Protect Mode: None
Retention: 0
@@ -44,61 +46,61 @@ Sort Columns: []
View Original Text: select * from srcpart
View Expanded Text: select `srcpart`.`key`, `srcpart`.`value`, `srcpart`.`ds`, `srcpart`.`hr` from `default`.`srcpart`
PREHOOK: query: -- modifying definition of unpartitioned view
-create or replace view v partitioned on (ds, hr) as select * from srcpart
+create or replace view vt.v partitioned on (ds, hr) as select * from srcpart
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@srcpart
POSTHOOK: query: -- modifying definition of unpartitioned view
-create or replace view v partitioned on (ds, hr) as select * from srcpart
+create or replace view vt.v partitioned on (ds, hr) as select * from srcpart
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@srcpart
-POSTHOOK: Output: default@v
-PREHOOK: query: alter view v add partition (ds='2008-04-08',hr='11')
+POSTHOOK: Output: vt@v
+PREHOOK: query: alter view vt.v add partition (ds='2008-04-08',hr='11')
PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-PREHOOK: Input: default@v
-PREHOOK: Output: default@v
-POSTHOOK: query: alter view v add partition (ds='2008-04-08',hr='11')
+PREHOOK: Input: vt@v
+PREHOOK: Output: vt@v
+POSTHOOK: query: alter view vt.v add partition (ds='2008-04-08',hr='11')
POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-POSTHOOK: Input: default@v
-POSTHOOK: Output: default@v
-POSTHOOK: Output: default@v@ds=2008-04-08/hr=11
-PREHOOK: query: alter view v add partition (ds='2008-04-08',hr='12')
+POSTHOOK: Input: vt@v
+POSTHOOK: Output: vt@v
+POSTHOOK: Output: vt@v@ds=2008-04-08/hr=11
+PREHOOK: query: alter view vt.v add partition (ds='2008-04-08',hr='12')
PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-PREHOOK: Input: default@v
-PREHOOK: Output: default@v
-POSTHOOK: query: alter view v add partition (ds='2008-04-08',hr='12')
+PREHOOK: Input: vt@v
+PREHOOK: Output: vt@v
+POSTHOOK: query: alter view vt.v add partition (ds='2008-04-08',hr='12')
POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-POSTHOOK: Input: default@v
-POSTHOOK: Output: default@v
-POSTHOOK: Output: default@v@ds=2008-04-08/hr=12
-PREHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11'
+POSTHOOK: Input: vt@v
+POSTHOOK: Output: vt@v
+POSTHOOK: Output: vt@v@ds=2008-04-08/hr=12
+PREHOOK: query: select * from vt.v where value='val_409' and ds='2008-04-08' and hr='11'
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-PREHOOK: Input: default@v
+PREHOOK: Input: vt@v
#### A masked pattern was here ####
-POSTHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11'
+POSTHOOK: query: select * from vt.v where value='val_409' and ds='2008-04-08' and hr='11'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-POSTHOOK: Input: default@v
+POSTHOOK: Input: vt@v
#### A masked pattern was here ####
409 val_409 2008-04-08 11
409 val_409 2008-04-08 11
409 val_409 2008-04-08 11
-PREHOOK: query: describe formatted v
+PREHOOK: query: describe formatted vt.v
PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@v
-POSTHOOK: query: describe formatted v
+PREHOOK: Input: vt@v
+POSTHOOK: query: describe formatted vt.v
POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@v
+POSTHOOK: Input: vt@v
# col_name data_type comment
key string
@@ -111,7 +113,7 @@ ds string
hr string
# Detailed Table Information
-Database: default
+Database: vt
#### A masked pattern was here ####
Protect Mode: None
Retention: 0
@@ -131,44 +133,66 @@ Sort Columns: []
# View Information
View Original Text: select * from srcpart
View Expanded Text: select `srcpart`.`key`, `srcpart`.`value`, `srcpart`.`ds`, `srcpart`.`hr` from `default`.`srcpart`
-PREHOOK: query: show partitions v
+PREHOOK: query: show partitions vt.v
PREHOOK: type: SHOWPARTITIONS
-PREHOOK: Input: default@v
-POSTHOOK: query: show partitions v
+PREHOOK: Input: vt@v
+POSTHOOK: query: show partitions vt.v
POSTHOOK: type: SHOWPARTITIONS
-POSTHOOK: Input: default@v
+POSTHOOK: Input: vt@v
ds=2008-04-08/hr=11
ds=2008-04-08/hr=12
+PREHOOK: query: alter view vt.v drop partition (ds='2008-04-08',hr='11')
+PREHOOK: type: ALTERTABLE_DROPPARTS
+PREHOOK: Input: vt@v
+PREHOOK: Output: vt@v@ds=2008-04-08/hr=11
+POSTHOOK: query: alter view vt.v drop partition (ds='2008-04-08',hr='11')
+POSTHOOK: type: ALTERTABLE_DROPPARTS
+POSTHOOK: Input: vt@v
+POSTHOOK: Output: vt@v@ds=2008-04-08/hr=11
+PREHOOK: query: alter view vt.v drop partition (ds='2008-04-08',hr='12')
+PREHOOK: type: ALTERTABLE_DROPPARTS
+PREHOOK: Input: vt@v
+PREHOOK: Output: vt@v@ds=2008-04-08/hr=12
+POSTHOOK: query: alter view vt.v drop partition (ds='2008-04-08',hr='12')
+POSTHOOK: type: ALTERTABLE_DROPPARTS
+POSTHOOK: Input: vt@v
+POSTHOOK: Output: vt@v@ds=2008-04-08/hr=12
+PREHOOK: query: show partitions vt.v
+PREHOOK: type: SHOWPARTITIONS
+PREHOOK: Input: vt@v
+POSTHOOK: query: show partitions vt.v
+POSTHOOK: type: SHOWPARTITIONS
+POSTHOOK: Input: vt@v
PREHOOK: query: -- altering partitioned view 1
-create or replace view v partitioned on (ds, hr) as select value, ds, hr from srcpart
+create or replace view vt.v partitioned on (ds, hr) as select value, ds, hr from srcpart
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@srcpart
POSTHOOK: query: -- altering partitioned view 1
-create or replace view v partitioned on (ds, hr) as select value, ds, hr from srcpart
+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: default@v
-PREHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11'
+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
PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-PREHOOK: Input: default@v
+PREHOOK: Input: vt@v
#### A masked pattern was here ####
-POSTHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11'
+POSTHOOK: query: select * from vt.v where value='val_409' and ds='2008-04-08' and hr='11'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-POSTHOOK: Input: default@v
+POSTHOOK: Input: vt@v
#### A masked pattern was here ####
val_409 2008-04-08 11
val_409 2008-04-08 11
val_409 2008-04-08 11
-PREHOOK: query: describe formatted v
+PREHOOK: query: describe formatted vt.v
PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@v
-POSTHOOK: query: describe formatted v
+PREHOOK: Input: vt@v
+POSTHOOK: query: describe formatted vt.v
POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@v
+POSTHOOK: Input: vt@v
# col_name data_type comment
value string
@@ -180,7 +204,7 @@ ds string
hr string
# Detailed Table Information
-Database: default
+Database: vt
#### A masked pattern was here ####
Protect Mode: None
Retention: 0
@@ -200,44 +224,42 @@ Sort Columns: []
# View Information
View Original Text: select value, ds, hr from srcpart
View Expanded Text: select `srcpart`.`value`, `srcpart`.`ds`, `srcpart`.`hr` from `default`.`srcpart`
-PREHOOK: query: show partitions v
+PREHOOK: query: show partitions vt.v
PREHOOK: type: SHOWPARTITIONS
-PREHOOK: Input: default@v
-POSTHOOK: query: show partitions v
+PREHOOK: Input: vt@v
+POSTHOOK: query: show partitions vt.v
POSTHOOK: type: SHOWPARTITIONS
-POSTHOOK: Input: default@v
-ds=2008-04-08/hr=11
-ds=2008-04-08/hr=12
+POSTHOOK: Input: vt@v
PREHOOK: query: -- altering partitioned view 2
-create or replace view v partitioned on (ds, hr) as select key, value, ds, hr from srcpart
+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
POSTHOOK: query: -- altering partitioned view 2
-create or replace view v partitioned on (ds, hr) as select key, value, ds, hr from srcpart
+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: default@v
-PREHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11'
+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
PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-PREHOOK: Input: default@v
+PREHOOK: Input: vt@v
#### A masked pattern was here ####
-POSTHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11'
+POSTHOOK: query: select * from vt.v where value='val_409' and ds='2008-04-08' and hr='11'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11
-POSTHOOK: Input: default@v
+POSTHOOK: Input: vt@v
#### A masked pattern was here ####
409 val_409 2008-04-08 11
409 val_409 2008-04-08 11
409 val_409 2008-04-08 11
-PREHOOK: query: describe formatted v
+PREHOOK: query: describe formatted vt.v
PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@v
-POSTHOOK: query: describe formatted v
+PREHOOK: Input: vt@v
+POSTHOOK: query: describe formatted vt.v
POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@v
+POSTHOOK: Input: vt@v
# col_name data_type comment
key string
@@ -250,7 +272,7 @@ ds string
hr string
# Detailed Table Information
-Database: default
+Database: vt
#### A masked pattern was here ####
Protect Mode: None
Retention: 0
@@ -270,22 +292,20 @@ Sort Columns: []
# View Information
View Original Text: select key, value, ds, hr from srcpart
View Expanded Text: select `srcpart`.`key`, `srcpart`.`value`, `srcpart`.`ds`, `srcpart`.`hr` from `default`.`srcpart`
-PREHOOK: query: show partitions v
+PREHOOK: query: show partitions vt.v
PREHOOK: type: SHOWPARTITIONS
-PREHOOK: Input: default@v
-POSTHOOK: query: show partitions v
+PREHOOK: Input: vt@v
+POSTHOOK: query: show partitions vt.v
POSTHOOK: type: SHOWPARTITIONS
-POSTHOOK: Input: default@v
-ds=2008-04-08/hr=11
-ds=2008-04-08/hr=12
-PREHOOK: query: drop view v
+POSTHOOK: Input: vt@v
+PREHOOK: query: drop view vt.v
PREHOOK: type: DROPVIEW
-PREHOOK: Input: default@v
-PREHOOK: Output: default@v
-POSTHOOK: query: drop view v
+PREHOOK: Input: vt@v
+PREHOOK: Output: vt@v
+POSTHOOK: query: drop view vt.v
POSTHOOK: type: DROPVIEW
-POSTHOOK: Input: default@v
-POSTHOOK: Output: default@v
+POSTHOOK: Input: vt@v
+POSTHOOK: Output: vt@v
PREHOOK: query: -- updating to fix view with invalid definition
create table srcpart_temp like srcpart
PREHOOK: type: CREATETABLE
@@ -296,13 +316,13 @@ create table srcpart_temp like srcpart
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@srcpart_temp
-PREHOOK: query: create view v partitioned on (ds, hr) as select * from 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
-POSTHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart_temp
+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: default@v
+POSTHOOK: Output: vt@v
PREHOOK: query: drop table srcpart_temp
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@srcpart_temp
@@ -311,21 +331,21 @@ POSTHOOK: query: drop table srcpart_temp
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@srcpart_temp
POSTHOOK: Output: default@srcpart_temp
-PREHOOK: query: -- v is now invalid
-create or replace view v partitioned on (ds, hr) as select * from srcpart
+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
-POSTHOOK: query: -- v is now invalid
-create or replace view v partitioned on (ds, hr) as select * from srcpart
+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: default@v
-PREHOOK: query: describe formatted v
+POSTHOOK: Output: vt@v
+PREHOOK: query: describe formatted vt.v
PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@v
-POSTHOOK: query: describe formatted v
+PREHOOK: Input: vt@v
+POSTHOOK: query: describe formatted vt.v
POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@v
+POSTHOOK: Input: vt@v
# col_name data_type comment
key string
@@ -338,7 +358,7 @@ ds string
hr string
# Detailed Table Information
-Database: default
+Database: vt
#### A masked pattern was here ####
Protect Mode: None
Retention: 0
@@ -358,11 +378,19 @@ Sort Columns: []
# View Information
View Original Text: select * from srcpart
View Expanded Text: select `srcpart`.`key`, `srcpart`.`value`, `srcpart`.`ds`, `srcpart`.`hr` from `default`.`srcpart`
-PREHOOK: query: drop view v
+PREHOOK: query: drop view vt.v
PREHOOK: type: DROPVIEW
-PREHOOK: Input: default@v
-PREHOOK: Output: default@v
-POSTHOOK: query: drop view v
+PREHOOK: Input: vt@v
+PREHOOK: Output: vt@v
+POSTHOOK: query: drop view vt.v
POSTHOOK: type: DROPVIEW
-POSTHOOK: Input: default@v
-POSTHOOK: Output: default@v
+POSTHOOK: Input: vt@v
+POSTHOOK: Output: vt@v
+PREHOOK: query: drop database vt
+PREHOOK: type: DROPDATABASE
+PREHOOK: Input: database:vt
+PREHOOK: Output: database:vt
+POSTHOOK: query: drop database vt
+POSTHOOK: type: DROPDATABASE
+POSTHOOK: Input: database:vt
+POSTHOOK: Output: database:vt
Modified: hive/trunk/ql/src/test/results/clientpositive/drop_multi_partitions.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/drop_multi_partitions.q.out?rev=1620472&r1=1620471&r2=1620472&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/drop_multi_partitions.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/drop_multi_partitions.q.out Mon Aug 25 21:56:13 2014
@@ -1,55 +1,64 @@
-PREHOOK: query: create table mp (a string) partitioned by (b string, c string)
+PREHOOK: query: create database dmp
+PREHOOK: type: CREATEDATABASE
+PREHOOK: Output: database:dmp
+POSTHOOK: query: create database dmp
+POSTHOOK: type: CREATEDATABASE
+POSTHOOK: Output: database:dmp
+PREHOOK: query: create table dmp.mp (a string) partitioned by (b string, c string)
PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@mp
-POSTHOOK: query: create table mp (a string) partitioned by (b string, c string)
+PREHOOK: Output: database:dmp
+PREHOOK: Output: dmp@dmp.mp
+POSTHOOK: query: create table dmp.mp (a string) partitioned by (b string, c string)
POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@mp
-PREHOOK: query: alter table mp add partition (b='1', c='1')
+POSTHOOK: Output: database:dmp
+POSTHOOK: Output: dmp@dmp.mp
+POSTHOOK: Output: dmp@mp
+PREHOOK: query: alter table dmp.mp add partition (b='1', c='1')
PREHOOK: type: ALTERTABLE_ADDPARTS
-PREHOOK: Output: default@mp
-POSTHOOK: query: alter table mp add partition (b='1', c='1')
+PREHOOK: Output: dmp@mp
+POSTHOOK: query: alter table dmp.mp add partition (b='1', c='1')
POSTHOOK: type: ALTERTABLE_ADDPARTS
-POSTHOOK: Output: default@mp
-POSTHOOK: Output: default@mp@b=1/c=1
-PREHOOK: query: alter table mp add partition (b='1', c='2')
+POSTHOOK: Output: dmp@mp
+POSTHOOK: Output: dmp@mp@b=1/c=1
+PREHOOK: query: alter table dmp.mp add partition (b='1', c='2')
PREHOOK: type: ALTERTABLE_ADDPARTS
-PREHOOK: Output: default@mp
-POSTHOOK: query: alter table mp add partition (b='1', c='2')
+PREHOOK: Output: dmp@mp
+POSTHOOK: query: alter table dmp.mp add partition (b='1', c='2')
POSTHOOK: type: ALTERTABLE_ADDPARTS
-POSTHOOK: Output: default@mp
-POSTHOOK: Output: default@mp@b=1/c=2
-PREHOOK: query: alter table mp add partition (b='2', c='2')
+POSTHOOK: Output: dmp@mp
+POSTHOOK: Output: dmp@mp@b=1/c=2
+PREHOOK: query: alter table dmp.mp add partition (b='2', c='2')
PREHOOK: type: ALTERTABLE_ADDPARTS
-PREHOOK: Output: default@mp
-POSTHOOK: query: alter table mp add partition (b='2', c='2')
+PREHOOK: Output: dmp@mp
+POSTHOOK: query: alter table dmp.mp add partition (b='2', c='2')
POSTHOOK: type: ALTERTABLE_ADDPARTS
-POSTHOOK: Output: default@mp
-POSTHOOK: Output: default@mp@b=2/c=2
-PREHOOK: query: show partitions mp
+POSTHOOK: Output: dmp@mp
+POSTHOOK: Output: dmp@mp@b=2/c=2
+PREHOOK: query: show partitions dmp.mp
PREHOOK: type: SHOWPARTITIONS
-PREHOOK: Input: default@mp
-POSTHOOK: query: show partitions mp
+PREHOOK: Input: dmp@mp
+POSTHOOK: query: show partitions dmp.mp
POSTHOOK: type: SHOWPARTITIONS
-POSTHOOK: Input: default@mp
+POSTHOOK: Input: dmp@mp
b=1/c=1
b=1/c=2
b=2/c=2
-PREHOOK: query: explain extended alter table mp drop partition (b='1')
+PREHOOK: query: explain extended alter table dmp.mp drop partition (b='1')
PREHOOK: type: ALTERTABLE_DROPPARTS
-POSTHOOK: query: explain extended alter table mp drop partition (b='1')
+POSTHOOK: query: explain extended alter table dmp.mp drop partition (b='1')
POSTHOOK: type: ALTERTABLE_DROPPARTS
ABSTRACT SYNTAX TREE:
-TOK_ALTERTABLE_DROPPARTS
+TOK_ALTERTABLE
TOK_TABNAME
+ dmp
mp
- TOK_PARTSPEC
- TOK_PARTVAL
- b
- =
- '1'
+ TOK_ALTERTABLE_DROPPARTS
+ TOK_PARTSPEC
+ TOK_PARTVAL
+ b
+ =
+ '1'
STAGE DEPENDENCIES:
@@ -59,35 +68,51 @@ STAGE PLANS:
Stage: Stage-0
Drop Table Operator:
Drop Table
- table: default.mp
+ table: dmp.mp
-PREHOOK: query: alter table mp drop partition (b='1')
+PREHOOK: query: alter table dmp.mp drop partition (b='1')
PREHOOK: type: ALTERTABLE_DROPPARTS
-PREHOOK: Input: default@mp
-PREHOOK: Output: default@mp@b=1/c=1
-PREHOOK: Output: default@mp@b=1/c=2
-POSTHOOK: query: alter table mp drop partition (b='1')
+PREHOOK: Input: dmp@mp
+PREHOOK: Output: dmp@mp@b=1/c=1
+PREHOOK: Output: dmp@mp@b=1/c=2
+POSTHOOK: query: alter table dmp.mp drop partition (b='1')
POSTHOOK: type: ALTERTABLE_DROPPARTS
-POSTHOOK: Input: default@mp
-POSTHOOK: Output: default@mp@b=1/c=1
-POSTHOOK: Output: default@mp@b=1/c=2
-PREHOOK: query: show partitions mp
+POSTHOOK: Input: dmp@mp
+POSTHOOK: Output: dmp@mp@b=1/c=1
+POSTHOOK: Output: dmp@mp@b=1/c=2
+PREHOOK: query: show partitions dmp.mp
PREHOOK: type: SHOWPARTITIONS
-PREHOOK: Input: default@mp
-POSTHOOK: query: show partitions mp
+PREHOOK: Input: dmp@mp
+POSTHOOK: query: show partitions dmp.mp
POSTHOOK: type: SHOWPARTITIONS
-POSTHOOK: Input: default@mp
+POSTHOOK: Input: dmp@mp
b=2/c=2
-PREHOOK: query: alter table mp drop if exists partition (b='3')
+PREHOOK: query: alter table dmp.mp drop if exists partition (b='3')
PREHOOK: type: ALTERTABLE_DROPPARTS
-PREHOOK: Input: default@mp
-POSTHOOK: query: alter table mp drop if exists partition (b='3')
+PREHOOK: Input: dmp@mp
+POSTHOOK: query: alter table dmp.mp drop if exists partition (b='3')
POSTHOOK: type: ALTERTABLE_DROPPARTS
-POSTHOOK: Input: default@mp
-PREHOOK: query: show partitions mp
+POSTHOOK: Input: dmp@mp
+PREHOOK: query: show partitions dmp.mp
PREHOOK: type: SHOWPARTITIONS
-PREHOOK: Input: default@mp
-POSTHOOK: query: show partitions mp
+PREHOOK: Input: dmp@mp
+POSTHOOK: query: show partitions dmp.mp
POSTHOOK: type: SHOWPARTITIONS
-POSTHOOK: Input: default@mp
+POSTHOOK: Input: dmp@mp
b=2/c=2
+PREHOOK: query: drop table dmp.mp
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: dmp@mp
+PREHOOK: Output: dmp@mp
+POSTHOOK: query: drop table dmp.mp
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: dmp@mp
+POSTHOOK: Output: dmp@mp
+PREHOOK: query: drop database dmp
+PREHOOK: type: DROPDATABASE
+PREHOOK: Input: database:dmp
+PREHOOK: Output: database:dmp
+POSTHOOK: query: drop database dmp
+POSTHOOK: type: DROPDATABASE
+POSTHOOK: Input: database:dmp
+POSTHOOK: Output: database:dmp
Modified: hive/trunk/ql/src/test/results/clientpositive/exchange_partition.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/exchange_partition.q.out?rev=1620472&r1=1620471&r2=1620472&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exchange_partition.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/exchange_partition.q.out Mon Aug 25 21:56:13 2014
@@ -1,65 +1,79 @@
-PREHOOK: query: CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING)
+PREHOOK: query: create database ex1
+PREHOOK: type: CREATEDATABASE
+PREHOOK: Output: database:ex1
+POSTHOOK: query: create database ex1
+POSTHOOK: type: CREATEDATABASE
+POSTHOOK: Output: database:ex1
+PREHOOK: query: create database ex2
+PREHOOK: type: CREATEDATABASE
+PREHOOK: Output: database:ex2
+POSTHOOK: query: create database ex2
+POSTHOOK: type: CREATEDATABASE
+POSTHOOK: Output: database:ex2
+PREHOOK: query: CREATE TABLE ex1.exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING)
PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@exchange_part_test1
-POSTHOOK: query: CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING)
+PREHOOK: Output: database:ex1
+PREHOOK: Output: ex1@ex1.exchange_part_test1
+POSTHOOK: query: CREATE TABLE ex1.exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING)
POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@exchange_part_test1
-PREHOOK: query: CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING)
+POSTHOOK: Output: database:ex1
+POSTHOOK: Output: ex1@ex1.exchange_part_test1
+POSTHOOK: Output: ex1@exchange_part_test1
+PREHOOK: query: CREATE TABLE ex2.exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING)
PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@exchange_part_test2
-POSTHOOK: query: CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING)
+PREHOOK: Output: database:ex2
+PREHOOK: Output: ex2@ex2.exchange_part_test2
+POSTHOOK: query: CREATE TABLE ex2.exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING)
POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@exchange_part_test2
-PREHOOK: query: SHOW PARTITIONS exchange_part_test1
-PREHOOK: type: SHOWPARTITIONS
-PREHOOK: Input: default@exchange_part_test1
-POSTHOOK: query: SHOW PARTITIONS exchange_part_test1
+POSTHOOK: Output: database:ex2
+POSTHOOK: Output: ex2@ex2.exchange_part_test2
+POSTHOOK: Output: ex2@exchange_part_test2
+PREHOOK: query: SHOW PARTITIONS ex1.exchange_part_test1
+PREHOOK: type: SHOWPARTITIONS
+PREHOOK: Input: ex1@exchange_part_test1
+POSTHOOK: query: SHOW PARTITIONS ex1.exchange_part_test1
POSTHOOK: type: SHOWPARTITIONS
-POSTHOOK: Input: default@exchange_part_test1
-PREHOOK: query: SHOW PARTITIONS exchange_part_test2
+POSTHOOK: Input: ex1@exchange_part_test1
+PREHOOK: query: SHOW PARTITIONS ex2.exchange_part_test2
PREHOOK: type: SHOWPARTITIONS
-PREHOOK: Input: default@exchange_part_test2
-POSTHOOK: query: SHOW PARTITIONS exchange_part_test2
+PREHOOK: Input: ex2@exchange_part_test2
+POSTHOOK: query: SHOW PARTITIONS ex2.exchange_part_test2
POSTHOOK: type: SHOWPARTITIONS
-POSTHOOK: Input: default@exchange_part_test2
-PREHOOK: query: ALTER TABLE exchange_part_test2 ADD PARTITION (ds='2013-04-05')
+POSTHOOK: Input: ex2@exchange_part_test2
+PREHOOK: query: ALTER TABLE ex2.exchange_part_test2 ADD PARTITION (ds='2013-04-05')
PREHOOK: type: ALTERTABLE_ADDPARTS
-PREHOOK: Output: default@exchange_part_test2
-POSTHOOK: query: ALTER TABLE exchange_part_test2 ADD PARTITION (ds='2013-04-05')
+PREHOOK: Output: ex2@exchange_part_test2
+POSTHOOK: query: ALTER TABLE ex2.exchange_part_test2 ADD PARTITION (ds='2013-04-05')
POSTHOOK: type: ALTERTABLE_ADDPARTS
-POSTHOOK: Output: default@exchange_part_test2
-POSTHOOK: Output: default@exchange_part_test2@ds=2013-04-05
-PREHOOK: query: SHOW PARTITIONS exchange_part_test1
+POSTHOOK: Output: ex2@exchange_part_test2
+POSTHOOK: Output: ex2@exchange_part_test2@ds=2013-04-05
+PREHOOK: query: SHOW PARTITIONS ex1.exchange_part_test1
PREHOOK: type: SHOWPARTITIONS
-PREHOOK: Input: default@exchange_part_test1
-POSTHOOK: query: SHOW PARTITIONS exchange_part_test1
+PREHOOK: Input: ex1@exchange_part_test1
+POSTHOOK: query: SHOW PARTITIONS ex1.exchange_part_test1
POSTHOOK: type: SHOWPARTITIONS
-POSTHOOK: Input: default@exchange_part_test1
-PREHOOK: query: SHOW PARTITIONS exchange_part_test2
+POSTHOOK: Input: ex1@exchange_part_test1
+PREHOOK: query: SHOW PARTITIONS ex2.exchange_part_test2
PREHOOK: type: SHOWPARTITIONS
-PREHOOK: Input: default@exchange_part_test2
-POSTHOOK: query: SHOW PARTITIONS exchange_part_test2
+PREHOOK: Input: ex2@exchange_part_test2
+POSTHOOK: query: SHOW PARTITIONS ex2.exchange_part_test2
POSTHOOK: type: SHOWPARTITIONS
-POSTHOOK: Input: default@exchange_part_test2
+POSTHOOK: Input: ex2@exchange_part_test2
ds=2013-04-05
-PREHOOK: query: ALTER TABLE exchange_part_test1 EXCHANGE PARTITION (ds='2013-04-05') WITH TABLE exchange_part_test2
+PREHOOK: query: ALTER TABLE ex1.exchange_part_test1 EXCHANGE PARTITION (ds='2013-04-05') WITH TABLE ex2.exchange_part_test2
PREHOOK: type: null
-POSTHOOK: query: ALTER TABLE exchange_part_test1 EXCHANGE PARTITION (ds='2013-04-05') WITH TABLE exchange_part_test2
+POSTHOOK: query: ALTER TABLE ex1.exchange_part_test1 EXCHANGE PARTITION (ds='2013-04-05') WITH TABLE ex2.exchange_part_test2
POSTHOOK: type: null
-PREHOOK: query: SHOW PARTITIONS exchange_part_test1
+PREHOOK: query: SHOW PARTITIONS ex1.exchange_part_test1
PREHOOK: type: SHOWPARTITIONS
-PREHOOK: Input: default@exchange_part_test1
-POSTHOOK: query: SHOW PARTITIONS exchange_part_test1
+PREHOOK: Input: ex1@exchange_part_test1
+POSTHOOK: query: SHOW PARTITIONS ex1.exchange_part_test1
POSTHOOK: type: SHOWPARTITIONS
-POSTHOOK: Input: default@exchange_part_test1
+POSTHOOK: Input: ex1@exchange_part_test1
ds=2013-04-05
-PREHOOK: query: SHOW PARTITIONS exchange_part_test2
+PREHOOK: query: SHOW PARTITIONS ex2.exchange_part_test2
PREHOOK: type: SHOWPARTITIONS
-PREHOOK: Input: default@exchange_part_test2
-POSTHOOK: query: SHOW PARTITIONS exchange_part_test2
+PREHOOK: Input: ex2@exchange_part_test2
+POSTHOOK: query: SHOW PARTITIONS ex2.exchange_part_test2
POSTHOOK: type: SHOWPARTITIONS
-POSTHOOK: Input: default@exchange_part_test2
+POSTHOOK: Input: ex2@exchange_part_test2
Modified: hive/trunk/ql/src/test/results/clientpositive/index_auto_empty.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_auto_empty.q.out?rev=1620472&r1=1620471&r2=1620472&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_auto_empty.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_auto_empty.q.out Mon Aug 25 21:56:13 2014
@@ -1,50 +1,57 @@
PREHOOK: query: -- Test to ensure that an empty index result is propagated correctly
--- Create temp, and populate it with some values in src.
-CREATE TABLE temp(key STRING, val STRING) STORED AS TEXTFILE
-PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@temp
+CREATE DATABASE it
+PREHOOK: type: CREATEDATABASE
+PREHOOK: Output: database:it
POSTHOOK: query: -- Test to ensure that an empty index result is propagated correctly
--- Create temp, and populate it with some values in src.
-CREATE TABLE temp(key STRING, val STRING) STORED AS TEXTFILE
+CREATE DATABASE it
+POSTHOOK: type: CREATEDATABASE
+POSTHOOK: Output: database:it
+PREHOOK: query: -- Create temp, and populate it with some values in src.
+CREATE TABLE it.temp(key STRING, val STRING) STORED AS TEXTFILE
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:it
+PREHOOK: Output: it@it.temp
+POSTHOOK: query: -- Create temp, and populate it with some values in src.
+CREATE TABLE it.temp(key STRING, val STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@temp
-PREHOOK: query: -- Build an index on temp.
-CREATE INDEX temp_index ON TABLE temp(key) as 'COMPACT' WITH DEFERRED REBUILD
+POSTHOOK: Output: database:it
+POSTHOOK: Output: it@it.temp
+POSTHOOK: Output: it@temp
+PREHOOK: query: -- Build an index on it.temp.
+CREATE INDEX temp_index ON TABLE it.temp(key) as 'COMPACT' WITH DEFERRED REBUILD
PREHOOK: type: CREATEINDEX
-PREHOOK: Input: default@temp
-POSTHOOK: query: -- Build an index on temp.
-CREATE INDEX temp_index ON TABLE temp(key) as 'COMPACT' WITH DEFERRED REBUILD
+PREHOOK: Input: it@temp
+POSTHOOK: query: -- Build an index on it.temp.
+CREATE INDEX temp_index ON TABLE it.temp(key) as 'COMPACT' WITH DEFERRED REBUILD
POSTHOOK: type: CREATEINDEX
-POSTHOOK: Input: default@temp
-POSTHOOK: Output: default@default__temp_temp_index__
-PREHOOK: query: ALTER INDEX temp_index ON temp REBUILD
+POSTHOOK: Input: it@temp
+POSTHOOK: Output: it@it__temp_temp_index__
+PREHOOK: query: ALTER INDEX temp_index ON it.temp REBUILD
PREHOOK: type: ALTERINDEX_REBUILD
-PREHOOK: Input: default@temp
-PREHOOK: Output: default@default__temp_temp_index__
-POSTHOOK: query: ALTER INDEX temp_index ON temp REBUILD
+PREHOOK: Input: it@temp
+PREHOOK: Output: it@it__temp_temp_index__
+POSTHOOK: query: ALTER INDEX temp_index ON it.temp REBUILD
POSTHOOK: type: ALTERINDEX_REBUILD
-POSTHOOK: Input: default@temp
-POSTHOOK: Output: default@default__temp_temp_index__
-POSTHOOK: Lineage: default__temp_temp_index__._bucketname SIMPLE [(temp)temp.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-POSTHOOK: Lineage: default__temp_temp_index__._offsets EXPRESSION [(temp)temp.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
-POSTHOOK: Lineage: default__temp_temp_index__.key SIMPLE [(temp)temp.FieldSchema(name:key, type:string, comment:null), ]
+POSTHOOK: Input: it@temp
+POSTHOOK: Output: it@it__temp_temp_index__
+POSTHOOK: Lineage: it__temp_temp_index__._bucketname SIMPLE [(temp)temp.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: it__temp_temp_index__._offsets EXPRESSION [(temp)temp.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ]
+POSTHOOK: Lineage: it__temp_temp_index__.key SIMPLE [(temp)temp.FieldSchema(name:key, type:string, comment:null), ]
PREHOOK: query: -- query should not return any values
-SELECT * FROM default__temp_temp_index__ WHERE key = 86
+SELECT * FROM it.it__temp_temp_index__ WHERE key = 86
PREHOOK: type: QUERY
-PREHOOK: Input: default@default__temp_temp_index__
+PREHOOK: Input: it@it__temp_temp_index__
#### A masked pattern was here ####
POSTHOOK: query: -- query should not return any values
-SELECT * FROM default__temp_temp_index__ WHERE key = 86
+SELECT * FROM it.it__temp_temp_index__ WHERE key = 86
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@default__temp_temp_index__
+POSTHOOK: Input: it@it__temp_temp_index__
#### A masked pattern was here ####
-PREHOOK: query: EXPLAIN SELECT * FROM temp WHERE key = 86
+PREHOOK: query: EXPLAIN SELECT * FROM it.temp WHERE key = 86
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN SELECT * FROM temp WHERE key = 86
+POSTHOOK: query: EXPLAIN SELECT * FROM it.temp WHERE key = 86
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -79,19 +86,27 @@ STAGE PLANS:
Processor Tree:
ListSink
-PREHOOK: query: SELECT * FROM temp WHERE key = 86
+PREHOOK: query: SELECT * FROM it.temp WHERE key = 86
PREHOOK: type: QUERY
-PREHOOK: Input: default@temp
+PREHOOK: Input: it@temp
#### A masked pattern was here ####
-POSTHOOK: query: SELECT * FROM temp WHERE key = 86
+POSTHOOK: query: SELECT * FROM it.temp WHERE key = 86
POSTHOOK: type: QUERY
-POSTHOOK: Input: default@temp
+POSTHOOK: Input: it@temp
#### A masked pattern was here ####
-PREHOOK: query: DROP table temp
+PREHOOK: query: DROP table it.temp
PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@temp
-PREHOOK: Output: default@temp
-POSTHOOK: query: DROP table temp
+PREHOOK: Input: it@temp
+PREHOOK: Output: it@temp
+POSTHOOK: query: DROP table it.temp
POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@temp
-POSTHOOK: Output: default@temp
+POSTHOOK: Input: it@temp
+POSTHOOK: Output: it@temp
+PREHOOK: query: DROP DATABASE it
+PREHOOK: type: DROPDATABASE
+PREHOOK: Input: database:it
+PREHOOK: Output: database:it
+POSTHOOK: query: DROP DATABASE it
+POSTHOOK: type: DROPDATABASE
+POSTHOOK: Input: database:it
+POSTHOOK: Output: database:it
Modified: hive/trunk/ql/src/test/results/clientpositive/touch.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/touch.q.out?rev=1620472&r1=1620471&r2=1620472&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/touch.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/touch.q.out Mon Aug 25 21:56:13 2014
@@ -1,89 +1,97 @@
-PREHOOK: query: drop table tstsrc
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tstsrc
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: drop table tstsrcpart
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tstsrcpart
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: create table tstsrc like src
+PREHOOK: query: create database tc
+PREHOOK: type: CREATEDATABASE
+PREHOOK: Output: database:tc
+POSTHOOK: query: create database tc
+POSTHOOK: type: CREATEDATABASE
+POSTHOOK: Output: database:tc
+PREHOOK: query: create table tc.tstsrc like default.src
PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@tstsrc
-POSTHOOK: query: create table tstsrc like src
+PREHOOK: Output: database:tc
+PREHOOK: Output: tc@tc.tstsrc
+POSTHOOK: query: create table tc.tstsrc like default.src
POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@tstsrc
-PREHOOK: query: insert overwrite table tstsrc select key, value from src
+POSTHOOK: Output: database:tc
+POSTHOOK: Output: tc@tc.tstsrc
+POSTHOOK: Output: tc@tstsrc
+PREHOOK: query: insert overwrite table tc.tstsrc select key, value from default.src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: default@tstsrc
-POSTHOOK: query: insert overwrite table tstsrc select key, value from src
+PREHOOK: Output: tc@tstsrc
+POSTHOOK: query: insert overwrite table tc.tstsrc select key, value from default.src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: default@tstsrc
+POSTHOOK: Output: tc@tstsrc
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), ]
-PREHOOK: query: create table tstsrcpart like srcpart
+PREHOOK: query: create table tc.tstsrcpart like default.srcpart
PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@tstsrcpart
-POSTHOOK: query: create table tstsrcpart like srcpart
+PREHOOK: Output: database:tc
+PREHOOK: Output: tc@tc.tstsrcpart
+POSTHOOK: query: create table tc.tstsrcpart like default.srcpart
POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@tstsrcpart
-PREHOOK: query: insert overwrite table tstsrcpart partition (ds='2008-04-08', hr='12')
-select key, value from srcpart where ds='2008-04-08' and hr='12'
+POSTHOOK: Output: database:tc
+POSTHOOK: Output: tc@tc.tstsrcpart
+POSTHOOK: Output: tc@tstsrcpart
+PREHOOK: query: insert overwrite table tc.tstsrcpart partition (ds='2008-04-08', hr='12')
+select key, value from default.srcpart where ds='2008-04-08' and hr='12'
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-PREHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=12
-POSTHOOK: query: insert overwrite table tstsrcpart partition (ds='2008-04-08', hr='12')
-select key, value from srcpart where ds='2008-04-08' and hr='12'
+PREHOOK: Output: tc@tstsrcpart@ds=2008-04-08/hr=12
+POSTHOOK: query: insert overwrite table tc.tstsrcpart partition (ds='2008-04-08', hr='12')
+select key, value from default.srcpart where ds='2008-04-08' and hr='12'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-POSTHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=12
+POSTHOOK: Output: tc@tstsrcpart@ds=2008-04-08/hr=12
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-08,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: ALTER TABLE tstsrc TOUCH
+PREHOOK: query: ALTER TABLE tc.tstsrc TOUCH
PREHOOK: type: ALTERTABLE_TOUCH
-PREHOOK: Input: default@tstsrc
-PREHOOK: Output: default@tstsrc
-POSTHOOK: query: ALTER TABLE tstsrc TOUCH
+PREHOOK: Input: tc@tstsrc
+PREHOOK: Output: tc@tstsrc
+POSTHOOK: query: ALTER TABLE tc.tstsrc TOUCH
POSTHOOK: type: ALTERTABLE_TOUCH
-POSTHOOK: Input: default@tstsrc
-POSTHOOK: Output: default@tstsrc
-PREHOOK: query: ALTER TABLE tstsrcpart TOUCH
+POSTHOOK: Input: tc@tstsrc
+POSTHOOK: Output: tc@tstsrc
+PREHOOK: query: ALTER TABLE tc.tstsrcpart TOUCH
PREHOOK: type: ALTERTABLE_TOUCH
-PREHOOK: Input: default@tstsrcpart
-PREHOOK: Output: default@tstsrcpart
-POSTHOOK: query: ALTER TABLE tstsrcpart TOUCH
+PREHOOK: Input: tc@tstsrcpart
+PREHOOK: Output: tc@tstsrcpart
+POSTHOOK: query: ALTER TABLE tc.tstsrcpart TOUCH
POSTHOOK: type: ALTERTABLE_TOUCH
-POSTHOOK: Input: default@tstsrcpart
-POSTHOOK: Output: default@tstsrcpart
-PREHOOK: query: ALTER TABLE tstsrcpart TOUCH PARTITION (ds='2008-04-08', hr='12')
+POSTHOOK: Input: tc@tstsrcpart
+POSTHOOK: Output: tc@tstsrcpart
+PREHOOK: query: ALTER TABLE tc.tstsrcpart TOUCH PARTITION (ds='2008-04-08', hr='12')
PREHOOK: type: ALTERTABLE_TOUCH
-PREHOOK: Input: default@tstsrcpart
-PREHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=12
-POSTHOOK: query: ALTER TABLE tstsrcpart TOUCH PARTITION (ds='2008-04-08', hr='12')
+PREHOOK: Input: tc@tstsrcpart
+PREHOOK: Output: tc@tstsrcpart@ds=2008-04-08/hr=12
+POSTHOOK: query: ALTER TABLE tc.tstsrcpart TOUCH PARTITION (ds='2008-04-08', hr='12')
POSTHOOK: type: ALTERTABLE_TOUCH
-POSTHOOK: Input: default@tstsrcpart
-POSTHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=12
-POSTHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=12
-PREHOOK: query: drop table tstsrc
+POSTHOOK: Input: tc@tstsrcpart
+POSTHOOK: Input: tc@tstsrcpart@ds=2008-04-08/hr=12
+POSTHOOK: Output: tc@tstsrcpart@ds=2008-04-08/hr=12
+PREHOOK: query: drop table tc.tstsrc
PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@tstsrc
-PREHOOK: Output: default@tstsrc
-POSTHOOK: query: drop table tstsrc
+PREHOOK: Input: tc@tstsrc
+PREHOOK: Output: tc@tstsrc
+POSTHOOK: query: drop table tc.tstsrc
POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@tstsrc
-POSTHOOK: Output: default@tstsrc
-PREHOOK: query: drop table tstsrcpart
+POSTHOOK: Input: tc@tstsrc
+POSTHOOK: Output: tc@tstsrc
+PREHOOK: query: drop table tc.tstsrcpart
PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@tstsrcpart
-PREHOOK: Output: default@tstsrcpart
-POSTHOOK: query: drop table tstsrcpart
+PREHOOK: Input: tc@tstsrcpart
+PREHOOK: Output: tc@tstsrcpart
+POSTHOOK: query: drop table tc.tstsrcpart
POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@tstsrcpart
-POSTHOOK: Output: default@tstsrcpart
+POSTHOOK: Input: tc@tstsrcpart
+POSTHOOK: Output: tc@tstsrcpart
+PREHOOK: query: drop database tc
+PREHOOK: type: DROPDATABASE
+PREHOOK: Input: database:tc
+PREHOOK: Output: database:tc
+POSTHOOK: query: drop database tc
+POSTHOOK: type: DROPDATABASE
+POSTHOOK: Input: database:tc
+POSTHOOK: Output: database:tc
Modified: hive/trunk/ql/src/test/results/clientpositive/unset_table_view_property.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/unset_table_view_property.q.out?rev=1620472&r1=1620471&r2=1620472&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/unset_table_view_property.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/unset_table_view_property.q.out Mon Aug 25 21:56:13 2014
@@ -1,29 +1,36 @@
-PREHOOK: query: CREATE TABLE testTable(col1 INT, col2 INT)
+PREHOOK: query: CREATE DATABASE vt
+PREHOOK: type: CREATEDATABASE
+PREHOOK: Output: database:vt
+POSTHOOK: query: CREATE DATABASE vt
+POSTHOOK: type: CREATEDATABASE
+POSTHOOK: Output: database:vt
+PREHOOK: query: CREATE TABLE vt.testTable(col1 INT, col2 INT)
PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@testTable
-POSTHOOK: query: CREATE TABLE testTable(col1 INT, col2 INT)
+PREHOOK: Output: database:vt
+PREHOOK: Output: vt@vt.testTable
+POSTHOOK: query: CREATE TABLE vt.testTable(col1 INT, col2 INT)
POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@testTable
-PREHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: Output: database:vt
+POSTHOOK: Output: vt@testTable
+POSTHOOK: Output: vt@vt.testTable
+PREHOOK: query: SHOW TBLPROPERTIES vt.testTable
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testTable
POSTHOOK: type: SHOW_TBLPROPERTIES
#### A masked pattern was here ####
PREHOOK: query: -- UNSET TABLE PROPERTIES
-ALTER TABLE testTable SET TBLPROPERTIES ('a'='1', 'c'='3')
+ALTER TABLE vt.testTable SET TBLPROPERTIES ('a'='1', 'c'='3')
PREHOOK: type: ALTERTABLE_PROPERTIES
-PREHOOK: Input: default@testtable
-PREHOOK: Output: default@testtable
+PREHOOK: Input: vt@testtable
+PREHOOK: Output: vt@testtable
POSTHOOK: query: -- UNSET TABLE PROPERTIES
-ALTER TABLE testTable SET TBLPROPERTIES ('a'='1', 'c'='3')
+ALTER TABLE vt.testTable SET TBLPROPERTIES ('a'='1', 'c'='3')
POSTHOOK: type: ALTERTABLE_PROPERTIES
-POSTHOOK: Input: default@testtable
-POSTHOOK: Output: default@testtable
-PREHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: Input: vt@testtable
+POSTHOOK: Output: vt@testtable
+PREHOOK: query: SHOW TBLPROPERTIES vt.testTable
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testTable
POSTHOOK: type: SHOW_TBLPROPERTIES
COLUMN_STATS_ACCURATE false
a 1
@@ -35,18 +42,18 @@ rawDataSize -1
totalSize 0
#### A masked pattern was here ####
PREHOOK: query: -- UNSET all the properties
-ALTER TABLE testTable UNSET TBLPROPERTIES ('a', 'c')
+ALTER TABLE vt.testTable UNSET TBLPROPERTIES ('a', 'c')
PREHOOK: type: ALTERTABLE_PROPERTIES
-PREHOOK: Input: default@testtable
-PREHOOK: Output: default@testtable
+PREHOOK: Input: vt@testtable
+PREHOOK: Output: vt@testtable
POSTHOOK: query: -- UNSET all the properties
-ALTER TABLE testTable UNSET TBLPROPERTIES ('a', 'c')
+ALTER TABLE vt.testTable UNSET TBLPROPERTIES ('a', 'c')
POSTHOOK: type: ALTERTABLE_PROPERTIES
-POSTHOOK: Input: default@testtable
-POSTHOOK: Output: default@testtable
-PREHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: Input: vt@testtable
+POSTHOOK: Output: vt@testtable
+PREHOOK: query: SHOW TBLPROPERTIES vt.testTable
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testTable
POSTHOOK: type: SHOW_TBLPROPERTIES
COLUMN_STATS_ACCURATE false
#### A masked pattern was here ####
@@ -55,17 +62,17 @@ numRows -1
rawDataSize -1
totalSize 0
#### A masked pattern was here ####
-PREHOOK: query: ALTER TABLE testTable SET TBLPROPERTIES ('a'='1', 'c'='3', 'd'='4')
+PREHOOK: query: ALTER TABLE vt.testTable SET TBLPROPERTIES ('a'='1', 'c'='3', 'd'='4')
PREHOOK: type: ALTERTABLE_PROPERTIES
-PREHOOK: Input: default@testtable
-PREHOOK: Output: default@testtable
-POSTHOOK: query: ALTER TABLE testTable SET TBLPROPERTIES ('a'='1', 'c'='3', 'd'='4')
+PREHOOK: Input: vt@testtable
+PREHOOK: Output: vt@testtable
+POSTHOOK: query: ALTER TABLE vt.testTable SET TBLPROPERTIES ('a'='1', 'c'='3', 'd'='4')
POSTHOOK: type: ALTERTABLE_PROPERTIES
-POSTHOOK: Input: default@testtable
-POSTHOOK: Output: default@testtable
-PREHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: Input: vt@testtable
+POSTHOOK: Output: vt@testtable
+PREHOOK: query: SHOW TBLPROPERTIES vt.testTable
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testTable
POSTHOOK: type: SHOW_TBLPROPERTIES
COLUMN_STATS_ACCURATE false
a 1
@@ -78,18 +85,18 @@ rawDataSize -1
totalSize 0
#### A masked pattern was here ####
PREHOOK: query: -- UNSET a subset of the properties
-ALTER TABLE testTable UNSET TBLPROPERTIES ('a', 'd')
+ALTER TABLE vt.testTable UNSET TBLPROPERTIES ('a', 'd')
PREHOOK: type: ALTERTABLE_PROPERTIES
-PREHOOK: Input: default@testtable
-PREHOOK: Output: default@testtable
+PREHOOK: Input: vt@testtable
+PREHOOK: Output: vt@testtable
POSTHOOK: query: -- UNSET a subset of the properties
-ALTER TABLE testTable UNSET TBLPROPERTIES ('a', 'd')
+ALTER TABLE vt.testTable UNSET TBLPROPERTIES ('a', 'd')
POSTHOOK: type: ALTERTABLE_PROPERTIES
-POSTHOOK: Input: default@testtable
-POSTHOOK: Output: default@testtable
-PREHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: Input: vt@testtable
+POSTHOOK: Output: vt@testtable
+PREHOOK: query: SHOW TBLPROPERTIES vt.testTable
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testTable
POSTHOOK: type: SHOW_TBLPROPERTIES
COLUMN_STATS_ACCURATE false
c 3
@@ -100,18 +107,18 @@ rawDataSize -1
totalSize 0
#### A masked pattern was here ####
PREHOOK: query: -- the same property being UNSET multiple times
-ALTER TABLE testTable UNSET TBLPROPERTIES ('c', 'c', 'c')
+ALTER TABLE vt.testTable UNSET TBLPROPERTIES ('c', 'c', 'c')
PREHOOK: type: ALTERTABLE_PROPERTIES
-PREHOOK: Input: default@testtable
-PREHOOK: Output: default@testtable
+PREHOOK: Input: vt@testtable
+PREHOOK: Output: vt@testtable
POSTHOOK: query: -- the same property being UNSET multiple times
-ALTER TABLE testTable UNSET TBLPROPERTIES ('c', 'c', 'c')
+ALTER TABLE vt.testTable UNSET TBLPROPERTIES ('c', 'c', 'c')
POSTHOOK: type: ALTERTABLE_PROPERTIES
-POSTHOOK: Input: default@testtable
-POSTHOOK: Output: default@testtable
-PREHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: Input: vt@testtable
+POSTHOOK: Output: vt@testtable
+PREHOOK: query: SHOW TBLPROPERTIES vt.testTable
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testTable
POSTHOOK: type: SHOW_TBLPROPERTIES
COLUMN_STATS_ACCURATE false
#### A masked pattern was here ####
@@ -120,17 +127,17 @@ numRows -1
rawDataSize -1
totalSize 0
#### A masked pattern was here ####
-PREHOOK: query: ALTER TABLE testTable SET TBLPROPERTIES ('a'='1', 'b' = '2', 'c'='3', 'd'='4')
+PREHOOK: query: ALTER TABLE vt.testTable SET TBLPROPERTIES ('a'='1', 'b' = '2', 'c'='3', 'd'='4')
PREHOOK: type: ALTERTABLE_PROPERTIES
-PREHOOK: Input: default@testtable
-PREHOOK: Output: default@testtable
-POSTHOOK: query: ALTER TABLE testTable SET TBLPROPERTIES ('a'='1', 'b' = '2', 'c'='3', 'd'='4')
+PREHOOK: Input: vt@testtable
+PREHOOK: Output: vt@testtable
+POSTHOOK: query: ALTER TABLE vt.testTable SET TBLPROPERTIES ('a'='1', 'b' = '2', 'c'='3', 'd'='4')
POSTHOOK: type: ALTERTABLE_PROPERTIES
-POSTHOOK: Input: default@testtable
-POSTHOOK: Output: default@testtable
-PREHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: Input: vt@testtable
+POSTHOOK: Output: vt@testtable
+PREHOOK: query: SHOW TBLPROPERTIES vt.testTable
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testTable
POSTHOOK: type: SHOW_TBLPROPERTIES
COLUMN_STATS_ACCURATE false
a 1
@@ -144,18 +151,18 @@ rawDataSize -1
totalSize 0
#### A masked pattern was here ####
PREHOOK: query: -- UNSET a subset of the properties and some non-existed properties using IF EXISTS
-ALTER TABLE testTable UNSET TBLPROPERTIES IF EXISTS ('b', 'd', 'b', 'f')
+ALTER TABLE vt.testTable UNSET TBLPROPERTIES IF EXISTS ('b', 'd', 'b', 'f')
PREHOOK: type: ALTERTABLE_PROPERTIES
-PREHOOK: Input: default@testtable
-PREHOOK: Output: default@testtable
+PREHOOK: Input: vt@testtable
+PREHOOK: Output: vt@testtable
POSTHOOK: query: -- UNSET a subset of the properties and some non-existed properties using IF EXISTS
-ALTER TABLE testTable UNSET TBLPROPERTIES IF EXISTS ('b', 'd', 'b', 'f')
+ALTER TABLE vt.testTable UNSET TBLPROPERTIES IF EXISTS ('b', 'd', 'b', 'f')
POSTHOOK: type: ALTERTABLE_PROPERTIES
-POSTHOOK: Input: default@testtable
-POSTHOOK: Output: default@testtable
-PREHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: Input: vt@testtable
+POSTHOOK: Output: vt@testtable
+PREHOOK: query: SHOW TBLPROPERTIES vt.testTable
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testTable
POSTHOOK: type: SHOW_TBLPROPERTIES
COLUMN_STATS_ACCURATE false
a 1
@@ -167,18 +174,18 @@ rawDataSize -1
totalSize 0
#### A masked pattern was here ####
PREHOOK: query: -- UNSET a subset of the properties and some non-existed properties using IF EXISTS
-ALTER TABLE testTable UNSET TBLPROPERTIES IF EXISTS ('b', 'd', 'c', 'f', 'x', 'y', 'z')
+ALTER TABLE vt.testTable UNSET TBLPROPERTIES IF EXISTS ('b', 'd', 'c', 'f', 'x', 'y', 'z')
PREHOOK: type: ALTERTABLE_PROPERTIES
-PREHOOK: Input: default@testtable
-PREHOOK: Output: default@testtable
+PREHOOK: Input: vt@testtable
+PREHOOK: Output: vt@testtable
POSTHOOK: query: -- UNSET a subset of the properties and some non-existed properties using IF EXISTS
-ALTER TABLE testTable UNSET TBLPROPERTIES IF EXISTS ('b', 'd', 'c', 'f', 'x', 'y', 'z')
+ALTER TABLE vt.testTable UNSET TBLPROPERTIES IF EXISTS ('b', 'd', 'c', 'f', 'x', 'y', 'z')
POSTHOOK: type: ALTERTABLE_PROPERTIES
-POSTHOOK: Input: default@testtable
-POSTHOOK: Output: default@testtable
-PREHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: Input: vt@testtable
+POSTHOOK: Output: vt@testtable
+PREHOOK: query: SHOW TBLPROPERTIES vt.testTable
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testTable
POSTHOOK: type: SHOW_TBLPROPERTIES
COLUMN_STATS_ACCURATE false
a 1
@@ -188,57 +195,65 @@ numRows -1
rawDataSize -1
totalSize 0
#### A masked pattern was here ####
+PREHOOK: query: DROP TABLE vt.testTable
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: vt@testtable
+PREHOOK: Output: vt@testtable
+POSTHOOK: query: DROP TABLE vt.testTable
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: vt@testtable
+POSTHOOK: Output: vt@testtable
PREHOOK: query: -- UNSET VIEW PROPERTIES
-CREATE VIEW testView AS SELECT value FROM src WHERE key=86
+CREATE VIEW vt.testView AS SELECT value FROM src WHERE key=86
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
POSTHOOK: query: -- UNSET VIEW PROPERTIES
-CREATE VIEW testView AS SELECT value FROM src WHERE key=86
+CREATE VIEW vt.testView AS SELECT value FROM src WHERE key=86
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
-POSTHOOK: Output: default@testView
-PREHOOK: query: ALTER VIEW testView SET TBLPROPERTIES ('propA'='100', 'propB'='200')
+POSTHOOK: Output: vt@testView
+PREHOOK: query: ALTER VIEW vt.testView SET TBLPROPERTIES ('propA'='100', 'propB'='200')
PREHOOK: type: ALTERVIEW_PROPERTIES
-PREHOOK: Input: default@testview
-PREHOOK: Output: default@testview
-POSTHOOK: query: ALTER VIEW testView SET TBLPROPERTIES ('propA'='100', 'propB'='200')
+PREHOOK: Input: vt@testview
+PREHOOK: Output: vt@testview
+POSTHOOK: query: ALTER VIEW vt.testView SET TBLPROPERTIES ('propA'='100', 'propB'='200')
POSTHOOK: type: ALTERVIEW_PROPERTIES
-POSTHOOK: Input: default@testview
-POSTHOOK: Output: default@testview
-PREHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: Input: vt@testview
+POSTHOOK: Output: vt@testview
+PREHOOK: query: SHOW TBLPROPERTIES vt.testView
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testView
POSTHOOK: type: SHOW_TBLPROPERTIES
#### A masked pattern was here ####
propA 100
propB 200
#### A masked pattern was here ####
PREHOOK: query: -- UNSET all the properties
-ALTER VIEW testView UNSET TBLPROPERTIES ('propA', 'propB')
+ALTER VIEW vt.testView UNSET TBLPROPERTIES ('propA', 'propB')
PREHOOK: type: ALTERVIEW_PROPERTIES
-PREHOOK: Input: default@testview
-PREHOOK: Output: default@testview
+PREHOOK: Input: vt@testview
+PREHOOK: Output: vt@testview
POSTHOOK: query: -- UNSET all the properties
-ALTER VIEW testView UNSET TBLPROPERTIES ('propA', 'propB')
+ALTER VIEW vt.testView UNSET TBLPROPERTIES ('propA', 'propB')
POSTHOOK: type: ALTERVIEW_PROPERTIES
-POSTHOOK: Input: default@testview
-POSTHOOK: Output: default@testview
-PREHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: Input: vt@testview
+POSTHOOK: Output: vt@testview
+PREHOOK: query: SHOW TBLPROPERTIES vt.testView
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testView
POSTHOOK: type: SHOW_TBLPROPERTIES
#### A masked pattern was here ####
-PREHOOK: query: ALTER VIEW testView SET TBLPROPERTIES ('propA'='100', 'propC'='300', 'propD'='400')
+PREHOOK: query: ALTER VIEW vt.testView SET TBLPROPERTIES ('propA'='100', 'propC'='300', 'propD'='400')
PREHOOK: type: ALTERVIEW_PROPERTIES
-PREHOOK: Input: default@testview
-PREHOOK: Output: default@testview
-POSTHOOK: query: ALTER VIEW testView SET TBLPROPERTIES ('propA'='100', 'propC'='300', 'propD'='400')
+PREHOOK: Input: vt@testview
+PREHOOK: Output: vt@testview
+POSTHOOK: query: ALTER VIEW vt.testView SET TBLPROPERTIES ('propA'='100', 'propC'='300', 'propD'='400')
POSTHOOK: type: ALTERVIEW_PROPERTIES
-POSTHOOK: Input: default@testview
-POSTHOOK: Output: default@testview
-PREHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: Input: vt@testview
+POSTHOOK: Output: vt@testview
+PREHOOK: query: SHOW TBLPROPERTIES vt.testView
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testView
POSTHOOK: type: SHOW_TBLPROPERTIES
#### A masked pattern was here ####
propA 100
@@ -246,48 +261,48 @@ propC 300
propD 400
#### A masked pattern was here ####
PREHOOK: query: -- UNSET a subset of the properties
-ALTER VIEW testView UNSET TBLPROPERTIES ('propA', 'propC')
+ALTER VIEW vt.testView UNSET TBLPROPERTIES ('propA', 'propC')
PREHOOK: type: ALTERVIEW_PROPERTIES
-PREHOOK: Input: default@testview
-PREHOOK: Output: default@testview
+PREHOOK: Input: vt@testview
+PREHOOK: Output: vt@testview
POSTHOOK: query: -- UNSET a subset of the properties
-ALTER VIEW testView UNSET TBLPROPERTIES ('propA', 'propC')
+ALTER VIEW vt.testView UNSET TBLPROPERTIES ('propA', 'propC')
POSTHOOK: type: ALTERVIEW_PROPERTIES
-POSTHOOK: Input: default@testview
-POSTHOOK: Output: default@testview
-PREHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: Input: vt@testview
+POSTHOOK: Output: vt@testview
+PREHOOK: query: SHOW TBLPROPERTIES vt.testView
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testView
POSTHOOK: type: SHOW_TBLPROPERTIES
#### A masked pattern was here ####
propD 400
#### A masked pattern was here ####
PREHOOK: query: -- the same property being UNSET multiple times
-ALTER VIEW testView UNSET TBLPROPERTIES ('propD', 'propD', 'propD')
+ALTER VIEW vt.testView UNSET TBLPROPERTIES ('propD', 'propD', 'propD')
PREHOOK: type: ALTERVIEW_PROPERTIES
-PREHOOK: Input: default@testview
-PREHOOK: Output: default@testview
+PREHOOK: Input: vt@testview
+PREHOOK: Output: vt@testview
POSTHOOK: query: -- the same property being UNSET multiple times
-ALTER VIEW testView UNSET TBLPROPERTIES ('propD', 'propD', 'propD')
+ALTER VIEW vt.testView UNSET TBLPROPERTIES ('propD', 'propD', 'propD')
POSTHOOK: type: ALTERVIEW_PROPERTIES
-POSTHOOK: Input: default@testview
-POSTHOOK: Output: default@testview
-PREHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: Input: vt@testview
+POSTHOOK: Output: vt@testview
+PREHOOK: query: SHOW TBLPROPERTIES vt.testView
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testView
POSTHOOK: type: SHOW_TBLPROPERTIES
#### A masked pattern was here ####
-PREHOOK: query: ALTER VIEW testView SET TBLPROPERTIES ('propA'='100', 'propB' = '200', 'propC'='300', 'propD'='400')
+PREHOOK: query: ALTER VIEW vt.testView SET TBLPROPERTIES ('propA'='100', 'propB' = '200', 'propC'='300', 'propD'='400')
PREHOOK: type: ALTERVIEW_PROPERTIES
-PREHOOK: Input: default@testview
-PREHOOK: Output: default@testview
-POSTHOOK: query: ALTER VIEW testView SET TBLPROPERTIES ('propA'='100', 'propB' = '200', 'propC'='300', 'propD'='400')
+PREHOOK: Input: vt@testview
+PREHOOK: Output: vt@testview
+POSTHOOK: query: ALTER VIEW vt.testView SET TBLPROPERTIES ('propA'='100', 'propB' = '200', 'propC'='300', 'propD'='400')
POSTHOOK: type: ALTERVIEW_PROPERTIES
-POSTHOOK: Input: default@testview
-POSTHOOK: Output: default@testview
-PREHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: Input: vt@testview
+POSTHOOK: Output: vt@testview
+PREHOOK: query: SHOW TBLPROPERTIES vt.testView
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testView
POSTHOOK: type: SHOW_TBLPROPERTIES
#### A masked pattern was here ####
propA 100
@@ -296,37 +311,53 @@ propC 300
propD 400
#### A masked pattern was here ####
PREHOOK: query: -- UNSET a subset of the properties and some non-existed properties using IF EXISTS
-ALTER VIEW testView UNSET TBLPROPERTIES IF EXISTS ('propC', 'propD', 'propD', 'propC', 'propZ')
+ALTER VIEW vt.testView UNSET TBLPROPERTIES IF EXISTS ('propC', 'propD', 'propD', 'propC', 'propZ')
PREHOOK: type: ALTERVIEW_PROPERTIES
-PREHOOK: Input: default@testview
-PREHOOK: Output: default@testview
+PREHOOK: Input: vt@testview
+PREHOOK: Output: vt@testview
POSTHOOK: query: -- UNSET a subset of the properties and some non-existed properties using IF EXISTS
-ALTER VIEW testView UNSET TBLPROPERTIES IF EXISTS ('propC', 'propD', 'propD', 'propC', 'propZ')
+ALTER VIEW vt.testView UNSET TBLPROPERTIES IF EXISTS ('propC', 'propD', 'propD', 'propC', 'propZ')
POSTHOOK: type: ALTERVIEW_PROPERTIES
-POSTHOOK: Input: default@testview
-POSTHOOK: Output: default@testview
-PREHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: Input: vt@testview
+POSTHOOK: Output: vt@testview
+PREHOOK: query: SHOW TBLPROPERTIES vt.testView
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testView
POSTHOOK: type: SHOW_TBLPROPERTIES
#### A masked pattern was here ####
propA 100
propB 200
#### A masked pattern was here ####
PREHOOK: query: -- UNSET a subset of the properties and some non-existed properties using IF EXISTS
-ALTER VIEW testView UNSET TBLPROPERTIES IF EXISTS ('propB', 'propC', 'propD', 'propF')
+ALTER VIEW vt.testView UNSET TBLPROPERTIES IF EXISTS ('propB', 'propC', 'propD', 'propF')
PREHOOK: type: ALTERVIEW_PROPERTIES
-PREHOOK: Input: default@testview
-PREHOOK: Output: default@testview
+PREHOOK: Input: vt@testview
+PREHOOK: Output: vt@testview
POSTHOOK: query: -- UNSET a subset of the properties and some non-existed properties using IF EXISTS
-ALTER VIEW testView UNSET TBLPROPERTIES IF EXISTS ('propB', 'propC', 'propD', 'propF')
+ALTER VIEW vt.testView UNSET TBLPROPERTIES IF EXISTS ('propB', 'propC', 'propD', 'propF')
POSTHOOK: type: ALTERVIEW_PROPERTIES
-POSTHOOK: Input: default@testview
-POSTHOOK: Output: default@testview
-PREHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: Input: vt@testview
+POSTHOOK: Output: vt@testview
+PREHOOK: query: SHOW TBLPROPERTIES vt.testView
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testView
POSTHOOK: type: SHOW_TBLPROPERTIES
#### A masked pattern was here ####
propA 100
#### A masked pattern was here ####
+PREHOOK: query: DROP VIEW vt.testView
+PREHOOK: type: DROPVIEW
+PREHOOK: Input: vt@testview
+PREHOOK: Output: vt@testview
+POSTHOOK: query: DROP VIEW vt.testView
+POSTHOOK: type: DROPVIEW
+POSTHOOK: Input: vt@testview
+POSTHOOK: Output: vt@testview
+PREHOOK: query: DROP DATABASE vt
+PREHOOK: type: DROPDATABASE
+PREHOOK: Input: database:vt
+PREHOOK: Output: database:vt
+POSTHOOK: query: DROP DATABASE vt
+POSTHOOK: type: DROPDATABASE
+POSTHOOK: Input: database:vt
+POSTHOOK: Output: database:vt