You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2014/09/02 21:57:07 UTC
svn commit: r1622108 [22/27] - in /hive/branches/tez: ./
accumulo-handler/src/java/org/apache/hadoop/hive/accumulo/predicate/
beeline/src/java/org/apache/hive/beeline/
beeline/src/test/org/apache/hive/beeline/ bin/ bin/ext/ checkstyle/
common/src/java/...
Modified: hive/branches/tez/ql/src/test/results/clientpositive/ctas.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/ctas.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/ctas.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/ctas.q.out Tue Sep 2 19:56:56 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: nzhang_CTAS1
+ name: default.nzhang_CTAS1
Stage: Stage-3
Stats-Aggr Operator
@@ -105,9 +105,12 @@ STAGE PLANS:
PREHOOK: query: create table nzhang_CTAS1 as select key k, value from src sort by k, value limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@nzhang_CTAS1
POSTHOOK: query: create table nzhang_CTAS1 as select key k, value from src sort by k, value limit 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@nzhang_CTAS1
PREHOOK: query: select * from nzhang_CTAS1
PREHOOK: type: QUERY
@@ -242,7 +245,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: nzhang_ctas2
+ name: default.nzhang_ctas2
Stage: Stage-3
Stats-Aggr Operator
@@ -250,9 +253,12 @@ STAGE PLANS:
PREHOOK: query: create table nzhang_ctas2 as select * from src sort by key, value limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@nzhang_ctas2
POSTHOOK: query: create table nzhang_ctas2 as select * from src sort by key, value limit 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@nzhang_ctas2
PREHOOK: query: select * from nzhang_ctas2
PREHOOK: type: QUERY
@@ -387,7 +393,7 @@ STAGE PLANS:
input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
serde name: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- name: nzhang_ctas3
+ name: default.nzhang_ctas3
Stage: Stage-3
Stats-Aggr Operator
@@ -395,9 +401,12 @@ STAGE PLANS:
PREHOOK: query: create table nzhang_ctas3 row format serde "org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe" stored as RCFile as select key/2 half_key, concat(value, "_con") conb from src sort by half_key, conb limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@nzhang_ctas3
POSTHOOK: query: create table nzhang_ctas3 row format serde "org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe" stored as RCFile as select key/2 half_key, concat(value, "_con") conb from src sort by half_key, conb limit 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@nzhang_ctas3
PREHOOK: query: select * from nzhang_ctas3
PREHOOK: type: QUERY
@@ -598,7 +607,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: nzhang_ctas4
+ name: default.nzhang_ctas4
Stage: Stage-3
Stats-Aggr Operator
@@ -606,9 +615,12 @@ STAGE PLANS:
PREHOOK: query: create table nzhang_ctas4 row format delimited fields terminated by ',' stored as textfile as select key, value from src sort by key, value limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@nzhang_ctas4
POSTHOOK: query: create table nzhang_ctas4 row format delimited fields terminated by ',' stored as textfile as select key, value from src sort by key, value limit 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@nzhang_ctas4
PREHOOK: query: select * from nzhang_ctas4
PREHOOK: type: QUERY
@@ -897,7 +909,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: nzhang_ctas5
+ name: default.nzhang_ctas5
Stage: Stage-3
Stats-Aggr Operator
@@ -906,9 +918,12 @@ STAGE PLANS:
PREHOOK: query: create table nzhang_ctas5 row format delimited fields terminated by ',' lines terminated by '\012' stored as textfile as select key, value from src sort by key, value limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@nzhang_ctas5
POSTHOOK: query: create table nzhang_ctas5 row format delimited fields terminated by ',' lines terminated by '\012' stored as textfile as select key, value from src sort by key, value limit 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@nzhang_ctas5
PREHOOK: query: create table nzhang_ctas6 (key string, `to` string)
PREHOOK: type: CREATETABLE
@@ -931,7 +946,10 @@ POSTHOOK: Lineage: nzhang_ctas6.to SIMPL
PREHOOK: query: create table nzhang_ctas7 as select key, `to` from nzhang_ctas6
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@nzhang_ctas6
+PREHOOK: Output: database:default
+PREHOOK: Output: default@nzhang_ctas7
POSTHOOK: query: create table nzhang_ctas7 as select key, `to` from nzhang_ctas6
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@nzhang_ctas6
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@nzhang_ctas7
Modified: hive/branches/tez/ql/src/test/results/clientpositive/ctas_char.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/ctas_char.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/ctas_char.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/ctas_char.q.out Tue Sep 2 19:56:56 2014
@@ -34,19 +34,25 @@ PREHOOK: query: -- create table as with
create table ctas_char_2 as select key, value from ctas_char_1
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@ctas_char_1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@ctas_char_2
POSTHOOK: query: -- create table as with char column
create table ctas_char_2 as select key, value from ctas_char_1
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@ctas_char_1
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@ctas_char_2
PREHOOK: query: -- view with char column
create view ctas_char_3 as select key, value from ctas_char_2
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@ctas_char_2
+PREHOOK: Output: database:default
+PREHOOK: Output: default@ctas_char_3
POSTHOOK: query: -- view with char column
create view ctas_char_3 as select key, value from ctas_char_2
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@ctas_char_2
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@ctas_char_3
PREHOOK: query: select key, value from ctas_char_1
PREHOOK: type: QUERY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/ctas_colname.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/ctas_colname.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/ctas_colname.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/ctas_colname.q.out Tue Sep 2 19:56:56 2014
@@ -72,7 +72,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: summary
+ name: default.summary
Stage: Stage-2
Stats-Aggr Operator
@@ -80,9 +80,12 @@ STAGE PLANS:
PREHOOK: query: create table summary as select *, sum(key), count(value) from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@summary
POSTHOOK: query: create table summary as select *, sum(key), count(value) from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@summary
PREHOOK: query: describe formatted summary
PREHOOK: type: DESCTABLE
@@ -189,7 +192,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: x4
+ name: default.x4
Stage: Stage-2
Stats-Aggr Operator
@@ -197,9 +200,12 @@ STAGE PLANS:
PREHOOK: query: create table x4 as select *, rank() over(partition by key order by value) as rr from src1
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@x4
POSTHOOK: query: create table x4 as select *, rank() over(partition by key order by value) as rr from src1
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src1
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@x4
PREHOOK: query: describe formatted x4
PREHOOK: type: DESCTABLE
@@ -354,7 +360,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: x5
+ name: default.x5
Stage: Stage-3
Stats-Aggr Operator
@@ -362,9 +368,12 @@ STAGE PLANS:
PREHOOK: query: create table x5 as select *, lead(key,1) over(partition by key order by value) as lead1 from src limit 20
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@x5
POSTHOOK: query: create table x5 as select *, lead(key,1) over(partition by key order by value) as lead1 from src limit 20
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@x5
PREHOOK: query: describe formatted x5
PREHOOK: type: DESCTABLE
@@ -497,7 +506,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: x6
+ name: default.x6
Stage: Stage-2
Stats-Aggr Operator
@@ -505,9 +514,12 @@ STAGE PLANS:
PREHOOK: query: create table x6 as select * from (select *, max(key) from src1) a
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@x6
POSTHOOK: query: create table x6 as select * from (select *, max(key) from src1) a
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src1
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@x6
PREHOOK: query: describe formatted x6
PREHOOK: type: DESCTABLE
@@ -619,7 +631,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: x7
+ name: default.x7
Stage: Stage-2
Stats-Aggr Operator
@@ -627,9 +639,12 @@ STAGE PLANS:
PREHOOK: query: create table x7 as select * from (select * from src group by key) a
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@x7
POSTHOOK: query: create table x7 as select * from (select * from src group by key) a
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@x7
PREHOOK: query: describe formatted x7
PREHOOK: type: DESCTABLE
@@ -1051,7 +1066,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: x8
+ name: default.x8
Stage: Stage-2
Stats-Aggr Operator
@@ -1059,9 +1074,12 @@ STAGE PLANS:
PREHOOK: query: create table x8 as select * from (select * from src group by key having key < 9) a
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@x8
POSTHOOK: query: create table x8 as select * from (select * from src group by key having key < 9) a
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@x8
PREHOOK: query: describe formatted x8
PREHOOK: type: DESCTABLE
@@ -1185,7 +1203,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: x9
+ name: default.x9
Stage: Stage-2
Stats-Aggr Operator
@@ -1193,9 +1211,12 @@ STAGE PLANS:
PREHOOK: query: create table x9 as select * from (select max(value),key from src group by key having key < 9 AND max(value) IS NOT NULL) a
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@x9
POSTHOOK: query: create table x9 as select * from (select max(value),key from src group by key having key < 9 AND max(value) IS NOT NULL) a
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@x9
PREHOOK: query: describe formatted x9
PREHOOK: type: DESCTABLE
Modified: hive/branches/tez/ql/src/test/results/clientpositive/ctas_date.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/ctas_date.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/ctas_date.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/ctas_date.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/ctas_uses_database_location.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/ctas_varchar.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/ctas_varchar.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/ctas_varchar.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/ctas_varchar.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/cte_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/cte_2.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/cte_2.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/cte_2.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/database.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/database.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/database.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/database.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/database_drop.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/database_drop.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/database_drop.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/database_drop.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/dbtxnmgr_ddl1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/dbtxnmgr_ddl1.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/dbtxnmgr_ddl1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/dbtxnmgr_ddl1.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/dbtxnmgr_query5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/dbtxnmgr_query5.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/dbtxnmgr_query5.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/dbtxnmgr_query5.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/decimal_6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/decimal_6.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/decimal_6.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/decimal_6.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/decimal_serde.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/decimal_serde.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/decimal_serde.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/decimal_serde.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/describe_formatted_view_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/describe_formatted_view_partitioned.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/describe_formatted_view_partitioned.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/describe_formatted_view_partitioned.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/describe_formatted_view_partitioned_json.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/describe_formatted_view_partitioned_json.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/describe_formatted_view_partitioned_json.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/describe_formatted_view_partitioned_json.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/describe_syntax.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/describe_syntax.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/describe_syntax.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/describe_syntax.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/drop_multi_partitions.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/drop_multi_partitions.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/drop_multi_partitions.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/drop_multi_partitions.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/exchange_partition.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/exchange_partition.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/exchange_partition.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/exchange_partition.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/explain_dependency.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/explain_dependency.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/explain_dependency.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/explain_dependency.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/explain_logical.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/explain_logical.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/explain_logical.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/explain_logical.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/fileformat_text.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/fileformat_text.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/fileformat_text.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/fileformat_text.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/global_limit.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/global_limit.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/global_limit.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/global_limit.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/groupby_duplicate_key.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/groupby_duplicate_key.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/groupby_duplicate_key.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/groupby_duplicate_key.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/index_auto_empty.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/index_auto_empty.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/index_auto_empty.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/index_auto_empty.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/input15.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/input15.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/input15.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/input15.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/input46.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/input46.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/input46.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/input46.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/inputddl1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/inputddl1.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/inputddl1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/inputddl1.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/inputddl2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/inputddl2.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/inputddl2.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/inputddl2.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/inputddl3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/inputddl3.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/inputddl3.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/inputddl3.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/insert1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/insert1.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/insert1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/insert1.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/join41.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/join41.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/join41.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/join41.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/join_filters_overlap.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/join_filters_overlap.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
Files hive/branches/tez/ql/src/test/results/clientpositive/join_filters_overlap.q.out (original) and hive/branches/tez/ql/src/test/results/clientpositive/join_filters_overlap.q.out Tue Sep 2 19:56:56 2014 differ
Modified: hive/branches/tez/ql/src/test/results/clientpositive/join_view.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/join_view.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/join_view.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/join_view.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/lateral_view_noalias.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/lateral_view_noalias.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/lateral_view_noalias.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/lateral_view_noalias.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/lateral_view_outer.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/lateral_view_outer.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/lateral_view_outer.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/lateral_view_outer.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/merge3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/merge3.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
Files hive/branches/tez/ql/src/test/results/clientpositive/merge3.q.out (original) and hive/branches/tez/ql/src/test/results/clientpositive/merge3.q.out Tue Sep 2 19:56:56 2014 differ
Modified: hive/branches/tez/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/multi_join_union.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/multi_join_union.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/multi_join_union.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/multi_join_union.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/nestedvirtual.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/nestedvirtual.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/nestedvirtual.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/nestedvirtual.q.out Tue Sep 2 19:56:56 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/tez/ql/src/test/results/clientpositive/nonmr_fetch.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/nonmr_fetch.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/nonmr_fetch.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/nonmr_fetch.q.out Tue Sep 2 19:56:56 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