You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2014/08/28 05:15:19 UTC
svn commit: r1621031 [6/10] - in /hive/branches/cbo: ./
common/src/java/org/apache/hadoop/hive/conf/
contrib/src/test/results/clientnegative/
contrib/src/test/results/clientpositive/ data/files/
hbase-handler/src/test/results/negative/ hcatalog/core/sr...
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