You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by th...@apache.org on 2014/08/27 19:36:26 UTC
svn commit: r1620949 [4/4] - in /hive/trunk:
contrib/src/test/results/clientnegative/
contrib/src/test/results/clientpositive/
hbase-handler/src/test/results/negative/
itests/hive-unit/src/test/java/org/apache/hadoop/hive/ql/security/authorization/plug...
Modified: hive/trunk/ql/src/test/results/clientpositive/temp_table_gb1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/temp_table_gb1.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/temp_table_gb1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/temp_table_gb1.q.out Wed Aug 27 17:36:23 2014
@@ -11,9 +11,12 @@ POSTHOOK: Output: default@dest_g2
PREHOOK: query: CREATE TEMPORARY TABLE src_temp AS SELECT * FROM src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@src_temp
POSTHOOK: query: CREATE TEMPORARY TABLE src_temp AS SELECT * FROM src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_temp
PREHOOK: query: FROM src_temp
INSERT OVERWRITE TABLE dest_g2 SELECT substr(src_temp.key,1,1), count(DISTINCT substr(src_temp.value,5)), concat(substr(src_temp.key,1,1),sum(substr(src_temp.value,5))) GROUP BY substr(src_temp.key,1,1)
Modified: hive/trunk/ql/src/test/results/clientpositive/temp_table_join1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/temp_table_join1.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/temp_table_join1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/temp_table_join1.q.out Wed Aug 27 17:36:23 2014
@@ -1,16 +1,22 @@
PREHOOK: query: CREATE TABLE src_nontemp AS SELECT * FROM src limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@src_nontemp
POSTHOOK: query: CREATE TABLE src_nontemp AS SELECT * FROM src limit 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_nontemp
PREHOOK: query: CREATE TEMPORARY TABLE src_temp AS SELECT * FROM src limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@src_temp
POSTHOOK: query: CREATE TEMPORARY TABLE src_temp AS SELECT * FROM src limit 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_temp
PREHOOK: query: -- Non temp table join
EXPLAIN
Modified: hive/trunk/ql/src/test/results/clientpositive/temp_table_names.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/temp_table_names.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/temp_table_names.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/temp_table_names.q.out Wed Aug 27 17:36:23 2014
@@ -1,12 +1,11 @@
PREHOOK: query: -- Test temp tables with upper/lower case names
create temporary table Default.Temp_Table_Names (C1 string, c2 string)
PREHOOK: type: CREATETABLE
-PREHOOK: Output: Default@Default.Temp_Table_Names
+PREHOOK: Output: Default@Temp_Table_Names
PREHOOK: Output: database:default
POSTHOOK: query: -- Test temp tables with upper/lower case names
create temporary table Default.Temp_Table_Names (C1 string, c2 string)
POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: Default@Default.Temp_Table_Names
POSTHOOK: Output: Default@Temp_Table_Names
POSTHOOK: Output: database:default
PREHOOK: query: show tables 'Temp_Table*'
Modified: hive/trunk/ql/src/test/results/clientpositive/temp_table_precedence.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/temp_table_precedence.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/temp_table_precedence.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/temp_table_precedence.q.out Wed Aug 27 17:36:23 2014
@@ -8,13 +8,12 @@ PREHOOK: query: -- Create non-temp table
create table ttp.tab1 (a1 string, a2 string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:ttp
-PREHOOK: Output: ttp@ttp.tab1
+PREHOOK: Output: ttp@tab1
POSTHOOK: query: -- Create non-temp tables
create table ttp.tab1 (a1 string, a2 string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:ttp
POSTHOOK: Output: ttp@tab1
-POSTHOOK: Output: ttp@ttp.tab1
PREHOOK: query: insert overwrite table ttp.tab1 select * from src where key = 5 limit 5
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -47,12 +46,11 @@ POSTHOOK: Input: ttp@tab1
PREHOOK: query: create table ttp.tab2 (b1 string, b2 string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:ttp
-PREHOOK: Output: ttp@ttp.tab2
+PREHOOK: Output: ttp@tab2
POSTHOOK: query: create table ttp.tab2 (b1 string, b2 string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:ttp
POSTHOOK: Output: ttp@tab2
-POSTHOOK: Output: ttp@ttp.tab2
PREHOOK: query: insert overwrite table ttp.tab2 select * from src where key = 2 limit 5
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -84,13 +82,12 @@ PREHOOK: query: -- Now create temp table
create temporary table ttp.tab1 (c1 int, c2 string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:ttp
-PREHOOK: Output: ttp@ttp.tab1
+PREHOOK: Output: ttp@tab1
POSTHOOK: query: -- Now create temp table with same name
create temporary table ttp.tab1 (c1 int, c2 string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:ttp
POSTHOOK: Output: ttp@tab1
-POSTHOOK: Output: ttp@ttp.tab1
PREHOOK: query: insert overwrite table ttp.tab1 select * from src where key = 0 limit 5
PREHOOK: type: QUERY
PREHOOK: Input: default@src
Modified: hive/trunk/ql/src/test/results/clientpositive/temp_table_subquery1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/temp_table_subquery1.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/temp_table_subquery1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/temp_table_subquery1.q.out Wed Aug 27 17:36:23 2014
@@ -1,9 +1,12 @@
PREHOOK: query: create temporary table src_temp as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@src_temp
POSTHOOK: query: create temporary table src_temp as select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_temp
PREHOOK: query: -- subquery exists
select *
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out Wed Aug 27 17:36:23 2014
@@ -2,21 +2,27 @@ PREHOOK: query: create table A as
select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@A
POSTHOOK: query: create table A as
select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@A
PREHOOK: query: create table B as
select * from src
limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@B
POSTHOOK: query: create table B as
select * from src
limit 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@B
Warning: Shuffle Join JOIN[4][tables = [a, b]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: explain select * from A join B
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out Wed Aug 27 17:36:23 2014
@@ -2,21 +2,27 @@ PREHOOK: query: create table A as
select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@A
POSTHOOK: query: create table A as
select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@A
PREHOOK: query: create table B as
select * from src
limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@B
POSTHOOK: query: create table B as
select * from src
limit 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@B
Warning: Map Join MAPJOIN[7][bigTable=a] in task 'Map 2' is a cross product
PREHOOK: query: explain select * from A join B
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/ctas.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/ctas.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/ctas.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/ctas.q.out Wed Aug 27 17:36:23 2014
@@ -91,7 +91,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
@@ -236,7 +239,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
@@ -381,7 +387,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
@@ -592,7 +601,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
@@ -854,7 +866,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
@@ -869,9 +881,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
@@ -894,7 +909,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/trunk/ql/src/test/results/clientpositive/tez/insert1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/insert1.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/insert1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/insert1.q.out Wed Aug 27 17:36:23 2014
@@ -143,12 +143,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)
@@ -406,11 +405,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/trunk/ql/src/test/results/clientpositive/tez/ptf.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/ptf.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/ptf.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/ptf.q.out Wed Aug 27 17:36:23 2014
@@ -772,6 +772,8 @@ from part
group by p_mfgr, p_brand
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@part
+PREHOOK: Output: database:default
+PREHOOK: Output: default@mfgr_price_view
POSTHOOK: query: -- 16. testViewAsTableInputToPTF
create view IF NOT EXISTS mfgr_price_view as
select p_mfgr, p_brand,
@@ -780,6 +782,7 @@ from part
group by p_mfgr, p_brand
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@part
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@mfgr_price_view
PREHOOK: query: select p_mfgr, p_brand, s,
sum(s) over w1 as s1
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/stats_counter.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/stats_counter.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/stats_counter.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/stats_counter.q.out Wed Aug 27 17:36:23 2014
@@ -2,10 +2,13 @@ PREHOOK: query: -- by analyze
create table dummy1 as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@dummy1
POSTHOOK: query: -- by analyze
create table dummy1 as select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dummy1
PREHOOK: query: analyze table dummy1 compute statistics
PREHOOK: type: QUERY
@@ -55,10 +58,13 @@ PREHOOK: query: -- by autogather
create table dummy2 as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@dummy2
POSTHOOK: query: -- by autogather
create table dummy2 as select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dummy2
PREHOOK: query: desc formatted dummy2
PREHOOK: type: DESCTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/subquery_exists.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/subquery_exists.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/subquery_exists.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/subquery_exists.q.out Wed Aug 27 17:36:23 2014
@@ -133,6 +133,8 @@ where exists
where b.value = a.value and a.key = b.key and a.value > 'val_9')
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@cv1
POSTHOOK: query: -- view test
create view cv1 as
select *
@@ -143,6 +145,7 @@ where exists
where b.value = a.value and a.key = b.key and a.value > 'val_9')
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@cv1
PREHOOK: query: select * from cv1
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/temp_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/temp_table.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/temp_table.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/temp_table.q.out Wed Aug 27 17:36:23 2014
@@ -46,7 +46,7 @@ STAGE PLANS:
#### A masked pattern was here ####
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: foo
+ name: default.foo
isTemporary: true
Stage: Stage-3
@@ -61,9 +61,12 @@ STAGE PLANS:
PREHOOK: query: CREATE TEMPORARY TABLE foo AS SELECT * FROM src WHERE key % 2 = 0
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@foo
POSTHOOK: query: CREATE TEMPORARY TABLE foo AS SELECT * FROM src WHERE key % 2 = 0
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@foo
PREHOOK: query: EXPLAIN CREATE TEMPORARY TABLE bar AS SELECT * FROM src WHERE key % 2 = 1
PREHOOK: type: CREATETABLE_AS_SELECT
@@ -113,7 +116,7 @@ STAGE PLANS:
#### A masked pattern was here ####
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: bar
+ name: default.bar
isTemporary: true
Stage: Stage-3
@@ -128,9 +131,12 @@ STAGE PLANS:
PREHOOK: query: CREATE TEMPORARY TABLE bar AS SELECT * FROM src WHERE key % 2 = 1
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@bar
POSTHOOK: query: CREATE TEMPORARY TABLE bar AS SELECT * FROM src WHERE key % 2 = 1
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@bar
PREHOOK: query: DESCRIBE foo
PREHOOK: type: DESCTABLE
@@ -378,9 +384,12 @@ POSTHOOK: type: SHOWTABLES
PREHOOK: query: CREATE TEMPORARY TABLE foo AS SELECT * FROM default.foo
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@foo
+PREHOOK: Output: database:two
+PREHOOK: Output: two@foo
POSTHOOK: query: CREATE TEMPORARY TABLE foo AS SELECT * FROM default.foo
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@foo
+POSTHOOK: Output: database:two
POSTHOOK: Output: two@foo
PREHOOK: query: SHOW TABLES
PREHOOK: type: SHOWTABLES
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/tez_dml.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/tez_dml.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/tez_dml.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/tez_dml.q.out Wed Aug 27 17:36:23 2014
@@ -82,7 +82,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: tmp_src
+ name: default.tmp_src
Stage: Stage-3
Stats-Aggr Operator
@@ -96,9 +96,12 @@ STAGE PLANS:
PREHOOK: query: CREATE TABLE tmp_src AS SELECT * FROM (SELECT value, count(value) AS cnt FROM src GROUP BY value) f1 ORDER BY cnt
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@tmp_src
POSTHOOK: query: CREATE TABLE tmp_src AS SELECT * FROM (SELECT value, count(value) AS cnt FROM src GROUP BY value) f1 ORDER BY cnt
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tmp_src
PREHOOK: query: SELECT * FROM tmp_src
PREHOOK: type: QUERY
@@ -1478,10 +1481,13 @@ PREHOOK: query: -- create empty table
CREATE TABLE empty STORED AS orc AS SELECT * FROM tmp_src_part WHERE d = -1000
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@tmp_src_part
+PREHOOK: Output: database:default
+PREHOOK: Output: default@empty
POSTHOOK: query: -- create empty table
CREATE TABLE empty STORED AS orc AS SELECT * FROM tmp_src_part WHERE d = -1000
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@tmp_src_part
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@empty
PREHOOK: query: SELECT * FROM empty
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/tez_union.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/tez_union.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/tez_union.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/tez_union.q.out Wed Aug 27 17:36:23 2014
@@ -92,12 +92,15 @@ UNION ALL
select s2.key as key, s2.value as value from src s2
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@ut
POSTHOOK: query: create table ut as
select s1.key as key, s1.value as value from src s1 join src s3 on s1.key=s3.key
UNION ALL
select s2.key as key, s2.value as value from src s2
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@ut
PREHOOK: query: select * from ut order by key, value limit 20
PREHOOK: type: QUERY
@@ -268,12 +271,15 @@ select count(*) as cnt from (select u1.k
u as u1 join u as u2 on (u1.key = u2.key)) a
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@ut
POSTHOOK: query: create table ut as
with u as (select * from src union all select * from src)
select count(*) as cnt from (select u1.key as k1, u2.key as k2 from
u as u1 join u as u2 on (u1.key = u2.key)) a
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@ut
PREHOOK: query: select * from ut order by cnt limit 20
PREHOOK: type: QUERY
@@ -401,12 +407,15 @@ src s1
join (select * from src union all select * from src) u1 on s1.key = u1.key
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@ut
POSTHOOK: query: create table ut as
select s1.key as skey, u1.key as ukey from
src s1
join (select * from src union all select * from src) u1 on s1.key = u1.key
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@ut
PREHOOK: query: select * from ut order by skey, ukey limit 20
PREHOOK: type: QUERY
@@ -708,6 +717,8 @@ join src s8 on (u1.key = s8.key)
order by lkey
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@ut
POSTHOOK: query: create table ut as
select s1.key as skey, u1.key as ukey, s8.key as lkey from
src s1
@@ -718,6 +729,7 @@ join src s8 on (u1.key = s8.key)
order by lkey
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@ut
PREHOOK: query: select * from ut order by skey, ukey, lkey limit 100
PREHOOK: type: QUERY
@@ -951,11 +963,14 @@ select s2.key as key from src s2 join sr
union all select s4.key from src s4 join src s5 on s4.key = s5.key
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@ut
POSTHOOK: query: create table ut as
select s2.key as key from src s2 join src s3 on s2.key = s3.key
union all select s4.key from src s4 join src s5 on s4.key = s5.key
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@ut
PREHOOK: query: select * from ut order by key limit 30
PREHOOK: type: QUERY
@@ -1190,12 +1205,15 @@ select u.key as ukey, s.key as skey from
right outer join src s on u.key = s.key
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@ut
POSTHOOK: query: create table ut as
select u.key as ukey, s.key as skey from
(select * from src union all select * from src) u
right outer join src s on u.key = s.key
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@ut
PREHOOK: query: select * from ut order by ukey, skey limit 20
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/vector_decimal_aggregate.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vector_decimal_aggregate.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/vector_decimal_aggregate.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/vector_decimal_aggregate.q.out Wed Aug 27 17:36:23 2014
@@ -5,6 +5,8 @@ PREHOOK: query: CREATE TABLE decimal_vgb
FROM alltypesorc
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: database:default
+PREHOOK: Output: default@decimal_vgby
POSTHOOK: query: CREATE TABLE decimal_vgby STORED AS ORC AS
SELECT cdouble, CAST (((cdouble*22.1)/37) AS DECIMAL(20,10)) AS cdecimal1,
CAST (((cdouble*9.3)/13) AS DECIMAL(23,14)) AS cdecimal2,
@@ -12,6 +14,7 @@ POSTHOOK: query: CREATE TABLE decimal_vg
FROM alltypesorc
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@decimal_vgby
PREHOOK: query: EXPLAIN SELECT cint,
COUNT(cdecimal1), MAX(cdecimal1), MIN(cdecimal1), SUM(cdecimal1), AVG(cdecimal1), STDDEV_POP(cdecimal1), STDDEV_SAMP(cdecimal1),
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out Wed Aug 27 17:36:23 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/touch.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/touch.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/touch.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/touch.q.out Wed Aug 27 17:36:23 2014
@@ -7,11 +7,10 @@ POSTHOOK: Output: database:tc
PREHOOK: query: create table tc.tstsrc like default.src
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:tc
-PREHOOK: Output: tc@tc.tstsrc
+PREHOOK: Output: tc@tstsrc
POSTHOOK: query: create table tc.tstsrc like default.src
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:tc
-POSTHOOK: Output: tc@tc.tstsrc
POSTHOOK: Output: tc@tstsrc
PREHOOK: query: insert overwrite table tc.tstsrc select key, value from default.src
PREHOOK: type: QUERY
@@ -26,11 +25,10 @@ POSTHOOK: Lineage: tstsrc.value SIMPLE [
PREHOOK: query: create table tc.tstsrcpart like default.srcpart
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:tc
-PREHOOK: Output: tc@tc.tstsrcpart
+PREHOOK: Output: tc@tstsrcpart
POSTHOOK: query: create table tc.tstsrcpart like default.srcpart
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:tc
-POSTHOOK: Output: tc@tc.tstsrcpart
POSTHOOK: Output: tc@tstsrcpart
PREHOOK: query: insert overwrite table tc.tstsrcpart partition (ds='2008-04-08', hr='12')
select key, value from default.srcpart where ds='2008-04-08' and hr='12'
Modified: hive/trunk/ql/src/test/results/clientpositive/union24.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union24.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/union24.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/union24.q.out Wed Aug 27 17:36:23 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/union25.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union25.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union25.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union25.q.out Wed Aug 27 17:36:23 2014
@@ -210,7 +210,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: tmp_unionall
+ name: default.tmp_unionall
Stage: Stage-3
Stats-Aggr Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/union27.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union27.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union27.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union27.q.out Wed Aug 27 17:36:23 2014
@@ -2,24 +2,33 @@ PREHOOK: query: -- SORT_BEFORE_DIFF
create table jackson_sev_same as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@jackson_sev_same
POSTHOOK: query: -- SORT_BEFORE_DIFF
create table jackson_sev_same as select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@jackson_sev_same
PREHOOK: query: create table dim_pho as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@dim_pho
POSTHOOK: query: create table dim_pho as select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dim_pho
PREHOOK: query: create table jackson_sev_add as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@jackson_sev_add
POSTHOOK: query: create table jackson_sev_add as select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@jackson_sev_add
PREHOOK: query: explain select b.* from jackson_sev_same a join (select * from dim_pho union all select * from jackson_sev_add)b on a.key=b.key and b.key=97
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/union31.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union31.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union31.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union31.q.out Wed Aug 27 17:36:23 2014
@@ -13,16 +13,22 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: create table t1 as select * from src where key < 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@t1
POSTHOOK: query: create table t1 as select * from src where key < 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t1
PREHOOK: query: create table t2 as select * from src where key < 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@t2
POSTHOOK: query: create table t2 as select * from src where key < 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t2
PREHOOK: query: create table t3(key string, cnt int)
PREHOOK: type: CREATETABLE
@@ -598,16 +604,22 @@ POSTHOOK: Output: default@t2
PREHOOK: query: create table t1 as select * from src where key < 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@t1
POSTHOOK: query: create table t1 as select * from src where key < 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t1
PREHOOK: query: create table t2 as select key, count(1) as cnt from src where key < 10 group by key
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@t2
POSTHOOK: query: create table t2 as select key, count(1) as cnt from src where key < 10 group by key
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t2
PREHOOK: query: create table t7(c1 string, cnt int)
PREHOOK: type: CREATETABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/union32.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union32.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union32.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union32.q.out Wed Aug 27 17:36:23 2014
@@ -6,6 +6,8 @@ PREHOOK: query: -- SORT_QUERY_RESULTS
CREATE TABLE t1 AS SELECT * FROM src WHERE key < 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@t1
POSTHOOK: query: -- SORT_QUERY_RESULTS
-- This tests various union queries which have columns on one side of the query
@@ -14,13 +16,17 @@ POSTHOOK: query: -- SORT_QUERY_RESULTS
CREATE TABLE t1 AS SELECT * FROM src WHERE key < 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t1
PREHOOK: query: CREATE TABLE t2 AS SELECT * FROM src WHERE key < 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@t2
POSTHOOK: query: CREATE TABLE t2 AS SELECT * FROM src WHERE key < 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t2
PREHOOK: query: -- Test simple union with double
EXPLAIN
Modified: hive/trunk/ql/src/test/results/clientpositive/union_top_level.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/union_top_level.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/union_top_level.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/union_top_level.q.out Wed Aug 27 17:36:23 2014
@@ -580,7 +580,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: union_top
+ name: default.union_top
Stage: Stage-3
Stats-Aggr Operator
@@ -693,6 +693,8 @@ union all
select key, 2 as value from src where key % 3 == 2 limit 3
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@union_top
POSTHOOK: query: create table union_top as
select key, 0 as value from src where key % 3 == 0 limit 3
union all
@@ -701,6 +703,7 @@ union all
select key, 2 as value from src where key % 3 == 2 limit 3
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@union_top
PREHOOK: query: select * from union_top
PREHOOK: type: QUERY
@@ -1305,7 +1308,7 @@ union all
select `src`.`key`, 1 as `value` from `default`.`src` where `src`.`key` % 3 == 1 limit 3
union all
select `src`.`key`, 2 as `value` from `default`.`src` where `src`.`key` % 3 == 2 limit 3
- name: union_top_view
+ name: default.union_top_view
original text: select key, 0 as value from src where key % 3 == 0 limit 3
union all
select key, 1 as value from src where key % 3 == 1 limit 3
@@ -1320,6 +1323,8 @@ union all
select key, 2 as value from src where key % 3 == 2 limit 3
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@union_top_view
POSTHOOK: query: create view union_top_view as
select key, 0 as value from src where key % 3 == 0 limit 3
union all
@@ -1328,6 +1333,7 @@ union all
select key, 2 as value from src where key % 3 == 2 limit 3
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@union_top_view
PREHOOK: query: select * from union_top_view
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/unset_table_view_property.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/unset_table_view_property.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/unset_table_view_property.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/unset_table_view_property.q.out Wed Aug 27 17:36:23 2014
@@ -7,12 +7,11 @@ POSTHOOK: Output: database:vt
PREHOOK: query: CREATE TABLE vt.testTable(col1 INT, col2 INT)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:vt
-PREHOOK: Output: vt@vt.testTable
+PREHOOK: Output: vt@testTable
POSTHOOK: query: CREATE TABLE vt.testTable(col1 INT, col2 INT)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:vt
POSTHOOK: Output: vt@testTable
-POSTHOOK: Output: vt@vt.testTable
PREHOOK: query: SHOW TBLPROPERTIES vt.testTable
PREHOOK: type: SHOW_TBLPROPERTIES
POSTHOOK: query: SHOW TBLPROPERTIES vt.testTable
@@ -207,10 +206,13 @@ PREHOOK: query: -- UNSET VIEW PROPERTIES
CREATE VIEW vt.testView AS SELECT value FROM src WHERE key=86
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:vt
+PREHOOK: Output: vt@testView
POSTHOOK: query: -- UNSET VIEW PROPERTIES
CREATE VIEW vt.testView AS SELECT value FROM src WHERE key=86
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:vt
POSTHOOK: Output: vt@testView
PREHOOK: query: ALTER VIEW vt.testView SET TBLPROPERTIES ('propA'='100', 'propB'='200')
PREHOOK: type: ALTERVIEW_PROPERTIES
Modified: hive/trunk/ql/src/test/results/clientpositive/updateAccessTime.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/updateAccessTime.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/updateAccessTime.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/updateAccessTime.q.out Wed Aug 27 17:36:23 2014
@@ -5,9 +5,12 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: create table tstsrc as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@tstsrc
POSTHOOK: query: create table tstsrc as select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tstsrc
PREHOOK: query: desc extended tstsrc
PREHOOK: type: DESCTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/varchar_nested_types.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/varchar_nested_types.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/varchar_nested_types.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/varchar_nested_types.q.out Wed Aug 27 17:36:23 2014
@@ -164,11 +164,14 @@ create table varchar_nested_cta as
select * from varchar_nested_struct
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@varchar_nested_struct
+PREHOOK: Output: database:default
+PREHOOK: Output: default@varchar_nested_cta
POSTHOOK: query: -- nested type with create table as
create table varchar_nested_cta as
select * from varchar_nested_struct
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@varchar_nested_struct
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@varchar_nested_cta
PREHOOK: query: describe varchar_nested_cta
PREHOOK: type: DESCTABLE
@@ -191,11 +194,14 @@ create table varchar_nested_view as
select * from varchar_nested_struct
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@varchar_nested_struct
+PREHOOK: Output: database:default
+PREHOOK: Output: default@varchar_nested_view
POSTHOOK: query: -- nested type with view
create table varchar_nested_view as
select * from varchar_nested_struct
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@varchar_nested_struct
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@varchar_nested_view
PREHOOK: query: describe varchar_nested_view
PREHOOK: type: DESCTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/vector_between_in.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_between_in.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vector_between_in.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vector_between_in.q.out Wed Aug 27 17:36:23 2014
@@ -1,9 +1,12 @@
PREHOOK: query: CREATE TABLE decimal_date_test STORED AS ORC AS SELECT cdouble, CAST (((cdouble*22.1)/37) AS DECIMAL(20,10)) AS cdecimal1, CAST (((cdouble*9.3)/13) AS DECIMAL(23,14)) AS cdecimal2, CAST(CAST((CAST(cint AS BIGINT) *ctinyint) AS TIMESTAMP) AS DATE) AS cdate FROM alltypesorc ORDER BY cdate
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: database:default
+PREHOOK: Output: default@decimal_date_test
POSTHOOK: query: CREATE TABLE decimal_date_test STORED AS ORC AS SELECT cdouble, CAST (((cdouble*22.1)/37) AS DECIMAL(20,10)) AS cdecimal1, CAST (((cdouble*9.3)/13) AS DECIMAL(23,14)) AS cdecimal2, CAST(CAST((CAST(cint AS BIGINT) *ctinyint) AS TIMESTAMP) AS DATE) AS cdate FROM alltypesorc ORDER BY cdate
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@decimal_date_test
PREHOOK: query: EXPLAIN SELECT cdate FROM decimal_date_test WHERE cdate IN (CAST("1969-10-26" AS DATE), CAST("1969-07-14" AS DATE)) ORDER BY cdate
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/vector_decimal_aggregate.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_decimal_aggregate.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vector_decimal_aggregate.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vector_decimal_aggregate.q.out Wed Aug 27 17:36:23 2014
@@ -5,6 +5,8 @@ PREHOOK: query: CREATE TABLE decimal_vgb
FROM alltypesorc
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: database:default
+PREHOOK: Output: default@decimal_vgby
POSTHOOK: query: CREATE TABLE decimal_vgby STORED AS ORC AS
SELECT cdouble, CAST (((cdouble*22.1)/37) AS DECIMAL(20,10)) AS cdecimal1,
CAST (((cdouble*9.3)/13) AS DECIMAL(23,14)) AS cdecimal2,
@@ -12,6 +14,7 @@ POSTHOOK: query: CREATE TABLE decimal_vg
FROM alltypesorc
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@decimal_vgby
PREHOOK: query: EXPLAIN SELECT cint,
COUNT(cdecimal1), MAX(cdecimal1), MIN(cdecimal1), SUM(cdecimal1), AVG(cdecimal1), STDDEV_POP(cdecimal1), STDDEV_SAMP(cdecimal1),
Modified: hive/trunk/ql/src/test/results/clientpositive/vector_decimal_expressions.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_decimal_expressions.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vector_decimal_expressions.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vector_decimal_expressions.q.out Wed Aug 27 17:36:23 2014
@@ -1,9 +1,12 @@
PREHOOK: query: CREATE TABLE decimal_test STORED AS ORC AS SELECT cdouble, CAST (((cdouble*22.1)/37) AS DECIMAL(20,10)) AS cdecimal1, CAST (((cdouble*9.3)/13) AS DECIMAL(23,14)) AS cdecimal2 FROM alltypesorc
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: database:default
+PREHOOK: Output: default@decimal_test
POSTHOOK: query: CREATE TABLE decimal_test STORED AS ORC AS SELECT cdouble, CAST (((cdouble*22.1)/37) AS DECIMAL(20,10)) AS cdecimal1, CAST (((cdouble*9.3)/13) AS DECIMAL(23,14)) AS cdecimal2 FROM alltypesorc
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@decimal_test
PREHOOK: query: EXPLAIN SELECT cdecimal1 + cdecimal2, cdecimal1 - (2*cdecimal2), ((cdecimal1+2.34)/cdecimal2), (cdecimal1 * (cdecimal2/3.4)), cdecimal1 % 10, CAST(cdecimal1 AS INT), CAST(cdecimal2 AS SMALLINT), CAST(cdecimal2 AS TINYINT), CAST(cdecimal1 AS BIGINT), CAST (cdecimal1 AS BOOLEAN), CAST(cdecimal2 AS DOUBLE), CAST(cdecimal1 AS FLOAT), CAST(cdecimal2 AS STRING), CAST(cdecimal1 AS TIMESTAMP) FROM decimal_test WHERE cdecimal1 > 0 AND cdecimal1 < 12345.5678 AND cdecimal2 != 0 AND cdecimal2 > 1000 AND cdouble IS NOT NULL LIMIT 10
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out Wed Aug 27 17:36:23 2014
@@ -5,6 +5,8 @@ PREHOOK: query: CREATE TABLE decimal_map
FROM alltypesorc
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: database:default
+PREHOOK: Output: default@decimal_mapjoin
POSTHOOK: query: CREATE TABLE decimal_mapjoin STORED AS ORC AS
SELECT cdouble, CAST (((cdouble*22.1)/37) AS DECIMAL(20,10)) AS cdecimal1,
CAST (((cdouble*9.3)/13) AS DECIMAL(23,14)) AS cdecimal2,
@@ -12,6 +14,7 @@ POSTHOOK: query: CREATE TABLE decimal_ma
FROM alltypesorc
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@decimal_mapjoin
PREHOOK: query: EXPLAIN SELECT l.cint, r.cint, l.cdecimal1, r.cdecimal2
FROM decimal_mapjoin l
Modified: hive/trunk/ql/src/test/results/clientpositive/vector_decimal_math_funcs.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vector_decimal_math_funcs.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vector_decimal_math_funcs.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vector_decimal_math_funcs.q.out Wed Aug 27 17:36:23 2014
@@ -1,9 +1,12 @@
PREHOOK: query: CREATE TABLE decimal_test STORED AS ORC AS SELECT cbigint, cdouble, CAST (((cdouble*22.1)/37) AS DECIMAL(20,10)) AS cdecimal1, CAST (((cdouble*9.3)/13) AS DECIMAL(23,14)) AS cdecimal2 FROM alltypesorc
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: database:default
+PREHOOK: Output: default@decimal_test
POSTHOOK: query: CREATE TABLE decimal_test STORED AS ORC AS SELECT cbigint, cdouble, CAST (((cdouble*22.1)/37) AS DECIMAL(20,10)) AS cdecimal1, CAST (((cdouble*9.3)/13) AS DECIMAL(23,14)) AS cdecimal2 FROM alltypesorc
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@decimal_test
PREHOOK: query: -- Test math functions in vectorized mode to verify they run correctly end-to-end.
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorization_decimal_date.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorization_decimal_date.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorization_decimal_date.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorization_decimal_date.q.out Wed Aug 27 17:36:23 2014
@@ -1,9 +1,12 @@
PREHOOK: query: CREATE TABLE date_decimal_test STORED AS ORC AS SELECT cint, cdouble, CAST (CAST (cint AS TIMESTAMP) AS DATE) AS cdate, CAST (((cdouble*22.1)/37) AS DECIMAL(20,10)) AS cdecimal FROM alltypesorc
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: database:default
+PREHOOK: Output: default@date_decimal_test
POSTHOOK: query: CREATE TABLE date_decimal_test STORED AS ORC AS SELECT cint, cdouble, CAST (CAST (cint AS TIMESTAMP) AS DATE) AS cdate, CAST (((cdouble*22.1)/37) AS DECIMAL(20,10)) AS cdecimal FROM alltypesorc
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@date_decimal_test
PREHOOK: query: EXPLAIN SELECT cdate, cdecimal from date_decimal_test where cint IS NOT NULL AND cdouble IS NOT NULL LIMIT 10
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorized_ptf.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorized_ptf.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/vectorized_ptf.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/vectorized_ptf.q.out Wed Aug 27 17:36:23 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/view.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/view.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/view.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/view.q.out Wed Aug 27 17:36:23 2014
@@ -54,77 +54,101 @@ PREHOOK: query: -- relative reference, n
CREATE VIEW v1 AS SELECT * FROM table1
PREHOOK: type: CREATEVIEW
PREHOOK: Input: db1@table1
+PREHOOK: Output: database:db1
+PREHOOK: Output: db1@v1
POSTHOOK: query: -- relative reference, no alias
CREATE VIEW v1 AS SELECT * FROM table1
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: db1@table1
+POSTHOOK: Output: database:db1
POSTHOOK: Output: db1@v1
PREHOOK: query: -- relative reference, aliased
CREATE VIEW v2 AS SELECT t1.* FROM table1 t1
PREHOOK: type: CREATEVIEW
PREHOOK: Input: db1@table1
+PREHOOK: Output: database:db1
+PREHOOK: Output: db1@v2
POSTHOOK: query: -- relative reference, aliased
CREATE VIEW v2 AS SELECT t1.* FROM table1 t1
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: db1@table1
+POSTHOOK: Output: database:db1
POSTHOOK: Output: db1@v2
PREHOOK: query: -- relative reference, multiple tables
CREATE VIEW v3 AS SELECT t1.*, t2.key k FROM table1 t1 JOIN table2 t2 ON t1.key = t2.key
PREHOOK: type: CREATEVIEW
PREHOOK: Input: db1@table1
PREHOOK: Input: db1@table2
+PREHOOK: Output: database:db1
+PREHOOK: Output: db1@v3
POSTHOOK: query: -- relative reference, multiple tables
CREATE VIEW v3 AS SELECT t1.*, t2.key k FROM table1 t1 JOIN table2 t2 ON t1.key = t2.key
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: db1@table1
POSTHOOK: Input: db1@table2
+POSTHOOK: Output: database:db1
POSTHOOK: Output: db1@v3
PREHOOK: query: -- absolute reference, no alias
CREATE VIEW v4 AS SELECT * FROM db1.table1
PREHOOK: type: CREATEVIEW
PREHOOK: Input: db1@table1
+PREHOOK: Output: database:db1
+PREHOOK: Output: db1@v4
POSTHOOK: query: -- absolute reference, no alias
CREATE VIEW v4 AS SELECT * FROM db1.table1
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: db1@table1
+POSTHOOK: Output: database:db1
POSTHOOK: Output: db1@v4
PREHOOK: query: -- absolute reference, aliased
CREATE VIEW v5 AS SELECT t1.* FROM db1.table1 t1
PREHOOK: type: CREATEVIEW
PREHOOK: Input: db1@table1
+PREHOOK: Output: database:db1
+PREHOOK: Output: db1@v5
POSTHOOK: query: -- absolute reference, aliased
CREATE VIEW v5 AS SELECT t1.* FROM db1.table1 t1
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: db1@table1
+POSTHOOK: Output: database:db1
POSTHOOK: Output: db1@v5
PREHOOK: query: -- absolute reference, multiple tables
CREATE VIEW v6 AS SELECT t1.*, t2.key k FROM db1.table1 t1 JOIN db1.table2 t2 ON t1.key = t2.key
PREHOOK: type: CREATEVIEW
PREHOOK: Input: db1@table1
PREHOOK: Input: db1@table2
+PREHOOK: Output: database:db1
+PREHOOK: Output: db1@v6
POSTHOOK: query: -- absolute reference, multiple tables
CREATE VIEW v6 AS SELECT t1.*, t2.key k FROM db1.table1 t1 JOIN db1.table2 t2 ON t1.key = t2.key
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: db1@table1
POSTHOOK: Input: db1@table2
+POSTHOOK: Output: database:db1
POSTHOOK: Output: db1@v6
PREHOOK: query: -- relative reference, explicit column
CREATE VIEW v7 AS SELECT key from table1
PREHOOK: type: CREATEVIEW
PREHOOK: Input: db1@table1
+PREHOOK: Output: database:db1
+PREHOOK: Output: db1@v7
POSTHOOK: query: -- relative reference, explicit column
CREATE VIEW v7 AS SELECT key from table1
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: db1@table1
+POSTHOOK: Output: database:db1
POSTHOOK: Output: db1@v7
PREHOOK: query: -- absolute reference, explicit column
CREATE VIEW v8 AS SELECT key from db1.table1
PREHOOK: type: CREATEVIEW
PREHOOK: Input: db1@table1
+PREHOOK: Output: database:db1
+PREHOOK: Output: db1@v8
POSTHOOK: query: -- absolute reference, explicit column
CREATE VIEW v8 AS SELECT key from db1.table1
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: db1@table1
+POSTHOOK: Output: database:db1
POSTHOOK: Output: db1@v8
PREHOOK: query: CREATE DATABASE db2
PREHOOK: type: CREATEDATABASE
Modified: hive/trunk/ql/src/test/results/clientpositive/view_cast.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/view_cast.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/view_cast.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/view_cast.q.out Wed Aug 27 17:36:23 2014
@@ -56,9 +56,12 @@ POSTHOOK: type: DROPVIEW
PREHOOK: query: CREATE VIEW aa_view_tw AS SELECT ks_uid, sr_id, act, at_ks_uid, at_sr_uid, from_unixtime(CAST(CAST( tstamp as BIGINT)/1000 AS BIGINT),'yyyyMMdd') AS act_date, from_unixtime(CAST(CAST( original_tstamp AS BIGINT)/1000 AS BIGINT),'yyyyMMdd') AS content_creation_date FROM atab WHERE dt='20130312' AND nt='tw' AND ks_uid != at_ks_uid
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@atab
+PREHOOK: Output: database:default
+PREHOOK: Output: default@aa_view_tw
POSTHOOK: query: CREATE VIEW aa_view_tw AS SELECT ks_uid, sr_id, act, at_ks_uid, at_sr_uid, from_unixtime(CAST(CAST( tstamp as BIGINT)/1000 AS BIGINT),'yyyyMMdd') AS act_date, from_unixtime(CAST(CAST( original_tstamp AS BIGINT)/1000 AS BIGINT),'yyyyMMdd') AS content_creation_date FROM atab WHERE dt='20130312' AND nt='tw' AND ks_uid != at_ks_uid
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@atab
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@aa_view_tw
PREHOOK: query: DROP VIEW IF EXISTS joined_aa_view_tw
PREHOOK: type: DROPVIEW
@@ -69,11 +72,14 @@ PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@aa_view_tw
PREHOOK: Input: default@atab
PREHOOK: Input: default@mstab
+PREHOOK: Output: database:default
+PREHOOK: Output: default@joined_aa_view_tw
POSTHOOK: query: CREATE VIEW joined_aa_view_tw AS SELECT aa.ks_uid, aa.sr_id, aa.act, at_sr_uid, aa.act_date, aa.at_ks_uid, aa.content_creation_date, coalesce( other.ksc, 10.0) AS at_ksc, coalesce( self.ksc , 10.0 ) AS self_ksc FROM aa_view_tw aa LEFT OUTER JOIN ( SELECT ks_uid, csc AS ksc FROM mstab WHERE dt='20130311' ) self ON ( CAST(aa.ks_uid AS BIGINT) = CAST(self.ks_uid AS BIGINT) ) LEFT OUTER JOIN ( SELECT ks_uid, csc AS ksc FROM mstab WHERE dt='20130311' ) other ON ( CAST(aa.at_ks_uid AS BIGINT) = CAST(other.ks_uid AS BIGINT) )
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@aa_view_tw
POSTHOOK: Input: default@atab
POSTHOOK: Input: default@mstab
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@joined_aa_view_tw
PREHOOK: query: SELECT * FROM joined_aa_view_tw
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/view_inputs.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/view_inputs.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/view_inputs.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/view_inputs.q.out Wed Aug 27 17:36:23 2014
@@ -3,20 +3,26 @@ PREHOOK: query: -- Tests that selecting
CREATE VIEW test_view1 AS SELECT * FROM src
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@test_view1
POSTHOOK: query: -- Tests that selecting from a view and another view that selects from that same view
CREATE VIEW test_view1 AS SELECT * FROM src
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@test_view1
PREHOOK: query: CREATE VIEW test_view2 AS SELECT * FROM test_view1
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
PREHOOK: Input: default@test_view1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@test_view2
POSTHOOK: query: CREATE VIEW test_view2 AS SELECT * FROM test_view1
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
POSTHOOK: Input: default@test_view1
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@test_view2
PREHOOK: query: SELECT COUNT(*) FROM test_view1 a JOIN test_view2 b ON a.key = b.key
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/windowing.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing.q.out Wed Aug 27 17:36:23 2014
@@ -1024,6 +1024,8 @@ from part
group by p_mfgr, p_brand
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@part
+PREHOOK: Output: database:default
+PREHOOK: Output: default@mfgr_price_view
POSTHOOK: query: -- 22. testViewAsTableInputWithWindowing
create view IF NOT EXISTS mfgr_price_view as
select p_mfgr, p_brand,
@@ -1032,6 +1034,7 @@ from part
group by p_mfgr, p_brand
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@part
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@mfgr_price_view
PREHOOK: query: select *
from (
@@ -1113,6 +1116,8 @@ from part
window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and current row)
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@part
+PREHOOK: Output: database:default
+PREHOOK: Output: default@mfgr_brand_price_view
POSTHOOK: query: -- 23. testCreateViewWithWindowingQuery
create view IF NOT EXISTS mfgr_brand_price_view as
select p_mfgr, p_brand,
@@ -1121,6 +1126,7 @@ from part
window w1 as (distribute by p_mfgr sort by p_name rows between 2 preceding and current row)
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@part
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@mfgr_brand_price_view
PREHOOK: query: select * from mfgr_brand_price_view
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/windowing_navfn.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing_navfn.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing_navfn.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing_navfn.q.out Wed Aug 27 17:36:23 2014
@@ -614,6 +614,8 @@ SELECT explode(
) s1 lateral view explode(barr) arr as b
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@wtest
POSTHOOK: query: create table wtest as
select a, b
from
@@ -628,6 +630,7 @@ SELECT explode(
) s1 lateral view explode(barr) arr as b
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@wtest
PREHOOK: query: select a, b,
first_value(b) over (partition by a order by b rows between 1 preceding and 1 following ) ,
Modified: hive/trunk/ql/src/test/results/clientpositive/windowing_streaming.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing_streaming.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing_streaming.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing_streaming.q.out Wed Aug 27 17:36:23 2014
@@ -347,10 +347,13 @@ PREHOOK: query: create table sB ROW FORM
select * from (select ctinyint, cdouble, rank() over(partition by ctinyint order by cdouble) r from alltypesorc) a where r < 5
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: database:default
+PREHOOK: Output: default@sB
POSTHOOK: query: create table sB ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE as
select * from (select ctinyint, cdouble, rank() over(partition by ctinyint order by cdouble) r from alltypesorc) a where r < 5
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@sB
PREHOOK: query: select * from sB
where ctinyint is null
@@ -412,10 +415,13 @@ PREHOOK: query: create table sD ROW FORM
select * from (select ctinyint, cdouble, rank() over(partition by ctinyint order by cdouble) r from alltypesorc) a where r < 5
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: database:default
+PREHOOK: Output: default@sD
POSTHOOK: query: create table sD ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' STORED AS TEXTFILE as
select * from (select ctinyint, cdouble, rank() over(partition by ctinyint order by cdouble) r from alltypesorc) a where r < 5
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@sD
PREHOOK: query: select * from sD
where ctinyint is null