Modified: hive/branches/spark/ql/src/test/results/clientpositive/add_part_exist.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/add_part_exist.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/add_part_exist.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/add_part_exist.q.out Sat Aug 30 06:44:46 2014 @@ -99,85 +99,91 @@ POSTHOOK: query: -- Test ALTER TABLE ADD CREATE DATABASE add_part_test_db POSTHOOK: type: CREATEDATABASE POSTHOOK: Output: database:add_part_test_db -PREHOOK: query: USE add_part_test_db -PREHOOK: type: SWITCHDATABASE -PREHOOK: Input: database:add_part_test_db -POSTHOOK: query: USE add_part_test_db -POSTHOOK: type: SWITCHDATABASE -POSTHOOK: Input: database:add_part_test_db -PREHOOK: query: SHOW TABLES -PREHOOK: type: SHOWTABLES -POSTHOOK: query: SHOW TABLES -POSTHOOK: type: SHOWTABLES -PREHOOK: query: CREATE TABLE add_part_test (key STRING, value STRING) PARTITIONED BY (ds STRING) +PREHOOK: query: CREATE TABLE add_part_test_db.add_part_test (key STRING, value STRING) PARTITIONED BY (ds STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: add_part_test_db@add_part_test PREHOOK: Output: database:add_part_test_db -POSTHOOK: query: CREATE TABLE add_part_test (key STRING, value STRING) PARTITIONED BY (ds STRING) +POSTHOOK: query: CREATE TABLE add_part_test_db.add_part_test (key STRING, value STRING) PARTITIONED BY (ds STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: add_part_test_db@add_part_test POSTHOOK: Output: database:add_part_test_db -PREHOOK: query: SHOW PARTITIONS add_part_test +PREHOOK: query: SHOW PARTITIONS add_part_test_db.add_part_test PREHOOK: type: SHOWPARTITIONS PREHOOK: Input: add_part_test_db@add_part_test -POSTHOOK: query: SHOW PARTITIONS add_part_test +POSTHOOK: query: SHOW PARTITIONS add_part_test_db.add_part_test POSTHOOK: type: SHOWPARTITIONS POSTHOOK: Input: add_part_test_db@add_part_test -PREHOOK: query: ALTER TABLE add_part_test ADD PARTITION (ds='2010-01-01') +PREHOOK: query: ALTER TABLE add_part_test_db.add_part_test ADD PARTITION (ds='2010-01-01') PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Output: add_part_test_db@add_part_test -POSTHOOK: query: ALTER TABLE add_part_test ADD PARTITION (ds='2010-01-01') +POSTHOOK: query: ALTER TABLE add_part_test_db.add_part_test ADD PARTITION (ds='2010-01-01') POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Output: add_part_test_db@add_part_test POSTHOOK: Output: add_part_test_db@add_part_test@ds=2010-01-01 -PREHOOK: query: SHOW PARTITIONS add_part_test +PREHOOK: query: SHOW PARTITIONS add_part_test_db.add_part_test PREHOOK: type: SHOWPARTITIONS PREHOOK: Input: add_part_test_db@add_part_test -POSTHOOK: query: SHOW PARTITIONS add_part_test +POSTHOOK: query: SHOW PARTITIONS add_part_test_db.add_part_test POSTHOOK: type: SHOWPARTITIONS POSTHOOK: Input: add_part_test_db@add_part_test ds=2010-01-01 -PREHOOK: query: ALTER TABLE add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-01') +PREHOOK: query: ALTER TABLE add_part_test_db.add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-01') PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Output: add_part_test_db@add_part_test -POSTHOOK: query: ALTER TABLE add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-01') +POSTHOOK: query: ALTER TABLE add_part_test_db.add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-01') POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Output: add_part_test_db@add_part_test -PREHOOK: query: SHOW PARTITIONS add_part_test +PREHOOK: query: SHOW PARTITIONS add_part_test_db.add_part_test PREHOOK: type: SHOWPARTITIONS PREHOOK: Input: add_part_test_db@add_part_test -POSTHOOK: query: SHOW PARTITIONS add_part_test +POSTHOOK: query: SHOW PARTITIONS add_part_test_db.add_part_test POSTHOOK: type: SHOWPARTITIONS POSTHOOK: Input: add_part_test_db@add_part_test ds=2010-01-01 -PREHOOK: query: ALTER TABLE add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-02') +PREHOOK: query: ALTER TABLE add_part_test_db.add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-02') PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Output: add_part_test_db@add_part_test -POSTHOOK: query: ALTER TABLE add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-02') +POSTHOOK: query: ALTER TABLE add_part_test_db.add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-02') POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Output: add_part_test_db@add_part_test POSTHOOK: Output: add_part_test_db@add_part_test@ds=2010-01-02 -PREHOOK: query: SHOW PARTITIONS add_part_test +PREHOOK: query: SHOW PARTITIONS add_part_test_db.add_part_test PREHOOK: type: SHOWPARTITIONS PREHOOK: Input: add_part_test_db@add_part_test -POSTHOOK: query: SHOW PARTITIONS add_part_test +POSTHOOK: query: SHOW PARTITIONS add_part_test_db.add_part_test POSTHOOK: type: SHOWPARTITIONS POSTHOOK: Input: add_part_test_db@add_part_test ds=2010-01-01 ds=2010-01-02 -PREHOOK: query: ALTER TABLE add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-01') PARTITION (ds='2010-01-02') PARTITION (ds='2010-01-03') +PREHOOK: query: ALTER TABLE add_part_test_db.add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-01') PARTITION (ds='2010-01-02') PARTITION (ds='2010-01-03') PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Output: add_part_test_db@add_part_test -POSTHOOK: query: ALTER TABLE add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-01') PARTITION (ds='2010-01-02') PARTITION (ds='2010-01-03') +POSTHOOK: query: ALTER TABLE add_part_test_db.add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-01') PARTITION (ds='2010-01-02') PARTITION (ds='2010-01-03') POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Output: add_part_test_db@add_part_test POSTHOOK: Output: add_part_test_db@add_part_test@ds=2010-01-03 -PREHOOK: query: SHOW PARTITIONS add_part_test +PREHOOK: query: SHOW PARTITIONS add_part_test_db.add_part_test PREHOOK: type: SHOWPARTITIONS PREHOOK: Input: add_part_test_db@add_part_test -POSTHOOK: query: SHOW PARTITIONS add_part_test +POSTHOOK: query: SHOW PARTITIONS add_part_test_db.add_part_test POSTHOOK: type: SHOWPARTITIONS POSTHOOK: Input: add_part_test_db@add_part_test ds=2010-01-01 ds=2010-01-02 ds=2010-01-03 +PREHOOK: query: DROP TABLE add_part_test_db.add_part_test +PREHOOK: type: DROPTABLE +PREHOOK: Input: add_part_test_db@add_part_test +PREHOOK: Output: add_part_test_db@add_part_test +POSTHOOK: query: DROP TABLE add_part_test_db.add_part_test +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: add_part_test_db@add_part_test +POSTHOOK: Output: add_part_test_db@add_part_test +PREHOOK: query: DROP DATABASE add_part_test_db +PREHOOK: type: DROPDATABASE +PREHOOK: Input: database:add_part_test_db +PREHOOK: Output: database:add_part_test_db +POSTHOOK: query: DROP DATABASE add_part_test_db +POSTHOOK: type: DROPDATABASE +POSTHOOK: Input: database:add_part_test_db +POSTHOOK: Output: database:add_part_test_db
Modified: hive/branches/spark/ql/src/test/results/clientpositive/allcolref_in_udf.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/allcolref_in_udf.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/allcolref_in_udf.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/allcolref_in_udf.q.out Sat Aug 30 06:44:46 2014 @@ -164,10 +164,13 @@ PREHOOK: query: -- HIVE-4181 TOK_FUNCTIO create table allcolref as select array(key, value) from src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@allcolref POSTHOOK: query: -- HIVE-4181 TOK_FUNCTIONSTAR for UDTF create table allcolref as select array(key, value) from src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@allcolref PREHOOK: query: explain select explode(*) as x from allcolref limit 10 PREHOOK: type: QUERY Modified: hive/branches/spark/ql/src/test/results/clientpositive/alter1.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/alter1.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/alter1.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/alter1.q.out Sat Aug 30 06:44:46 2014 @@ -210,209 +210,197 @@ POSTHOOK: query: -- With non-default Dat CREATE DATABASE alter1_db POSTHOOK: type: CREATEDATABASE POSTHOOK: Output: database:alter1_db -PREHOOK: query: USE alter1_db -PREHOOK: type: SWITCHDATABASE -PREHOOK: Input: database:alter1_db -POSTHOOK: query: USE alter1_db -POSTHOOK: type: SWITCHDATABASE -POSTHOOK: Input: database:alter1_db -PREHOOK: query: SHOW TABLES +PREHOOK: query: SHOW TABLES alter1_db PREHOOK: type: SHOWTABLES -POSTHOOK: query: SHOW TABLES +POSTHOOK: query: SHOW TABLES alter1_db POSTHOOK: type: SHOWTABLES -PREHOOK: query: CREATE TABLE alter1(a INT, b INT) +PREHOOK: query: CREATE TABLE alter1_db.alter1(a INT, b INT) PREHOOK: type: CREATETABLE PREHOOK: Output: alter1_db@alter1 PREHOOK: Output: database:alter1_db -POSTHOOK: query: CREATE TABLE alter1(a INT, b INT) +POSTHOOK: query: CREATE TABLE alter1_db.alter1(a INT, b INT) POSTHOOK: type: CREATETABLE POSTHOOK: Output: alter1_db@alter1 POSTHOOK: Output: database:alter1_db -PREHOOK: query: DESCRIBE EXTENDED alter1 +PREHOOK: query: DESCRIBE EXTENDED alter1_db.alter1 PREHOOK: type: DESCTABLE PREHOOK: Input: alter1_db@alter1 -POSTHOOK: query: DESCRIBE EXTENDED alter1 +POSTHOOK: query: DESCRIBE EXTENDED alter1_db.alter1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: alter1_db@alter1 a int b int #### A masked pattern was here #### -PREHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('a'='1', 'c'='3') +PREHOOK: query: ALTER TABLE alter1_db.alter1 SET TBLPROPERTIES ('a'='1', 'c'='3') PREHOOK: type: ALTERTABLE_PROPERTIES PREHOOK: Input: alter1_db@alter1 PREHOOK: Output: alter1_db@alter1 -POSTHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('a'='1', 'c'='3') +POSTHOOK: query: ALTER TABLE alter1_db.alter1 SET TBLPROPERTIES ('a'='1', 'c'='3') POSTHOOK: type: ALTERTABLE_PROPERTIES POSTHOOK: Input: alter1_db@alter1 POSTHOOK: Output: alter1_db@alter1 -PREHOOK: query: DESCRIBE EXTENDED alter1 +PREHOOK: query: DESCRIBE EXTENDED alter1_db.alter1 PREHOOK: type: DESCTABLE PREHOOK: Input: alter1_db@alter1 -POSTHOOK: query: DESCRIBE EXTENDED alter1 +POSTHOOK: query: DESCRIBE EXTENDED alter1_db.alter1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: alter1_db@alter1 a int b int #### A masked pattern was here #### -PREHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('a'='1', 'c'='4', 'd'='3') +PREHOOK: query: ALTER TABLE alter1_db.alter1 SET TBLPROPERTIES ('a'='1', 'c'='4', 'd'='3') PREHOOK: type: ALTERTABLE_PROPERTIES PREHOOK: Input: alter1_db@alter1 PREHOOK: Output: alter1_db@alter1 -POSTHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('a'='1', 'c'='4', 'd'='3') +POSTHOOK: query: ALTER TABLE alter1_db.alter1 SET TBLPROPERTIES ('a'='1', 'c'='4', 'd'='3') POSTHOOK: type: ALTERTABLE_PROPERTIES POSTHOOK: Input: alter1_db@alter1 POSTHOOK: Output: alter1_db@alter1 -PREHOOK: query: DESCRIBE EXTENDED alter1 +PREHOOK: query: DESCRIBE EXTENDED alter1_db.alter1 PREHOOK: type: DESCTABLE PREHOOK: Input: alter1_db@alter1 -POSTHOOK: query: DESCRIBE EXTENDED alter1 +POSTHOOK: query: DESCRIBE EXTENDED alter1_db.alter1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: alter1_db@alter1 a int b int #### A masked pattern was here #### -PREHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('EXTERNAL'='TRUE') +PREHOOK: query: ALTER TABLE alter1_db.alter1 SET TBLPROPERTIES ('EXTERNAL'='TRUE') PREHOOK: type: ALTERTABLE_PROPERTIES PREHOOK: Input: alter1_db@alter1 PREHOOK: Output: alter1_db@alter1 -POSTHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('EXTERNAL'='TRUE') +POSTHOOK: query: ALTER TABLE alter1_db.alter1 SET TBLPROPERTIES ('EXTERNAL'='TRUE') POSTHOOK: type: ALTERTABLE_PROPERTIES POSTHOOK: Input: alter1_db@alter1 POSTHOOK: Output: alter1_db@alter1 -PREHOOK: query: DESCRIBE EXTENDED alter1 +PREHOOK: query: DESCRIBE EXTENDED alter1_db.alter1 PREHOOK: type: DESCTABLE PREHOOK: Input: alter1_db@alter1 -POSTHOOK: query: DESCRIBE EXTENDED alter1 +POSTHOOK: query: DESCRIBE EXTENDED alter1_db.alter1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: alter1_db@alter1 a int b int #### A masked pattern was here #### -PREHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('EXTERNAL'='FALSE') +PREHOOK: query: ALTER TABLE alter1_db.alter1 SET TBLPROPERTIES ('EXTERNAL'='FALSE') PREHOOK: type: ALTERTABLE_PROPERTIES PREHOOK: Input: alter1_db@alter1 PREHOOK: Output: alter1_db@alter1 -POSTHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('EXTERNAL'='FALSE') +POSTHOOK: query: ALTER TABLE alter1_db.alter1 SET TBLPROPERTIES ('EXTERNAL'='FALSE') POSTHOOK: type: ALTERTABLE_PROPERTIES POSTHOOK: Input: alter1_db@alter1 POSTHOOK: Output: alter1_db@alter1 -PREHOOK: query: DESCRIBE EXTENDED alter1 +PREHOOK: query: DESCRIBE EXTENDED alter1_db.alter1 PREHOOK: type: DESCTABLE PREHOOK: Input: alter1_db@alter1 -POSTHOOK: query: DESCRIBE EXTENDED alter1 +POSTHOOK: query: DESCRIBE EXTENDED alter1_db.alter1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: alter1_db@alter1 a int b int #### A masked pattern was here #### -PREHOOK: query: ALTER TABLE alter1 SET SERDEPROPERTIES('s1'='9') +PREHOOK: query: ALTER TABLE alter1_db.alter1 SET SERDEPROPERTIES('s1'='9') PREHOOK: type: ALTERTABLE_SERDEPROPERTIES PREHOOK: Input: alter1_db@alter1 PREHOOK: Output: alter1_db@alter1 -POSTHOOK: query: ALTER TABLE alter1 SET SERDEPROPERTIES('s1'='9') +POSTHOOK: query: ALTER TABLE alter1_db.alter1 SET SERDEPROPERTIES('s1'='9') POSTHOOK: type: ALTERTABLE_SERDEPROPERTIES POSTHOOK: Input: alter1_db@alter1 POSTHOOK: Output: alter1_db@alter1 -PREHOOK: query: DESCRIBE EXTENDED alter1 +PREHOOK: query: DESCRIBE EXTENDED alter1_db.alter1 PREHOOK: type: DESCTABLE PREHOOK: Input: alter1_db@alter1 -POSTHOOK: query: DESCRIBE EXTENDED alter1 +POSTHOOK: query: DESCRIBE EXTENDED alter1_db.alter1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: alter1_db@alter1 a int b int #### A masked pattern was here #### -PREHOOK: query: ALTER TABLE alter1 SET SERDEPROPERTIES('s1'='10', 's2' ='20') +PREHOOK: query: ALTER TABLE alter1_db.alter1 SET SERDEPROPERTIES('s1'='10', 's2' ='20') PREHOOK: type: ALTERTABLE_SERDEPROPERTIES PREHOOK: Input: alter1_db@alter1 PREHOOK: Output: alter1_db@alter1 -POSTHOOK: query: ALTER TABLE alter1 SET SERDEPROPERTIES('s1'='10', 's2' ='20') +POSTHOOK: query: ALTER TABLE alter1_db.alter1 SET SERDEPROPERTIES('s1'='10', 's2' ='20') POSTHOOK: type: ALTERTABLE_SERDEPROPERTIES POSTHOOK: Input: alter1_db@alter1 POSTHOOK: Output: alter1_db@alter1 -PREHOOK: query: DESCRIBE EXTENDED alter1 +PREHOOK: query: DESCRIBE EXTENDED alter1_db.alter1 PREHOOK: type: DESCTABLE PREHOOK: Input: alter1_db@alter1 -POSTHOOK: query: DESCRIBE EXTENDED alter1 +POSTHOOK: query: DESCRIBE EXTENDED alter1_db.alter1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: alter1_db@alter1 a int b int #### A masked pattern was here #### -PREHOOK: query: ALTER TABLE alter1 SET SERDE 'org.apache.hadoop.hive.serde2.TestSerDe' WITH SERDEPROPERTIES ('s1'='9') +PREHOOK: query: ALTER TABLE alter1_db.alter1 SET SERDE 'org.apache.hadoop.hive.serde2.TestSerDe' WITH SERDEPROPERTIES ('s1'='9') PREHOOK: type: ALTERTABLE_SERIALIZER PREHOOK: Input: alter1_db@alter1 PREHOOK: Output: alter1_db@alter1 -POSTHOOK: query: ALTER TABLE alter1 SET SERDE 'org.apache.hadoop.hive.serde2.TestSerDe' WITH SERDEPROPERTIES ('s1'='9') +POSTHOOK: query: ALTER TABLE alter1_db.alter1 SET SERDE 'org.apache.hadoop.hive.serde2.TestSerDe' WITH SERDEPROPERTIES ('s1'='9') POSTHOOK: type: ALTERTABLE_SERIALIZER POSTHOOK: Input: alter1_db@alter1 POSTHOOK: Output: alter1_db@alter1 -PREHOOK: query: DESCRIBE EXTENDED alter1 +PREHOOK: query: DESCRIBE EXTENDED alter1_db.alter1 PREHOOK: type: DESCTABLE PREHOOK: Input: alter1_db@alter1 -POSTHOOK: query: DESCRIBE EXTENDED alter1 +POSTHOOK: query: DESCRIBE EXTENDED alter1_db.alter1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: alter1_db@alter1 a string b string #### A masked pattern was here #### -PREHOOK: query: ALTER TABLE alter1 SET SERDE 'org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe' +PREHOOK: query: ALTER TABLE alter1_db.alter1 SET SERDE 'org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe' PREHOOK: type: ALTERTABLE_SERIALIZER PREHOOK: Input: alter1_db@alter1 PREHOOK: Output: alter1_db@alter1 -POSTHOOK: query: ALTER TABLE alter1 SET SERDE 'org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe' +POSTHOOK: query: ALTER TABLE alter1_db.alter1 SET SERDE 'org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe' POSTHOOK: type: ALTERTABLE_SERIALIZER POSTHOOK: Input: alter1_db@alter1 POSTHOOK: Output: alter1_db@alter1 -PREHOOK: query: DESCRIBE EXTENDED alter1 +PREHOOK: query: DESCRIBE EXTENDED alter1_db.alter1 PREHOOK: type: DESCTABLE PREHOOK: Input: alter1_db@alter1 -POSTHOOK: query: DESCRIBE EXTENDED alter1 +POSTHOOK: query: DESCRIBE EXTENDED alter1_db.alter1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: alter1_db@alter1 a string b string #### A masked pattern was here #### -PREHOOK: query: ALTER TABLE alter1 REPLACE COLUMNS (a int, b int, c string) +PREHOOK: query: ALTER TABLE alter1_db.alter1 REPLACE COLUMNS (a int, b int, c string) PREHOOK: type: ALTERTABLE_REPLACECOLS PREHOOK: Input: alter1_db@alter1 PREHOOK: Output: alter1_db@alter1 -POSTHOOK: query: ALTER TABLE alter1 REPLACE COLUMNS (a int, b int, c string) +POSTHOOK: query: ALTER TABLE alter1_db.alter1 REPLACE COLUMNS (a int, b int, c string) POSTHOOK: type: ALTERTABLE_REPLACECOLS POSTHOOK: Input: alter1_db@alter1 POSTHOOK: Output: alter1_db@alter1 -PREHOOK: query: DESCRIBE alter1 +PREHOOK: query: DESCRIBE alter1_db.alter1 PREHOOK: type: DESCTABLE PREHOOK: Input: alter1_db@alter1 -POSTHOOK: query: DESCRIBE alter1 +POSTHOOK: query: DESCRIBE alter1_db.alter1 POSTHOOK: type: DESCTABLE POSTHOOK: Input: alter1_db@alter1 a int b int c string -PREHOOK: query: DROP TABLE alter1 +PREHOOK: query: DROP TABLE alter1_db.alter1 PREHOOK: type: DROPTABLE PREHOOK: Input: alter1_db@alter1 PREHOOK: Output: alter1_db@alter1 -POSTHOOK: query: DROP TABLE alter1 +POSTHOOK: query: DROP TABLE alter1_db.alter1 POSTHOOK: type: DROPTABLE POSTHOOK: Input: alter1_db@alter1 POSTHOOK: Output: alter1_db@alter1 -PREHOOK: query: USE default -PREHOOK: type: SWITCHDATABASE -PREHOOK: Input: database:default -POSTHOOK: query: USE default -POSTHOOK: type: SWITCHDATABASE -POSTHOOK: Input: database:default PREHOOK: query: DROP DATABASE alter1_db PREHOOK: type: DROPDATABASE PREHOOK: Input: database:alter1_db Modified: hive/branches/spark/ql/src/test/results/clientpositive/alter_char1.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/alter_char1.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/alter_char1.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/alter_char1.q.out Sat Aug 30 06:44:46 2014 @@ -1,38 +1,40 @@ PREHOOK: query: -- SORT_QUERY_RESULTS -drop table alter_char_1 -PREHOOK: type: DROPTABLE +create database ac +PREHOOK: type: CREATEDATABASE +PREHOOK: Output: database:ac POSTHOOK: query: -- SORT_QUERY_RESULTS -drop table alter_char_1 -POSTHOOK: type: DROPTABLE -PREHOOK: query: create table alter_char_1 (key string, value string) +create database ac +POSTHOOK: type: CREATEDATABASE +POSTHOOK: Output: database:ac +PREHOOK: query: create table ac.alter_char_1 (key string, value string) PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@alter_char_1 -POSTHOOK: query: create table alter_char_1 (key string, value string) +PREHOOK: Output: ac@alter_char_1 +PREHOOK: Output: database:ac +POSTHOOK: query: create table ac.alter_char_1 (key string, value string) POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@alter_char_1 -PREHOOK: query: insert overwrite table alter_char_1 +POSTHOOK: Output: ac@alter_char_1 +POSTHOOK: Output: database:ac +PREHOOK: query: insert overwrite table ac.alter_char_1 select key, value from src order by key limit 5 PREHOOK: type: QUERY PREHOOK: Input: default@src -PREHOOK: Output: default@alter_char_1 -POSTHOOK: query: insert overwrite table alter_char_1 +PREHOOK: Output: ac@alter_char_1 +POSTHOOK: query: insert overwrite table ac.alter_char_1 select key, value from src order by key limit 5 POSTHOOK: type: QUERY POSTHOOK: Input: default@src -POSTHOOK: Output: default@alter_char_1 +POSTHOOK: Output: ac@alter_char_1 POSTHOOK: Lineage: alter_char_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: alter_char_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: select * from alter_char_1 +PREHOOK: query: select * from ac.alter_char_1 PREHOOK: type: QUERY -PREHOOK: Input: default@alter_char_1 +PREHOOK: Input: ac@alter_char_1 #### A masked pattern was here #### -POSTHOOK: query: select * from alter_char_1 +POSTHOOK: query: select * from ac.alter_char_1 POSTHOOK: type: QUERY -POSTHOOK: Input: default@alter_char_1 +POSTHOOK: Input: ac@alter_char_1 #### A masked pattern was here #### 0 val_0 0 val_0 @@ -40,24 +42,24 @@ POSTHOOK: Input: default@alter_char_1 10 val_10 100 val_100 PREHOOK: query: -- change column to char -alter table alter_char_1 change column value value char(20) +alter table ac.alter_char_1 change column value value char(20) PREHOOK: type: ALTERTABLE_RENAMECOL -PREHOOK: Input: default@alter_char_1 -PREHOOK: Output: default@alter_char_1 +PREHOOK: Input: ac@alter_char_1 +PREHOOK: Output: ac@alter_char_1 POSTHOOK: query: -- change column to char -alter table alter_char_1 change column value value char(20) +alter table ac.alter_char_1 change column value value char(20) POSTHOOK: type: ALTERTABLE_RENAMECOL -POSTHOOK: Input: default@alter_char_1 -POSTHOOK: Output: default@alter_char_1 +POSTHOOK: Input: ac@alter_char_1 +POSTHOOK: Output: ac@alter_char_1 PREHOOK: query: -- contents should still look the same -select * from alter_char_1 +select * from ac.alter_char_1 PREHOOK: type: QUERY -PREHOOK: Input: default@alter_char_1 +PREHOOK: Input: ac@alter_char_1 #### A masked pattern was here #### POSTHOOK: query: -- contents should still look the same -select * from alter_char_1 +select * from ac.alter_char_1 POSTHOOK: type: QUERY -POSTHOOK: Input: default@alter_char_1 +POSTHOOK: Input: ac@alter_char_1 #### A masked pattern was here #### 0 val_0 0 val_0 @@ -65,24 +67,24 @@ POSTHOOK: Input: default@alter_char_1 10 val_10 100 val_100 PREHOOK: query: -- change column to smaller char -alter table alter_char_1 change column value value char(3) +alter table ac.alter_char_1 change column value value char(3) PREHOOK: type: ALTERTABLE_RENAMECOL -PREHOOK: Input: default@alter_char_1 -PREHOOK: Output: default@alter_char_1 +PREHOOK: Input: ac@alter_char_1 +PREHOOK: Output: ac@alter_char_1 POSTHOOK: query: -- change column to smaller char -alter table alter_char_1 change column value value char(3) +alter table ac.alter_char_1 change column value value char(3) POSTHOOK: type: ALTERTABLE_RENAMECOL -POSTHOOK: Input: default@alter_char_1 -POSTHOOK: Output: default@alter_char_1 +POSTHOOK: Input: ac@alter_char_1 +POSTHOOK: Output: ac@alter_char_1 PREHOOK: query: -- value column should be truncated now -select * from alter_char_1 +select * from ac.alter_char_1 PREHOOK: type: QUERY -PREHOOK: Input: default@alter_char_1 +PREHOOK: Input: ac@alter_char_1 #### A masked pattern was here #### POSTHOOK: query: -- value column should be truncated now -select * from alter_char_1 +select * from ac.alter_char_1 POSTHOOK: type: QUERY -POSTHOOK: Input: default@alter_char_1 +POSTHOOK: Input: ac@alter_char_1 #### A masked pattern was here #### 0 val 0 val @@ -90,24 +92,24 @@ POSTHOOK: Input: default@alter_char_1 10 val 100 val PREHOOK: query: -- change back to bigger char -alter table alter_char_1 change column value value char(20) +alter table ac.alter_char_1 change column value value char(20) PREHOOK: type: ALTERTABLE_RENAMECOL -PREHOOK: Input: default@alter_char_1 -PREHOOK: Output: default@alter_char_1 +PREHOOK: Input: ac@alter_char_1 +PREHOOK: Output: ac@alter_char_1 POSTHOOK: query: -- change back to bigger char -alter table alter_char_1 change column value value char(20) +alter table ac.alter_char_1 change column value value char(20) POSTHOOK: type: ALTERTABLE_RENAMECOL -POSTHOOK: Input: default@alter_char_1 -POSTHOOK: Output: default@alter_char_1 +POSTHOOK: Input: ac@alter_char_1 +POSTHOOK: Output: ac@alter_char_1 PREHOOK: query: -- column values should be full size again -select * from alter_char_1 +select * from ac.alter_char_1 PREHOOK: type: QUERY -PREHOOK: Input: default@alter_char_1 +PREHOOK: Input: ac@alter_char_1 #### A masked pattern was here #### POSTHOOK: query: -- column values should be full size again -select * from alter_char_1 +select * from ac.alter_char_1 POSTHOOK: type: QUERY -POSTHOOK: Input: default@alter_char_1 +POSTHOOK: Input: ac@alter_char_1 #### A masked pattern was here #### 0 val_0 0 val_0 @@ -115,60 +117,68 @@ POSTHOOK: Input: default@alter_char_1 10 val_10 100 val_100 PREHOOK: query: -- add char column -alter table alter_char_1 add columns (key2 int, value2 char(10)) +alter table ac.alter_char_1 add columns (key2 int, value2 char(10)) PREHOOK: type: ALTERTABLE_ADDCOLS -PREHOOK: Input: default@alter_char_1 -PREHOOK: Output: default@alter_char_1 +PREHOOK: Input: ac@alter_char_1 +PREHOOK: Output: ac@alter_char_1 POSTHOOK: query: -- add char column -alter table alter_char_1 add columns (key2 int, value2 char(10)) +alter table ac.alter_char_1 add columns (key2 int, value2 char(10)) POSTHOOK: type: ALTERTABLE_ADDCOLS -POSTHOOK: Input: default@alter_char_1 -POSTHOOK: Output: default@alter_char_1 -PREHOOK: query: select * from alter_char_1 +POSTHOOK: Input: ac@alter_char_1 +POSTHOOK: Output: ac@alter_char_1 +PREHOOK: query: select * from ac.alter_char_1 PREHOOK: type: QUERY -PREHOOK: Input: default@alter_char_1 +PREHOOK: Input: ac@alter_char_1 #### A masked pattern was here #### -POSTHOOK: query: select * from alter_char_1 +POSTHOOK: query: select * from ac.alter_char_1 POSTHOOK: type: QUERY -POSTHOOK: Input: default@alter_char_1 +POSTHOOK: Input: ac@alter_char_1 #### A masked pattern was here #### 0 val_0 NULL NULL 0 val_0 NULL NULL 0 val_0 NULL NULL 10 val_10 NULL NULL 100 val_100 NULL NULL -PREHOOK: query: insert overwrite table alter_char_1 +PREHOOK: query: insert overwrite table ac.alter_char_1 select key, value, key, value from src order by key limit 5 PREHOOK: type: QUERY PREHOOK: Input: default@src -PREHOOK: Output: default@alter_char_1 -POSTHOOK: query: insert overwrite table alter_char_1 +PREHOOK: Output: ac@alter_char_1 +POSTHOOK: query: insert overwrite table ac.alter_char_1 select key, value, key, value from src order by key limit 5 POSTHOOK: type: QUERY POSTHOOK: Input: default@src -POSTHOOK: Output: default@alter_char_1 +POSTHOOK: Output: ac@alter_char_1 POSTHOOK: Lineage: alter_char_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: alter_char_1.key2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: alter_char_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: alter_char_1.value2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: select * from alter_char_1 +PREHOOK: query: select * from ac.alter_char_1 PREHOOK: type: QUERY -PREHOOK: Input: default@alter_char_1 +PREHOOK: Input: ac@alter_char_1 #### A masked pattern was here #### -POSTHOOK: query: select * from alter_char_1 +POSTHOOK: query: select * from ac.alter_char_1 POSTHOOK: type: QUERY -POSTHOOK: Input: default@alter_char_1 +POSTHOOK: Input: ac@alter_char_1 #### A masked pattern was here #### 0 val_0 0 val_0 0 val_0 0 val_0 0 val_0 0 val_0 10 val_10 10 val_10 100 val_100 100 val_100 -PREHOOK: query: drop table alter_char_1 +PREHOOK: query: drop table ac.alter_char_1 PREHOOK: type: DROPTABLE -PREHOOK: Input: default@alter_char_1 -PREHOOK: Output: default@alter_char_1 -POSTHOOK: query: drop table alter_char_1 +PREHOOK: Input: ac@alter_char_1 +PREHOOK: Output: ac@alter_char_1 +POSTHOOK: query: drop table ac.alter_char_1 POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@alter_char_1 -POSTHOOK: Output: default@alter_char_1 +POSTHOOK: Input: ac@alter_char_1 +POSTHOOK: Output: ac@alter_char_1 +PREHOOK: query: drop database ac +PREHOOK: type: DROPDATABASE +PREHOOK: Input: database:ac +PREHOOK: Output: database:ac +POSTHOOK: query: drop database ac +POSTHOOK: type: DROPDATABASE +POSTHOOK: Input: database:ac +POSTHOOK: Output: database:ac Modified: hive/branches/spark/ql/src/test/results/clientpositive/alter_index.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/alter_index.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/alter_index.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/alter_index.q.out Sat Aug 30 06:44:46 2014 @@ -4,10 +4,10 @@ PREHOOK: Input: default@src POSTHOOK: query: drop index src_index_8 on src POSTHOOK: type: DROPINDEX POSTHOOK: Input: default@src -PREHOOK: query: create index src_index_8 on table src(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2") +PREHOOK: query: create index src_index_8 on table default.src(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2") PREHOOK: type: CREATEINDEX PREHOOK: Input: default@src -POSTHOOK: query: create index src_index_8 on table src(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2") +POSTHOOK: query: create index src_index_8 on table default.src(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2") POSTHOOK: type: CREATEINDEX POSTHOOK: Input: default@src POSTHOOK: Output: default@default__src_src_index_8__ @@ -22,9 +22,9 @@ _bucketname string _offsets array<bigint> #### A masked pattern was here #### -PREHOOK: query: alter index src_index_8 on src set IDXPROPERTIES ("prop1"="val1_new", "prop3"="val3") +PREHOOK: query: alter index src_index_8 on default.src set IDXPROPERTIES ("prop1"="val1_new", "prop3"="val3") PREHOOK: type: ALTERINDEX_PROPS -POSTHOOK: query: alter index src_index_8 on src set IDXPROPERTIES ("prop1"="val1_new", "prop3"="val3") +POSTHOOK: query: alter index src_index_8 on default.src set IDXPROPERTIES ("prop1"="val1_new", "prop3"="val3") POSTHOOK: type: ALTERINDEX_PROPS PREHOOK: query: desc extended default__src_src_index_8__ PREHOOK: type: DESCTABLE @@ -37,10 +37,10 @@ _bucketname string _offsets array<bigint> #### A masked pattern was here #### -PREHOOK: query: drop index src_index_8 on src +PREHOOK: query: drop index src_index_8 on default.src PREHOOK: type: DROPINDEX PREHOOK: Input: default@src -POSTHOOK: query: drop index src_index_8 on src +POSTHOOK: query: drop index src_index_8 on default.src POSTHOOK: type: DROPINDEX POSTHOOK: Input: default@src PREHOOK: query: show tables Modified: hive/branches/spark/ql/src/test/results/clientpositive/alter_partition_coltype.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/alter_partition_coltype.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== Files hive/branches/spark/ql/src/test/results/clientpositive/alter_partition_coltype.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/alter_partition_coltype.q.out Sat Aug 30 06:44:46 2014 differ Modified: hive/branches/spark/ql/src/test/results/clientpositive/alter_rename_partition_authorization.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/alter_rename_partition_authorization.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/alter_rename_partition_authorization.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/alter_rename_partition_authorization.q.out Sat Aug 30 06:44:46 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/branches/spark/ql/src/test/results/clientpositive/alter_rename_table.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/alter_rename_table.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/alter_rename_table.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/alter_rename_table.q.out Sat Aug 30 06:44:46 2014 @@ -13,11 +13,10 @@ POSTHOOK: Output: database:target PREHOOK: query: create table source.src like default.src PREHOOK: type: CREATETABLE PREHOOK: Output: database:source -PREHOOK: Output: [email protected] +PREHOOK: Output: source@src POSTHOOK: query: create table source.src like default.src POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:source -POSTHOOK: Output: [email protected] POSTHOOK: Output: source@src PREHOOK: query: load data local inpath '../../data/files/kv1.txt' overwrite into table source.src PREHOOK: type: LOAD @@ -30,11 +29,10 @@ POSTHOOK: Output: source@src PREHOOK: query: create table source.srcpart like default.srcpart PREHOOK: type: CREATETABLE PREHOOK: Output: database:source -PREHOOK: Output: [email protected] +PREHOOK: Output: source@srcpart POSTHOOK: query: create table source.srcpart like default.srcpart POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:source -POSTHOOK: Output: [email protected] POSTHOOK: Output: source@srcpart PREHOOK: query: load data local inpath '../../data/files/kv1.txt' overwrite into table source.srcpart partition (ds='2008-04-08', hr='11') PREHOOK: type: LOAD @@ -215,20 +213,18 @@ POSTHOOK: Input: target@srcpart@ds=2008- PREHOOK: query: create table source.src like default.src PREHOOK: type: CREATETABLE PREHOOK: Output: database:source -PREHOOK: Output: [email protected] +PREHOOK: Output: source@src POSTHOOK: query: create table source.src like default.src POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:source -POSTHOOK: Output: [email protected] POSTHOOK: Output: source@src PREHOOK: query: create table source.src1 like default.src PREHOOK: type: CREATETABLE PREHOOK: Output: database:source -PREHOOK: Output: [email protected] +PREHOOK: Output: source@src1 POSTHOOK: query: create table source.src1 like default.src POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:source -POSTHOOK: Output: [email protected] POSTHOOK: Output: source@src1 PREHOOK: query: load data local inpath '../../data/files/kv1.txt' overwrite into table source.src PREHOOK: type: LOAD Modified: hive/branches/spark/ql/src/test/results/clientpositive/alter_skewed_table.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/alter_skewed_table.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/alter_skewed_table.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/alter_skewed_table.q.out Sat Aug 30 06:44:46 2014 @@ -92,27 +92,33 @@ POSTHOOK: query: drop table original POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@original POSTHOOK: Output: default@original -PREHOOK: query: create table original2 (key STRING, value STRING) +PREHOOK: query: create database skew_test +PREHOOK: type: CREATEDATABASE +PREHOOK: Output: database:skew_test +POSTHOOK: query: create database skew_test +POSTHOOK: type: CREATEDATABASE +POSTHOOK: Output: database:skew_test +PREHOOK: query: create table skew_test.original2 (key STRING, value STRING) PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@original2 -POSTHOOK: query: create table original2 (key STRING, value STRING) +PREHOOK: Output: database:skew_test +PREHOOK: Output: skew_test@original2 +POSTHOOK: query: create table skew_test.original2 (key STRING, value STRING) POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@original2 -PREHOOK: query: describe formatted original2 +POSTHOOK: Output: database:skew_test +POSTHOOK: Output: skew_test@original2 +PREHOOK: query: describe formatted skew_test.original2 PREHOOK: type: DESCTABLE -PREHOOK: Input: default@original2 -POSTHOOK: query: describe formatted original2 +PREHOOK: Input: skew_test@original2 +POSTHOOK: query: describe formatted skew_test.original2 POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@original2 +POSTHOOK: Input: skew_test@original2 # col_name data_type comment key string value string # Detailed Table Information -Database: default +Database: skew_test #### A masked pattern was here #### Protect Mode: None Retention: 0 @@ -131,27 +137,27 @@ Bucket Columns: [] Sort Columns: [] Storage Desc Params: serialization.format 1 -PREHOOK: query: alter table original2 SKEWED BY (key, value) ON ((1,1),(5,6)) +PREHOOK: query: alter table skew_test.original2 SKEWED BY (key, value) ON ((1,1),(5,6)) PREHOOK: type: ALTERTABLE_SKEWED -PREHOOK: Input: default@original2 -PREHOOK: Output: default@original2 -POSTHOOK: query: alter table original2 SKEWED BY (key, value) ON ((1,1),(5,6)) +PREHOOK: Input: skew_test@original2 +PREHOOK: Output: skew_test@original2 +POSTHOOK: query: alter table skew_test.original2 SKEWED BY (key, value) ON ((1,1),(5,6)) POSTHOOK: type: ALTERTABLE_SKEWED -POSTHOOK: Input: default@original2 -POSTHOOK: Output: default@original2 -PREHOOK: query: describe formatted original2 +POSTHOOK: Input: skew_test@original2 +POSTHOOK: Output: skew_test@original2 +PREHOOK: query: describe formatted skew_test.original2 PREHOOK: type: DESCTABLE -PREHOOK: Input: default@original2 -POSTHOOK: query: describe formatted original2 +PREHOOK: Input: skew_test@original2 +POSTHOOK: query: describe formatted skew_test.original2 POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@original2 +POSTHOOK: Input: skew_test@original2 # col_name data_type comment key string value string # Detailed Table Information -Database: default +Database: skew_test #### A masked pattern was here #### Protect Mode: None Retention: 0 @@ -178,35 +184,35 @@ Skewed Columns: [key, value] Skewed Values: [[1, 1], [5, 6]] Storage Desc Params: serialization.format 1 -PREHOOK: query: drop table original2 +PREHOOK: query: drop table skew_test.original2 PREHOOK: type: DROPTABLE -PREHOOK: Input: default@original2 -PREHOOK: Output: default@original2 -POSTHOOK: query: drop table original2 +PREHOOK: Input: skew_test@original2 +PREHOOK: Output: skew_test@original2 +POSTHOOK: query: drop table skew_test.original2 POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@original2 -POSTHOOK: Output: default@original2 -PREHOOK: query: create table original3 (key STRING, value STRING) SKEWED BY (key, value) ON ((1,1),(5,6)) +POSTHOOK: Input: skew_test@original2 +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:default -PREHOOK: Output: default@original3 -POSTHOOK: query: create table original3 (key STRING, value STRING) SKEWED BY (key, value) ON ((1,1),(5,6)) +PREHOOK: Output: database:skew_test +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:default -POSTHOOK: Output: default@original3 -PREHOOK: query: describe formatted original3 +POSTHOOK: Output: database:skew_test +POSTHOOK: Output: skew_test@original3 +PREHOOK: query: describe formatted skew_test.original3 PREHOOK: type: DESCTABLE -PREHOOK: Input: default@original3 -POSTHOOK: query: describe formatted original3 +PREHOOK: Input: skew_test@original3 +POSTHOOK: query: describe formatted skew_test.original3 POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@original3 +POSTHOOK: Input: skew_test@original3 # col_name data_type comment key string value string # Detailed Table Information -Database: default +Database: skew_test #### A masked pattern was here #### Protect Mode: None Retention: 0 @@ -227,27 +233,27 @@ Skewed Columns: [key, value] Skewed Values: [[1, 1], [5, 6]] Storage Desc Params: serialization.format 1 -PREHOOK: query: alter table original3 not skewed +PREHOOK: query: alter table skew_test.original3 not skewed PREHOOK: type: ALTERTABLE_SKEWED -PREHOOK: Input: default@original3 -PREHOOK: Output: default@original3 -POSTHOOK: query: alter table original3 not skewed +PREHOOK: Input: skew_test@original3 +PREHOOK: Output: skew_test@original3 +POSTHOOK: query: alter table skew_test.original3 not skewed POSTHOOK: type: ALTERTABLE_SKEWED -POSTHOOK: Input: default@original3 -POSTHOOK: Output: default@original3 -PREHOOK: query: describe formatted original3 +POSTHOOK: Input: skew_test@original3 +POSTHOOK: Output: skew_test@original3 +PREHOOK: query: describe formatted skew_test.original3 PREHOOK: type: DESCTABLE -PREHOOK: Input: default@original3 -POSTHOOK: query: describe formatted original3 +PREHOOK: Input: skew_test@original3 +POSTHOOK: query: describe formatted skew_test.original3 POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@original3 +POSTHOOK: Input: skew_test@original3 # col_name data_type comment key string value string # Detailed Table Information -Database: default +Database: skew_test #### A masked pattern was here #### Protect Mode: None Retention: 0 @@ -272,11 +278,19 @@ Bucket Columns: [] Sort Columns: [] Storage Desc Params: serialization.format 1 -PREHOOK: query: drop table original3 +PREHOOK: query: drop table skew_test.original3 PREHOOK: type: DROPTABLE -PREHOOK: Input: default@original3 -PREHOOK: Output: default@original3 -POSTHOOK: query: drop table original3 +PREHOOK: Input: skew_test@original3 +PREHOOK: Output: skew_test@original3 +POSTHOOK: query: drop table skew_test.original3 POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@original3 -POSTHOOK: Output: default@original3 +POSTHOOK: Input: skew_test@original3 +POSTHOOK: Output: skew_test@original3 +PREHOOK: query: drop database skew_test +PREHOOK: type: DROPDATABASE +PREHOOK: Input: database:skew_test +PREHOOK: Output: database:skew_test +POSTHOOK: query: drop database skew_test +POSTHOOK: type: DROPDATABASE +POSTHOOK: Input: database:skew_test +POSTHOOK: Output: database:skew_test Modified: hive/branches/spark/ql/src/test/results/clientpositive/alter_table_update_status.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/alter_table_update_status.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/alter_table_update_status.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/alter_table_update_status.q.out Sat Aug 30 06:44:46 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/branches/spark/ql/src/test/results/clientpositive/alter_varchar1.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/alter_varchar1.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/alter_varchar1.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/alter_varchar1.q.out Sat Aug 30 06:44:46 2014 @@ -1,38 +1,40 @@ PREHOOK: query: -- SORT_QUERY_RESULTS -drop table alter_varchar_1 -PREHOOK: type: DROPTABLE +create database avc +PREHOOK: type: CREATEDATABASE +PREHOOK: Output: database:avc POSTHOOK: query: -- SORT_QUERY_RESULTS -drop table alter_varchar_1 -POSTHOOK: type: DROPTABLE -PREHOOK: query: create table alter_varchar_1 (key string, value string) +create database avc +POSTHOOK: type: CREATEDATABASE +POSTHOOK: Output: database:avc +PREHOOK: query: create table avc.alter_varchar_1 (key string, value string) PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@alter_varchar_1 -POSTHOOK: query: create table alter_varchar_1 (key string, value string) +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: database:default -POSTHOOK: Output: default@alter_varchar_1 -PREHOOK: query: insert overwrite table alter_varchar_1 +POSTHOOK: Output: 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 PREHOOK: type: QUERY PREHOOK: Input: default@src -PREHOOK: Output: default@alter_varchar_1 -POSTHOOK: query: insert overwrite table alter_varchar_1 +PREHOOK: Output: avc@alter_varchar_1 +POSTHOOK: query: insert overwrite table avc.alter_varchar_1 select key, value from src order by key limit 5 POSTHOOK: type: QUERY POSTHOOK: Input: default@src -POSTHOOK: Output: default@alter_varchar_1 +POSTHOOK: Output: avc@alter_varchar_1 POSTHOOK: Lineage: alter_varchar_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: alter_varchar_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: select * from alter_varchar_1 +PREHOOK: query: select * from avc.alter_varchar_1 PREHOOK: type: QUERY -PREHOOK: Input: default@alter_varchar_1 +PREHOOK: Input: avc@alter_varchar_1 #### A masked pattern was here #### -POSTHOOK: query: select * from alter_varchar_1 +POSTHOOK: query: select * from avc.alter_varchar_1 POSTHOOK: type: QUERY -POSTHOOK: Input: default@alter_varchar_1 +POSTHOOK: Input: avc@alter_varchar_1 #### A masked pattern was here #### 0 val_0 0 val_0 @@ -40,24 +42,24 @@ POSTHOOK: Input: default@alter_varchar_1 10 val_10 100 val_100 PREHOOK: query: -- change column to varchar -alter table alter_varchar_1 change column value value varchar(20) +alter table avc.alter_varchar_1 change column value value varchar(20) PREHOOK: type: ALTERTABLE_RENAMECOL -PREHOOK: Input: default@alter_varchar_1 -PREHOOK: Output: default@alter_varchar_1 +PREHOOK: Input: avc@alter_varchar_1 +PREHOOK: Output: avc@alter_varchar_1 POSTHOOK: query: -- change column to varchar -alter table alter_varchar_1 change column value value varchar(20) +alter table avc.alter_varchar_1 change column value value varchar(20) POSTHOOK: type: ALTERTABLE_RENAMECOL -POSTHOOK: Input: default@alter_varchar_1 -POSTHOOK: Output: default@alter_varchar_1 +POSTHOOK: Input: avc@alter_varchar_1 +POSTHOOK: Output: avc@alter_varchar_1 PREHOOK: query: -- contents should still look the same -select * from alter_varchar_1 +select * from avc.alter_varchar_1 PREHOOK: type: QUERY -PREHOOK: Input: default@alter_varchar_1 +PREHOOK: Input: avc@alter_varchar_1 #### A masked pattern was here #### POSTHOOK: query: -- contents should still look the same -select * from alter_varchar_1 +select * from avc.alter_varchar_1 POSTHOOK: type: QUERY -POSTHOOK: Input: default@alter_varchar_1 +POSTHOOK: Input: avc@alter_varchar_1 #### A masked pattern was here #### 0 val_0 0 val_0 @@ -65,24 +67,24 @@ POSTHOOK: Input: default@alter_varchar_1 10 val_10 100 val_100 PREHOOK: query: -- change column to smaller varchar -alter table alter_varchar_1 change column value value varchar(3) +alter table avc.alter_varchar_1 change column value value varchar(3) PREHOOK: type: ALTERTABLE_RENAMECOL -PREHOOK: Input: default@alter_varchar_1 -PREHOOK: Output: default@alter_varchar_1 +PREHOOK: Input: avc@alter_varchar_1 +PREHOOK: Output: avc@alter_varchar_1 POSTHOOK: query: -- change column to smaller varchar -alter table alter_varchar_1 change column value value varchar(3) +alter table avc.alter_varchar_1 change column value value varchar(3) POSTHOOK: type: ALTERTABLE_RENAMECOL -POSTHOOK: Input: default@alter_varchar_1 -POSTHOOK: Output: default@alter_varchar_1 +POSTHOOK: Input: avc@alter_varchar_1 +POSTHOOK: Output: avc@alter_varchar_1 PREHOOK: query: -- value column should be truncated now -select * from alter_varchar_1 +select * from avc.alter_varchar_1 PREHOOK: type: QUERY -PREHOOK: Input: default@alter_varchar_1 +PREHOOK: Input: avc@alter_varchar_1 #### A masked pattern was here #### POSTHOOK: query: -- value column should be truncated now -select * from alter_varchar_1 +select * from avc.alter_varchar_1 POSTHOOK: type: QUERY -POSTHOOK: Input: default@alter_varchar_1 +POSTHOOK: Input: avc@alter_varchar_1 #### A masked pattern was here #### 0 val 0 val @@ -90,24 +92,24 @@ POSTHOOK: Input: default@alter_varchar_1 10 val 100 val PREHOOK: query: -- change back to bigger varchar -alter table alter_varchar_1 change column value value varchar(20) +alter table avc.alter_varchar_1 change column value value varchar(20) PREHOOK: type: ALTERTABLE_RENAMECOL -PREHOOK: Input: default@alter_varchar_1 -PREHOOK: Output: default@alter_varchar_1 +PREHOOK: Input: avc@alter_varchar_1 +PREHOOK: Output: avc@alter_varchar_1 POSTHOOK: query: -- change back to bigger varchar -alter table alter_varchar_1 change column value value varchar(20) +alter table avc.alter_varchar_1 change column value value varchar(20) POSTHOOK: type: ALTERTABLE_RENAMECOL -POSTHOOK: Input: default@alter_varchar_1 -POSTHOOK: Output: default@alter_varchar_1 +POSTHOOK: Input: avc@alter_varchar_1 +POSTHOOK: Output: avc@alter_varchar_1 PREHOOK: query: -- column values should be full size again -select * from alter_varchar_1 +select * from avc.alter_varchar_1 PREHOOK: type: QUERY -PREHOOK: Input: default@alter_varchar_1 +PREHOOK: Input: avc@alter_varchar_1 #### A masked pattern was here #### POSTHOOK: query: -- column values should be full size again -select * from alter_varchar_1 +select * from avc.alter_varchar_1 POSTHOOK: type: QUERY -POSTHOOK: Input: default@alter_varchar_1 +POSTHOOK: Input: avc@alter_varchar_1 #### A masked pattern was here #### 0 val_0 0 val_0 @@ -115,60 +117,68 @@ POSTHOOK: Input: default@alter_varchar_1 10 val_10 100 val_100 PREHOOK: query: -- add varchar column -alter table alter_varchar_1 add columns (key2 int, value2 varchar(10)) +alter table avc.alter_varchar_1 add columns (key2 int, value2 varchar(10)) PREHOOK: type: ALTERTABLE_ADDCOLS -PREHOOK: Input: default@alter_varchar_1 -PREHOOK: Output: default@alter_varchar_1 +PREHOOK: Input: avc@alter_varchar_1 +PREHOOK: Output: avc@alter_varchar_1 POSTHOOK: query: -- add varchar column -alter table alter_varchar_1 add columns (key2 int, value2 varchar(10)) +alter table avc.alter_varchar_1 add columns (key2 int, value2 varchar(10)) POSTHOOK: type: ALTERTABLE_ADDCOLS -POSTHOOK: Input: default@alter_varchar_1 -POSTHOOK: Output: default@alter_varchar_1 -PREHOOK: query: select * from alter_varchar_1 +POSTHOOK: Input: avc@alter_varchar_1 +POSTHOOK: Output: avc@alter_varchar_1 +PREHOOK: query: select * from avc.alter_varchar_1 PREHOOK: type: QUERY -PREHOOK: Input: default@alter_varchar_1 +PREHOOK: Input: avc@alter_varchar_1 #### A masked pattern was here #### -POSTHOOK: query: select * from alter_varchar_1 +POSTHOOK: query: select * from avc.alter_varchar_1 POSTHOOK: type: QUERY -POSTHOOK: Input: default@alter_varchar_1 +POSTHOOK: Input: avc@alter_varchar_1 #### A masked pattern was here #### 0 val_0 NULL NULL 0 val_0 NULL NULL 0 val_0 NULL NULL 10 val_10 NULL NULL 100 val_100 NULL NULL -PREHOOK: query: insert overwrite table alter_varchar_1 +PREHOOK: query: insert overwrite table avc.alter_varchar_1 select key, value, key, value from src order by key limit 5 PREHOOK: type: QUERY PREHOOK: Input: default@src -PREHOOK: Output: default@alter_varchar_1 -POSTHOOK: query: insert overwrite table alter_varchar_1 +PREHOOK: Output: avc@alter_varchar_1 +POSTHOOK: query: insert overwrite table avc.alter_varchar_1 select key, value, key, value from src order by key limit 5 POSTHOOK: type: QUERY POSTHOOK: Input: default@src -POSTHOOK: Output: default@alter_varchar_1 +POSTHOOK: Output: avc@alter_varchar_1 POSTHOOK: Lineage: alter_varchar_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: alter_varchar_1.key2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: alter_varchar_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ] POSTHOOK: Lineage: alter_varchar_1.value2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: select * from alter_varchar_1 +PREHOOK: query: select * from avc.alter_varchar_1 PREHOOK: type: QUERY -PREHOOK: Input: default@alter_varchar_1 +PREHOOK: Input: avc@alter_varchar_1 #### A masked pattern was here #### -POSTHOOK: query: select * from alter_varchar_1 +POSTHOOK: query: select * from avc.alter_varchar_1 POSTHOOK: type: QUERY -POSTHOOK: Input: default@alter_varchar_1 +POSTHOOK: Input: avc@alter_varchar_1 #### A masked pattern was here #### 0 val_0 0 val_0 0 val_0 0 val_0 0 val_0 0 val_0 10 val_10 10 val_10 100 val_100 100 val_100 -PREHOOK: query: drop table alter_varchar_1 +PREHOOK: query: drop table avc.alter_varchar_1 PREHOOK: type: DROPTABLE -PREHOOK: Input: default@alter_varchar_1 -PREHOOK: Output: default@alter_varchar_1 -POSTHOOK: query: drop table alter_varchar_1 +PREHOOK: Input: avc@alter_varchar_1 +PREHOOK: Output: avc@alter_varchar_1 +POSTHOOK: query: drop table avc.alter_varchar_1 POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@alter_varchar_1 -POSTHOOK: Output: default@alter_varchar_1 +POSTHOOK: Input: avc@alter_varchar_1 +POSTHOOK: Output: avc@alter_varchar_1 +PREHOOK: query: drop database avc +PREHOOK: type: DROPDATABASE +PREHOOK: Input: database:avc +PREHOOK: Output: database:avc +POSTHOOK: query: drop database avc +POSTHOOK: type: DROPDATABASE +POSTHOOK: Input: database:avc +POSTHOOK: Output: database:avc Modified: hive/branches/spark/ql/src/test/results/clientpositive/alter_view_as_select.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/alter_view_as_select.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/alter_view_as_select.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/alter_view_as_select.q.out Sat Aug 30 06:44:46 2014 @@ -1,20 +1,25 @@ -PREHOOK: query: DROP VIEW testView -PREHOOK: type: DROPVIEW -POSTHOOK: query: DROP VIEW testView -POSTHOOK: type: DROPVIEW -PREHOOK: query: CREATE VIEW testView as SELECT * FROM srcpart +PREHOOK: query: CREATE DATABASE tv +PREHOOK: type: CREATEDATABASE +PREHOOK: Output: database:tv +POSTHOOK: query: CREATE DATABASE tv +POSTHOOK: type: CREATEDATABASE +POSTHOOK: Output: database:tv +PREHOOK: query: CREATE VIEW tv.testView as SELECT * FROM srcpart PREHOOK: type: CREATEVIEW PREHOOK: Input: default@srcpart -POSTHOOK: query: CREATE VIEW testView as SELECT * FROM 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: default@testView -PREHOOK: query: DESCRIBE FORMATTED testView +POSTHOOK: Output: database:tv +POSTHOOK: Output: tv@testView +PREHOOK: query: DESCRIBE FORMATTED tv.testView PREHOOK: type: DESCTABLE -PREHOOK: Input: default@testview -POSTHOOK: query: DESCRIBE FORMATTED testView +PREHOOK: Input: tv@testview +POSTHOOK: query: DESCRIBE FORMATTED tv.testView POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@testview +POSTHOOK: Input: tv@testview # col_name data_type comment key string @@ -23,7 +28,7 @@ ds string hr string # Detailed Table Information -Database: default +Database: tv #### A masked pattern was here #### Protect Mode: None Retention: 0 @@ -43,25 +48,29 @@ 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: ALTER VIEW testView AS SELECT value FROM src WHERE key=86 +PREHOOK: query: ALTER VIEW tv.testView AS SELECT value FROM src WHERE key=86 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src -POSTHOOK: query: ALTER VIEW testView AS SELECT value FROM src WHERE key=86 +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: default@testview -PREHOOK: query: DESCRIBE FORMATTED testView +POSTHOOK: Output: database:tv +POSTHOOK: Output: tv@testView +POSTHOOK: Output: tv@testview +PREHOOK: query: DESCRIBE FORMATTED tv.testView PREHOOK: type: DESCTABLE -PREHOOK: Input: default@testview -POSTHOOK: query: DESCRIBE FORMATTED testView +PREHOOK: Input: tv@testview +POSTHOOK: query: DESCRIBE FORMATTED tv.testView POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@testview +POSTHOOK: Input: tv@testview # col_name data_type comment value string # Detailed Table Information -Database: default +Database: tv #### A masked pattern was here #### Protect Mode: None Retention: 0 @@ -81,34 +90,38 @@ Sort Columns: [] # View Information View Original Text: SELECT value FROM src WHERE key=86 View Expanded Text: SELECT `src`.`value` FROM `default`.`src` WHERE `src`.`key`=86 -PREHOOK: query: ALTER VIEW testView AS +PREHOOK: query: ALTER VIEW tv.testView AS SELECT * FROM src WHERE key > 80 AND key < 100 ORDER BY key, value LIMIT 10 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src -POSTHOOK: query: ALTER VIEW testView AS +PREHOOK: Output: database:tv +PREHOOK: Output: tv@testView +POSTHOOK: query: ALTER VIEW tv.testView AS SELECT * FROM src WHERE key > 80 AND key < 100 ORDER BY key, value LIMIT 10 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src -POSTHOOK: Output: default@testview -PREHOOK: query: DESCRIBE FORMATTED testView +POSTHOOK: Output: database:tv +POSTHOOK: Output: tv@testView +POSTHOOK: Output: tv@testview +PREHOOK: query: DESCRIBE FORMATTED tv.testView PREHOOK: type: DESCTABLE -PREHOOK: Input: default@testview -POSTHOOK: query: DESCRIBE FORMATTED testView +PREHOOK: Input: tv@testview +POSTHOOK: query: DESCRIBE FORMATTED tv.testView POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@testview +POSTHOOK: Input: tv@testview # col_name data_type comment key string value string # Detailed Table Information -Database: default +Database: tv #### A masked pattern was here #### Protect Mode: None Retention: 0 @@ -134,3 +147,19 @@ View Expanded Text: SELECT `src`.`key`, WHERE `src`.`key` > 80 AND `src`.`key` < 100 ORDER BY `src`.`key`, `src`.`value` LIMIT 10 +PREHOOK: query: DROP VIEW tv.testView +PREHOOK: type: DROPVIEW +PREHOOK: Input: tv@testview +PREHOOK: Output: tv@testview +POSTHOOK: query: DROP VIEW tv.testView +POSTHOOK: type: DROPVIEW +POSTHOOK: Input: tv@testview +POSTHOOK: Output: tv@testview +PREHOOK: query: DROP DATABASE tv +PREHOOK: type: DROPDATABASE +PREHOOK: Input: database:tv +PREHOOK: Output: database:tv +POSTHOOK: query: DROP DATABASE tv +POSTHOOK: type: DROPDATABASE +POSTHOOK: Input: database:tv +POSTHOOK: Output: database:tv Modified: hive/branches/spark/ql/src/test/results/clientpositive/alter_view_rename.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/alter_view_rename.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/alter_view_rename.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/alter_view_rename.q.out Sat Aug 30 06:44:46 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,56 @@ 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 +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: default@view1 -PREHOOK: query: DESCRIBE EXTENDED view1 +POSTHOOK: Output: database:tv1 +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 +77,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/branches/spark/ql/src/test/results/clientpositive/archive_multi.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/archive_multi.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/archive_multi.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/archive_multi.q.out Sat Aug 30 06:44:46 2014 @@ -1,161 +1,159 @@ -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@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@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@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@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 +164,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
