You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2014/09/02 21:57:07 UTC
svn commit: r1622108 [20/27] - in /hive/branches/tez: ./
accumulo-handler/src/java/org/apache/hadoop/hive/accumulo/predicate/
beeline/src/java/org/apache/hive/beeline/
beeline/src/test/org/apache/hive/beeline/ bin/ bin/ext/ checkstyle/
common/src/java/...
Modified: hive/branches/tez/ql/src/test/results/clientpositive/add_part_exist.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/add_part_exist.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/add_part_exist.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/add_part_exist.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/allcolref_in_udf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/allcolref_in_udf.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/allcolref_in_udf.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/allcolref_in_udf.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/alter1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/alter1.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/alter1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/alter1.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/alter_char1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/alter_char1.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/alter_char1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/alter_char1.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/alter_index.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/alter_index.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/alter_index.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/alter_index.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/alter_partition_coltype.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/alter_partition_coltype.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
Files hive/branches/tez/ql/src/test/results/clientpositive/alter_partition_coltype.q.out (original) and hive/branches/tez/ql/src/test/results/clientpositive/alter_partition_coltype.q.out Tue Sep 2 19:56:56 2014 differ
Modified: hive/branches/tez/ql/src/test/results/clientpositive/alter_rename_partition_authorization.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/alter_rename_partition_authorization.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/alter_rename_partition_authorization.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/alter_rename_partition_authorization.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/alter_rename_table.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/alter_rename_table.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/alter_rename_table.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/alter_rename_table.q.out Tue Sep 2 19:56:56 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: source@source.src
+PREHOOK: Output: source@src
POSTHOOK: query: create table source.src like default.src
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:source
-POSTHOOK: Output: source@source.src
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: source@source.srcpart
+PREHOOK: Output: source@srcpart
POSTHOOK: query: create table source.srcpart like default.srcpart
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:source
-POSTHOOK: Output: source@source.srcpart
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: source@source.src
+PREHOOK: Output: source@src
POSTHOOK: query: create table source.src like default.src
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:source
-POSTHOOK: Output: source@source.src
POSTHOOK: Output: source@src
PREHOOK: query: create table source.src1 like default.src
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:source
-PREHOOK: Output: source@source.src1
+PREHOOK: Output: source@src1
POSTHOOK: query: create table source.src1 like default.src
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:source
-POSTHOOK: Output: source@source.src1
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/tez/ql/src/test/results/clientpositive/alter_skewed_table.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/alter_skewed_table.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/alter_skewed_table.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/alter_skewed_table.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/alter_table_update_status.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/alter_table_update_status.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/alter_table_update_status.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/alter_table_update_status.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/alter_varchar1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/alter_varchar1.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/alter_varchar1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/alter_varchar1.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/alter_view_as_select.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/alter_view_as_select.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/alter_view_as_select.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/alter_view_as_select.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/alter_view_rename.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/alter_view_rename.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/alter_view_rename.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/alter_view_rename.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/annotate_stats_join.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/annotate_stats_join.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/annotate_stats_join.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/annotate_stats_join.q.out Tue Sep 2 19:56:56 2014
@@ -391,17 +391,17 @@ STAGE PLANS:
0 {KEY.reducesinkkey1} {KEY.reducesinkkey0} {VALUE._col0}
1 {KEY.reducesinkkey0} {KEY.reducesinkkey1}
outputColumnNames: _col0, _col1, _col2, _col6, _col7
- Statistics: Num rows: 1 Data size: 194 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 11 Data size: 2134 Basic stats: COMPLETE Column stats: COMPLETE
Filter Operator
predicate: (((_col1 = _col6) and (_col0 = _col7)) and (_col7 = _col0)) (type: boolean)
- Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics: Num rows: 1 Data size: 194 Basic stats: COMPLETE Column stats: COMPLETE
Select Operator
expressions: _col0 (type: string), _col1 (type: int), _col2 (type: int), _col6 (type: int), _col7 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4
- Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics: Num rows: 1 Data size: 194 Basic stats: COMPLETE Column stats: COMPLETE
File Output Operator
compressed: false
- Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: COMPLETE
+ Statistics: Num rows: 1 Data size: 194 Basic stats: COMPLETE Column stats: COMPLETE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/annotate_stats_part.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/annotate_stats_part.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/annotate_stats_part.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/annotate_stats_part.q.out Tue Sep 2 19:56:56 2014
@@ -366,14 +366,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: loc_orc
- Statistics: Num rows: 8 Data size: 724 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 8 Data size: 724 Basic stats: COMPLETE Column stats: PARTIAL
Select Operator
expressions: state (type: string)
outputColumnNames: _col0
- Statistics: Num rows: 8 Data size: 688 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 8 Data size: 688 Basic stats: COMPLETE Column stats: PARTIAL
File Output Operator
compressed: false
- Statistics: Num rows: 8 Data size: 688 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 8 Data size: 688 Basic stats: COMPLETE Column stats: PARTIAL
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -403,14 +403,14 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: loc_orc
- Statistics: Num rows: 8 Data size: 724 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 8 Data size: 724 Basic stats: COMPLETE Column stats: PARTIAL
Select Operator
expressions: state (type: string), locid (type: int)
outputColumnNames: _col0, _col1
- Statistics: Num rows: 8 Data size: 720 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 8 Data size: 720 Basic stats: COMPLETE Column stats: PARTIAL
File Output Operator
compressed: false
- Statistics: Num rows: 8 Data size: 720 Basic stats: COMPLETE Column stats: COMPLETE
+ Statistics: Num rows: 8 Data size: 720 Basic stats: COMPLETE Column stats: PARTIAL
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat