Modified: hive/trunk/ql/src/test/results/clientpositive/subquery_exists.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/subquery_exists.q.out?rev=1564472&r1=1564471&r2=1564472&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/subquery_exists.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/subquery_exists.q.out Tue Feb 4 20:34:39 2014 @@ -123,6 +123,7 @@ where exists from src a where b.value = a.value and a.key = b.key and a.value > 'val_9') PREHOOK: type: CREATEVIEW +PREHOOK: Input: default@src POSTHOOK: query: -- view test create view cv1 as select * @@ -132,6 +133,7 @@ where exists from src a where b.value = a.value and a.key = b.key and a.value > 'val_9') POSTHOOK: type: CREATEVIEW +POSTHOOK: Input: default@src POSTHOOK: Output: default@cv1 PREHOOK: query: select * from cv1 PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/subquery_exists_having.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/subquery_exists_having.q.out?rev=1564472&r1=1564471&r2=1564472&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/subquery_exists_having.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/subquery_exists_having.q.out Tue Feb 4 20:34:39 2014 @@ -159,6 +159,7 @@ having exists where a.key = b.key and a.value > 'val_9' ) PREHOOK: type: CREATEVIEW +PREHOOK: Input: default@src POSTHOOK: query: -- view test create view cv1 as select b.key, count(*) as c @@ -170,6 +171,7 @@ having exists where a.key = b.key and a.value > 'val_9' ) POSTHOOK: type: CREATEVIEW +POSTHOOK: Input: default@src POSTHOOK: Output: default@cv1 PREHOOK: query: select * from cv1 PREHOOK: type: QUERY Modified: hive/trunk/ql/src/test/results/clientpositive/subquery_notin.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/subquery_notin.q.out?rev=1564472&r1=1564471&r2=1564472&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/subquery_notin.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/subquery_notin.q.out Tue Feb 4 20:34:39 2014 @@ -1388,18 +1388,22 @@ PREHOOK: query: -- null check create view T1_v as select key from src where key <'11' PREHOOK: type: CREATEVIEW +PREHOOK: Input: default@src POSTHOOK: query: -- null check create view T1_v as select key from src where key <'11' POSTHOOK: type: CREATEVIEW +POSTHOOK: Input: default@src POSTHOOK: Output: default@T1_v PREHOOK: query: create view T2_v as select case when key > '104' then null else key end as key from T1_v PREHOOK: type: CREATEVIEW +PREHOOK: Input: default@src PREHOOK: Input: default@t1_v POSTHOOK: query: create view T2_v as select case when key > '104' then null else key end as key from T1_v POSTHOOK: type: CREATEVIEW +POSTHOOK: Input: default@src POSTHOOK: Input: default@t1_v POSTHOOK: Output: default@T2_v PREHOOK: query: explain Modified: hive/trunk/ql/src/test/results/clientpositive/subquery_views.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/subquery_views.q.out?rev=1564472&r1=1564471&r2=1564472&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/subquery_views.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/subquery_views.q.out Tue Feb 4 20:34:39 2014 @@ -7,6 +7,7 @@ where exists from src a where b.value = a.value and a.key = b.key and a.value > 'val_9') PREHOOK: type: CREATEVIEW +PREHOOK: Input: default@src POSTHOOK: query: -- exists test create view cv1 as select * @@ -16,6 +17,7 @@ where exists from src a where b.value = a.value and a.key = b.key and a.value > 'val_9') POSTHOOK: type: CREATEVIEW +POSTHOOK: Input: default@src POSTHOOK: Output: default@cv1 PREHOOK: query: select * from cv1 where cv1.key in (select key from cv1 c where c.key > '95') @@ -44,6 +46,7 @@ where b.key not in where b.value = a.value and a.key = b.key and a.value > 'val_11' ) PREHOOK: type: CREATEVIEW +PREHOOK: Input: default@src POSTHOOK: query: -- not in test create view cv2 as select * @@ -54,6 +57,7 @@ where b.key not in where b.value = a.value and a.key = b.key and a.value > 'val_11' ) POSTHOOK: type: CREATEVIEW +POSTHOOK: Input: default@src POSTHOOK: Output: default@cv2 PREHOOK: query: select * from cv2 where cv2.key in (select key from cv2 c where c.key < '11') @@ -86,6 +90,7 @@ where b.key in (select key from src wher group by key, value having count(*) in (select count(*) from src s1 where s1.key > '9' group by s1.key ) PREHOOK: type: CREATEVIEW +PREHOOK: Input: default@src POSTHOOK: query: -- in where + having create view cv3 as select key, value, count(*) @@ -94,6 +99,7 @@ where b.key in (select key from src wher group by key, value having count(*) in (select count(*) from src s1 where s1.key > '9' group by s1.key ) POSTHOOK: type: CREATEVIEW +POSTHOOK: Input: default@src POSTHOOK: Output: default@cv3 PREHOOK: query: select * from cv3 PREHOOK: type: QUERY 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=1564472&r1=1564471&r2=1564472&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 Tue Feb 4 20:34:39 2014 @@ -1286,6 +1286,7 @@ select key, 1 as value from src where ke union all select key, 2 as value from src where key % 3 == 2 limit 3 PREHOOK: type: CREATEVIEW +PREHOOK: Input: default@src POSTHOOK: query: create view union_top_view as select key, 0 as value from src where key % 3 == 0 limit 3 union all @@ -1293,6 +1294,7 @@ select key, 1 as value from src where ke union all select key, 2 as value from src where key % 3 == 2 limit 3 POSTHOOK: type: CREATEVIEW +POSTHOOK: Input: default@src POSTHOOK: Output: default@union_top_view POSTHOOK: Lineage: union_top.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: union_top.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:key, type:string, comment:default), ] 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=1564472&r1=1564471&r2=1564472&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 Tue Feb 4 20:34:39 2014 @@ -193,9 +193,11 @@ rawDataSize -1 PREHOOK: query: -- UNSET VIEW PROPERTIES CREATE VIEW testView AS SELECT value FROM src WHERE key=86 PREHOOK: type: CREATEVIEW +PREHOOK: Input: default@src POSTHOOK: query: -- UNSET VIEW PROPERTIES CREATE VIEW testView AS SELECT value FROM src WHERE key=86 POSTHOOK: type: CREATEVIEW +POSTHOOK: Input: default@src POSTHOOK: Output: default@testView PREHOOK: query: ALTER VIEW testView SET TBLPROPERTIES ('propA'='100', 'propB'='200') PREHOOK: type: ALTERVIEW_PROPERTIES 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=1564472&r1=1564471&r2=1564472&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/view.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/view.q.out Tue Feb 4 20:34:39 2014 @@ -39,58 +39,78 @@ POSTHOOK: Output: db1@table2 PREHOOK: query: -- relative reference, no alias CREATE VIEW v1 AS SELECT * FROM table1 PREHOOK: type: CREATEVIEW +PREHOOK: Input: db1@table1 POSTHOOK: query: -- relative reference, no alias CREATE VIEW v1 AS SELECT * FROM table1 POSTHOOK: type: CREATEVIEW +POSTHOOK: Input: db1@table1 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 POSTHOOK: query: -- relative reference, aliased CREATE VIEW v2 AS SELECT t1.* FROM table1 t1 POSTHOOK: type: CREATEVIEW +POSTHOOK: Input: db1@table1 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 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: db1@v3 PREHOOK: query: -- absolute reference, no alias CREATE VIEW v4 AS SELECT * FROM db1.table1 PREHOOK: type: CREATEVIEW +PREHOOK: Input: db1@table1 POSTHOOK: query: -- absolute reference, no alias CREATE VIEW v4 AS SELECT * FROM db1.table1 POSTHOOK: type: CREATEVIEW +POSTHOOK: Input: db1@table1 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 POSTHOOK: query: -- absolute reference, aliased CREATE VIEW v5 AS SELECT t1.* FROM db1.table1 t1 POSTHOOK: type: CREATEVIEW +POSTHOOK: Input: db1@table1 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 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: db1@v6 PREHOOK: query: -- relative reference, explicit column CREATE VIEW v7 AS SELECT key from table1 PREHOOK: type: CREATEVIEW +PREHOOK: Input: db1@table1 POSTHOOK: query: -- relative reference, explicit column CREATE VIEW v7 AS SELECT key from table1 POSTHOOK: type: CREATEVIEW +POSTHOOK: Input: db1@table1 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 POSTHOOK: query: -- absolute reference, explicit column CREATE VIEW v8 AS SELECT key from db1.table1 POSTHOOK: type: CREATEVIEW +POSTHOOK: Input: db1@table1 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=1564472&r1=1564471&r2=1564472&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 Tue Feb 4 20:34:39 2014 @@ -43,8 +43,10 @@ POSTHOOK: query: DROP VIEW IF EXISTS aa_ 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 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: default@aa_view_tw PREHOOK: query: DROP VIEW IF EXISTS joined_aa_view_tw PREHOOK: type: DROPVIEW @@ -53,9 +55,13 @@ POSTHOOK: type: DROPVIEW PREHOOK: 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) ) PREHOOK: type: CREATEVIEW PREHOOK: Input: default@aa_view_tw +PREHOOK: Input: default@atab +PREHOOK: Input: default@mstab 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: 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=1564472&r1=1564471&r2=1564472&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 Tue Feb 4 20:34:39 2014 @@ -2,16 +2,20 @@ PREHOOK: query: -- Tests that selecting CREATE VIEW test_view1 AS SELECT * FROM src PREHOOK: type: CREATEVIEW +PREHOOK: Input: default@src 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: 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 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: default@test_view2 PREHOOK: query: SELECT COUNT(*) FROM test_view1 a JOIN test_view2 b ON a.key = b.key 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=1564472&r1=1564471&r2=1564472&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/windowing.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/windowing.q.out Tue Feb 4 20:34:39 2014 @@ -1018,6 +1018,7 @@ round(sum(p_retailprice),2) as s from part group by p_mfgr, p_brand PREHOOK: type: CREATEVIEW +PREHOOK: Input: default@part POSTHOOK: query: -- 22. testViewAsTableInputWithWindowing create view IF NOT EXISTS mfgr_price_view as select p_mfgr, p_brand, @@ -1025,6 +1026,7 @@ round(sum(p_retailprice),2) as s from part group by p_mfgr, p_brand POSTHOOK: type: CREATEVIEW +POSTHOOK: Input: default@part POSTHOOK: Output: default@mfgr_price_view PREHOOK: query: select * from ( @@ -1105,6 +1107,7 @@ sum(p_retailprice) over w1 as s 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 POSTHOOK: query: -- 23. testCreateViewWithWindowingQuery create view IF NOT EXISTS mfgr_brand_price_view as select p_mfgr, p_brand, @@ -1112,6 +1115,7 @@ sum(p_retailprice) over w1 as s 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: default@mfgr_brand_price_view PREHOOK: query: select * from mfgr_brand_price_view PREHOOK: type: QUERY
