Modified: hive/branches/spark/ql/src/test/results/clientpositive/ctas_date.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/ctas_date.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/ctas_date.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/ctas_date.q.out Sat Aug 30 06:44:46 2014 @@ -39,26 +39,35 @@ PREHOOK: query: -- create table as with create table ctas_date_2 as select key, value, dd, date '1980-12-12' from ctas_date_1 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@ctas_date_1 +PREHOOK: Output: database:default +PREHOOK: Output: default@ctas_date_2 POSTHOOK: query: -- create table as with date column create table ctas_date_2 as select key, value, dd, date '1980-12-12' from ctas_date_1 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@ctas_date_1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@ctas_date_2 PREHOOK: query: -- view with date column create view ctas_date_3 as select * from ctas_date_2 where dd > date '2000-01-01' PREHOOK: type: CREATEVIEW PREHOOK: Input: default@ctas_date_2 +PREHOOK: Output: database:default +PREHOOK: Output: default@ctas_date_3 POSTHOOK: query: -- view with date column create view ctas_date_3 as select * from ctas_date_2 where dd > date '2000-01-01' POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@ctas_date_2 +POSTHOOK: Output: database:default POSTHOOK: Output: default@ctas_date_3 PREHOOK: query: create view ctas_date_4 as select * from ctas_date_2 where dd < date '2000-01-01' PREHOOK: type: CREATEVIEW PREHOOK: Input: default@ctas_date_2 +PREHOOK: Output: database:default +PREHOOK: Output: default@ctas_date_4 POSTHOOK: query: create view ctas_date_4 as select * from ctas_date_2 where dd < date '2000-01-01' POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@ctas_date_2 +POSTHOOK: Output: database:default POSTHOOK: Output: default@ctas_date_4 PREHOOK: query: select key, value, dd, date '1980-12-12' from ctas_date_1 PREHOOK: type: QUERY
Modified: hive/branches/spark/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out Sat Aug 30 06:44:46 2014 @@ -79,7 +79,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: table_db1 + name: db1.table_db1 Stage: Stage-2 Stats-Aggr Operator @@ -117,9 +117,12 @@ STAGE PLANS: PREHOOK: query: CREATE TABLE table_db1 AS SELECT * FROM default.src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:db1 +PREHOOK: Output: db1@table_db1 POSTHOOK: query: CREATE TABLE table_db1 AS SELECT * FROM default.src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:db1 POSTHOOK: Output: db1@table_db1 PREHOOK: query: DESCRIBE FORMATTED table_db1 PREHOOK: type: DESCTABLE Modified: hive/branches/spark/ql/src/test/results/clientpositive/ctas_varchar.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/ctas_varchar.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/ctas_varchar.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/ctas_varchar.q.out Sat Aug 30 06:44:46 2014 @@ -34,19 +34,25 @@ PREHOOK: query: -- create table as with create table ctas_varchar_2 as select key, value from ctas_varchar_1 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@ctas_varchar_1 +PREHOOK: Output: database:default +PREHOOK: Output: default@ctas_varchar_2 POSTHOOK: query: -- create table as with varchar column create table ctas_varchar_2 as select key, value from ctas_varchar_1 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@ctas_varchar_1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@ctas_varchar_2 PREHOOK: query: -- view with varchar column create view ctas_varchar_3 as select key, value from ctas_varchar_2 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@ctas_varchar_2 +PREHOOK: Output: database:default +PREHOOK: Output: default@ctas_varchar_3 POSTHOOK: query: -- view with varchar column create view ctas_varchar_3 as select key, value from ctas_varchar_2 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@ctas_varchar_2 +POSTHOOK: Output: database:default POSTHOOK: Output: default@ctas_varchar_3 PREHOOK: query: select key, value from ctas_varchar_1 PREHOOK: type: QUERY Modified: hive/branches/spark/ql/src/test/results/clientpositive/cte_2.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/cte_2.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/cte_2.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/cte_2.q.out Sat Aug 30 06:44:46 2014 @@ -84,12 +84,15 @@ with q1 as ( select key from src where k select * from q1 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@s2 POSTHOOK: query: -- ctas create table s2 as with q1 as ( select key from src where key = '4') select * from q1 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@s2 PREHOOK: query: select * from s2 PREHOOK: type: QUERY @@ -114,12 +117,15 @@ with q1 as ( select key from src where k select * from q1 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@v1 POSTHOOK: query: -- view test create view v1 as with q1 as ( select key from src where key = '5') select * from q1 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@v1 PREHOOK: query: select * from v1 PREHOOK: type: QUERY @@ -148,12 +154,15 @@ with q1 as ( select key from src where k select * from q1 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@v1 POSTHOOK: query: -- view test, name collision create view v1 as with q1 as ( select key from src where key = '5') select * from q1 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@v1 PREHOOK: query: with q1 as ( select key from src where key = '4') select * from v1 Modified: hive/branches/spark/ql/src/test/results/clientpositive/database.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/database.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/database.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/database.q.out Sat Aug 30 06:44:46 2014 @@ -585,13 +585,12 @@ CREATE TABLE db1.src(key STRING, value S STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:db1 -PREHOOK: Output: [email protected] +PREHOOK: Output: db1@src POSTHOOK: query: -- CREATE foreign table CREATE TABLE db1.src(key STRING, value STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:db1 -POSTHOOK: Output: [email protected] POSTHOOK: Output: db1@src PREHOOK: query: -- LOAD into foreign table LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' @@ -1121,14 +1120,13 @@ PARTITIONED BY (ds STRING, hr STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:db1 -PREHOOK: Output: [email protected] +PREHOOK: Output: db1@srcpart POSTHOOK: query: -- CREATE Partitioned foreign table CREATE TABLE db1.srcpart(key STRING, value STRING) PARTITIONED BY (ds STRING, hr STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:db1 -POSTHOOK: Output: [email protected] POSTHOOK: Output: db1@srcpart PREHOOK: query: -- LOAD data into Partitioned foreign table LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' @@ -1305,22 +1303,28 @@ CREATE TABLE conflict_name AS SELECT value FROM default.src WHERE key = 66 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:db2 +PREHOOK: Output: db2@conflict_name POSTHOOK: query: -- CREATE TABLE AS SELECT from foreign table CREATE TABLE conflict_name AS SELECT value FROM default.src WHERE key = 66 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:db2 POSTHOOK: Output: db2@conflict_name PREHOOK: query: -- CREATE foreign table CREATE TABLE db1.conflict_name AS SELECT value FROM db1.src WHERE key = 8 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: db1@src +PREHOOK: Output: database:db1 +PREHOOK: Output: db1@conflict_name POSTHOOK: query: -- CREATE foreign table CREATE TABLE db1.conflict_name AS SELECT value FROM db1.src WHERE key = 8 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: db1@src +POSTHOOK: Output: database:db1 POSTHOOK: Output: db1@conflict_name PREHOOK: query: -- query tables with the same names in different DBs SELECT * FROM ( @@ -1407,12 +1411,11 @@ PREHOOK: query: -- CREATE TABLE LIKE CREATE TABLE db2.src1 LIKE default.src PREHOOK: type: CREATETABLE PREHOOK: Output: database:db2 -PREHOOK: Output: [email protected] +PREHOOK: Output: db2@src1 POSTHOOK: query: -- CREATE TABLE LIKE CREATE TABLE db2.src1 LIKE default.src POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:db2 -POSTHOOK: Output: [email protected] POSTHOOK: Output: db2@src1 PREHOOK: query: USE db2 PREHOOK: type: SWITCHDATABASE Modified: hive/branches/spark/ql/src/test/results/clientpositive/database_drop.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/database_drop.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/database_drop.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/database_drop.q.out Sat Aug 30 06:44:46 2014 @@ -50,9 +50,12 @@ POSTHOOK: Output: db5@temp_tbl PREHOOK: query: CREATE VIEW temp_tbl_view AS SELECT * FROM temp_tbl PREHOOK: type: CREATEVIEW PREHOOK: Input: db5@temp_tbl +PREHOOK: Output: database:db5 +PREHOOK: Output: db5@temp_tbl_view POSTHOOK: query: CREATE VIEW temp_tbl_view AS SELECT * FROM temp_tbl POSTHOOK: type: CREATEVIEW POSTHOOK: Input: db5@temp_tbl +POSTHOOK: Output: database:db5 POSTHOOK: Output: db5@temp_tbl_view PREHOOK: query: CREATE INDEX idx1 ON TABLE temp_tbl(id) AS 'COMPACT' with DEFERRED REBUILD PREHOOK: type: CREATEINDEX @@ -95,9 +98,12 @@ POSTHOOK: Output: db5@temp_tbl2 PREHOOK: query: CREATE VIEW temp_tbl2_view AS SELECT * FROM temp_tbl2 PREHOOK: type: CREATEVIEW PREHOOK: Input: db5@temp_tbl2 +PREHOOK: Output: database:db5 +PREHOOK: Output: db5@temp_tbl2_view POSTHOOK: query: CREATE VIEW temp_tbl2_view AS SELECT * FROM temp_tbl2 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: db5@temp_tbl2 +POSTHOOK: Output: database:db5 POSTHOOK: Output: db5@temp_tbl2_view #### A masked pattern was here #### PREHOOK: type: CREATEINDEX Modified: hive/branches/spark/ql/src/test/results/clientpositive/dbtxnmgr_ddl1.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/dbtxnmgr_ddl1.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/dbtxnmgr_ddl1.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/dbtxnmgr_ddl1.q.out Sat Aug 30 06:44:46 2014 @@ -59,9 +59,12 @@ POSTHOOK: Input: default@t1 PREHOOK: query: create table T3 as select * from T1 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@t1 +PREHOOK: Output: database:default +PREHOOK: Output: default@T3 POSTHOOK: query: create table T3 as select * from T1 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@t1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@T3 PREHOOK: query: create table T4 (key char(10), val decimal(5,2), b int) partitioned by (ds string) @@ -221,9 +224,12 @@ POSTHOOK: Output: default@t4@ds=tomorrow PREHOOK: query: create view V1 as select key from T1 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@t1 +PREHOOK: Output: database:default +PREHOOK: Output: default@V1 POSTHOOK: query: create view V1 as select key from T1 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@t1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@V1 PREHOOK: query: alter view V1 set tblproperties ('test'='thisisatest') PREHOOK: type: ALTERVIEW_PROPERTIES Modified: hive/branches/spark/ql/src/test/results/clientpositive/dbtxnmgr_query5.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/dbtxnmgr_query5.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/dbtxnmgr_query5.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/dbtxnmgr_query5.q.out Sat Aug 30 06:44:46 2014 @@ -28,9 +28,12 @@ POSTHOOK: Output: foo@t1@ds=today PREHOOK: query: create view V1 as select key from T1 PREHOOK: type: CREATEVIEW PREHOOK: Input: foo@t1 +PREHOOK: Output: database:foo +PREHOOK: Output: foo@V1 POSTHOOK: query: create view V1 as select key from T1 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: foo@t1 +POSTHOOK: Output: database:foo POSTHOOK: Output: foo@V1 PREHOOK: query: show tables PREHOOK: type: SHOWTABLES Modified: hive/branches/spark/ql/src/test/results/clientpositive/decimal_6.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/decimal_6.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/decimal_6.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/decimal_6.q.out Sat Aug 30 06:44:46 2014 @@ -129,9 +129,12 @@ NULL PREHOOK: query: CREATE TABLE DECIMAL_6_3 AS SELECT key + 5.5 AS k, value * 11 AS v from DECIMAL_6_1 ORDER BY v PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@decimal_6_1 +PREHOOK: Output: database:default +PREHOOK: Output: default@DECIMAL_6_3 POSTHOOK: query: CREATE TABLE DECIMAL_6_3 AS SELECT key + 5.5 AS k, value * 11 AS v from DECIMAL_6_1 ORDER BY v POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@decimal_6_1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@DECIMAL_6_3 PREHOOK: query: desc DECIMAL_6_3 PREHOOK: type: DESCTABLE Modified: hive/branches/spark/ql/src/test/results/clientpositive/decimal_serde.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/decimal_serde.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/decimal_serde.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/decimal_serde.q.out Sat Aug 30 06:44:46 2014 @@ -87,11 +87,14 @@ STORED AS RCFile AS SELECT * FROM DECIMAL_TEXT PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@decimal_text +PREHOOK: Output: database:default +PREHOOK: Output: default@DECIMAL_RC POSTHOOK: query: CREATE TABLE DECIMAL_RC STORED AS RCFile AS SELECT * FROM DECIMAL_TEXT POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@decimal_text +POSTHOOK: Output: database:default POSTHOOK: Output: default@DECIMAL_RC PREHOOK: query: CREATE TABLE DECIMAL_LAZY_COL ROW FORMAT SERDE "org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe" @@ -99,12 +102,15 @@ STORED AS RCFile AS SELECT * FROM DECIMAL_RC PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@decimal_rc +PREHOOK: Output: database:default +PREHOOK: Output: default@DECIMAL_LAZY_COL POSTHOOK: query: CREATE TABLE DECIMAL_LAZY_COL ROW FORMAT SERDE "org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe" STORED AS RCFile AS SELECT * FROM DECIMAL_RC POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@decimal_rc +POSTHOOK: Output: database:default POSTHOOK: Output: default@DECIMAL_LAZY_COL PREHOOK: query: CREATE TABLE DECIMAL_SEQUENCE ROW FORMAT DELIMITED @@ -115,6 +121,8 @@ STORED AS SEQUENCEFILE AS SELECT * FROM DECIMAL_LAZY_COL ORDER BY key PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@decimal_lazy_col +PREHOOK: Output: database:default +PREHOOK: Output: default@DECIMAL_SEQUENCE POSTHOOK: query: CREATE TABLE DECIMAL_SEQUENCE ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' @@ -124,6 +132,7 @@ STORED AS SEQUENCEFILE AS SELECT * FROM DECIMAL_LAZY_COL ORDER BY key POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@decimal_lazy_col +POSTHOOK: Output: database:default POSTHOOK: Output: default@DECIMAL_SEQUENCE PREHOOK: query: SELECT * FROM DECIMAL_SEQUENCE ORDER BY key, value PREHOOK: type: QUERY Modified: hive/branches/spark/ql/src/test/results/clientpositive/describe_formatted_view_partitioned.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/describe_formatted_view_partitioned.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/describe_formatted_view_partitioned.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/describe_formatted_view_partitioned.q.out Sat Aug 30 06:44:46 2014 @@ -10,6 +10,8 @@ FROM src WHERE key=86 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view_partitioned POSTHOOK: query: CREATE VIEW view_partitioned PARTITIONED ON (value) AS @@ -18,6 +20,7 @@ FROM src WHERE key=86 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view_partitioned PREHOOK: query: ALTER VIEW view_partitioned ADD PARTITION (value='val_86') Modified: hive/branches/spark/ql/src/test/results/clientpositive/describe_formatted_view_partitioned_json.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/describe_formatted_view_partitioned_json.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/describe_formatted_view_partitioned_json.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/describe_formatted_view_partitioned_json.q.out Sat Aug 30 06:44:46 2014 @@ -10,6 +10,8 @@ FROM src WHERE key=86 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view_partitioned POSTHOOK: query: CREATE VIEW view_partitioned PARTITIONED ON (value) AS @@ -18,6 +20,7 @@ FROM src WHERE key=86 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view_partitioned PREHOOK: query: ALTER VIEW view_partitioned ADD PARTITION (value='val_86') Modified: hive/branches/spark/ql/src/test/results/clientpositive/describe_syntax.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/describe_syntax.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/describe_syntax.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/describe_syntax.q.out Sat Aug 30 06:44:46 2014 @@ -7,11 +7,10 @@ POSTHOOK: Output: database:db1 PREHOOK: query: CREATE TABLE db1.t1(key1 INT, value1 STRING) PARTITIONED BY (ds STRING, part STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:db1 -PREHOOK: Output: [email protected] +PREHOOK: Output: db1@t1 POSTHOOK: query: CREATE TABLE db1.t1(key1 INT, value1 STRING) PARTITIONED BY (ds STRING, part STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:db1 -POSTHOOK: Output: [email protected] POSTHOOK: Output: db1@t1 PREHOOK: query: use db1 PREHOOK: type: SWITCHDATABASE Modified: hive/branches/spark/ql/src/test/results/clientpositive/drop_multi_partitions.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/drop_multi_partitions.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/drop_multi_partitions.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/drop_multi_partitions.q.out Sat Aug 30 06:44:46 2014 @@ -1,55 +1,63 @@ -PREHOOK: query: create table mp (a string) partitioned by (b string, c string) +PREHOOK: query: create database dmp +PREHOOK: type: CREATEDATABASE +PREHOOK: Output: database:dmp +POSTHOOK: query: create database dmp +POSTHOOK: type: CREATEDATABASE +POSTHOOK: Output: database:dmp +PREHOOK: query: create table dmp.mp (a string) partitioned by (b string, c string) PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@mp -POSTHOOK: query: create table mp (a string) partitioned by (b string, c string) +PREHOOK: Output: database:dmp +PREHOOK: Output: dmp@mp +POSTHOOK: query: create table dmp.mp (a string) partitioned by (b string, c string) POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@mp -PREHOOK: query: alter table mp add partition (b='1', c='1') +POSTHOOK: Output: database:dmp +POSTHOOK: Output: dmp@mp +PREHOOK: query: alter table dmp.mp add partition (b='1', c='1') PREHOOK: type: ALTERTABLE_ADDPARTS -PREHOOK: Output: default@mp -POSTHOOK: query: alter table mp add partition (b='1', c='1') +PREHOOK: Output: dmp@mp +POSTHOOK: query: alter table dmp.mp add partition (b='1', c='1') POSTHOOK: type: ALTERTABLE_ADDPARTS -POSTHOOK: Output: default@mp -POSTHOOK: Output: default@mp@b=1/c=1 -PREHOOK: query: alter table mp add partition (b='1', c='2') +POSTHOOK: Output: dmp@mp +POSTHOOK: Output: dmp@mp@b=1/c=1 +PREHOOK: query: alter table dmp.mp add partition (b='1', c='2') PREHOOK: type: ALTERTABLE_ADDPARTS -PREHOOK: Output: default@mp -POSTHOOK: query: alter table mp add partition (b='1', c='2') +PREHOOK: Output: dmp@mp +POSTHOOK: query: alter table dmp.mp add partition (b='1', c='2') POSTHOOK: type: ALTERTABLE_ADDPARTS -POSTHOOK: Output: default@mp -POSTHOOK: Output: default@mp@b=1/c=2 -PREHOOK: query: alter table mp add partition (b='2', c='2') +POSTHOOK: Output: dmp@mp +POSTHOOK: Output: dmp@mp@b=1/c=2 +PREHOOK: query: alter table dmp.mp add partition (b='2', c='2') PREHOOK: type: ALTERTABLE_ADDPARTS -PREHOOK: Output: default@mp -POSTHOOK: query: alter table mp add partition (b='2', c='2') +PREHOOK: Output: dmp@mp +POSTHOOK: query: alter table dmp.mp add partition (b='2', c='2') POSTHOOK: type: ALTERTABLE_ADDPARTS -POSTHOOK: Output: default@mp -POSTHOOK: Output: default@mp@b=2/c=2 -PREHOOK: query: show partitions mp +POSTHOOK: Output: dmp@mp +POSTHOOK: Output: dmp@mp@b=2/c=2 +PREHOOK: query: show partitions dmp.mp PREHOOK: type: SHOWPARTITIONS -PREHOOK: Input: default@mp -POSTHOOK: query: show partitions mp +PREHOOK: Input: dmp@mp +POSTHOOK: query: show partitions dmp.mp POSTHOOK: type: SHOWPARTITIONS -POSTHOOK: Input: default@mp +POSTHOOK: Input: dmp@mp b=1/c=1 b=1/c=2 b=2/c=2 -PREHOOK: query: explain extended alter table mp drop partition (b='1') +PREHOOK: query: explain extended alter table dmp.mp drop partition (b='1') PREHOOK: type: ALTERTABLE_DROPPARTS -POSTHOOK: query: explain extended alter table mp drop partition (b='1') +POSTHOOK: query: explain extended alter table dmp.mp drop partition (b='1') POSTHOOK: type: ALTERTABLE_DROPPARTS ABSTRACT SYNTAX TREE: -TOK_ALTERTABLE_DROPPARTS +TOK_ALTERTABLE TOK_TABNAME + dmp mp - TOK_PARTSPEC - TOK_PARTVAL - b - = - '1' + TOK_ALTERTABLE_DROPPARTS + TOK_PARTSPEC + TOK_PARTVAL + b + = + '1' STAGE DEPENDENCIES: @@ -59,35 +67,51 @@ STAGE PLANS: Stage: Stage-0 Drop Table Operator: Drop Table - table: default.mp + table: dmp.mp -PREHOOK: query: alter table mp drop partition (b='1') +PREHOOK: query: alter table dmp.mp drop partition (b='1') PREHOOK: type: ALTERTABLE_DROPPARTS -PREHOOK: Input: default@mp -PREHOOK: Output: default@mp@b=1/c=1 -PREHOOK: Output: default@mp@b=1/c=2 -POSTHOOK: query: alter table mp drop partition (b='1') +PREHOOK: Input: dmp@mp +PREHOOK: Output: dmp@mp@b=1/c=1 +PREHOOK: Output: dmp@mp@b=1/c=2 +POSTHOOK: query: alter table dmp.mp drop partition (b='1') POSTHOOK: type: ALTERTABLE_DROPPARTS -POSTHOOK: Input: default@mp -POSTHOOK: Output: default@mp@b=1/c=1 -POSTHOOK: Output: default@mp@b=1/c=2 -PREHOOK: query: show partitions mp +POSTHOOK: Input: dmp@mp +POSTHOOK: Output: dmp@mp@b=1/c=1 +POSTHOOK: Output: dmp@mp@b=1/c=2 +PREHOOK: query: show partitions dmp.mp PREHOOK: type: SHOWPARTITIONS -PREHOOK: Input: default@mp -POSTHOOK: query: show partitions mp +PREHOOK: Input: dmp@mp +POSTHOOK: query: show partitions dmp.mp POSTHOOK: type: SHOWPARTITIONS -POSTHOOK: Input: default@mp +POSTHOOK: Input: dmp@mp b=2/c=2 -PREHOOK: query: alter table mp drop if exists partition (b='3') +PREHOOK: query: alter table dmp.mp drop if exists partition (b='3') PREHOOK: type: ALTERTABLE_DROPPARTS -PREHOOK: Input: default@mp -POSTHOOK: query: alter table mp drop if exists partition (b='3') +PREHOOK: Input: dmp@mp +POSTHOOK: query: alter table dmp.mp drop if exists partition (b='3') POSTHOOK: type: ALTERTABLE_DROPPARTS -POSTHOOK: Input: default@mp -PREHOOK: query: show partitions mp +POSTHOOK: Input: dmp@mp +PREHOOK: query: show partitions dmp.mp PREHOOK: type: SHOWPARTITIONS -PREHOOK: Input: default@mp -POSTHOOK: query: show partitions mp +PREHOOK: Input: dmp@mp +POSTHOOK: query: show partitions dmp.mp POSTHOOK: type: SHOWPARTITIONS -POSTHOOK: Input: default@mp +POSTHOOK: Input: dmp@mp b=2/c=2 +PREHOOK: query: drop table dmp.mp +PREHOOK: type: DROPTABLE +PREHOOK: Input: dmp@mp +PREHOOK: Output: dmp@mp +POSTHOOK: query: drop table dmp.mp +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: dmp@mp +POSTHOOK: Output: dmp@mp +PREHOOK: query: drop database dmp +PREHOOK: type: DROPDATABASE +PREHOOK: Input: database:dmp +PREHOOK: Output: database:dmp +POSTHOOK: query: drop database dmp +POSTHOOK: type: DROPDATABASE +POSTHOOK: Input: database:dmp +POSTHOOK: Output: database:dmp Modified: hive/branches/spark/ql/src/test/results/clientpositive/exchange_partition.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/exchange_partition.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/exchange_partition.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/exchange_partition.q.out Sat Aug 30 06:44:46 2014 @@ -1,65 +1,77 @@ -PREHOOK: query: CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING) +PREHOOK: query: create database ex1 +PREHOOK: type: CREATEDATABASE +PREHOOK: Output: database:ex1 +POSTHOOK: query: create database ex1 +POSTHOOK: type: CREATEDATABASE +POSTHOOK: Output: database:ex1 +PREHOOK: query: create database ex2 +PREHOOK: type: CREATEDATABASE +PREHOOK: Output: database:ex2 +POSTHOOK: query: create database ex2 +POSTHOOK: type: CREATEDATABASE +POSTHOOK: Output: database:ex2 +PREHOOK: query: CREATE TABLE ex1.exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING) PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@exchange_part_test1 -POSTHOOK: query: CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING) +PREHOOK: Output: database:ex1 +PREHOOK: Output: ex1@exchange_part_test1 +POSTHOOK: query: CREATE TABLE ex1.exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING) POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@exchange_part_test1 -PREHOOK: query: CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING) +POSTHOOK: Output: database:ex1 +POSTHOOK: Output: ex1@exchange_part_test1 +PREHOOK: query: CREATE TABLE ex2.exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING) PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@exchange_part_test2 -POSTHOOK: query: CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING) +PREHOOK: Output: database:ex2 +PREHOOK: Output: ex2@exchange_part_test2 +POSTHOOK: query: CREATE TABLE ex2.exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING) POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@exchange_part_test2 -PREHOOK: query: SHOW PARTITIONS exchange_part_test1 +POSTHOOK: Output: database:ex2 +POSTHOOK: Output: ex2@exchange_part_test2 +PREHOOK: query: SHOW PARTITIONS ex1.exchange_part_test1 PREHOOK: type: SHOWPARTITIONS -PREHOOK: Input: default@exchange_part_test1 -POSTHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: Input: ex1@exchange_part_test1 +POSTHOOK: query: SHOW PARTITIONS ex1.exchange_part_test1 POSTHOOK: type: SHOWPARTITIONS -POSTHOOK: Input: default@exchange_part_test1 -PREHOOK: query: SHOW PARTITIONS exchange_part_test2 +POSTHOOK: Input: ex1@exchange_part_test1 +PREHOOK: query: SHOW PARTITIONS ex2.exchange_part_test2 PREHOOK: type: SHOWPARTITIONS -PREHOOK: Input: default@exchange_part_test2 -POSTHOOK: query: SHOW PARTITIONS exchange_part_test2 +PREHOOK: Input: ex2@exchange_part_test2 +POSTHOOK: query: SHOW PARTITIONS ex2.exchange_part_test2 POSTHOOK: type: SHOWPARTITIONS -POSTHOOK: Input: default@exchange_part_test2 -PREHOOK: query: ALTER TABLE exchange_part_test2 ADD PARTITION (ds='2013-04-05') +POSTHOOK: Input: ex2@exchange_part_test2 +PREHOOK: query: ALTER TABLE ex2.exchange_part_test2 ADD PARTITION (ds='2013-04-05') PREHOOK: type: ALTERTABLE_ADDPARTS -PREHOOK: Output: default@exchange_part_test2 -POSTHOOK: query: ALTER TABLE exchange_part_test2 ADD PARTITION (ds='2013-04-05') +PREHOOK: Output: ex2@exchange_part_test2 +POSTHOOK: query: ALTER TABLE ex2.exchange_part_test2 ADD PARTITION (ds='2013-04-05') POSTHOOK: type: ALTERTABLE_ADDPARTS -POSTHOOK: Output: default@exchange_part_test2 -POSTHOOK: Output: default@exchange_part_test2@ds=2013-04-05 -PREHOOK: query: SHOW PARTITIONS exchange_part_test1 +POSTHOOK: Output: ex2@exchange_part_test2 +POSTHOOK: Output: ex2@exchange_part_test2@ds=2013-04-05 +PREHOOK: query: SHOW PARTITIONS ex1.exchange_part_test1 PREHOOK: type: SHOWPARTITIONS -PREHOOK: Input: default@exchange_part_test1 -POSTHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: Input: ex1@exchange_part_test1 +POSTHOOK: query: SHOW PARTITIONS ex1.exchange_part_test1 POSTHOOK: type: SHOWPARTITIONS -POSTHOOK: Input: default@exchange_part_test1 -PREHOOK: query: SHOW PARTITIONS exchange_part_test2 +POSTHOOK: Input: ex1@exchange_part_test1 +PREHOOK: query: SHOW PARTITIONS ex2.exchange_part_test2 PREHOOK: type: SHOWPARTITIONS -PREHOOK: Input: default@exchange_part_test2 -POSTHOOK: query: SHOW PARTITIONS exchange_part_test2 +PREHOOK: Input: ex2@exchange_part_test2 +POSTHOOK: query: SHOW PARTITIONS ex2.exchange_part_test2 POSTHOOK: type: SHOWPARTITIONS -POSTHOOK: Input: default@exchange_part_test2 +POSTHOOK: Input: ex2@exchange_part_test2 ds=2013-04-05 -PREHOOK: query: ALTER TABLE exchange_part_test1 EXCHANGE PARTITION (ds='2013-04-05') WITH TABLE exchange_part_test2 +PREHOOK: query: ALTER TABLE ex1.exchange_part_test1 EXCHANGE PARTITION (ds='2013-04-05') WITH TABLE ex2.exchange_part_test2 PREHOOK: type: null -POSTHOOK: query: ALTER TABLE exchange_part_test1 EXCHANGE PARTITION (ds='2013-04-05') WITH TABLE exchange_part_test2 +POSTHOOK: query: ALTER TABLE ex1.exchange_part_test1 EXCHANGE PARTITION (ds='2013-04-05') WITH TABLE ex2.exchange_part_test2 POSTHOOK: type: null -PREHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: query: SHOW PARTITIONS ex1.exchange_part_test1 PREHOOK: type: SHOWPARTITIONS -PREHOOK: Input: default@exchange_part_test1 -POSTHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: Input: ex1@exchange_part_test1 +POSTHOOK: query: SHOW PARTITIONS ex1.exchange_part_test1 POSTHOOK: type: SHOWPARTITIONS -POSTHOOK: Input: default@exchange_part_test1 +POSTHOOK: Input: ex1@exchange_part_test1 ds=2013-04-05 -PREHOOK: query: SHOW PARTITIONS exchange_part_test2 +PREHOOK: query: SHOW PARTITIONS ex2.exchange_part_test2 PREHOOK: type: SHOWPARTITIONS -PREHOOK: Input: default@exchange_part_test2 -POSTHOOK: query: SHOW PARTITIONS exchange_part_test2 +PREHOOK: Input: ex2@exchange_part_test2 +POSTHOOK: query: SHOW PARTITIONS ex2.exchange_part_test2 POSTHOOK: type: SHOWPARTITIONS -POSTHOOK: Input: default@exchange_part_test2 +POSTHOOK: Input: ex2@exchange_part_test2 Modified: hive/branches/spark/ql/src/test/results/clientpositive/explain_dependency.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/explain_dependency.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/explain_dependency.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/explain_dependency.q.out Sat Aug 30 06:44:46 2014 @@ -4,19 +4,25 @@ PREHOOK: query: -- This test is used for CREATE VIEW V1 AS SELECT key, value from src PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@V1 POSTHOOK: query: -- This test is used for testing EXPLAIN DEPENDENCY command -- Create some views CREATE VIEW V1 AS SELECT key, value from src POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@V1 PREHOOK: query: CREATE VIEW V2 AS SELECT ds, key, value FROM srcpart WHERE ds IS NOT NULL PREHOOK: type: CREATEVIEW PREHOOK: Input: default@srcpart +PREHOOK: Output: database:default +PREHOOK: Output: default@V2 POSTHOOK: query: CREATE VIEW V2 AS SELECT ds, key, value FROM srcpart WHERE ds IS NOT NULL POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@srcpart +POSTHOOK: Output: database:default POSTHOOK: Output: default@V2 PREHOOK: query: CREATE VIEW V3 AS SELECT src1.key, src2.value FROM V2 src1 @@ -25,6 +31,8 @@ PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src PREHOOK: Input: default@srcpart PREHOOK: Input: default@v2 +PREHOOK: Output: database:default +PREHOOK: Output: default@V3 POSTHOOK: query: CREATE VIEW V3 AS SELECT src1.key, src2.value FROM V2 src1 JOIN src src2 ON src1.key = src2.key WHERE src1.ds IS NOT NULL @@ -32,6 +40,7 @@ POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@v2 +POSTHOOK: Output: database:default POSTHOOK: Output: default@V3 PREHOOK: query: CREATE VIEW V4 AS SELECT src1.key, src2.value as value1, src3.value as value2 @@ -41,6 +50,8 @@ PREHOOK: Input: default@src PREHOOK: Input: default@srcpart PREHOOK: Input: default@v1 PREHOOK: Input: default@v2 +PREHOOK: Output: database:default +PREHOOK: Output: default@V4 POSTHOOK: query: CREATE VIEW V4 AS SELECT src1.key, src2.value as value1, src3.value as value2 FROM V1 src1 JOIN V2 src2 on src1.key = src2.key JOIN src src3 ON src2.key = src3.key @@ -49,6 +60,7 @@ POSTHOOK: Input: default@src POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@v1 POSTHOOK: Input: default@v2 +POSTHOOK: Output: database:default POSTHOOK: Output: default@V4 PREHOOK: query: -- Simple select queries, union queries and join queries EXPLAIN DEPENDENCY @@ -111,11 +123,14 @@ PREHOOK: query: -- The table should show CREATE VIEW V5 as SELECT * FROM srcpart where ds = '10' PREHOOK: type: CREATEVIEW PREHOOK: Input: default@srcpart +PREHOOK: Output: database:default +PREHOOK: Output: default@V5 POSTHOOK: query: -- The table should show up in the explain dependency even if none -- of the partitions are selected. CREATE VIEW V5 as SELECT * FROM srcpart where ds = '10' POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@srcpart +POSTHOOK: Output: database:default POSTHOOK: Output: default@V5 PREHOOK: query: EXPLAIN DEPENDENCY SELECT * FROM V5 PREHOOK: type: QUERY Modified: hive/branches/spark/ql/src/test/results/clientpositive/explain_logical.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/explain_logical.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/explain_logical.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/explain_logical.q.out Sat Aug 30 06:44:46 2014 @@ -4,19 +4,25 @@ PREHOOK: query: -- This test is used for CREATE VIEW V1 AS SELECT key, value from src PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@V1 POSTHOOK: query: -- This test is used for testing EXPLAIN LOGICAL command -- Create some views CREATE VIEW V1 AS SELECT key, value from src POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@V1 PREHOOK: query: CREATE VIEW V2 AS SELECT ds, key, value FROM srcpart WHERE ds IS NOT NULL PREHOOK: type: CREATEVIEW PREHOOK: Input: default@srcpart +PREHOOK: Output: database:default +PREHOOK: Output: default@V2 POSTHOOK: query: CREATE VIEW V2 AS SELECT ds, key, value FROM srcpart WHERE ds IS NOT NULL POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@srcpart +POSTHOOK: Output: database:default POSTHOOK: Output: default@V2 PREHOOK: query: CREATE VIEW V3 AS SELECT src1.key, src2.value FROM V2 src1 @@ -25,6 +31,8 @@ PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src PREHOOK: Input: default@srcpart PREHOOK: Input: default@v2 +PREHOOK: Output: database:default +PREHOOK: Output: default@V3 POSTHOOK: query: CREATE VIEW V3 AS SELECT src1.key, src2.value FROM V2 src1 JOIN src src2 ON src1.key = src2.key WHERE src1.ds IS NOT NULL @@ -32,6 +40,7 @@ POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@v2 +POSTHOOK: Output: database:default POSTHOOK: Output: default@V3 PREHOOK: query: CREATE VIEW V4 AS SELECT src1.key, src2.value as value1, src3.value as value2 @@ -41,6 +50,8 @@ PREHOOK: Input: default@src PREHOOK: Input: default@srcpart PREHOOK: Input: default@v1 PREHOOK: Input: default@v2 +PREHOOK: Output: database:default +PREHOOK: Output: default@V4 POSTHOOK: query: CREATE VIEW V4 AS SELECT src1.key, src2.value as value1, src3.value as value2 FROM V1 src1 JOIN V2 src2 on src1.key = src2.key JOIN src src3 ON src2.key = src3.key @@ -49,6 +60,7 @@ POSTHOOK: Input: default@src POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@v1 POSTHOOK: Input: default@v2 +POSTHOOK: Output: database:default POSTHOOK: Output: default@V4 PREHOOK: query: -- Simple select queries, union queries and join queries EXPLAIN LOGICAL @@ -678,11 +690,14 @@ PREHOOK: query: -- The table should show CREATE VIEW V5 as SELECT * FROM srcpart where ds = '10' PREHOOK: type: CREATEVIEW PREHOOK: Input: default@srcpart +PREHOOK: Output: database:default +PREHOOK: Output: default@V5 POSTHOOK: query: -- The table should show up in the explain logical even if none -- of the partitions are selected. CREATE VIEW V5 as SELECT * FROM srcpart where ds = '10' POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@srcpart +POSTHOOK: Output: database:default POSTHOOK: Output: default@V5 PREHOOK: query: EXPLAIN LOGICAL SELECT * FROM V5 PREHOOK: type: QUERY Modified: hive/branches/spark/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out Sat Aug 30 06:44:46 2014 @@ -18,7 +18,7 @@ STAGE PLANS: columns: key int, value string input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.mapred.SequenceFileOutputFormat - name: dest1 + name: default.dest1 PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat' Modified: hive/branches/spark/ql/src/test/results/clientpositive/fileformat_text.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/fileformat_text.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/fileformat_text.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/fileformat_text.q.out Sat Aug 30 06:44:46 2014 @@ -18,7 +18,7 @@ STAGE PLANS: columns: key int, value string input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat - name: dest1 + name: default.dest1 PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' Modified: hive/branches/spark/ql/src/test/results/clientpositive/global_limit.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/global_limit.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/global_limit.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/global_limit.q.out Sat Aug 30 06:44:46 2014 @@ -50,10 +50,13 @@ PREHOOK: query: -- need one file create table gl_tgt as select key from gl_src1 limit 1 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@gl_src1 +PREHOOK: Output: database:default +PREHOOK: Output: default@gl_tgt POSTHOOK: query: -- need one file create table gl_tgt as select key from gl_src1 limit 1 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@gl_src1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@gl_tgt PREHOOK: query: select * from gl_tgt ORDER BY key ASC PREHOOK: type: QUERY Modified: hive/branches/spark/ql/src/test/results/clientpositive/groupby_duplicate_key.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/groupby_duplicate_key.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/groupby_duplicate_key.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/groupby_duplicate_key.q.out Sat Aug 30 06:44:46 2014 @@ -140,7 +140,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: dummy + name: default.dummy Stage: Stage-2 Stats-Aggr Operator @@ -149,10 +149,13 @@ PREHOOK: query: create table dummy as select distinct key, "X" as dummy1, "X" as dummy2 from src tablesample (10 rows) PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@dummy POSTHOOK: query: create table dummy as select distinct key, "X" as dummy1, "X" as dummy2 from src tablesample (10 rows) POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@dummy PREHOOK: query: select key,dummy1,dummy2 from dummy PREHOOK: type: QUERY Modified: hive/branches/spark/ql/src/test/results/clientpositive/index_auto_empty.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/index_auto_empty.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/index_auto_empty.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/index_auto_empty.q.out Sat Aug 30 06:44:46 2014 @@ -1,50 +1,56 @@ PREHOOK: query: -- Test to ensure that an empty index result is propagated correctly --- Create temp, and populate it with some values in src. -CREATE TABLE temp(key STRING, val STRING) STORED AS TEXTFILE -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@temp +CREATE DATABASE it +PREHOOK: type: CREATEDATABASE +PREHOOK: Output: database:it POSTHOOK: query: -- Test to ensure that an empty index result is propagated correctly --- Create temp, and populate it with some values in src. -CREATE TABLE temp(key STRING, val STRING) STORED AS TEXTFILE +CREATE DATABASE it +POSTHOOK: type: CREATEDATABASE +POSTHOOK: Output: database:it +PREHOOK: query: -- Create temp, and populate it with some values in src. +CREATE TABLE it.temp(key STRING, val STRING) STORED AS TEXTFILE +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:it +PREHOOK: Output: it@temp +POSTHOOK: query: -- Create temp, and populate it with some values in src. +CREATE TABLE it.temp(key STRING, val STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@temp -PREHOOK: query: -- Build an index on temp. -CREATE INDEX temp_index ON TABLE temp(key) as 'COMPACT' WITH DEFERRED REBUILD +POSTHOOK: Output: database:it +POSTHOOK: Output: it@temp +PREHOOK: query: -- Build an index on it.temp. +CREATE INDEX temp_index ON TABLE it.temp(key) as 'COMPACT' WITH DEFERRED REBUILD PREHOOK: type: CREATEINDEX -PREHOOK: Input: default@temp -POSTHOOK: query: -- Build an index on temp. -CREATE INDEX temp_index ON TABLE temp(key) as 'COMPACT' WITH DEFERRED REBUILD +PREHOOK: Input: it@temp +POSTHOOK: query: -- Build an index on it.temp. +CREATE INDEX temp_index ON TABLE it.temp(key) as 'COMPACT' WITH DEFERRED REBUILD POSTHOOK: type: CREATEINDEX -POSTHOOK: Input: default@temp -POSTHOOK: Output: default@default__temp_temp_index__ -PREHOOK: query: ALTER INDEX temp_index ON temp REBUILD +POSTHOOK: Input: it@temp +POSTHOOK: Output: it@it__temp_temp_index__ +PREHOOK: query: ALTER INDEX temp_index ON it.temp REBUILD PREHOOK: type: ALTERINDEX_REBUILD -PREHOOK: Input: default@temp -PREHOOK: Output: default@default__temp_temp_index__ -POSTHOOK: query: ALTER INDEX temp_index ON temp REBUILD +PREHOOK: Input: it@temp +PREHOOK: Output: it@it__temp_temp_index__ +POSTHOOK: query: ALTER INDEX temp_index ON it.temp REBUILD POSTHOOK: type: ALTERINDEX_REBUILD -POSTHOOK: Input: default@temp -POSTHOOK: Output: default@default__temp_temp_index__ -POSTHOOK: Lineage: default__temp_temp_index__._bucketname SIMPLE [(temp)temp.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] -POSTHOOK: Lineage: default__temp_temp_index__._offsets EXPRESSION [(temp)temp.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] -POSTHOOK: Lineage: default__temp_temp_index__.key SIMPLE [(temp)temp.FieldSchema(name:key, type:string, comment:null), ] +POSTHOOK: Input: it@temp +POSTHOOK: Output: it@it__temp_temp_index__ +POSTHOOK: Lineage: it__temp_temp_index__._bucketname SIMPLE [(temp)temp.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] +POSTHOOK: Lineage: it__temp_temp_index__._offsets EXPRESSION [(temp)temp.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), ] +POSTHOOK: Lineage: it__temp_temp_index__.key SIMPLE [(temp)temp.FieldSchema(name:key, type:string, comment:null), ] PREHOOK: query: -- query should not return any values -SELECT * FROM default__temp_temp_index__ WHERE key = 86 +SELECT * FROM it.it__temp_temp_index__ WHERE key = 86 PREHOOK: type: QUERY -PREHOOK: Input: default@default__temp_temp_index__ +PREHOOK: Input: it@it__temp_temp_index__ #### A masked pattern was here #### POSTHOOK: query: -- query should not return any values -SELECT * FROM default__temp_temp_index__ WHERE key = 86 +SELECT * FROM it.it__temp_temp_index__ WHERE key = 86 POSTHOOK: type: QUERY -POSTHOOK: Input: default@default__temp_temp_index__ +POSTHOOK: Input: it@it__temp_temp_index__ #### A masked pattern was here #### -PREHOOK: query: EXPLAIN SELECT * FROM temp WHERE key = 86 +PREHOOK: query: EXPLAIN SELECT * FROM it.temp WHERE key = 86 PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN SELECT * FROM temp WHERE key = 86 +POSTHOOK: query: EXPLAIN SELECT * FROM it.temp WHERE key = 86 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage @@ -79,19 +85,27 @@ STAGE PLANS: Processor Tree: ListSink -PREHOOK: query: SELECT * FROM temp WHERE key = 86 +PREHOOK: query: SELECT * FROM it.temp WHERE key = 86 PREHOOK: type: QUERY -PREHOOK: Input: default@temp +PREHOOK: Input: it@temp #### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM temp WHERE key = 86 +POSTHOOK: query: SELECT * FROM it.temp WHERE key = 86 POSTHOOK: type: QUERY -POSTHOOK: Input: default@temp +POSTHOOK: Input: it@temp #### A masked pattern was here #### -PREHOOK: query: DROP table temp +PREHOOK: query: DROP table it.temp PREHOOK: type: DROPTABLE -PREHOOK: Input: default@temp -PREHOOK: Output: default@temp -POSTHOOK: query: DROP table temp +PREHOOK: Input: it@temp +PREHOOK: Output: it@temp +POSTHOOK: query: DROP table it.temp POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@temp -POSTHOOK: Output: default@temp +POSTHOOK: Input: it@temp +POSTHOOK: Output: it@temp +PREHOOK: query: DROP DATABASE it +PREHOOK: type: DROPDATABASE +PREHOOK: Input: database:it +PREHOOK: Output: database:it +POSTHOOK: query: DROP DATABASE it +POSTHOOK: type: DROPDATABASE +POSTHOOK: Input: database:it +POSTHOOK: Output: database:it Modified: hive/branches/spark/ql/src/test/results/clientpositive/input15.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/input15.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/input15.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/input15.q.out Sat Aug 30 06:44:46 2014 @@ -16,7 +16,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: TEST15 + name: default.TEST15 PREHOOK: query: CREATE TABLE TEST15(key INT, value STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE PREHOOK: type: CREATETABLE Modified: hive/branches/spark/ql/src/test/results/clientpositive/input46.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/input46.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/input46.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/input46.q.out Sat Aug 30 06:44:46 2014 @@ -7,34 +7,38 @@ POSTHOOK: Output: database:table_in_data PREHOOK: query: create table table_in_database_creation.test1 as select * from src limit 1 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:table_in_database_creation +PREHOOK: Output: table_in_database_creation@test1 POSTHOOK: query: create table table_in_database_creation.test1 as select * from src limit 1 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:table_in_database_creation POSTHOOK: Output: table_in_database_creation@test1 -PREHOOK: query: create table `table_in_database_creation.test2` as select * from src limit 1 +PREHOOK: query: create table `table_in_database_creation`.`test2` as select * from src limit 1 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src -POSTHOOK: query: create table `table_in_database_creation.test2` as select * from src limit 1 +PREHOOK: Output: database:table_in_database_creation +PREHOOK: Output: table_in_database_creation@test2 +POSTHOOK: query: create table `table_in_database_creation`.`test2` as select * from src limit 1 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:table_in_database_creation POSTHOOK: Output: table_in_database_creation@test2 PREHOOK: query: create table table_in_database_creation.test3 (a string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:table_in_database_creation -PREHOOK: Output: table_in_database_creation@table_in_database_creation.test3 +PREHOOK: Output: table_in_database_creation@test3 POSTHOOK: query: create table table_in_database_creation.test3 (a string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:table_in_database_creation -POSTHOOK: Output: table_in_database_creation@table_in_database_creation.test3 POSTHOOK: Output: table_in_database_creation@test3 -PREHOOK: query: create table `table_in_database_creation.test4` (a string) +PREHOOK: query: create table `table_in_database_creation`.`test4` (a string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:table_in_database_creation -PREHOOK: Output: table_in_database_creation@table_in_database_creation.test4 -POSTHOOK: query: create table `table_in_database_creation.test4` (a string) +PREHOOK: Output: table_in_database_creation@test4 +POSTHOOK: query: create table `table_in_database_creation`.`test4` (a string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:table_in_database_creation -POSTHOOK: Output: table_in_database_creation@table_in_database_creation.test4 POSTHOOK: Output: table_in_database_creation@test4 PREHOOK: query: drop database table_in_database_creation cascade PREHOOK: type: DROPDATABASE Modified: hive/branches/spark/ql/src/test/results/clientpositive/inputddl1.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/inputddl1.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/inputddl1.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/inputddl1.q.out Sat Aug 30 06:44:46 2014 @@ -15,7 +15,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: INPUTDDL1 + name: default.INPUTDDL1 PREHOOK: query: CREATE TABLE INPUTDDL1(key INT, value STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE Modified: hive/branches/spark/ql/src/test/results/clientpositive/inputddl2.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/inputddl2.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/inputddl2.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/inputddl2.q.out Sat Aug 30 06:44:46 2014 @@ -16,7 +16,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat partition columns: ds string, country string serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: INPUTDDL2 + name: default.INPUTDDL2 PREHOOK: query: CREATE TABLE INPUTDDL2(key INT, value STRING) PARTITIONED BY(ds STRING, country STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE Modified: hive/branches/spark/ql/src/test/results/clientpositive/inputddl3.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/inputddl3.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/inputddl3.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/inputddl3.q.out Sat Aug 30 06:44:46 2014 @@ -16,7 +16,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: INPUTDDL3 + name: default.INPUTDDL3 PREHOOK: query: CREATE TABLE INPUTDDL3(key INT, value STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE PREHOOK: type: CREATETABLE Modified: hive/branches/spark/ql/src/test/results/clientpositive/insert1.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/insert1.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/insert1.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/insert1.q.out Sat Aug 30 06:44:46 2014 @@ -217,12 +217,11 @@ POSTHOOK: Output: database:x PREHOOK: query: create table x.insert1(key int, value string) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:x -PREHOOK: Output: [email protected] +PREHOOK: Output: x@insert1 POSTHOOK: query: create table x.insert1(key int, value string) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:x POSTHOOK: Output: x@insert1 -POSTHOOK: Output: [email protected] PREHOOK: query: explain insert into table x.INSERT1 select a.key, a.value from insert2 a WHERE (a.key=-1) PREHOOK: type: QUERY POSTHOOK: query: explain insert into table x.INSERT1 select a.key, a.value from insert2 a WHERE (a.key=-1) @@ -635,11 +634,10 @@ POSTHOOK: Output: database:db1 PREHOOK: query: CREATE TABLE db1.result(col1 STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:db1 -PREHOOK: Output: [email protected] +PREHOOK: Output: db1@result POSTHOOK: query: CREATE TABLE db1.result(col1 STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:db1 -POSTHOOK: Output: [email protected] POSTHOOK: Output: db1@result PREHOOK: query: INSERT OVERWRITE TABLE db1.result SELECT 'db1_insert1' FROM src LIMIT 1 PREHOOK: type: QUERY Modified: hive/branches/spark/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out Sat Aug 30 06:44:46 2014 @@ -13,11 +13,10 @@ POSTHOOK: Output: database:db2 PREHOOK: query: CREATE TABLE db1.sourceTable (one string,two string) PARTITIONED BY (ds string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:db1 -PREHOOK: Output: [email protected] +PREHOOK: Output: db1@sourceTable POSTHOOK: query: CREATE TABLE db1.sourceTable (one string,two string) PARTITIONED BY (ds string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:db1 -POSTHOOK: Output: [email protected] POSTHOOK: Output: db1@sourceTable PREHOOK: query: load data local inpath '../../data/files/kv1.txt' INTO TABLE db1.sourceTable partition(ds='2011-11-11') PREHOOK: type: LOAD @@ -39,11 +38,10 @@ POSTHOOK: Output: db1@sourcetable@ds=201 PREHOOK: query: CREATE TABLE db2.destinTable (one string,two string) PARTITIONED BY (ds string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:db2 -PREHOOK: Output: [email protected] +PREHOOK: Output: db2@destinTable POSTHOOK: query: CREATE TABLE db2.destinTable (one string,two string) PARTITIONED BY (ds string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:db2 -POSTHOOK: Output: [email protected] POSTHOOK: Output: db2@destinTable PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE db2.destinTable PARTITION (ds='2011-11-11') SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one desc, two desc limit 5 Modified: hive/branches/spark/ql/src/test/results/clientpositive/join41.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join41.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/join41.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/join41.q.out Sat Aug 30 06:44:46 2014 @@ -1,9 +1,12 @@ PREHOOK: query: create table s1 as select * from src where key = 0 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@s1 POSTHOOK: query: create table s1 as select * from src where key = 0 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@s1 PREHOOK: query: EXPLAIN SELECT * FROM s1 src1 LEFT OUTER JOIN s1 src2 ON (src1.key = src2.key AND src2.key > 10) Modified: hive/branches/spark/ql/src/test/results/clientpositive/join_filters_overlap.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join_filters_overlap.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== Files hive/branches/spark/ql/src/test/results/clientpositive/join_filters_overlap.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/join_filters_overlap.q.out Sat Aug 30 06:44:46 2014 differ Modified: hive/branches/spark/ql/src/test/results/clientpositive/join_view.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/join_view.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/join_view.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/join_view.q.out Sat Aug 30 06:44:46 2014 @@ -28,12 +28,15 @@ create view v as select invites.bar, inv PREHOOK: type: CREATEVIEW PREHOOK: Input: default@invites PREHOOK: Input: default@invites2 +PREHOOK: Output: database:default +PREHOOK: Output: default@v POSTHOOK: query: -- test join views: see HIVE-1989 create view v as select invites.bar, invites2.foo, invites2.ds from invites join invites2 on invites.ds=invites2.ds POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@invites POSTHOOK: Input: default@invites2 +POSTHOOK: Output: database:default POSTHOOK: Output: default@v PREHOOK: query: explain select * from v where ds='2011-09-01' PREHOOK: type: QUERY Modified: hive/branches/spark/ql/src/test/results/clientpositive/lateral_view_noalias.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/lateral_view_noalias.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/lateral_view_noalias.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/lateral_view_noalias.q.out Sat Aug 30 06:44:46 2014 @@ -130,10 +130,13 @@ PREHOOK: query: -- view create view lv_noalias as SELECT myTab.* from src LATERAL VIEW explode(map('key1', 100, 'key2', 200)) myTab limit 2 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@lv_noalias POSTHOOK: query: -- view create view lv_noalias as SELECT myTab.* from src LATERAL VIEW explode(map('key1', 100, 'key2', 200)) myTab limit 2 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@lv_noalias PREHOOK: query: explain select * from lv_noalias a join lv_noalias b on a.key=b.key PREHOOK: type: QUERY Modified: hive/branches/spark/ql/src/test/results/clientpositive/lateral_view_outer.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/lateral_view_outer.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/lateral_view_outer.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/lateral_view_outer.q.out Sat Aug 30 06:44:46 2014 @@ -185,9 +185,12 @@ POSTHOOK: Input: default@src PREHOOK: query: create table array_valued as select key, if (key > 300, array(value, value), null) as value from src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@array_valued POSTHOOK: query: create table array_valued as select key, if (key > 300, array(value, value), null) as value from src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@array_valued PREHOOK: query: explain select * from array_valued LATERAL VIEW OUTER explode(value) C AS a limit 10 Modified: hive/branches/spark/ql/src/test/results/clientpositive/merge3.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/merge3.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== Files hive/branches/spark/ql/src/test/results/clientpositive/merge3.q.out (original) and hive/branches/spark/ql/src/test/results/clientpositive/merge3.q.out Sat Aug 30 06:44:46 2014 differ Modified: hive/branches/spark/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out Sat Aug 30 06:44:46 2014 @@ -3,11 +3,14 @@ PREHOOK: query: -- SORT_QUERY_RESULTS create table src_10 as select * from src limit 10 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@src_10 POSTHOOK: query: -- SORT_QUERY_RESULTS create table src_10 as select * from src limit 10 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@src_10 PREHOOK: query: create table src_lv1 (key string, value string) PREHOOK: type: CREATETABLE Modified: hive/branches/spark/ql/src/test/results/clientpositive/multi_join_union.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/multi_join_union.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/multi_join_union.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/multi_join_union.q.out Sat Aug 30 06:44:46 2014 @@ -1,30 +1,42 @@ PREHOOK: query: CREATE TABLE src11 as SELECT * FROM src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@src11 POSTHOOK: query: CREATE TABLE src11 as SELECT * FROM src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@src11 PREHOOK: query: CREATE TABLE src12 as SELECT * FROM src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@src12 POSTHOOK: query: CREATE TABLE src12 as SELECT * FROM src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@src12 PREHOOK: query: CREATE TABLE src13 as SELECT * FROM src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@src13 POSTHOOK: query: CREATE TABLE src13 as SELECT * FROM src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@src13 PREHOOK: query: CREATE TABLE src14 as SELECT * FROM src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@src14 POSTHOOK: query: CREATE TABLE src14 as SELECT * FROM src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@src14 PREHOOK: query: EXPLAIN SELECT * FROM src11 a JOIN Modified: hive/branches/spark/ql/src/test/results/clientpositive/nestedvirtual.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/nestedvirtual.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/nestedvirtual.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/nestedvirtual.q.out Sat Aug 30 06:44:46 2014 @@ -18,10 +18,13 @@ PREHOOK: query: create table jssarma_nil PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@pokes PREHOOK: Input: default@pokes2 +PREHOOK: Output: database:default +PREHOOK: Output: default@jssarma_nilzma_bad POSTHOOK: query: create table jssarma_nilzma_bad as select a.val, a.filename, a.offset from (select hash(foo) as val, INPUT__FILE__NAME as filename, BLOCK__OFFSET__INSIDE__FILE as offset from pokes) a join pokes2 b on (a.val = b.foo) POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@pokes POSTHOOK: Input: default@pokes2 +POSTHOOK: Output: database:default POSTHOOK: Output: default@jssarma_nilzma_bad PREHOOK: query: drop table jssarma_nilzma_bad PREHOOK: type: DROPTABLE @@ -67,10 +70,13 @@ PREHOOK: query: create table jssarma_nil PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@pokes PREHOOK: Input: default@pokes2 +PREHOOK: Output: database:default +PREHOOK: Output: default@jssarma_nilzma_bad POSTHOOK: query: create table jssarma_nilzma_bad as select a.val, a.filename, a.offset from (select hash(foo) as val, INPUT__FILE__NAME as filename, BLOCK__OFFSET__INSIDE__FILE as offset from pokes) a join pokes2 b on (a.val = b.foo) POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@pokes POSTHOOK: Input: default@pokes2 +POSTHOOK: Output: database:default POSTHOOK: Output: default@jssarma_nilzma_bad PREHOOK: query: drop table jssarma_nilzma_bad PREHOOK: type: DROPTABLE @@ -116,10 +122,13 @@ PREHOOK: query: create table jssarma_nil PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@pokes PREHOOK: Input: default@pokes2 +PREHOOK: Output: database:default +PREHOOK: Output: default@jssarma_nilzma_bad POSTHOOK: query: create table jssarma_nilzma_bad as select a.val, a.filename, a.offset from (select hash(foo) as val, INPUT__FILE__NAME as filename, BLOCK__OFFSET__INSIDE__FILE as offset from pokes) a join pokes2 b on (a.val = b.foo) POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@pokes POSTHOOK: Input: default@pokes2 +POSTHOOK: Output: database:default POSTHOOK: Output: default@jssarma_nilzma_bad PREHOOK: query: drop table jssarma_nilzma_bad PREHOOK: type: DROPTABLE Modified: hive/branches/spark/ql/src/test/results/clientpositive/nonmr_fetch.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/nonmr_fetch.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/nonmr_fetch.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/nonmr_fetch.q.out Sat Aug 30 06:44:46 2014 @@ -1015,7 +1015,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: srcx + name: default.srcx Stage: Stage-2 Stats-Aggr Operator Modified: hive/branches/spark/ql/src/test/results/clientpositive/nullformat.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/nullformat.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/nullformat.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/nullformat.q.out Sat Aug 30 06:44:46 2014 @@ -53,7 +53,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: null_tab1 + name: default.null_tab1 PREHOOK: query: CREATE TABLE null_tab1(a STRING, b STRING) ROW FORMAT DELIMITED NULL DEFINED AS 'fooNull' PREHOOK: type: CREATETABLE Modified: hive/branches/spark/ql/src/test/results/clientpositive/nullformatCTAS.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/nullformatCTAS.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/nullformatCTAS.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/nullformatCTAS.q.out Sat Aug 30 06:44:46 2014 @@ -97,7 +97,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: null_tab3 + name: default.null_tab3 Stage: Stage-2 Stats-Aggr Operator @@ -136,10 +136,13 @@ PREHOOK: query: CREATE TABLE null_tab3 R AS SELECT a, b FROM base_tab PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@base_tab +PREHOOK: Output: database:default +PREHOOK: Output: default@null_tab3 POSTHOOK: query: CREATE TABLE null_tab3 ROW FORMAT DELIMITED NULL DEFINED AS 'fooNull' AS SELECT a, b FROM base_tab POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@base_tab +POSTHOOK: Output: database:default POSTHOOK: Output: default@null_tab3 PREHOOK: query: DESCRIBE EXTENDED null_tab3 PREHOOK: type: DESCTABLE Modified: hive/branches/spark/ql/src/test/results/clientpositive/orc_analyze.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/orc_analyze.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/orc_analyze.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/orc_analyze.q.out Sat Aug 30 06:44:46 2014 @@ -105,7 +105,7 @@ Table Parameters: numFiles 1 numRows 100 rawDataSize 52600 - totalSize 3042 + totalSize 3098 #### A masked pattern was here #### # Storage Information @@ -195,7 +195,7 @@ Table Parameters: numFiles 1 numRows 100 rawDataSize 52600 - totalSize 3042 + totalSize 3098 #### A masked pattern was here #### # Storage Information @@ -309,7 +309,7 @@ Partition Parameters: numFiles 1 numRows 50 rawDataSize 21950 - totalSize 1962 + totalSize 2016 #### A masked pattern was here #### # Storage Information @@ -354,7 +354,7 @@ Partition Parameters: numFiles 1 numRows 50 rawDataSize 22050 - totalSize 1981 + totalSize 2036 #### A masked pattern was here #### # Storage Information @@ -456,7 +456,7 @@ Partition Parameters: numFiles 1 numRows 50 rawDataSize 21950 - totalSize 1962 + totalSize 2016 #### A masked pattern was here #### # Storage Information @@ -501,7 +501,7 @@ Partition Parameters: numFiles 1 numRows 50 rawDataSize 22050 - totalSize 1981 + totalSize 2036 #### A masked pattern was here #### # Storage Information @@ -621,7 +621,7 @@ Partition Parameters: numFiles 4 numRows 50 rawDataSize 21980 - totalSize 4746 + totalSize 4955 #### A masked pattern was here #### # Storage Information @@ -666,7 +666,7 @@ Partition Parameters: numFiles 4 numRows 50 rawDataSize 22048 - totalSize 4829 + totalSize 5046 #### A masked pattern was here #### # Storage Information @@ -774,7 +774,7 @@ Partition Parameters: numFiles 4 numRows 50 rawDataSize 21980 - totalSize 4746 + totalSize 4955 #### A masked pattern was here #### # Storage Information @@ -819,7 +819,7 @@ Partition Parameters: numFiles 4 numRows 50 rawDataSize 22048 - totalSize 4829 + totalSize 5046 #### A masked pattern was here #### # Storage Information @@ -984,7 +984,7 @@ Partition Parameters: numFiles 1 numRows 50 rawDataSize 21950 - totalSize 1962 + totalSize 2016 #### A masked pattern was here #### # Storage Information Modified: hive/branches/spark/ql/src/test/results/clientpositive/orc_createas1.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/orc_createas1.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/orc_createas1.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/orc_createas1.q.out Sat Aug 30 06:44:46 2014 @@ -105,7 +105,7 @@ STAGE PLANS: input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat serde name: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: orc_createas1b + name: default.orc_createas1b Stage: Stage-2 Stats-Aggr Operator @@ -131,11 +131,14 @@ PREHOOK: query: CREATE TABLE orc_createa SELECT * FROM src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@orc_createas1b POSTHOOK: query: CREATE TABLE orc_createas1b STORED AS ORC AS SELECT * FROM src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@orc_createas1b PREHOOK: query: EXPLAIN SELECT * FROM orc_createas1b ORDER BY key LIMIT 5 PREHOOK: type: QUERY @@ -261,7 +264,7 @@ STAGE PLANS: input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat serde name: org.apache.hadoop.hive.ql.io.orc.OrcSerde - name: orc_createas1c + name: default.orc_createas1c Stage: Stage-2 Stats-Aggr Operator @@ -290,6 +293,8 @@ PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@orc_createas1a PREHOOK: Input: default@orc_createas1a@ds=1 PREHOOK: Input: default@orc_createas1a@ds=2 +PREHOOK: Output: database:default +PREHOOK: Output: default@orc_createas1c POSTHOOK: query: CREATE TABLE orc_createas1c STORED AS ORC AS SELECT key, value, PMOD(HASH(key), 50) as part @@ -298,6 +303,7 @@ POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@orc_createas1a POSTHOOK: Input: default@orc_createas1a@ds=1 POSTHOOK: Input: default@orc_createas1a@ds=2 +POSTHOOK: Output: database:default POSTHOOK: Output: default@orc_createas1c PREHOOK: query: SELECT SUM(HASH(c)) FROM ( SELECT TRANSFORM(key, value) USING 'tr \t _' AS (c) Copied: hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out (from r1620669, hive/trunk/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out) URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out?p2=hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out&p1=hive/trunk/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out&r1=1620669&r2=1621416&rev=1621416&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat1.q.out Sat Aug 30 06:44:46 2014 @@ -172,7 +172,7 @@ Table Parameters: numFiles 5 numRows 15 rawDataSize 3825 - totalSize 2739 + totalSize 2862 #### A masked pattern was here #### # Storage Information @@ -250,7 +250,7 @@ Table Parameters: numFiles 3 numRows 15 rawDataSize 3825 - totalSize 2235 + totalSize 2325 #### A masked pattern was here #### # Storage Information Copied: hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat2.q.out (from r1620669, hive/trunk/ql/src/test/results/clientpositive/orc_merge_incompat2.q.out) URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat2.q.out?p2=hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat2.q.out&p1=hive/trunk/ql/src/test/results/clientpositive/orc_merge_incompat2.q.out&r1=1620669&r2=1621416&rev=1621416&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/orc_merge_incompat2.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/orc_merge_incompat2.q.out Sat Aug 30 06:44:46 2014 @@ -245,7 +245,7 @@ Partition Parameters: numFiles 4 numRows 4 rawDataSize 1020 - totalSize 1992 + totalSize 2092 #### A masked pattern was here #### # Storage Information @@ -289,7 +289,7 @@ Partition Parameters: numFiles 4 numRows 8 rawDataSize 2040 - totalSize 2104 + totalSize 2204 #### A masked pattern was here #### # Storage Information @@ -430,7 +430,7 @@ Partition Parameters: numFiles 3 numRows 4 rawDataSize 1020 - totalSize 1767 + totalSize 1851 #### A masked pattern was here #### # Storage Information @@ -474,7 +474,7 @@ Partition Parameters: numFiles 3 numRows 8 rawDataSize 2040 - totalSize 1860 + totalSize 1944 #### A masked pattern was here #### # Storage Information Modified: hive/branches/spark/ql/src/test/results/clientpositive/parallel_orderby.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/parallel_orderby.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/parallel_orderby.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/parallel_orderby.q.out Sat Aug 30 06:44:46 2014 @@ -76,7 +76,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: total_ordered + name: default.total_ordered Stage: Stage-2 Stats-Aggr Operator @@ -84,9 +84,12 @@ STAGE PLANS: PREHOOK: query: create table total_ordered as select * from src5 order by key, value PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src5 +PREHOOK: Output: database:default +PREHOOK: Output: default@total_ordered POSTHOOK: query: create table total_ordered as select * from src5 order by key, value POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src5 +POSTHOOK: Output: database:default POSTHOOK: Output: default@total_ordered PREHOOK: query: desc formatted total_ordered PREHOOK: type: DESCTABLE @@ -195,9 +198,12 @@ POSTHOOK: Output: default@total_ordered PREHOOK: query: create table total_ordered as select * from src5 order by key, value PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src5 +PREHOOK: Output: database:default +PREHOOK: Output: default@total_ordered POSTHOOK: query: create table total_ordered as select * from src5 order by key, value POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src5 +POSTHOOK: Output: database:default POSTHOOK: Output: default@total_ordered PREHOOK: query: desc formatted total_ordered PREHOOK: type: DESCTABLE
