Modified: hive/branches/cbo/ql/src/test/results/clientpositive/alter_view_rename.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/alter_view_rename.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/alter_view_rename.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/alter_view_rename.q.out Thu Aug 28 03:15:13 2014 @@ -1,3 +1,15 @@ +PREHOOK: query: CREATE DATABASE tv1 +PREHOOK: type: CREATEDATABASE +PREHOOK: Output: database:tv1 +POSTHOOK: query: CREATE DATABASE tv1 +POSTHOOK: type: CREATEDATABASE +POSTHOOK: Output: database:tv1 +PREHOOK: query: CREATE DATABASE tv2 +PREHOOK: type: CREATEDATABASE +PREHOOK: Output: database:tv2 +POSTHOOK: query: CREATE DATABASE tv2 +POSTHOOK: type: CREATEDATABASE +POSTHOOK: Output: database:tv2 PREHOOK: query: CREATE TABLE invites (foo INT, bar STRING) PARTITIONED BY (ds STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default @@ -6,53 +18,56 @@ POSTHOOK: query: CREATE TABLE invites (f POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@invites -PREHOOK: query: CREATE VIEW view1 as SELECT * FROM invites +PREHOOK: query: CREATE VIEW tv1.view1 as SELECT * FROM invites PREHOOK: type: CREATEVIEW PREHOOK: Input: default@invites -POSTHOOK: query: CREATE VIEW view1 as SELECT * FROM invites +PREHOOK: Output: database:tv1 +PREHOOK: Output: tv1@view1 +POSTHOOK: query: CREATE VIEW tv1.view1 as SELECT * FROM invites POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@invites -POSTHOOK: Output: default@view1 -PREHOOK: query: DESCRIBE EXTENDED view1 +POSTHOOK: Output: database:tv1 +POSTHOOK: Output: tv1@view1 +PREHOOK: query: DESCRIBE EXTENDED tv1.view1 PREHOOK: type: DESCTABLE -PREHOOK: Input: default@view1 -POSTHOOK: query: DESCRIBE EXTENDED view1 +PREHOOK: Input: tv1@view1 +POSTHOOK: query: DESCRIBE EXTENDED tv1.view1 POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@view1 +POSTHOOK: Input: tv1@view1 foo int bar string ds string #### A masked pattern was here #### -PREHOOK: query: ALTER VIEW view1 RENAME TO view2 +PREHOOK: query: ALTER VIEW tv1.view1 RENAME TO tv2.view2 PREHOOK: type: ALTERVIEW_RENAME -PREHOOK: Input: default@view1 -PREHOOK: Output: default@view1 -POSTHOOK: query: ALTER VIEW view1 RENAME TO view2 +PREHOOK: Input: tv1@view1 +PREHOOK: Output: tv1@view1 +POSTHOOK: query: ALTER VIEW tv1.view1 RENAME TO tv2.view2 POSTHOOK: type: ALTERVIEW_RENAME -POSTHOOK: Input: default@view1 -POSTHOOK: Output: default@view1 -POSTHOOK: Output: default@view2 -PREHOOK: query: DESCRIBE EXTENDED view2 +POSTHOOK: Input: tv1@view1 +POSTHOOK: Output: tv1@view1 +POSTHOOK: Output: tv2@view2 +PREHOOK: query: DESCRIBE EXTENDED tv2.view2 PREHOOK: type: DESCTABLE -PREHOOK: Input: default@view2 -POSTHOOK: query: DESCRIBE EXTENDED view2 +PREHOOK: Input: tv2@view2 +POSTHOOK: query: DESCRIBE EXTENDED tv2.view2 POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@view2 +POSTHOOK: Input: tv2@view2 foo int bar string ds string #### A masked pattern was here #### -PREHOOK: query: SELECT * FROM view2 +PREHOOK: query: SELECT * FROM tv2.view2 PREHOOK: type: QUERY PREHOOK: Input: default@invites -PREHOOK: Input: default@view2 +PREHOOK: Input: tv2@view2 #### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM view2 +POSTHOOK: query: SELECT * FROM tv2.view2 POSTHOOK: type: QUERY POSTHOOK: Input: default@invites -POSTHOOK: Input: default@view2 +POSTHOOK: Input: tv2@view2 #### A masked pattern was here #### PREHOOK: query: DROP TABLE invites PREHOOK: type: DROPTABLE @@ -62,11 +77,27 @@ POSTHOOK: query: DROP TABLE invites POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@invites POSTHOOK: Output: default@invites -PREHOOK: query: DROP VIEW view2 +PREHOOK: query: DROP VIEW tv2.view2 PREHOOK: type: DROPVIEW -PREHOOK: Input: default@view2 -PREHOOK: Output: default@view2 -POSTHOOK: query: DROP VIEW view2 +PREHOOK: Input: tv2@view2 +PREHOOK: Output: tv2@view2 +POSTHOOK: query: DROP VIEW tv2.view2 POSTHOOK: type: DROPVIEW -POSTHOOK: Input: default@view2 -POSTHOOK: Output: default@view2 +POSTHOOK: Input: tv2@view2 +POSTHOOK: Output: tv2@view2 +PREHOOK: query: DROP DATABASE tv1 +PREHOOK: type: DROPDATABASE +PREHOOK: Input: database:tv1 +PREHOOK: Output: database:tv1 +POSTHOOK: query: DROP DATABASE tv1 +POSTHOOK: type: DROPDATABASE +POSTHOOK: Input: database:tv1 +POSTHOOK: Output: database:tv1 +PREHOOK: query: DROP DATABASE tv2 +PREHOOK: type: DROPDATABASE +PREHOOK: Input: database:tv2 +PREHOOK: Output: database:tv2 +POSTHOOK: query: DROP DATABASE tv2 +POSTHOOK: type: DROPDATABASE +POSTHOOK: Input: database:tv2 +POSTHOOK: Output: database:tv2
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_part.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_part.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_part.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/annotate_stats_part.q.out Thu Aug 28 03:15:13 2014 @@ -366,14 +366,14 @@ STAGE PLANS: Map Operator Tree: TableScan alias: loc_orc - Statistics: Num rows: 8 Data size: 724 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 8 Data size: 724 Basic stats: COMPLETE Column stats: PARTIAL Select Operator expressions: state (type: string) outputColumnNames: _col0 - Statistics: Num rows: 8 Data size: 688 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 8 Data size: 688 Basic stats: COMPLETE Column stats: PARTIAL File Output Operator compressed: false - Statistics: Num rows: 8 Data size: 688 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 8 Data size: 688 Basic stats: COMPLETE Column stats: PARTIAL table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -403,14 +403,14 @@ STAGE PLANS: Map Operator Tree: TableScan alias: loc_orc - Statistics: Num rows: 8 Data size: 724 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 8 Data size: 724 Basic stats: COMPLETE Column stats: PARTIAL Select Operator expressions: state (type: string), locid (type: int) outputColumnNames: _col0, _col1 - Statistics: Num rows: 8 Data size: 720 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 8 Data size: 720 Basic stats: COMPLETE Column stats: PARTIAL File Output Operator compressed: false - Statistics: Num rows: 8 Data size: 720 Basic stats: COMPLETE Column stats: COMPLETE + Statistics: Num rows: 8 Data size: 720 Basic stats: COMPLETE Column stats: PARTIAL table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Modified: hive/branches/cbo/ql/src/test/results/clientpositive/archive_multi.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/archive_multi.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/archive_multi.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/archive_multi.q.out Thu Aug 28 03:15:13 2014 @@ -1,161 +1,159 @@ -PREHOOK: query: drop table tstsrc -PREHOOK: type: DROPTABLE -POSTHOOK: query: drop table tstsrc -POSTHOOK: type: DROPTABLE -PREHOOK: query: drop table tstsrcpart -PREHOOK: type: DROPTABLE -POSTHOOK: query: drop table tstsrcpart -POSTHOOK: type: DROPTABLE -PREHOOK: query: create table tstsrc like src +PREHOOK: query: create database ac_test +PREHOOK: type: CREATEDATABASE +PREHOOK: Output: database:ac_test +POSTHOOK: query: create database ac_test +POSTHOOK: type: CREATEDATABASE +POSTHOOK: Output: database:ac_test +PREHOOK: query: create table ac_test.tstsrc like default.src PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@tstsrc -POSTHOOK: query: create table tstsrc like src +PREHOOK: Output: ac_test@tstsrc +PREHOOK: Output: database:ac_test +POSTHOOK: query: create table ac_test.tstsrc like default.src POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@tstsrc -PREHOOK: query: insert overwrite table tstsrc select key, value from src +POSTHOOK: Output: ac_test@tstsrc +POSTHOOK: Output: database:ac_test +PREHOOK: query: insert overwrite table ac_test.tstsrc select key, value from default.src PREHOOK: type: QUERY PREHOOK: Input: default@src -PREHOOK: Output: default@tstsrc -POSTHOOK: query: insert overwrite table tstsrc select key, value from src +PREHOOK: Output: ac_test@tstsrc +POSTHOOK: query: insert overwrite table ac_test.tstsrc select key, value from default.src POSTHOOK: type: QUERY POSTHOOK: Input: default@src -POSTHOOK: Output: default@tstsrc +POSTHOOK: Output: ac_test@tstsrc POSTHOOK: Lineage: tstsrc.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: tstsrc.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: create table tstsrcpart like srcpart +PREHOOK: query: create table ac_test.tstsrcpart like default.srcpart PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@tstsrcpart -POSTHOOK: query: create table tstsrcpart like srcpart +PREHOOK: Output: ac_test@tstsrcpart +PREHOOK: Output: database:ac_test +POSTHOOK: query: create table ac_test.tstsrcpart like default.srcpart POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@tstsrcpart -PREHOOK: query: insert overwrite table tstsrcpart partition (ds='2008-04-08', hr='11') -select key, value from srcpart where ds='2008-04-08' and hr='11' +POSTHOOK: Output: ac_test@tstsrcpart +POSTHOOK: Output: database:ac_test +PREHOOK: query: insert overwrite table ac_test.tstsrcpart partition (ds='2008-04-08', hr='11') +select key, value from default.srcpart where ds='2008-04-08' and hr='11' PREHOOK: type: QUERY PREHOOK: Input: default@srcpart PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -PREHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=11 -POSTHOOK: query: insert overwrite table tstsrcpart partition (ds='2008-04-08', hr='11') -select key, value from srcpart where ds='2008-04-08' and hr='11' +PREHOOK: Output: ac_test@tstsrcpart@ds=2008-04-08/hr=11 +POSTHOOK: query: insert overwrite table ac_test.tstsrcpart partition (ds='2008-04-08', hr='11') +select key, value from default.srcpart where ds='2008-04-08' and hr='11' POSTHOOK: type: QUERY POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -POSTHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=11 +POSTHOOK: Output: ac_test@tstsrcpart@ds=2008-04-08/hr=11 POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: insert overwrite table tstsrcpart partition (ds='2008-04-08', hr='12') -select key, value from srcpart where ds='2008-04-08' and hr='12' +PREHOOK: query: insert overwrite table ac_test.tstsrcpart partition (ds='2008-04-08', hr='12') +select key, value from default.srcpart where ds='2008-04-08' and hr='12' PREHOOK: type: QUERY PREHOOK: Input: default@srcpart PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 -PREHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=12 -POSTHOOK: query: insert overwrite table tstsrcpart partition (ds='2008-04-08', hr='12') -select key, value from srcpart where ds='2008-04-08' and hr='12' +PREHOOK: Output: ac_test@tstsrcpart@ds=2008-04-08/hr=12 +POSTHOOK: query: insert overwrite table ac_test.tstsrcpart partition (ds='2008-04-08', hr='12') +select key, value from default.srcpart where ds='2008-04-08' and hr='12' POSTHOOK: type: QUERY POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 -POSTHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=12 +POSTHOOK: Output: ac_test@tstsrcpart@ds=2008-04-08/hr=12 POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-08,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: insert overwrite table tstsrcpart partition (ds='2008-04-09', hr='11') -select key, value from srcpart where ds='2008-04-09' and hr='11' +PREHOOK: query: insert overwrite table ac_test.tstsrcpart partition (ds='2008-04-09', hr='11') +select key, value from default.srcpart where ds='2008-04-09' and hr='11' PREHOOK: type: QUERY PREHOOK: Input: default@srcpart PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 -PREHOOK: Output: default@tstsrcpart@ds=2008-04-09/hr=11 -POSTHOOK: query: insert overwrite table tstsrcpart partition (ds='2008-04-09', hr='11') -select key, value from srcpart where ds='2008-04-09' and hr='11' +PREHOOK: Output: ac_test@tstsrcpart@ds=2008-04-09/hr=11 +POSTHOOK: query: insert overwrite table ac_test.tstsrcpart partition (ds='2008-04-09', hr='11') +select key, value from default.srcpart where ds='2008-04-09' and hr='11' POSTHOOK: type: QUERY POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11 -POSTHOOK: Output: default@tstsrcpart@ds=2008-04-09/hr=11 +POSTHOOK: Output: ac_test@tstsrcpart@ds=2008-04-09/hr=11 POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: insert overwrite table tstsrcpart partition (ds='2008-04-09', hr='12') -select key, value from srcpart where ds='2008-04-09' and hr='12' +PREHOOK: query: insert overwrite table ac_test.tstsrcpart partition (ds='2008-04-09', hr='12') +select key, value from default.srcpart where ds='2008-04-09' and hr='12' PREHOOK: type: QUERY PREHOOK: Input: default@srcpart PREHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 -PREHOOK: Output: default@tstsrcpart@ds=2008-04-09/hr=12 -POSTHOOK: query: insert overwrite table tstsrcpart partition (ds='2008-04-09', hr='12') -select key, value from srcpart where ds='2008-04-09' and hr='12' +PREHOOK: Output: ac_test@tstsrcpart@ds=2008-04-09/hr=12 +POSTHOOK: query: insert overwrite table ac_test.tstsrcpart partition (ds='2008-04-09', hr='12') +select key, value from default.srcpart where ds='2008-04-09' and hr='12' POSTHOOK: type: QUERY POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 -POSTHOOK: Output: default@tstsrcpart@ds=2008-04-09/hr=12 +POSTHOOK: Output: ac_test@tstsrcpart@ds=2008-04-09/hr=12 POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ] POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ] PREHOOK: query: -- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19) SELECT SUM(hash(col)) FROM (SELECT transform(*) using 'tr "\t" "_"' AS col -FROM (SELECT * FROM tstsrcpart WHERE ds='2008-04-08') subq1) subq2 +FROM (SELECT * FROM ac_test.tstsrcpart WHERE ds='2008-04-08') subq1) subq2 PREHOOK: type: QUERY -PREHOOK: Input: default@tstsrcpart -PREHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=11 -PREHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=12 +PREHOOK: Input: ac_test@tstsrcpart +PREHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=11 +PREHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=12 #### A masked pattern was here #### POSTHOOK: query: -- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19) SELECT SUM(hash(col)) FROM (SELECT transform(*) using 'tr "\t" "_"' AS col -FROM (SELECT * FROM tstsrcpart WHERE ds='2008-04-08') subq1) subq2 +FROM (SELECT * FROM ac_test.tstsrcpart WHERE ds='2008-04-08') subq1) subq2 POSTHOOK: type: QUERY -POSTHOOK: Input: default@tstsrcpart -POSTHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=11 -POSTHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=12 +POSTHOOK: Input: ac_test@tstsrcpart +POSTHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=11 +POSTHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=12 #### A masked pattern was here #### 48479881068 -PREHOOK: query: ALTER TABLE tstsrcpart ARCHIVE PARTITION (ds='2008-04-08') +PREHOOK: query: ALTER TABLE ac_test.tstsrcpart ARCHIVE PARTITION (ds='2008-04-08') PREHOOK: type: ALTERTABLE_ARCHIVE -PREHOOK: Input: default@tstsrcpart -PREHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=11 -PREHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=12 -POSTHOOK: query: ALTER TABLE tstsrcpart ARCHIVE PARTITION (ds='2008-04-08') +PREHOOK: Input: ac_test@tstsrcpart +PREHOOK: Output: ac_test@tstsrcpart@ds=2008-04-08/hr=11 +PREHOOK: Output: ac_test@tstsrcpart@ds=2008-04-08/hr=12 +POSTHOOK: query: ALTER TABLE ac_test.tstsrcpart ARCHIVE PARTITION (ds='2008-04-08') POSTHOOK: type: ALTERTABLE_ARCHIVE -POSTHOOK: Input: default@tstsrcpart -POSTHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=11 -POSTHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=12 +POSTHOOK: Input: ac_test@tstsrcpart +POSTHOOK: Output: ac_test@tstsrcpart@ds=2008-04-08/hr=11 +POSTHOOK: Output: ac_test@tstsrcpart@ds=2008-04-08/hr=12 PREHOOK: query: SELECT SUM(hash(col)) FROM (SELECT transform(*) using 'tr "\t" "_"' AS col -FROM (SELECT * FROM tstsrcpart WHERE ds='2008-04-08') subq1) subq2 +FROM (SELECT * FROM ac_test.tstsrcpart WHERE ds='2008-04-08') subq1) subq2 PREHOOK: type: QUERY -PREHOOK: Input: default@tstsrcpart -PREHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=11 -PREHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=12 +PREHOOK: Input: ac_test@tstsrcpart +PREHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=11 +PREHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=12 #### A masked pattern was here #### POSTHOOK: query: SELECT SUM(hash(col)) FROM (SELECT transform(*) using 'tr "\t" "_"' AS col -FROM (SELECT * FROM tstsrcpart WHERE ds='2008-04-08') subq1) subq2 +FROM (SELECT * FROM ac_test.tstsrcpart WHERE ds='2008-04-08') subq1) subq2 POSTHOOK: type: QUERY -POSTHOOK: Input: default@tstsrcpart -POSTHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=11 -POSTHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=12 +POSTHOOK: Input: ac_test@tstsrcpart +POSTHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=11 +POSTHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=12 #### A masked pattern was here #### 48479881068 -PREHOOK: query: SELECT key, count(1) FROM tstsrcpart WHERE ds='2008-04-08' AND hr='12' AND key='0' GROUP BY key +PREHOOK: query: SELECT key, count(1) FROM ac_test.tstsrcpart WHERE ds='2008-04-08' AND hr='12' AND key='0' GROUP BY key PREHOOK: type: QUERY -PREHOOK: Input: default@tstsrcpart -PREHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=12 +PREHOOK: Input: ac_test@tstsrcpart +PREHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=12 #### A masked pattern was here #### -POSTHOOK: query: SELECT key, count(1) FROM tstsrcpart WHERE ds='2008-04-08' AND hr='12' AND key='0' GROUP BY key +POSTHOOK: query: SELECT key, count(1) FROM ac_test.tstsrcpart WHERE ds='2008-04-08' AND hr='12' AND key='0' GROUP BY key POSTHOOK: type: QUERY -POSTHOOK: Input: default@tstsrcpart -POSTHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=12 +POSTHOOK: Input: ac_test@tstsrcpart +POSTHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=12 #### A masked pattern was here #### 0 3 -PREHOOK: query: SELECT * FROM tstsrcpart a JOIN tstsrc b ON a.key=b.key +PREHOOK: query: SELECT * FROM ac_test.tstsrcpart a JOIN ac_test.tstsrc b ON a.key=b.key WHERE a.ds='2008-04-08' AND a.hr='12' AND a.key='0' PREHOOK: type: QUERY -PREHOOK: Input: default@tstsrc -PREHOOK: Input: default@tstsrcpart -PREHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=12 +PREHOOK: Input: ac_test@tstsrc +PREHOOK: Input: ac_test@tstsrcpart +PREHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=12 #### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM tstsrcpart a JOIN tstsrc b ON a.key=b.key +POSTHOOK: query: SELECT * FROM ac_test.tstsrcpart a JOIN ac_test.tstsrc b ON a.key=b.key WHERE a.ds='2008-04-08' AND a.hr='12' AND a.key='0' POSTHOOK: type: QUERY -POSTHOOK: Input: default@tstsrc -POSTHOOK: Input: default@tstsrcpart -POSTHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=12 +POSTHOOK: Input: ac_test@tstsrc +POSTHOOK: Input: ac_test@tstsrcpart +POSTHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=12 #### A masked pattern was here #### 0 val_0 2008-04-08 12 0 val_0 0 val_0 2008-04-08 12 0 val_0 @@ -166,28 +164,28 @@ POSTHOOK: Input: default@tstsrcpart@ds=2 0 val_0 2008-04-08 12 0 val_0 0 val_0 2008-04-08 12 0 val_0 0 val_0 2008-04-08 12 0 val_0 -PREHOOK: query: ALTER TABLE tstsrcpart UNARCHIVE PARTITION (ds='2008-04-08') +PREHOOK: query: ALTER TABLE ac_test.tstsrcpart UNARCHIVE PARTITION (ds='2008-04-08') PREHOOK: type: ALTERTABLE_UNARCHIVE -PREHOOK: Input: default@tstsrcpart -PREHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=11 -PREHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=12 -POSTHOOK: query: ALTER TABLE tstsrcpart UNARCHIVE PARTITION (ds='2008-04-08') +PREHOOK: Input: ac_test@tstsrcpart +PREHOOK: Output: ac_test@tstsrcpart@ds=2008-04-08/hr=11 +PREHOOK: Output: ac_test@tstsrcpart@ds=2008-04-08/hr=12 +POSTHOOK: query: ALTER TABLE ac_test.tstsrcpart UNARCHIVE PARTITION (ds='2008-04-08') POSTHOOK: type: ALTERTABLE_UNARCHIVE -POSTHOOK: Input: default@tstsrcpart -POSTHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=11 -POSTHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=12 +POSTHOOK: Input: ac_test@tstsrcpart +POSTHOOK: Output: ac_test@tstsrcpart@ds=2008-04-08/hr=11 +POSTHOOK: Output: ac_test@tstsrcpart@ds=2008-04-08/hr=12 PREHOOK: query: SELECT SUM(hash(col)) FROM (SELECT transform(*) using 'tr "\t" "_"' AS col -FROM (SELECT * FROM tstsrcpart WHERE ds='2008-04-08') subq1) subq2 +FROM (SELECT * FROM ac_test.tstsrcpart WHERE ds='2008-04-08') subq1) subq2 PREHOOK: type: QUERY -PREHOOK: Input: default@tstsrcpart -PREHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=11 -PREHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=12 +PREHOOK: Input: ac_test@tstsrcpart +PREHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=11 +PREHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=12 #### A masked pattern was here #### POSTHOOK: query: SELECT SUM(hash(col)) FROM (SELECT transform(*) using 'tr "\t" "_"' AS col -FROM (SELECT * FROM tstsrcpart WHERE ds='2008-04-08') subq1) subq2 +FROM (SELECT * FROM ac_test.tstsrcpart WHERE ds='2008-04-08') subq1) subq2 POSTHOOK: type: QUERY -POSTHOOK: Input: default@tstsrcpart -POSTHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=11 -POSTHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=12 +POSTHOOK: Input: ac_test@tstsrcpart +POSTHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=11 +POSTHOOK: Input: ac_test@tstsrcpart@ds=2008-04-08/hr=12 #### A masked pattern was here #### 48479881068 Modified: hive/branches/cbo/ql/src/test/results/clientpositive/authorization_1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/authorization_1.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/authorization_1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/authorization_1.q.out Thu Aug 28 03:15:13 2014 @@ -3,11 +3,14 @@ PREHOOK: query: -- SORT_BEFORE_DIFF create table src_autho_test as select * from src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@src_autho_test POSTHOOK: query: -- SORT_BEFORE_DIFF create table src_autho_test as select * from src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@src_autho_test PREHOOK: query: --table grant to user Modified: hive/branches/cbo/ql/src/test/results/clientpositive/authorization_2.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/authorization_2.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/authorization_2.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/authorization_2.q.out Thu Aug 28 03:15:13 2014 @@ -13,9 +13,12 @@ POSTHOOK: Output: default@authorization_ PREHOOK: query: create table src_auth_tmp as select * from src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@src_auth_tmp POSTHOOK: query: create table src_auth_tmp as select * from src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@src_auth_tmp PREHOOK: query: ALTER TABLE authorization_part SET TBLPROPERTIES ("PARTITION_LEVEL_PRIVILEGE"="TRUE") PREHOOK: type: ALTERTABLE_PROPERTIES Modified: hive/branches/cbo/ql/src/test/results/clientpositive/authorization_3.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/authorization_3.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/authorization_3.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/authorization_3.q.out Thu Aug 28 03:15:13 2014 @@ -3,11 +3,14 @@ PREHOOK: query: -- SORT_BEFORE_DIFF create table src_autho_test as select * from src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@src_autho_test POSTHOOK: query: -- SORT_BEFORE_DIFF create table src_autho_test as select * from src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@src_autho_test PREHOOK: query: grant drop on table src_autho_test to user hive_test_user PREHOOK: type: GRANT_PRIVILEGE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/authorization_4.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/authorization_4.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/authorization_4.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/authorization_4.q.out Thu Aug 28 03:15:13 2014 @@ -3,11 +3,14 @@ PREHOOK: query: -- SORT_BEFORE_DIFF create table src_autho_test as select * from src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@src_autho_test POSTHOOK: query: -- SORT_BEFORE_DIFF create table src_autho_test as select * from src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@src_autho_test PREHOOK: query: grant All on table src_autho_test to user hive_test_user PREHOOK: type: GRANT_PRIVILEGE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/authorization_6.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/authorization_6.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/authorization_6.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/authorization_6.q.out Thu Aug 28 03:15:13 2014 @@ -3,11 +3,14 @@ PREHOOK: query: -- SORT_BEFORE_DIFF create table src_auth_tmp as select * from src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@src_auth_tmp POSTHOOK: query: -- SORT_BEFORE_DIFF create table src_auth_tmp as select * from src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@src_auth_tmp PREHOOK: query: create table authorization_part (key int, value string) partitioned by (ds string) PREHOOK: type: CREATETABLE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/authorization_8.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/authorization_8.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/authorization_8.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/authorization_8.q.out Thu Aug 28 03:15:13 2014 @@ -13,9 +13,12 @@ POSTHOOK: Output: default@tbl_j5jbymsx8e PREHOOK: query: CREATE VIEW view_j5jbymsx8e_1 as SELECT * FROM tbl_j5jbymsx8e PREHOOK: type: CREATEVIEW PREHOOK: Input: default@tbl_j5jbymsx8e +PREHOOK: Output: database:default +PREHOOK: Output: default@view_j5jbymsx8e_1 POSTHOOK: query: CREATE VIEW view_j5jbymsx8e_1 as SELECT * FROM tbl_j5jbymsx8e POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@tbl_j5jbymsx8e +POSTHOOK: Output: database:default POSTHOOK: Output: default@view_j5jbymsx8e_1 PREHOOK: query: DESCRIBE view_j5jbymsx8e_1 PREHOOK: type: DESCTABLE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/authorization_cli_createtab.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/authorization_cli_createtab.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/authorization_cli_createtab.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/authorization_cli_createtab.q.out Thu Aug 28 03:15:13 2014 @@ -23,9 +23,12 @@ default t_cli hive_test_user USER UPDA PREHOOK: query: create view v_cli (i) as select i from t_cli PREHOOK: type: CREATEVIEW PREHOOK: Input: default@t_cli +PREHOOK: Output: database:default +PREHOOK: Output: default@v_cli POSTHOOK: query: create view v_cli (i) as select i from t_cli POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@t_cli +POSTHOOK: Output: database:default POSTHOOK: Output: default@v_cli PREHOOK: query: show grant user hive_test_user on v_cli PREHOOK: type: SHOW_GRANT Modified: hive/branches/cbo/ql/src/test/results/clientpositive/authorization_create_temp_table.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/authorization_create_temp_table.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/authorization_create_temp_table.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/authorization_create_temp_table.q.out Thu Aug 28 03:15:13 2014 @@ -1,9 +1,12 @@ PREHOOK: query: create table authorization_create_temp_table_1 as select * from src limit 10 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@authorization_create_temp_table_1 POSTHOOK: query: create table authorization_create_temp_table_1 as select * from src limit 10 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@authorization_create_temp_table_1 PREHOOK: query: grant select on authorization_create_temp_table_1 to user user1 PREHOOK: type: GRANT_PRIVILEGE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/authorization_owner_actions.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/authorization_owner_actions.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/authorization_owner_actions.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/authorization_owner_actions.q.out Thu Aug 28 03:15:13 2014 @@ -35,9 +35,12 @@ POSTHOOK: Output: default@t1 PREHOOK: query: create view vt1 as select * from t1 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@t1 +PREHOOK: Output: database:default +PREHOOK: Output: default@vt1 POSTHOOK: query: create view vt1 as select * from t1 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@t1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@vt1 PREHOOK: query: drop view vt1 PREHOOK: type: DROPVIEW Modified: hive/branches/cbo/ql/src/test/results/clientpositive/authorization_view_sqlstd.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/authorization_view_sqlstd.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/authorization_view_sqlstd.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/authorization_view_sqlstd.q.out Thu Aug 28 03:15:13 2014 @@ -22,19 +22,25 @@ PREHOOK: query: -- protecting certain co create view vt1 as select i,k from t1 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@t1 +PREHOOK: Output: database:default +PREHOOK: Output: default@vt1 POSTHOOK: query: -- protecting certain columns create view vt1 as select i,k from t1 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@t1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@vt1 PREHOOK: query: -- protecting certain rows create view vt2 as select * from t1 where i > 1 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@t1 +PREHOOK: Output: database:default +PREHOOK: Output: default@vt2 POSTHOOK: query: -- protecting certain rows create view vt2 as select * from t1 where i > 1 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@t1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@vt2 PREHOOK: query: show grant user user1 on all PREHOOK: type: SHOW_GRANT Modified: hive/branches/cbo/ql/src/test/results/clientpositive/autogen_colalias.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/autogen_colalias.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/autogen_colalias.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/autogen_colalias.q.out Thu Aug 28 03:15:13 2014 @@ -10,12 +10,15 @@ PREHOOK: query: create table dest_groupe from src group by src.key PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@dest_grouped_old1 POSTHOOK: query: create table dest_grouped_old1 as select 1+1, 2+2 as zz, src.key, test_max(length(src.value)), count(src.value), sin(count(src.value)), count(sin(src.value)), unix_timestamp(), CAST(SUM(IF(value > 10, value, 1)) AS INT), if(src.key > 1, 1, 0) from src group by src.key POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@dest_grouped_old1 PREHOOK: query: describe dest_grouped_old1 PREHOOK: type: DESCTABLE @@ -36,9 +39,12 @@ _c9 int PREHOOK: query: create table dest_grouped_old2 as select distinct src.key from src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@dest_grouped_old2 POSTHOOK: query: create table dest_grouped_old2 as select distinct src.key from src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@dest_grouped_old2 PREHOOK: query: describe dest_grouped_old2 PREHOOK: type: DESCTABLE @@ -53,12 +59,15 @@ PREHOOK: query: create table dest_groupe from src group by src.key PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@dest_grouped_new1 POSTHOOK: query: create table dest_grouped_new1 as select 1+1, 2+2 as zz, ((src.key % 2)+2)/2, test_max(length(src.value)), count(src.value), sin(count(src.value)), count(sin(src.value)), unix_timestamp(), CAST(SUM(IF(value > 10, value, 1)) AS INT), if(src.key > 10, (src.key +5) % 2, 0) from src group by src.key POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@dest_grouped_new1 PREHOOK: query: describe dest_grouped_new1 PREHOOK: type: DESCTABLE @@ -79,9 +88,12 @@ if_src_key_10_src_ke_9 double PREHOOK: query: create table dest_grouped_new2 as select distinct src.key from src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@dest_grouped_new2 POSTHOOK: query: create table dest_grouped_new2 as select distinct src.key from src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@dest_grouped_new2 PREHOOK: query: describe dest_grouped_new2 PREHOOK: type: DESCTABLE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/cbo_correctness.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/cbo_correctness.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/cbo_correctness.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/cbo_correctness.q.out Thu Aug 28 03:15:13 2014 @@ -153,9 +153,12 @@ POSTHOOK: Output: default@lineitem PREHOOK: query: create table src_cbo as select * from src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@src_cbo POSTHOOK: query: create table src_cbo as select * from src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@src_cbo PREHOOK: query: analyze table t1 partition (dt) compute statistics PREHOOK: type: QUERY @@ -16441,17 +16444,23 @@ PREHOOK: query: -- 10. Test views create view v1 as select c_int, value, c_boolean, dt from t1 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@t1 +PREHOOK: Output: database:default +PREHOOK: Output: default@v1 POSTHOOK: query: -- 10. Test views create view v1 as select c_int, value, c_boolean, dt from t1 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@t1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@v1 PREHOOK: query: create view v2 as select c_int, value from t2 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@t2 +PREHOOK: Output: database:default +PREHOOK: Output: default@v2 POSTHOOK: query: create view v2 as select c_int, value from t2 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@t2 +POSTHOOK: Output: database:default POSTHOOK: Output: default@v2 PREHOOK: query: select value from v1 where c_boolean=false PREHOOK: type: QUERY @@ -16535,10 +16544,13 @@ PREHOOK: query: create view v3 as select PREHOOK: type: CREATEVIEW PREHOOK: Input: default@t1 PREHOOK: Input: default@v1 +PREHOOK: Output: database:default +PREHOOK: Output: default@v3 POSTHOOK: query: create view v3 as select v1.value val from v1 join t1 on v1.c_boolean = t1.c_boolean POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@t1 POSTHOOK: Input: default@v1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@v3 PREHOOK: query: select count(val) from v3 where val != '1' PREHOOK: type: QUERY @@ -16588,11 +16600,14 @@ with q1 as ( select key,c_int from t1 w select * from q1 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@t1 +PREHOOK: Output: database:default +PREHOOK: Output: default@v4 POSTHOOK: query: create view v4 as with q1 as ( select key,c_int from t1 where key = '1') select * from q1 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@t1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@v4 PREHOOK: query: with q1 as ( select c_int from q2 where c_boolean = false), q2 as ( select c_int,c_boolean from v1 where value = '1') @@ -18781,6 +18796,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_cbo +PREHOOK: Output: database:default +PREHOOK: Output: default@cv1 POSTHOOK: query: -- 19. SubQueries Exists -- view test create view cv1 as @@ -18792,6 +18809,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_cbo +POSTHOOK: Output: database:default POSTHOOK: Output: default@cv1 PREHOOK: query: select * from cv1 PREHOOK: type: QUERY Modified: hive/branches/cbo/ql/src/test/results/clientpositive/char_nested_types.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/char_nested_types.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/char_nested_types.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/char_nested_types.q.out Thu Aug 28 03:15:13 2014 @@ -164,11 +164,14 @@ create table char_nested_cta as select * from char_nested_struct PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@char_nested_struct +PREHOOK: Output: database:default +PREHOOK: Output: default@char_nested_cta POSTHOOK: query: -- nested type with create table as create table char_nested_cta as select * from char_nested_struct POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@char_nested_struct +POSTHOOK: Output: database:default POSTHOOK: Output: default@char_nested_cta PREHOOK: query: describe char_nested_cta PREHOOK: type: DESCTABLE @@ -191,11 +194,14 @@ create table char_nested_view as select * from char_nested_struct PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@char_nested_struct +PREHOOK: Output: database:default +PREHOOK: Output: default@char_nested_view POSTHOOK: query: -- nested type with view create table char_nested_view as select * from char_nested_struct POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@char_nested_struct +POSTHOOK: Output: database:default POSTHOOK: Output: default@char_nested_view PREHOOK: query: describe char_nested_view PREHOOK: type: DESCTABLE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/colstats_all_nulls.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/colstats_all_nulls.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/colstats_all_nulls.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/colstats_all_nulls.q.out Thu Aug 28 03:15:13 2014 @@ -17,9 +17,12 @@ POSTHOOK: Output: default@src_null PREHOOK: query: create table all_nulls as SELECT a, cast(a as double) as b, cast(a as decimal) as c FROM src_null where a is null limit 5 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src_null +PREHOOK: Output: database:default +PREHOOK: Output: default@all_nulls POSTHOOK: query: create table all_nulls as SELECT a, cast(a as double) as b, cast(a as decimal) as c FROM src_null where a is null limit 5 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src_null +POSTHOOK: Output: database:default POSTHOOK: Output: default@all_nulls PREHOOK: query: analyze table all_nulls compute statistics for columns PREHOOK: type: QUERY Modified: hive/branches/cbo/ql/src/test/results/clientpositive/create_big_view.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/create_big_view.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/create_big_view.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/create_big_view.q.out Thu Aug 28 03:15:13 2014 @@ -243,6 +243,8 @@ CREATE VIEW big_view AS SELECT FROM src PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@big_view POSTHOOK: query: -- Define a view with long SQL text to test metastore and other limits. CREATE VIEW big_view AS SELECT @@ -484,6 +486,7 @@ CREATE VIEW big_view AS SELECT FROM src POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@big_view PREHOOK: query: SELECT a FROM big_view LIMIT 1 Modified: hive/branches/cbo/ql/src/test/results/clientpositive/create_default_prop.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/create_default_prop.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/create_default_prop.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/create_default_prop.q.out Thu Aug 28 03:15:13 2014 @@ -35,9 +35,12 @@ a string PREHOOK: query: CREATE TABLE table_p3 AS SELECT * FROM table_p1 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@table_p1 +PREHOOK: Output: database:default +PREHOOK: Output: default@table_p3 POSTHOOK: query: CREATE TABLE table_p3 AS SELECT * FROM table_p1 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@table_p1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@table_p3 PREHOOK: query: DESC EXTENDED table_p3 PREHOOK: type: DESCTABLE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/create_like_tbl_props.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/create_like_tbl_props.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/create_like_tbl_props.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/create_like_tbl_props.q.out Thu Aug 28 03:15:13 2014 @@ -181,11 +181,14 @@ PREHOOK: query: --Test that CREATE TALBE CREATE VIEW test_view (key, value) AS SELECT * FROM src PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@test_view POSTHOOK: query: --Test that CREATE TALBE LIKE on a view can take explicit table properties CREATE VIEW test_view (key, value) AS SELECT * FROM src POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@test_view PREHOOK: query: CREATE TABLE test_table4 LIKE test_view TBLPROPERTIES('key'='value') PREHOOK: type: CREATETABLE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/create_like_view.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/create_like_view.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/create_like_view.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/create_like_view.q.out Thu Aug 28 03:15:13 2014 @@ -68,9 +68,12 @@ Storage Desc Params: PREHOOK: query: CREATE VIEW view1 AS SELECT * FROM table1 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@table1 +PREHOOK: Output: database:default +PREHOOK: Output: default@view1 POSTHOOK: query: CREATE VIEW view1 AS SELECT * FROM table1 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@table1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@view1 PREHOOK: query: CREATE TABLE table2 LIKE view1 PREHOOK: type: CREATETABLE @@ -242,10 +245,13 @@ PREHOOK: query: -- check partitions create view view1 partitioned on (ds, hr) as select * from srcpart PREHOOK: type: CREATEVIEW PREHOOK: Input: default@srcpart +PREHOOK: Output: database:default +PREHOOK: Output: default@view1 POSTHOOK: query: -- check partitions create view view1 partitioned on (ds, hr) as select * from srcpart POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@srcpart +POSTHOOK: Output: database:default POSTHOOK: Output: default@view1 PREHOOK: query: create table table1 like view1 PREHOOK: type: CREATETABLE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/create_or_replace_view.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/create_or_replace_view.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/create_or_replace_view.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/create_or_replace_view.q.out Thu Aug 28 03:15:13 2014 @@ -1,20 +1,25 @@ -PREHOOK: query: drop view v -PREHOOK: type: DROPVIEW -POSTHOOK: query: drop view v -POSTHOOK: type: DROPVIEW -PREHOOK: query: create view v as select * from srcpart +PREHOOK: query: create database vt +PREHOOK: type: CREATEDATABASE +PREHOOK: Output: database:vt +POSTHOOK: query: create database vt +POSTHOOK: type: CREATEDATABASE +POSTHOOK: Output: database:vt +PREHOOK: query: create view vt.v as select * from srcpart PREHOOK: type: CREATEVIEW PREHOOK: Input: default@srcpart -POSTHOOK: query: create view v as select * from srcpart +PREHOOK: Output: database:vt +PREHOOK: Output: vt@v +POSTHOOK: query: create view vt.v as select * from srcpart POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@srcpart -POSTHOOK: Output: default@v -PREHOOK: query: describe formatted v +POSTHOOK: Output: database:vt +POSTHOOK: Output: vt@v +PREHOOK: query: describe formatted vt.v PREHOOK: type: DESCTABLE -PREHOOK: Input: default@v -POSTHOOK: query: describe formatted v +PREHOOK: Input: vt@v +POSTHOOK: query: describe formatted vt.v POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@v +POSTHOOK: Input: vt@v # col_name data_type comment key string @@ -23,7 +28,7 @@ ds string hr string # Detailed Table Information -Database: default +Database: vt #### A masked pattern was here #### Protect Mode: None Retention: 0 @@ -44,61 +49,64 @@ Sort Columns: [] View Original Text: select * from srcpart View Expanded Text: select `srcpart`.`key`, `srcpart`.`value`, `srcpart`.`ds`, `srcpart`.`hr` from `default`.`srcpart` PREHOOK: query: -- modifying definition of unpartitioned view -create or replace view v partitioned on (ds, hr) as select * from srcpart +create or replace view vt.v partitioned on (ds, hr) as select * from srcpart PREHOOK: type: CREATEVIEW PREHOOK: Input: default@srcpart +PREHOOK: Output: database:vt +PREHOOK: Output: vt@v POSTHOOK: query: -- modifying definition of unpartitioned view -create or replace view v partitioned on (ds, hr) as select * from srcpart +create or replace view vt.v partitioned on (ds, hr) as select * from srcpart POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@srcpart -POSTHOOK: Output: default@v -PREHOOK: query: alter view v add partition (ds='2008-04-08',hr='11') +POSTHOOK: Output: database:vt +POSTHOOK: Output: vt@v +PREHOOK: query: alter view vt.v add partition (ds='2008-04-08',hr='11') PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Input: default@srcpart PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -PREHOOK: Input: default@v -PREHOOK: Output: default@v -POSTHOOK: query: alter view v add partition (ds='2008-04-08',hr='11') +PREHOOK: Input: vt@v +PREHOOK: Output: vt@v +POSTHOOK: query: alter view vt.v add partition (ds='2008-04-08',hr='11') POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -POSTHOOK: Input: default@v -POSTHOOK: Output: default@v -POSTHOOK: Output: default@v@ds=2008-04-08/hr=11 -PREHOOK: query: alter view v add partition (ds='2008-04-08',hr='12') +POSTHOOK: Input: vt@v +POSTHOOK: Output: vt@v +POSTHOOK: Output: vt@v@ds=2008-04-08/hr=11 +PREHOOK: query: alter view vt.v add partition (ds='2008-04-08',hr='12') PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Input: default@srcpart PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 -PREHOOK: Input: default@v -PREHOOK: Output: default@v -POSTHOOK: query: alter view v add partition (ds='2008-04-08',hr='12') +PREHOOK: Input: vt@v +PREHOOK: Output: vt@v +POSTHOOK: query: alter view vt.v add partition (ds='2008-04-08',hr='12') POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 -POSTHOOK: Input: default@v -POSTHOOK: Output: default@v -POSTHOOK: Output: default@v@ds=2008-04-08/hr=12 -PREHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11' +POSTHOOK: Input: vt@v +POSTHOOK: Output: vt@v +POSTHOOK: Output: vt@v@ds=2008-04-08/hr=12 +PREHOOK: query: select * from vt.v where value='val_409' and ds='2008-04-08' and hr='11' PREHOOK: type: QUERY PREHOOK: Input: default@srcpart PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -PREHOOK: Input: default@v +PREHOOK: Input: vt@v #### A masked pattern was here #### -POSTHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11' +POSTHOOK: query: select * from vt.v where value='val_409' and ds='2008-04-08' and hr='11' POSTHOOK: type: QUERY POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -POSTHOOK: Input: default@v +POSTHOOK: Input: vt@v #### A masked pattern was here #### 409 val_409 2008-04-08 11 409 val_409 2008-04-08 11 409 val_409 2008-04-08 11 -PREHOOK: query: describe formatted v +PREHOOK: query: describe formatted vt.v PREHOOK: type: DESCTABLE -PREHOOK: Input: default@v -POSTHOOK: query: describe formatted v +PREHOOK: Input: vt@v +POSTHOOK: query: describe formatted vt.v POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@v +POSTHOOK: Input: vt@v # col_name data_type comment key string @@ -111,7 +119,7 @@ ds string hr string # Detailed Table Information -Database: default +Database: vt #### A masked pattern was here #### Protect Mode: None Retention: 0 @@ -131,44 +139,69 @@ Sort Columns: [] # View Information View Original Text: select * from srcpart View Expanded Text: select `srcpart`.`key`, `srcpart`.`value`, `srcpart`.`ds`, `srcpart`.`hr` from `default`.`srcpart` -PREHOOK: query: show partitions v +PREHOOK: query: show partitions vt.v PREHOOK: type: SHOWPARTITIONS -PREHOOK: Input: default@v -POSTHOOK: query: show partitions v +PREHOOK: Input: vt@v +POSTHOOK: query: show partitions vt.v POSTHOOK: type: SHOWPARTITIONS -POSTHOOK: Input: default@v +POSTHOOK: Input: vt@v ds=2008-04-08/hr=11 ds=2008-04-08/hr=12 +PREHOOK: query: alter view vt.v drop partition (ds='2008-04-08',hr='11') +PREHOOK: type: ALTERTABLE_DROPPARTS +PREHOOK: Input: vt@v +PREHOOK: Output: vt@v@ds=2008-04-08/hr=11 +POSTHOOK: query: alter view vt.v drop partition (ds='2008-04-08',hr='11') +POSTHOOK: type: ALTERTABLE_DROPPARTS +POSTHOOK: Input: vt@v +POSTHOOK: Output: vt@v@ds=2008-04-08/hr=11 +PREHOOK: query: alter view vt.v drop partition (ds='2008-04-08',hr='12') +PREHOOK: type: ALTERTABLE_DROPPARTS +PREHOOK: Input: vt@v +PREHOOK: Output: vt@v@ds=2008-04-08/hr=12 +POSTHOOK: query: alter view vt.v drop partition (ds='2008-04-08',hr='12') +POSTHOOK: type: ALTERTABLE_DROPPARTS +POSTHOOK: Input: vt@v +POSTHOOK: Output: vt@v@ds=2008-04-08/hr=12 +PREHOOK: query: show partitions vt.v +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: vt@v +POSTHOOK: query: show partitions vt.v +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: vt@v PREHOOK: query: -- altering partitioned view 1 -create or replace view v partitioned on (ds, hr) as select value, ds, hr from srcpart +create or replace view vt.v partitioned on (ds, hr) as select value, ds, hr from srcpart PREHOOK: type: CREATEVIEW PREHOOK: Input: default@srcpart +PREHOOK: Output: database:vt +PREHOOK: Output: vt@v POSTHOOK: query: -- altering partitioned view 1 -create or replace view v partitioned on (ds, hr) as select value, ds, hr from srcpart +create or replace view vt.v partitioned on (ds, hr) as select value, ds, hr from srcpart POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@srcpart -POSTHOOK: Output: default@v -PREHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11' +POSTHOOK: Output: database:vt +POSTHOOK: Output: vt@v +PREHOOK: query: select * from vt.v where value='val_409' and ds='2008-04-08' and hr='11' PREHOOK: type: QUERY PREHOOK: Input: default@srcpart PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -PREHOOK: Input: default@v +PREHOOK: Input: vt@v #### A masked pattern was here #### -POSTHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11' +POSTHOOK: query: select * from vt.v where value='val_409' and ds='2008-04-08' and hr='11' POSTHOOK: type: QUERY POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -POSTHOOK: Input: default@v +POSTHOOK: Input: vt@v #### A masked pattern was here #### val_409 2008-04-08 11 val_409 2008-04-08 11 val_409 2008-04-08 11 -PREHOOK: query: describe formatted v +PREHOOK: query: describe formatted vt.v PREHOOK: type: DESCTABLE -PREHOOK: Input: default@v -POSTHOOK: query: describe formatted v +PREHOOK: Input: vt@v +POSTHOOK: query: describe formatted vt.v POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@v +POSTHOOK: Input: vt@v # col_name data_type comment value string @@ -180,7 +213,7 @@ ds string hr string # Detailed Table Information -Database: default +Database: vt #### A masked pattern was here #### Protect Mode: None Retention: 0 @@ -200,44 +233,45 @@ Sort Columns: [] # View Information View Original Text: select value, ds, hr from srcpart View Expanded Text: select `srcpart`.`value`, `srcpart`.`ds`, `srcpart`.`hr` from `default`.`srcpart` -PREHOOK: query: show partitions v +PREHOOK: query: show partitions vt.v PREHOOK: type: SHOWPARTITIONS -PREHOOK: Input: default@v -POSTHOOK: query: show partitions v +PREHOOK: Input: vt@v +POSTHOOK: query: show partitions vt.v POSTHOOK: type: SHOWPARTITIONS -POSTHOOK: Input: default@v -ds=2008-04-08/hr=11 -ds=2008-04-08/hr=12 +POSTHOOK: Input: vt@v PREHOOK: query: -- altering partitioned view 2 -create or replace view v partitioned on (ds, hr) as select key, value, ds, hr from srcpart +create or replace view vt.v partitioned on (ds, hr) as select key, value, ds, hr from srcpart PREHOOK: type: CREATEVIEW PREHOOK: Input: default@srcpart +PREHOOK: Output: database:vt +PREHOOK: Output: vt@v POSTHOOK: query: -- altering partitioned view 2 -create or replace view v partitioned on (ds, hr) as select key, value, ds, hr from srcpart +create or replace view vt.v partitioned on (ds, hr) as select key, value, ds, hr from srcpart POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@srcpart -POSTHOOK: Output: default@v -PREHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11' +POSTHOOK: Output: database:vt +POSTHOOK: Output: vt@v +PREHOOK: query: select * from vt.v where value='val_409' and ds='2008-04-08' and hr='11' PREHOOK: type: QUERY PREHOOK: Input: default@srcpart PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -PREHOOK: Input: default@v +PREHOOK: Input: vt@v #### A masked pattern was here #### -POSTHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11' +POSTHOOK: query: select * from vt.v where value='val_409' and ds='2008-04-08' and hr='11' POSTHOOK: type: QUERY POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -POSTHOOK: Input: default@v +POSTHOOK: Input: vt@v #### A masked pattern was here #### 409 val_409 2008-04-08 11 409 val_409 2008-04-08 11 409 val_409 2008-04-08 11 -PREHOOK: query: describe formatted v +PREHOOK: query: describe formatted vt.v PREHOOK: type: DESCTABLE -PREHOOK: Input: default@v -POSTHOOK: query: describe formatted v +PREHOOK: Input: vt@v +POSTHOOK: query: describe formatted vt.v POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@v +POSTHOOK: Input: vt@v # col_name data_type comment key string @@ -250,7 +284,7 @@ ds string hr string # Detailed Table Information -Database: default +Database: vt #### A masked pattern was here #### Protect Mode: None Retention: 0 @@ -270,22 +304,20 @@ Sort Columns: [] # View Information View Original Text: select key, value, ds, hr from srcpart View Expanded Text: select `srcpart`.`key`, `srcpart`.`value`, `srcpart`.`ds`, `srcpart`.`hr` from `default`.`srcpart` -PREHOOK: query: show partitions v +PREHOOK: query: show partitions vt.v PREHOOK: type: SHOWPARTITIONS -PREHOOK: Input: default@v -POSTHOOK: query: show partitions v +PREHOOK: Input: vt@v +POSTHOOK: query: show partitions vt.v POSTHOOK: type: SHOWPARTITIONS -POSTHOOK: Input: default@v -ds=2008-04-08/hr=11 -ds=2008-04-08/hr=12 -PREHOOK: query: drop view v +POSTHOOK: Input: vt@v +PREHOOK: query: drop view vt.v PREHOOK: type: DROPVIEW -PREHOOK: Input: default@v -PREHOOK: Output: default@v -POSTHOOK: query: drop view v +PREHOOK: Input: vt@v +PREHOOK: Output: vt@v +POSTHOOK: query: drop view vt.v POSTHOOK: type: DROPVIEW -POSTHOOK: Input: default@v -POSTHOOK: Output: default@v +POSTHOOK: Input: vt@v +POSTHOOK: Output: vt@v PREHOOK: query: -- updating to fix view with invalid definition create table srcpart_temp like srcpart PREHOOK: type: CREATETABLE @@ -296,13 +328,16 @@ create table srcpart_temp like srcpart POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@srcpart_temp -PREHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart_temp +PREHOOK: query: create view vt.v partitioned on (ds, hr) as select * from srcpart_temp PREHOOK: type: CREATEVIEW PREHOOK: Input: default@srcpart_temp -POSTHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart_temp +PREHOOK: Output: database:vt +PREHOOK: Output: vt@v +POSTHOOK: query: create view vt.v partitioned on (ds, hr) as select * from srcpart_temp POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@srcpart_temp -POSTHOOK: Output: default@v +POSTHOOK: Output: database:vt +POSTHOOK: Output: vt@v PREHOOK: query: drop table srcpart_temp PREHOOK: type: DROPTABLE PREHOOK: Input: default@srcpart_temp @@ -311,21 +346,24 @@ POSTHOOK: query: drop table srcpart_temp POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@srcpart_temp POSTHOOK: Output: default@srcpart_temp -PREHOOK: query: -- v is now invalid -create or replace view v partitioned on (ds, hr) as select * from srcpart +PREHOOK: query: -- vt.v is now invalid +create or replace view vt.v partitioned on (ds, hr) as select * from srcpart PREHOOK: type: CREATEVIEW PREHOOK: Input: default@srcpart -POSTHOOK: query: -- v is now invalid -create or replace view v partitioned on (ds, hr) as select * from srcpart +PREHOOK: Output: database:vt +PREHOOK: Output: vt@v +POSTHOOK: query: -- vt.v is now invalid +create or replace view vt.v partitioned on (ds, hr) as select * from srcpart POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@srcpart -POSTHOOK: Output: default@v -PREHOOK: query: describe formatted v +POSTHOOK: Output: database:vt +POSTHOOK: Output: vt@v +PREHOOK: query: describe formatted vt.v PREHOOK: type: DESCTABLE -PREHOOK: Input: default@v -POSTHOOK: query: describe formatted v +PREHOOK: Input: vt@v +POSTHOOK: query: describe formatted vt.v POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@v +POSTHOOK: Input: vt@v # col_name data_type comment key string @@ -338,7 +376,7 @@ ds string hr string # Detailed Table Information -Database: default +Database: vt #### A masked pattern was here #### Protect Mode: None Retention: 0 @@ -358,11 +396,19 @@ Sort Columns: [] # View Information View Original Text: select * from srcpart View Expanded Text: select `srcpart`.`key`, `srcpart`.`value`, `srcpart`.`ds`, `srcpart`.`hr` from `default`.`srcpart` -PREHOOK: query: drop view v +PREHOOK: query: drop view vt.v PREHOOK: type: DROPVIEW -PREHOOK: Input: default@v -PREHOOK: Output: default@v -POSTHOOK: query: drop view v +PREHOOK: Input: vt@v +PREHOOK: Output: vt@v +POSTHOOK: query: drop view vt.v POSTHOOK: type: DROPVIEW -POSTHOOK: Input: default@v -POSTHOOK: Output: default@v +POSTHOOK: Input: vt@v +POSTHOOK: Output: vt@v +PREHOOK: query: drop database vt +PREHOOK: type: DROPDATABASE +PREHOOK: Input: database:vt +PREHOOK: Output: database:vt +POSTHOOK: query: drop database vt +POSTHOOK: type: DROPDATABASE +POSTHOOK: Input: database:vt +POSTHOOK: Output: database:vt Modified: hive/branches/cbo/ql/src/test/results/clientpositive/create_union_table.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/create_union_table.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/create_union_table.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/create_union_table.q.out Thu Aug 28 03:15:13 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: abc + name: default.abc PREHOOK: query: create table abc(mydata uniontype<int,double,array<string>,struct<a:int,b:string>>, strct struct<a:int, b:string, c:string>) Modified: hive/branches/cbo/ql/src/test/results/clientpositive/create_view.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/create_view.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/create_view.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/create_view.q.out Thu Aug 28 03:15:13 2014 @@ -86,27 +86,36 @@ POSTHOOK: Input: default@src PREHOOK: query: CREATE VIEW view1 AS SELECT value FROM src WHERE key=86 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view1 POSTHOOK: query: CREATE VIEW view1 AS SELECT value FROM src WHERE key=86 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view1 PREHOOK: query: CREATE VIEW view2 AS SELECT * FROM src PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view2 POSTHOOK: query: CREATE VIEW view2 AS SELECT * FROM src POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view2 PREHOOK: query: CREATE VIEW view3(valoo) TBLPROPERTIES ("fear" = "factor") AS SELECT upper(value) FROM src WHERE key=86 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view3 POSTHOOK: query: CREATE VIEW view3(valoo) TBLPROPERTIES ("fear" = "factor") AS SELECT upper(value) FROM src WHERE key=86 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view3 PREHOOK: query: SELECT * from view1 PREHOOK: type: QUERY @@ -159,8 +168,8 @@ STAGE PLANS: Create View or replace: false columns: valoo string - expanded text: SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `default`.`src` WHERE `src`.`key`=86) `view0` - name: view0 + expanded text: SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `default`.`src` WHERE `src`.`key`=86) `default.view0` + name: default.view0 original text: SELECT upper(value) FROM src WHERE key=86 PREHOOK: query: -- make sure EXPLAIN works with a query which references a view @@ -354,7 +363,7 @@ Sort Columns: [] # View Information View Original Text: SELECT upper(value) FROM src WHERE key=86 -View Expanded Text: SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `default`.`src` WHERE `src`.`key`=86) `view3` +View Expanded Text: SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `default`.`src` WHERE `src`.`key`=86) `default.view3` PREHOOK: query: ALTER VIEW view3 SET TBLPROPERTIES ("biggest" = "loser") PREHOOK: type: ALTERVIEW_PROPERTIES PREHOOK: Input: default@view3 @@ -404,7 +413,7 @@ Sort Columns: [] # View Information View Original Text: SELECT upper(value) FROM src WHERE key=86 -View Expanded Text: SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `default`.`src` WHERE `src`.`key`=86) `view3` +View Expanded Text: SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `default`.`src` WHERE `src`.`key`=86) `default.view3` PREHOOK: query: CREATE TABLE table1 (key int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default @@ -470,9 +479,12 @@ POSTHOOK: Input: default@table1 PREHOOK: query: CREATE VIEW view4 AS SELECT * FROM table1 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@table1 +PREHOOK: Output: database:default +PREHOOK: Output: default@view4 POSTHOOK: query: CREATE VIEW view4 AS SELECT * FROM table1 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@table1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@view4 PREHOOK: query: SELECT * FROM view4 PREHOOK: type: QUERY @@ -540,11 +552,14 @@ FROM view4 v1 join view4 v2 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@table1 PREHOOK: Input: default@view4 +PREHOOK: Output: database:default +PREHOOK: Output: default@view5 POSTHOOK: query: CREATE VIEW view5 AS SELECT v1.key as key1, v2.key as key2 FROM view4 v1 join view4 v2 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@table1 POSTHOOK: Input: default@view4 +POSTHOOK: Output: database:default POSTHOOK: Output: default@view5 Warning: Shuffle Join JOIN[6][tables = [v1, v2]] in Stage 'Stage-1:MAPRED' is a cross product PREHOOK: query: SELECT * FROM view5 @@ -574,12 +589,15 @@ CREATE VIEW view6(valoo COMMENT 'I canno SELECT upper(value) as blarg FROM src WHERE key=86 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view6 POSTHOOK: query: -- verify that column name and comment in DDL portion -- overrides column alias in SELECT CREATE VIEW view6(valoo COMMENT 'I cannot spell') AS SELECT upper(value) as blarg FROM src WHERE key=86 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view6 PREHOOK: query: DESCRIBE view6 PREHOOK: type: DESCTABLE @@ -596,6 +614,8 @@ ORDER BY key, value LIMIT 10 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view7 POSTHOOK: query: -- verify that ORDER BY and LIMIT are both supported in view def CREATE VIEW view7 AS SELECT * FROM src @@ -604,6 +624,7 @@ ORDER BY key, value LIMIT 10 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view7 PREHOOK: query: SELECT * FROM view7 PREHOOK: type: QUERY @@ -705,11 +726,14 @@ SELECT test_translate('abc', 'a', 'b') FROM table1 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@table1 +PREHOOK: Output: database:default +PREHOOK: Output: default@view8 POSTHOOK: query: CREATE VIEW view8(c) AS SELECT test_translate('abc', 'a', 'b') FROM table1 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@table1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@view8 PREHOOK: query: DESCRIBE EXTENDED view8 PREHOOK: type: DESCTABLE @@ -721,7 +745,7 @@ c string #### A masked pattern was here #### FROM table1, viewExpandedText:SELECT `_c0` AS `c` FROM (SELECT `test_translate`('abc', 'a', 'b') -FROM `default`.`table1`) `view8`, tableType:VIRTUAL_VIEW) +FROM `default`.`table1`) `default.view8`, tableType:VIRTUAL_VIEW) PREHOOK: query: DESCRIBE FORMATTED view8 PREHOOK: type: DESCTABLE PREHOOK: Input: default@view8 @@ -754,7 +778,7 @@ Sort Columns: [] View Original Text: SELECT test_translate('abc', 'a', 'b') FROM table1 View Expanded Text: SELECT `_c0` AS `c` FROM (SELECT `test_translate`('abc', 'a', 'b') -FROM `default`.`table1`) `view8` +FROM `default`.`table1`) `default.view8` PREHOOK: query: SELECT * FROM view8 PREHOOK: type: QUERY PREHOOK: Input: default@table1 @@ -782,12 +806,15 @@ SELECT test_max(length(value)) FROM src PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view9 POSTHOOK: query: -- disable map-side aggregation CREATE VIEW view9(m) AS SELECT test_max(length(value)) FROM src POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view9 PREHOOK: query: DESCRIBE EXTENDED view9 PREHOOK: type: DESCTABLE @@ -799,7 +826,7 @@ m int #### A masked pattern was here #### FROM src, viewExpandedText:SELECT `_c0` AS `m` FROM (SELECT `test_max`(length(`src`.`value`)) -FROM `default`.`src`) `view9`, tableType:VIRTUAL_VIEW) +FROM `default`.`src`) `default.view9`, tableType:VIRTUAL_VIEW) PREHOOK: query: DESCRIBE FORMATTED view9 PREHOOK: type: DESCTABLE PREHOOK: Input: default@view9 @@ -832,7 +859,7 @@ Sort Columns: [] View Original Text: SELECT test_max(length(value)) FROM src View Expanded Text: SELECT `_c0` AS `m` FROM (SELECT `test_max`(length(`src`.`value`)) -FROM `default`.`src`) `view9` +FROM `default`.`src`) `default.view9` PREHOOK: query: SELECT * FROM view9 PREHOOK: type: QUERY PREHOOK: Input: default@src @@ -858,12 +885,15 @@ SELECT test_max(length(value)) FROM src PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view9 POSTHOOK: query: -- enable map-side aggregation CREATE VIEW view9(m) AS SELECT test_max(length(value)) FROM src POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view9 PREHOOK: query: DESCRIBE EXTENDED view9 PREHOOK: type: DESCTABLE @@ -875,7 +905,7 @@ m int #### A masked pattern was here #### FROM src, viewExpandedText:SELECT `_c0` AS `m` FROM (SELECT `test_max`(length(`src`.`value`)) -FROM `default`.`src`) `view9`, tableType:VIRTUAL_VIEW) +FROM `default`.`src`) `default.view9`, tableType:VIRTUAL_VIEW) PREHOOK: query: DESCRIBE FORMATTED view9 PREHOOK: type: DESCTABLE PREHOOK: Input: default@view9 @@ -908,7 +938,7 @@ Sort Columns: [] View Original Text: SELECT test_max(length(value)) FROM src View Expanded Text: SELECT `_c0` AS `m` FROM (SELECT `test_max`(length(`src`.`value`)) -FROM `default`.`src`) `view9` +FROM `default`.`src`) `default.view9` PREHOOK: query: SELECT * FROM view9 PREHOOK: type: QUERY PREHOOK: Input: default@src @@ -925,11 +955,14 @@ CREATE VIEW view10 AS SELECT slurp.* FROM (SELECT * FROM src WHERE key=86) slurp PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view10 POSTHOOK: query: -- test usage of a subselect within a view CREATE VIEW view10 AS SELECT slurp.* FROM (SELECT * FROM src WHERE key=86) slurp POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view10 PREHOOK: query: DESCRIBE EXTENDED view10 PREHOOK: type: DESCTABLE @@ -999,11 +1032,14 @@ SELECT test_explode(array(1,2,3)) AS (bo FROM table1 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@table1 +PREHOOK: Output: database:default +PREHOOK: Output: default@view11 POSTHOOK: query: CREATE VIEW view11 AS SELECT test_explode(array(1,2,3)) AS (boom) FROM table1 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@table1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@view11 PREHOOK: query: DESCRIBE EXTENDED view11 PREHOOK: type: DESCTABLE @@ -1067,11 +1103,14 @@ CREATE VIEW view12 AS SELECT * FROM src LATERAL VIEW explode(array(1,2,3)) myTable AS myCol PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view12 POSTHOOK: query: -- test usage of LATERAL within a view CREATE VIEW view12 AS SELECT * FROM src LATERAL VIEW explode(array(1,2,3)) myTable AS myCol POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view12 PREHOOK: query: DESCRIBE EXTENDED view12 PREHOOK: type: DESCTABLE @@ -1151,12 +1190,15 @@ SELECT s.key FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 ON key) s PREHOOK: type: CREATEVIEW PREHOOK: Input: default@srcbucket +PREHOOK: Output: database:default +PREHOOK: Output: default@view13 POSTHOOK: query: -- test usage of TABLESAMPLE within a view CREATE VIEW view13 AS SELECT s.key FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 ON key) s POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@srcbucket +POSTHOOK: Output: database:default POSTHOOK: Output: default@view13 PREHOOK: query: DESCRIBE EXTENDED view13 PREHOOK: type: DESCTABLE @@ -1240,6 +1282,8 @@ JOIN ON (unionsrc1.key = unionsrc2.key) PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view14 POSTHOOK: query: -- test usage of JOIN+UNION+AGG all within same view CREATE VIEW view14 AS SELECT unionsrc1.key as k1, unionsrc1.value as v1, @@ -1254,6 +1298,7 @@ JOIN ON (unionsrc1.key = unionsrc2.key) POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view14 PREHOOK: query: DESCRIBE EXTENDED view14 PREHOOK: type: DESCTABLE @@ -1379,6 +1424,8 @@ FROM src GROUP BY key PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view15 POSTHOOK: query: -- test usage of GROUP BY within view CREATE VIEW view15 AS SELECT key,COUNT(value) AS value_count @@ -1386,6 +1433,7 @@ FROM src GROUP BY key POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view15 PREHOOK: query: DESCRIBE EXTENDED view15 PREHOOK: type: DESCTABLE @@ -1467,12 +1515,15 @@ SELECT DISTINCT value FROM src PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view16 POSTHOOK: query: -- test usage of DISTINCT within view CREATE VIEW view16 AS SELECT DISTINCT value FROM src POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view16 PREHOOK: query: DESCRIBE EXTENDED view16 PREHOOK: type: DESCTABLE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/create_view_partitioned.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/create_view_partitioned.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/create_view_partitioned.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/create_view_partitioned.q.out Thu Aug 28 03:15:13 2014 @@ -20,6 +20,8 @@ FROM src WHERE key=86 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@vp1 POSTHOOK: query: -- test partitioned view definition -- (underlying table is not actually partitioned) CREATE VIEW vp1 @@ -30,6 +32,7 @@ FROM src WHERE key=86 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@vp1 PREHOOK: query: DESCRIBE EXTENDED vp1 PREHOOK: type: DESCTABLE @@ -245,6 +248,8 @@ PARTITIONED ON (hr) AS SELECT * FROM srcpart WHERE key < 10 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@srcpart +PREHOOK: Output: database:default +PREHOOK: Output: default@vp2 POSTHOOK: query: -- test a partitioned view on top of an underlying partitioned table, -- but with only a suffix of the partitioning columns CREATE VIEW vp2 @@ -252,6 +257,7 @@ PARTITIONED ON (hr) AS SELECT * FROM srcpart WHERE key < 10 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@srcpart +POSTHOOK: Output: database:default POSTHOOK: Output: default@vp2 PREHOOK: query: DESCRIBE FORMATTED vp2 PREHOOK: type: DESCTABLE @@ -355,6 +361,8 @@ FROM src WHERE key=86 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@vp3 POSTHOOK: query: -- test a partitioned view where the PARTITIONED ON clause references -- an imposed column name CREATE VIEW vp3(k,v) @@ -365,6 +373,7 @@ FROM src WHERE key=86 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@vp3 PREHOOK: query: DESCRIBE FORMATTED vp3 PREHOOK: type: DESCTABLE @@ -405,7 +414,7 @@ FROM src WHERE key=86 View Expanded Text: SELECT `key` AS `k`, `value` AS `v` FROM (SELECT `src`.`key`, `src`.`value` FROM `default`.`src` -WHERE `src`.`key`=86) `vp3` +WHERE `src`.`key`=86) `default.vp3` PREHOOK: query: ALTER VIEW vp3 ADD PARTITION (v='val_86') PREHOOK: type: ALTERTABLE_ADDPARTS Modified: hive/branches/cbo/ql/src/test/results/clientpositive/create_view_translate.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/create_view_translate.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/create_view_translate.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/create_view_translate.q.out Thu Aug 28 03:15:13 2014 @@ -9,9 +9,12 @@ POSTHOOK: type: DROPVIEW PREHOOK: query: create view v as select cast(key as string) from src PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@v POSTHOOK: query: create view v as select cast(key as string) from src POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@v PREHOOK: query: describe formatted v PREHOOK: type: DESCTABLE @@ -49,11 +52,14 @@ PREHOOK: query: create view w as select ) a PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@w POSTHOOK: query: create view w as select key, value from ( select key, value from src ) a POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@w PREHOOK: query: describe formatted w PREHOOK: type: DESCTABLE @@ -135,15 +141,18 @@ STAGE PLANS: or replace: false columns: id int, _c1 string expanded text: SELECT `items`.`id`, `items`.`info`['price'] FROM `default`.`items` - name: priceview + name: default.priceview original text: SELECT items.id, items.info['price'] FROM items PREHOOK: query: CREATE VIEW priceview AS SELECT items.id, items.info['price'] FROM items PREHOOK: type: CREATEVIEW PREHOOK: Input: default@items +PREHOOK: Output: database:default +PREHOOK: Output: default@priceview POSTHOOK: query: CREATE VIEW priceview AS SELECT items.id, items.info['price'] FROM items POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@items +POSTHOOK: Output: database:default POSTHOOK: Output: default@priceview PREHOOK: query: select * from priceview PREHOOK: type: QUERY Modified: hive/branches/cbo/ql/src/test/results/clientpositive/cross_product_check_1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/cross_product_check_1.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/cross_product_check_1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/cross_product_check_1.q.out Thu Aug 28 03:15:13 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 'Stage-1:MAPRED' is a cross product PREHOOK: query: explain select * from A join B