You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by br...@apache.org on 2014/08/30 08:44:53 UTC
svn commit: r1621416 [8/11] - in /hive/branches/spark: ./
common/src/java/org/apache/hadoop/hive/common/
common/src/java/org/apache/hadoop/hive/conf/
contrib/src/test/results/clientnegative/
contrib/src/test/results/clientpositive/ hbase-handler/src/te...
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: db1@db1.src
+PREHOOK: Output: db1@src
POSTHOOK: query: -- CREATE foreign table
CREATE TABLE db1.src(key STRING, value STRING)
STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:db1
-POSTHOOK: Output: db1@db1.src
POSTHOOK: Output: db1@src
PREHOOK: query: -- LOAD into foreign table
LOAD DATA LOCAL INPATH '../../data/files/kv1.txt'
@@ -1121,14 +1120,13 @@ PARTITIONED BY (ds STRING, hr STRING)
STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:db1
-PREHOOK: Output: db1@db1.srcpart
+PREHOOK: Output: db1@srcpart
POSTHOOK: query: -- CREATE Partitioned foreign table
CREATE TABLE db1.srcpart(key STRING, value STRING)
PARTITIONED BY (ds STRING, hr STRING)
STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:db1
-POSTHOOK: Output: db1@db1.srcpart
POSTHOOK: Output: db1@srcpart
PREHOOK: query: -- LOAD data into Partitioned foreign table
LOAD DATA LOCAL INPATH '../../data/files/kv1.txt'
@@ -1305,22 +1303,28 @@ CREATE TABLE conflict_name AS
SELECT value FROM default.src WHERE key = 66
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:db2
+PREHOOK: Output: db2@conflict_name
POSTHOOK: query: -- CREATE TABLE AS SELECT from foreign table
CREATE TABLE conflict_name AS
SELECT value FROM default.src WHERE key = 66
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:db2
POSTHOOK: Output: db2@conflict_name
PREHOOK: query: -- CREATE foreign table
CREATE TABLE db1.conflict_name AS
SELECT value FROM db1.src WHERE key = 8
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: db1@src
+PREHOOK: Output: database:db1
+PREHOOK: Output: db1@conflict_name
POSTHOOK: query: -- CREATE foreign table
CREATE TABLE db1.conflict_name AS
SELECT value FROM db1.src WHERE key = 8
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: db1@src
+POSTHOOK: Output: database:db1
POSTHOOK: Output: db1@conflict_name
PREHOOK: query: -- query tables with the same names in different DBs
SELECT * FROM (
@@ -1407,12 +1411,11 @@ PREHOOK: query: -- CREATE TABLE LIKE
CREATE TABLE db2.src1 LIKE default.src
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:db2
-PREHOOK: Output: db2@db2.src1
+PREHOOK: Output: db2@src1
POSTHOOK: query: -- CREATE TABLE LIKE
CREATE TABLE db2.src1 LIKE default.src
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:db2
-POSTHOOK: Output: db2@db2.src1
POSTHOOK: Output: db2@src1
PREHOOK: query: USE db2
PREHOOK: type: SWITCHDATABASE
Modified: hive/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: db1@db1.t1
+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: db1@db1.t1
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: x@x.insert1
+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: x@x.insert1
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: db1@db1.result
+PREHOOK: Output: db1@result
POSTHOOK: query: CREATE TABLE db1.result(col1 STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:db1
-POSTHOOK: Output: db1@db1.result
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: db1@db1.sourceTable
+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: db1@db1.sourceTable
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: db2@db2.destinTable
+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: db2@db2.destinTable
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