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 [5/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/clientnegative/authorization_select_view.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/authorization_select_view.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/authorization_select_view.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/authorization_select_view.q.out Thu Aug 28 03:15:13 2014
@@ -11,8 +11,11 @@ POSTHOOK: Output: default@t1
 PREHOOK: query: create view v1 as select * from t1
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@t1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@v1
 POSTHOOK: query: create view v1 as select * from t1
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@t1
+POSTHOOK: Output: database:default
 POSTHOOK: Output: default@v1
 FAILED: HiveAccessControlException Permission denied: Principal [name=user1, type=USER] does not have following privileges for operation QUERY [[SELECT] on Object [type=TABLE_OR_VIEW, name=default.v1]]

Modified: hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view1.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view1.q.out Thu Aug 28 03:15:13 2014
@@ -9,9 +9,12 @@ POSTHOOK: type: DROPVIEW
 PREHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@srcpart
+PREHOOK: Output: database:default
+PREHOOK: Output: default@v
 POSTHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@srcpart
+POSTHOOK: Output: database:default
 POSTHOOK: Output: default@v
 PREHOOK: query: alter view v add partition (ds='1',hr='2')
 PREHOOK: type: ALTERTABLE_ADDPARTS
@@ -25,4 +28,4 @@ POSTHOOK: Input: default@v
 POSTHOOK: Output: default@v
 POSTHOOK: Output: default@v@ds=1/hr=2
 FAILED: SemanticException [Error 10217]: Cannot replace a view with CREATE VIEW or REPLACE VIEW or ALTER VIEW AS SELECT if the view has partitions
- The following view has partition, it could not be replaced: v
+ The following view has partition, it could not be replaced: default.v

Modified: hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view2.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view2.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view2.q.out Thu Aug 28 03:15:13 2014
@@ -9,9 +9,12 @@ POSTHOOK: type: DROPVIEW
 PREHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@srcpart
+PREHOOK: Output: database:default
+PREHOOK: Output: default@v
 POSTHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@srcpart
+POSTHOOK: Output: database:default
 POSTHOOK: Output: default@v
 PREHOOK: query: alter view v add partition (ds='1',hr='2')
 PREHOOK: type: ALTERTABLE_ADDPARTS
@@ -25,4 +28,4 @@ POSTHOOK: Input: default@v
 POSTHOOK: Output: default@v
 POSTHOOK: Output: default@v@ds=1/hr=2
 FAILED: SemanticException [Error 10217]: Cannot replace a view with CREATE VIEW or REPLACE VIEW or ALTER VIEW AS SELECT if the view has partitions
- The following view has partition, it could not be replaced: v
+ The following view has partition, it could not be replaced: default.v

Modified: hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view3.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view3.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view3.q.out Thu Aug 28 03:15:13 2014
@@ -1,2 +1,2 @@
 FAILED: SemanticException [Error 10218]: Existing table is not a view
- The following is an existing table, not a view: src
+ The following is an existing table, not a view: default.src

Modified: hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view4.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view4.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view4.q.out Thu Aug 28 03:15:13 2014
@@ -9,8 +9,11 @@ POSTHOOK: type: DROPVIEW
 PREHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@srcpart
+PREHOOK: Output: database:default
+PREHOOK: Output: default@v
 POSTHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@srcpart
+POSTHOOK: Output: database:default
 POSTHOOK: Output: default@v
 FAILED: SemanticException [Error 10092]: At least one non-partitioning column must be present in view

Modified: hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view5.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view5.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view5.q.out Thu Aug 28 03:15:13 2014
@@ -9,8 +9,11 @@ POSTHOOK: type: DROPVIEW
 PREHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@srcpart
+PREHOOK: Output: database:default
+PREHOOK: Output: default@v
 POSTHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@srcpart
+POSTHOOK: Output: database:default
 POSTHOOK: Output: default@v
 FAILED: SemanticException Can't combine IF NOT EXISTS and OR REPLACE.

Modified: hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view6.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view6.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view6.q.out Thu Aug 28 03:15:13 2014
@@ -9,8 +9,11 @@ POSTHOOK: type: DROPVIEW
 PREHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@srcpart
+PREHOOK: Output: database:default
+PREHOOK: Output: default@v
 POSTHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@srcpart
+POSTHOOK: Output: database:default
 POSTHOOK: Output: default@v
 FAILED: ParseException line 2:52 cannot recognize input near 'blah' '<EOF>' '<EOF>' in select clause

Modified: hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view7.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view7.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view7.q.out Thu Aug 28 03:15:13 2014
@@ -9,28 +9,37 @@ POSTHOOK: type: DROPVIEW
 PREHOOK: query: create view v1 partitioned on (ds, hr) as select * from srcpart
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@srcpart
+PREHOOK: Output: database:default
+PREHOOK: Output: default@v1
 POSTHOOK: query: create view v1 partitioned on (ds, hr) as select * from srcpart
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@srcpart
+POSTHOOK: Output: database:default
 POSTHOOK: Output: default@v1
 PREHOOK: query: create view v2 partitioned on (ds, hr) as select * from v1
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@srcpart
 PREHOOK: Input: default@v1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@v2
 POSTHOOK: query: create view v2 partitioned on (ds, hr) as select * from v1
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@srcpart
 POSTHOOK: Input: default@v1
+POSTHOOK: Output: database:default
 POSTHOOK: Output: default@v2
 PREHOOK: query: create view v3 partitioned on (ds, hr) as select * from v2
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@srcpart
 PREHOOK: Input: default@v1
 PREHOOK: Input: default@v2
+PREHOOK: Output: database:default
+PREHOOK: Output: default@v3
 POSTHOOK: query: create view v3 partitioned on (ds, hr) as select * from v2
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@srcpart
 POSTHOOK: Input: default@v1
 POSTHOOK: Input: default@v2
+POSTHOOK: Output: database:default
 POSTHOOK: Output: default@v3
 FAILED: SemanticException Recursive view default.v1 detected (cycle: default.v1 -> default.v3 -> default.v2 -> default.v1).

Modified: hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view8.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view8.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view8.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/create_or_replace_view8.q.out Thu Aug 28 03:15:13 2014
@@ -9,8 +9,11 @@ POSTHOOK: type: DROPVIEW
 PREHOOK: query: create view v1 partitioned on (ds, hr) as select * from srcpart
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@srcpart
+PREHOOK: Output: database:default
+PREHOOK: Output: default@v1
 POSTHOOK: query: create view v1 partitioned on (ds, hr) as select * from srcpart
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@srcpart
+POSTHOOK: Output: database:default
 POSTHOOK: Output: default@v1
 FAILED: SemanticException Recursive view default.v1 detected (cycle: default.v1 -> default.v1).

Modified: hive/branches/cbo/ql/src/test/results/clientnegative/create_view_failure1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/create_view_failure1.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/create_view_failure1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/create_view_failure1.q.out Thu Aug 28 03:15:13 2014
@@ -15,4 +15,6 @@ POSTHOOK: Output: default@xxx12
 PREHOOK: query: CREATE VIEW xxx12 AS SELECT key FROM src
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@xxx12
 FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. AlreadyExistsException(message:Table xxx12 already exists)

Modified: hive/branches/cbo/ql/src/test/results/clientnegative/create_view_failure2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/create_view_failure2.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/create_view_failure2.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/create_view_failure2.q.out Thu Aug 28 03:15:13 2014
@@ -6,10 +6,13 @@ PREHOOK: query: -- views and tables shar
 CREATE VIEW xxx4 AS SELECT key FROM src
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@xxx4
 POSTHOOK: query: -- views and tables share the same namespace
 CREATE VIEW xxx4 AS SELECT key FROM src
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
 POSTHOOK: Output: default@xxx4
 PREHOOK: query: CREATE TABLE xxx4(key int)
 PREHOOK: type: CREATETABLE

Modified: hive/branches/cbo/ql/src/test/results/clientnegative/create_view_failure4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/create_view_failure4.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/create_view_failure4.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/create_view_failure4.q.out Thu Aug 28 03:15:13 2014
@@ -7,4 +7,6 @@ CREATE VIEW xxx5(x,x) AS
 SELECT key,value FROM src
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@xxx5
 FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. org.apache.hadoop.hive.ql.metadata.HiveException: Duplicate column name x in the table definition.

Modified: hive/branches/cbo/ql/src/test/results/clientnegative/desc_failure3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/desc_failure3.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/desc_failure3.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/desc_failure3.q.out Thu Aug 28 03:15:13 2014
@@ -7,10 +7,9 @@ POSTHOOK: Output: database:db1
 PREHOOK: query: CREATE TABLE db1.t1(key1 INT, value1 STRING) PARTITIONED BY (ds STRING, part STRING)
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:db1
-PREHOOK: Output: db1@db1.t1
+PREHOOK: Output: db1@t1
 POSTHOOK: query: CREATE TABLE db1.t1(key1 INT, value1 STRING) PARTITIONED BY (ds STRING, part STRING)
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: database:db1
-POSTHOOK: Output: db1@db1.t1
 POSTHOOK: Output: db1@t1
 FAILED: SemanticException [Error 10004]: Invalid table alias or column reference db1.t1.key1

Modified: hive/branches/cbo/ql/src/test/results/clientnegative/drop_table_failure2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/drop_table_failure2.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/drop_table_failure2.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/drop_table_failure2.q.out Thu Aug 28 03:15:13 2014
@@ -1,9 +1,12 @@
 PREHOOK: query: CREATE VIEW xxx6 AS SELECT key FROM src
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@xxx6
 POSTHOOK: query: CREATE VIEW xxx6 AS SELECT key FROM src
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
 POSTHOOK: Output: default@xxx6
 PREHOOK: query: -- Can't use DROP TABLE on a view
 DROP TABLE xxx6

Modified: hive/branches/cbo/ql/src/test/results/clientnegative/insert_view_failure.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/insert_view_failure.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/insert_view_failure.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/insert_view_failure.q.out Thu Aug 28 03:15:13 2014
@@ -5,8 +5,11 @@ POSTHOOK: type: DROPVIEW
 PREHOOK: query: CREATE VIEW xxx2 AS SELECT * FROM src
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@xxx2
 POSTHOOK: query: CREATE VIEW xxx2 AS SELECT * FROM src
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
 POSTHOOK: Output: default@xxx2
 FAILED: SemanticException [Error 10090]: A view cannot be used as target table for LOAD or INSERT

Modified: hive/branches/cbo/ql/src/test/results/clientnegative/invalidate_view1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/invalidate_view1.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/invalidate_view1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/invalidate_view1.q.out Thu Aug 28 03:15:13 2014
@@ -23,18 +23,24 @@ POSTHOOK: Output: default@xxx10
 PREHOOK: query: CREATE VIEW xxx9 AS SELECT * FROM xxx10
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@xxx10
+PREHOOK: Output: database:default
+PREHOOK: Output: default@xxx9
 POSTHOOK: query: CREATE VIEW xxx9 AS SELECT * FROM xxx10
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@xxx10
+POSTHOOK: Output: database:default
 POSTHOOK: Output: default@xxx9
 PREHOOK: query: CREATE VIEW xxx8 AS SELECT * FROM xxx9 xxx
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@xxx10
 PREHOOK: Input: default@xxx9
+PREHOOK: Output: database:default
+PREHOOK: Output: default@xxx8
 POSTHOOK: query: CREATE VIEW xxx8 AS SELECT * FROM xxx9 xxx
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@xxx10
 POSTHOOK: Input: default@xxx9
+POSTHOOK: Output: database:default
 POSTHOOK: Output: default@xxx8
 PREHOOK: query: ALTER TABLE xxx10 REPLACE COLUMNS (key int)
 PREHOOK: type: ALTERTABLE_REPLACECOLS

Modified: hive/branches/cbo/ql/src/test/results/clientnegative/load_view_failure.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/load_view_failure.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/load_view_failure.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/load_view_failure.q.out Thu Aug 28 03:15:13 2014
@@ -5,8 +5,11 @@ POSTHOOK: type: DROPVIEW
 PREHOOK: query: CREATE VIEW xxx11 AS SELECT * FROM src
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@xxx11
 POSTHOOK: query: CREATE VIEW xxx11 AS SELECT * FROM src
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
 POSTHOOK: Output: default@xxx11
 FAILED: SemanticException [Error 10090]: A view cannot be used as target table for LOAD or INSERT

Modified: hive/branches/cbo/ql/src/test/results/clientnegative/recursive_view.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/recursive_view.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/recursive_view.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/recursive_view.q.out Thu Aug 28 03:15:13 2014
@@ -33,29 +33,38 @@ POSTHOOK: Output: default@t
 PREHOOK: query: create view r0 as select * from t
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@t
+PREHOOK: Output: database:default
+PREHOOK: Output: default@r0
 POSTHOOK: query: create view r0 as select * from t
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@t
+POSTHOOK: Output: database:default
 POSTHOOK: Output: default@r0
 PREHOOK: query: create view r1 as select * from r0
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@r0
 PREHOOK: Input: default@t
+PREHOOK: Output: database:default
+PREHOOK: Output: default@r1
 POSTHOOK: query: create view r1 as select * from r0
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@r0
 POSTHOOK: Input: default@t
+POSTHOOK: Output: database:default
 POSTHOOK: Output: default@r1
 PREHOOK: query: create view r2 as select * from r1
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@r0
 PREHOOK: Input: default@r1
 PREHOOK: Input: default@t
+PREHOOK: Output: database:default
+PREHOOK: Output: default@r2
 POSTHOOK: query: create view r2 as select * from r1
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@r0
 POSTHOOK: Input: default@r1
 POSTHOOK: Input: default@t
+POSTHOOK: Output: database:default
 POSTHOOK: Output: default@r2
 PREHOOK: query: create view r3 as select * from r2
 PREHOOK: type: CREATEVIEW
@@ -63,12 +72,15 @@ PREHOOK: Input: default@r0
 PREHOOK: Input: default@r1
 PREHOOK: Input: default@r2
 PREHOOK: Input: default@t
+PREHOOK: Output: database:default
+PREHOOK: Output: default@r3
 POSTHOOK: query: create view r3 as select * from r2
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@r0
 POSTHOOK: Input: default@r1
 POSTHOOK: Input: default@r2
 POSTHOOK: Input: default@t
+POSTHOOK: Output: database:default
 POSTHOOK: Output: default@r3
 PREHOOK: query: drop view r0
 PREHOOK: type: DROPVIEW

Modified: hive/branches/cbo/ql/src/test/results/clientnegative/unset_view_property.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/unset_view_property.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientnegative/unset_view_property.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientnegative/unset_view_property.q.out Thu Aug 28 03:15:13 2014
@@ -1,9 +1,12 @@
 PREHOOK: query: CREATE VIEW testView AS SELECT value FROM src WHERE key=86
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@testView
 POSTHOOK: query: CREATE VIEW testView AS SELECT value FROM src WHERE key=86
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
 POSTHOOK: Output: default@testView
 PREHOOK: query: ALTER VIEW testView SET TBLPROPERTIES ('propA'='100', 'propB'='200')
 PREHOOK: type: ALTERVIEW_PROPERTIES

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/add_part_exist.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/add_part_exist.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/add_part_exist.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/add_part_exist.q.out Thu Aug 28 03:15:13 2014
@@ -99,85 +99,91 @@ POSTHOOK: query: -- Test ALTER TABLE ADD
 CREATE DATABASE add_part_test_db
 POSTHOOK: type: CREATEDATABASE
 POSTHOOK: Output: database:add_part_test_db
-PREHOOK: query: USE add_part_test_db
-PREHOOK: type: SWITCHDATABASE
-PREHOOK: Input: database:add_part_test_db
-POSTHOOK: query: USE add_part_test_db
-POSTHOOK: type: SWITCHDATABASE
-POSTHOOK: Input: database:add_part_test_db
-PREHOOK: query: SHOW TABLES
-PREHOOK: type: SHOWTABLES
-POSTHOOK: query: SHOW TABLES
-POSTHOOK: type: SHOWTABLES
-PREHOOK: query: CREATE TABLE add_part_test (key STRING, value STRING) PARTITIONED BY (ds STRING)
+PREHOOK: query: CREATE TABLE add_part_test_db.add_part_test (key STRING, value STRING) PARTITIONED BY (ds STRING)
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: add_part_test_db@add_part_test
 PREHOOK: Output: database:add_part_test_db
-POSTHOOK: query: CREATE TABLE add_part_test (key STRING, value STRING) PARTITIONED BY (ds STRING)
+POSTHOOK: query: CREATE TABLE add_part_test_db.add_part_test (key STRING, value STRING) PARTITIONED BY (ds STRING)
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: add_part_test_db@add_part_test
 POSTHOOK: Output: database:add_part_test_db
-PREHOOK: query: SHOW PARTITIONS add_part_test
+PREHOOK: query: SHOW PARTITIONS add_part_test_db.add_part_test
 PREHOOK: type: SHOWPARTITIONS
 PREHOOK: Input: add_part_test_db@add_part_test
-POSTHOOK: query: SHOW PARTITIONS add_part_test
+POSTHOOK: query: SHOW PARTITIONS add_part_test_db.add_part_test
 POSTHOOK: type: SHOWPARTITIONS
 POSTHOOK: Input: add_part_test_db@add_part_test
-PREHOOK: query: ALTER TABLE add_part_test ADD PARTITION (ds='2010-01-01')
+PREHOOK: query: ALTER TABLE add_part_test_db.add_part_test ADD PARTITION (ds='2010-01-01')
 PREHOOK: type: ALTERTABLE_ADDPARTS
 PREHOOK: Output: add_part_test_db@add_part_test
-POSTHOOK: query: ALTER TABLE add_part_test ADD PARTITION (ds='2010-01-01')
+POSTHOOK: query: ALTER TABLE add_part_test_db.add_part_test ADD PARTITION (ds='2010-01-01')
 POSTHOOK: type: ALTERTABLE_ADDPARTS
 POSTHOOK: Output: add_part_test_db@add_part_test
 POSTHOOK: Output: add_part_test_db@add_part_test@ds=2010-01-01
-PREHOOK: query: SHOW PARTITIONS add_part_test
+PREHOOK: query: SHOW PARTITIONS add_part_test_db.add_part_test
 PREHOOK: type: SHOWPARTITIONS
 PREHOOK: Input: add_part_test_db@add_part_test
-POSTHOOK: query: SHOW PARTITIONS add_part_test
+POSTHOOK: query: SHOW PARTITIONS add_part_test_db.add_part_test
 POSTHOOK: type: SHOWPARTITIONS
 POSTHOOK: Input: add_part_test_db@add_part_test
 ds=2010-01-01
-PREHOOK: query: ALTER TABLE add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-01')
+PREHOOK: query: ALTER TABLE add_part_test_db.add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-01')
 PREHOOK: type: ALTERTABLE_ADDPARTS
 PREHOOK: Output: add_part_test_db@add_part_test
-POSTHOOK: query: ALTER TABLE add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-01')
+POSTHOOK: query: ALTER TABLE add_part_test_db.add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-01')
 POSTHOOK: type: ALTERTABLE_ADDPARTS
 POSTHOOK: Output: add_part_test_db@add_part_test
-PREHOOK: query: SHOW PARTITIONS add_part_test
+PREHOOK: query: SHOW PARTITIONS add_part_test_db.add_part_test
 PREHOOK: type: SHOWPARTITIONS
 PREHOOK: Input: add_part_test_db@add_part_test
-POSTHOOK: query: SHOW PARTITIONS add_part_test
+POSTHOOK: query: SHOW PARTITIONS add_part_test_db.add_part_test
 POSTHOOK: type: SHOWPARTITIONS
 POSTHOOK: Input: add_part_test_db@add_part_test
 ds=2010-01-01
-PREHOOK: query: ALTER TABLE add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-02')
+PREHOOK: query: ALTER TABLE add_part_test_db.add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-02')
 PREHOOK: type: ALTERTABLE_ADDPARTS
 PREHOOK: Output: add_part_test_db@add_part_test
-POSTHOOK: query: ALTER TABLE add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-02')
+POSTHOOK: query: ALTER TABLE add_part_test_db.add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-02')
 POSTHOOK: type: ALTERTABLE_ADDPARTS
 POSTHOOK: Output: add_part_test_db@add_part_test
 POSTHOOK: Output: add_part_test_db@add_part_test@ds=2010-01-02
-PREHOOK: query: SHOW PARTITIONS add_part_test
+PREHOOK: query: SHOW PARTITIONS add_part_test_db.add_part_test
 PREHOOK: type: SHOWPARTITIONS
 PREHOOK: Input: add_part_test_db@add_part_test
-POSTHOOK: query: SHOW PARTITIONS add_part_test
+POSTHOOK: query: SHOW PARTITIONS add_part_test_db.add_part_test
 POSTHOOK: type: SHOWPARTITIONS
 POSTHOOK: Input: add_part_test_db@add_part_test
 ds=2010-01-01
 ds=2010-01-02
-PREHOOK: query: ALTER TABLE add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-01') PARTITION (ds='2010-01-02') PARTITION (ds='2010-01-03')
+PREHOOK: query: ALTER TABLE add_part_test_db.add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-01') PARTITION (ds='2010-01-02') PARTITION (ds='2010-01-03')
 PREHOOK: type: ALTERTABLE_ADDPARTS
 PREHOOK: Output: add_part_test_db@add_part_test
-POSTHOOK: query: ALTER TABLE add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-01') PARTITION (ds='2010-01-02') PARTITION (ds='2010-01-03')
+POSTHOOK: query: ALTER TABLE add_part_test_db.add_part_test ADD IF NOT EXISTS PARTITION (ds='2010-01-01') PARTITION (ds='2010-01-02') PARTITION (ds='2010-01-03')
 POSTHOOK: type: ALTERTABLE_ADDPARTS
 POSTHOOK: Output: add_part_test_db@add_part_test
 POSTHOOK: Output: add_part_test_db@add_part_test@ds=2010-01-03
-PREHOOK: query: SHOW PARTITIONS add_part_test
+PREHOOK: query: SHOW PARTITIONS add_part_test_db.add_part_test
 PREHOOK: type: SHOWPARTITIONS
 PREHOOK: Input: add_part_test_db@add_part_test
-POSTHOOK: query: SHOW PARTITIONS add_part_test
+POSTHOOK: query: SHOW PARTITIONS add_part_test_db.add_part_test
 POSTHOOK: type: SHOWPARTITIONS
 POSTHOOK: Input: add_part_test_db@add_part_test
 ds=2010-01-01
 ds=2010-01-02
 ds=2010-01-03
+PREHOOK: query: DROP TABLE add_part_test_db.add_part_test
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: add_part_test_db@add_part_test
+PREHOOK: Output: add_part_test_db@add_part_test
+POSTHOOK: query: DROP TABLE add_part_test_db.add_part_test
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: add_part_test_db@add_part_test
+POSTHOOK: Output: add_part_test_db@add_part_test
+PREHOOK: query: DROP DATABASE add_part_test_db
+PREHOOK: type: DROPDATABASE
+PREHOOK: Input: database:add_part_test_db
+PREHOOK: Output: database:add_part_test_db
+POSTHOOK: query: DROP DATABASE add_part_test_db
+POSTHOOK: type: DROPDATABASE
+POSTHOOK: Input: database:add_part_test_db
+POSTHOOK: Output: database:add_part_test_db

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/allcolref_in_udf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/allcolref_in_udf.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/allcolref_in_udf.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/allcolref_in_udf.q.out Thu Aug 28 03:15:13 2014
@@ -164,10 +164,13 @@ PREHOOK: query: -- HIVE-4181 TOK_FUNCTIO
 create table allcolref as select array(key, value) from src
 PREHOOK: type: CREATETABLE_AS_SELECT
 PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@allcolref
 POSTHOOK: query: -- HIVE-4181 TOK_FUNCTIONSTAR for UDTF
 create table allcolref as select array(key, value) from src
 POSTHOOK: type: CREATETABLE_AS_SELECT
 POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
 POSTHOOK: Output: default@allcolref
 PREHOOK: query: explain select explode(*) as x from allcolref limit 10
 PREHOOK: type: QUERY

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/alter1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/alter1.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/alter1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/alter1.q.out Thu Aug 28 03:15:13 2014
@@ -210,209 +210,197 @@ POSTHOOK: query: -- With non-default Dat
 CREATE DATABASE alter1_db
 POSTHOOK: type: CREATEDATABASE
 POSTHOOK: Output: database:alter1_db
-PREHOOK: query: USE alter1_db
-PREHOOK: type: SWITCHDATABASE
-PREHOOK: Input: database:alter1_db
-POSTHOOK: query: USE alter1_db
-POSTHOOK: type: SWITCHDATABASE
-POSTHOOK: Input: database:alter1_db
-PREHOOK: query: SHOW TABLES
+PREHOOK: query: SHOW TABLES alter1_db
 PREHOOK: type: SHOWTABLES
-POSTHOOK: query: SHOW TABLES
+POSTHOOK: query: SHOW TABLES alter1_db
 POSTHOOK: type: SHOWTABLES
-PREHOOK: query: CREATE TABLE alter1(a INT, b INT)
+PREHOOK: query: CREATE TABLE alter1_db.alter1(a INT, b INT)
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: alter1_db@alter1
 PREHOOK: Output: database:alter1_db
-POSTHOOK: query: CREATE TABLE alter1(a INT, b INT)
+POSTHOOK: query: CREATE TABLE alter1_db.alter1(a INT, b INT)
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: alter1_db@alter1
 POSTHOOK: Output: database:alter1_db
-PREHOOK: query: DESCRIBE EXTENDED alter1
+PREHOOK: query: DESCRIBE EXTENDED alter1_db.alter1
 PREHOOK: type: DESCTABLE
 PREHOOK: Input: alter1_db@alter1
-POSTHOOK: query: DESCRIBE EXTENDED alter1
+POSTHOOK: query: DESCRIBE EXTENDED alter1_db.alter1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: alter1_db@alter1
 a                   	int                 	                    
 b                   	int                 	                    
 	 	 
 #### A masked pattern was here ####
-PREHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('a'='1', 'c'='3')
+PREHOOK: query: ALTER TABLE alter1_db.alter1 SET TBLPROPERTIES ('a'='1', 'c'='3')
 PREHOOK: type: ALTERTABLE_PROPERTIES
 PREHOOK: Input: alter1_db@alter1
 PREHOOK: Output: alter1_db@alter1
-POSTHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('a'='1', 'c'='3')
+POSTHOOK: query: ALTER TABLE alter1_db.alter1 SET TBLPROPERTIES ('a'='1', 'c'='3')
 POSTHOOK: type: ALTERTABLE_PROPERTIES
 POSTHOOK: Input: alter1_db@alter1
 POSTHOOK: Output: alter1_db@alter1
-PREHOOK: query: DESCRIBE EXTENDED alter1
+PREHOOK: query: DESCRIBE EXTENDED alter1_db.alter1
 PREHOOK: type: DESCTABLE
 PREHOOK: Input: alter1_db@alter1
-POSTHOOK: query: DESCRIBE EXTENDED alter1
+POSTHOOK: query: DESCRIBE EXTENDED alter1_db.alter1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: alter1_db@alter1
 a                   	int                 	                    
 b                   	int                 	                    
 	 	 
 #### A masked pattern was here ####
-PREHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('a'='1', 'c'='4', 'd'='3')
+PREHOOK: query: ALTER TABLE alter1_db.alter1 SET TBLPROPERTIES ('a'='1', 'c'='4', 'd'='3')
 PREHOOK: type: ALTERTABLE_PROPERTIES
 PREHOOK: Input: alter1_db@alter1
 PREHOOK: Output: alter1_db@alter1
-POSTHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('a'='1', 'c'='4', 'd'='3')
+POSTHOOK: query: ALTER TABLE alter1_db.alter1 SET TBLPROPERTIES ('a'='1', 'c'='4', 'd'='3')
 POSTHOOK: type: ALTERTABLE_PROPERTIES
 POSTHOOK: Input: alter1_db@alter1
 POSTHOOK: Output: alter1_db@alter1
-PREHOOK: query: DESCRIBE EXTENDED alter1
+PREHOOK: query: DESCRIBE EXTENDED alter1_db.alter1
 PREHOOK: type: DESCTABLE
 PREHOOK: Input: alter1_db@alter1
-POSTHOOK: query: DESCRIBE EXTENDED alter1
+POSTHOOK: query: DESCRIBE EXTENDED alter1_db.alter1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: alter1_db@alter1
 a                   	int                 	                    
 b                   	int                 	                    
 	 	 
 #### A masked pattern was here ####
-PREHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('EXTERNAL'='TRUE')
+PREHOOK: query: ALTER TABLE alter1_db.alter1 SET TBLPROPERTIES ('EXTERNAL'='TRUE')
 PREHOOK: type: ALTERTABLE_PROPERTIES
 PREHOOK: Input: alter1_db@alter1
 PREHOOK: Output: alter1_db@alter1
-POSTHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('EXTERNAL'='TRUE')
+POSTHOOK: query: ALTER TABLE alter1_db.alter1 SET TBLPROPERTIES ('EXTERNAL'='TRUE')
 POSTHOOK: type: ALTERTABLE_PROPERTIES
 POSTHOOK: Input: alter1_db@alter1
 POSTHOOK: Output: alter1_db@alter1
-PREHOOK: query: DESCRIBE EXTENDED alter1
+PREHOOK: query: DESCRIBE EXTENDED alter1_db.alter1
 PREHOOK: type: DESCTABLE
 PREHOOK: Input: alter1_db@alter1
-POSTHOOK: query: DESCRIBE EXTENDED alter1
+POSTHOOK: query: DESCRIBE EXTENDED alter1_db.alter1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: alter1_db@alter1
 a                   	int                 	                    
 b                   	int                 	                    
 	 	 
 #### A masked pattern was here ####
-PREHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('EXTERNAL'='FALSE')
+PREHOOK: query: ALTER TABLE alter1_db.alter1 SET TBLPROPERTIES ('EXTERNAL'='FALSE')
 PREHOOK: type: ALTERTABLE_PROPERTIES
 PREHOOK: Input: alter1_db@alter1
 PREHOOK: Output: alter1_db@alter1
-POSTHOOK: query: ALTER TABLE alter1 SET TBLPROPERTIES ('EXTERNAL'='FALSE')
+POSTHOOK: query: ALTER TABLE alter1_db.alter1 SET TBLPROPERTIES ('EXTERNAL'='FALSE')
 POSTHOOK: type: ALTERTABLE_PROPERTIES
 POSTHOOK: Input: alter1_db@alter1
 POSTHOOK: Output: alter1_db@alter1
-PREHOOK: query: DESCRIBE EXTENDED alter1
+PREHOOK: query: DESCRIBE EXTENDED alter1_db.alter1
 PREHOOK: type: DESCTABLE
 PREHOOK: Input: alter1_db@alter1
-POSTHOOK: query: DESCRIBE EXTENDED alter1
+POSTHOOK: query: DESCRIBE EXTENDED alter1_db.alter1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: alter1_db@alter1
 a                   	int                 	                    
 b                   	int                 	                    
 	 	 
 #### A masked pattern was here ####
-PREHOOK: query: ALTER TABLE alter1 SET SERDEPROPERTIES('s1'='9')
+PREHOOK: query: ALTER TABLE alter1_db.alter1 SET SERDEPROPERTIES('s1'='9')
 PREHOOK: type: ALTERTABLE_SERDEPROPERTIES
 PREHOOK: Input: alter1_db@alter1
 PREHOOK: Output: alter1_db@alter1
-POSTHOOK: query: ALTER TABLE alter1 SET SERDEPROPERTIES('s1'='9')
+POSTHOOK: query: ALTER TABLE alter1_db.alter1 SET SERDEPROPERTIES('s1'='9')
 POSTHOOK: type: ALTERTABLE_SERDEPROPERTIES
 POSTHOOK: Input: alter1_db@alter1
 POSTHOOK: Output: alter1_db@alter1
-PREHOOK: query: DESCRIBE EXTENDED alter1
+PREHOOK: query: DESCRIBE EXTENDED alter1_db.alter1
 PREHOOK: type: DESCTABLE
 PREHOOK: Input: alter1_db@alter1
-POSTHOOK: query: DESCRIBE EXTENDED alter1
+POSTHOOK: query: DESCRIBE EXTENDED alter1_db.alter1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: alter1_db@alter1
 a                   	int                 	                    
 b                   	int                 	                    
 	 	 
 #### A masked pattern was here ####
-PREHOOK: query: ALTER TABLE alter1 SET SERDEPROPERTIES('s1'='10', 's2' ='20')
+PREHOOK: query: ALTER TABLE alter1_db.alter1 SET SERDEPROPERTIES('s1'='10', 's2' ='20')
 PREHOOK: type: ALTERTABLE_SERDEPROPERTIES
 PREHOOK: Input: alter1_db@alter1
 PREHOOK: Output: alter1_db@alter1
-POSTHOOK: query: ALTER TABLE alter1 SET SERDEPROPERTIES('s1'='10', 's2' ='20')
+POSTHOOK: query: ALTER TABLE alter1_db.alter1 SET SERDEPROPERTIES('s1'='10', 's2' ='20')
 POSTHOOK: type: ALTERTABLE_SERDEPROPERTIES
 POSTHOOK: Input: alter1_db@alter1
 POSTHOOK: Output: alter1_db@alter1
-PREHOOK: query: DESCRIBE EXTENDED alter1
+PREHOOK: query: DESCRIBE EXTENDED alter1_db.alter1
 PREHOOK: type: DESCTABLE
 PREHOOK: Input: alter1_db@alter1
-POSTHOOK: query: DESCRIBE EXTENDED alter1
+POSTHOOK: query: DESCRIBE EXTENDED alter1_db.alter1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: alter1_db@alter1
 a                   	int                 	                    
 b                   	int                 	                    
 	 	 
 #### A masked pattern was here ####
-PREHOOK: query: ALTER TABLE alter1 SET SERDE 'org.apache.hadoop.hive.serde2.TestSerDe' WITH SERDEPROPERTIES ('s1'='9')
+PREHOOK: query: ALTER TABLE alter1_db.alter1 SET SERDE 'org.apache.hadoop.hive.serde2.TestSerDe' WITH SERDEPROPERTIES ('s1'='9')
 PREHOOK: type: ALTERTABLE_SERIALIZER
 PREHOOK: Input: alter1_db@alter1
 PREHOOK: Output: alter1_db@alter1
-POSTHOOK: query: ALTER TABLE alter1 SET SERDE 'org.apache.hadoop.hive.serde2.TestSerDe' WITH SERDEPROPERTIES ('s1'='9')
+POSTHOOK: query: ALTER TABLE alter1_db.alter1 SET SERDE 'org.apache.hadoop.hive.serde2.TestSerDe' WITH SERDEPROPERTIES ('s1'='9')
 POSTHOOK: type: ALTERTABLE_SERIALIZER
 POSTHOOK: Input: alter1_db@alter1
 POSTHOOK: Output: alter1_db@alter1
-PREHOOK: query: DESCRIBE EXTENDED alter1
+PREHOOK: query: DESCRIBE EXTENDED alter1_db.alter1
 PREHOOK: type: DESCTABLE
 PREHOOK: Input: alter1_db@alter1
-POSTHOOK: query: DESCRIBE EXTENDED alter1
+POSTHOOK: query: DESCRIBE EXTENDED alter1_db.alter1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: alter1_db@alter1
 a                   	string              	                    
 b                   	string              	                    
 	 	 
 #### A masked pattern was here ####
-PREHOOK: query: ALTER TABLE alter1 SET SERDE 'org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe'
+PREHOOK: query: ALTER TABLE alter1_db.alter1 SET SERDE 'org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe'
 PREHOOK: type: ALTERTABLE_SERIALIZER
 PREHOOK: Input: alter1_db@alter1
 PREHOOK: Output: alter1_db@alter1
-POSTHOOK: query: ALTER TABLE alter1 SET SERDE 'org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe'
+POSTHOOK: query: ALTER TABLE alter1_db.alter1 SET SERDE 'org.apache.hadoop.hive.serde2.MetadataTypedColumnsetSerDe'
 POSTHOOK: type: ALTERTABLE_SERIALIZER
 POSTHOOK: Input: alter1_db@alter1
 POSTHOOK: Output: alter1_db@alter1
-PREHOOK: query: DESCRIBE EXTENDED alter1
+PREHOOK: query: DESCRIBE EXTENDED alter1_db.alter1
 PREHOOK: type: DESCTABLE
 PREHOOK: Input: alter1_db@alter1
-POSTHOOK: query: DESCRIBE EXTENDED alter1
+POSTHOOK: query: DESCRIBE EXTENDED alter1_db.alter1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: alter1_db@alter1
 a                   	string              	                    
 b                   	string              	                    
 	 	 
 #### A masked pattern was here ####
-PREHOOK: query: ALTER TABLE alter1 REPLACE COLUMNS (a int, b int, c string)
+PREHOOK: query: ALTER TABLE alter1_db.alter1 REPLACE COLUMNS (a int, b int, c string)
 PREHOOK: type: ALTERTABLE_REPLACECOLS
 PREHOOK: Input: alter1_db@alter1
 PREHOOK: Output: alter1_db@alter1
-POSTHOOK: query: ALTER TABLE alter1 REPLACE COLUMNS (a int, b int, c string)
+POSTHOOK: query: ALTER TABLE alter1_db.alter1 REPLACE COLUMNS (a int, b int, c string)
 POSTHOOK: type: ALTERTABLE_REPLACECOLS
 POSTHOOK: Input: alter1_db@alter1
 POSTHOOK: Output: alter1_db@alter1
-PREHOOK: query: DESCRIBE alter1
+PREHOOK: query: DESCRIBE alter1_db.alter1
 PREHOOK: type: DESCTABLE
 PREHOOK: Input: alter1_db@alter1
-POSTHOOK: query: DESCRIBE alter1
+POSTHOOK: query: DESCRIBE alter1_db.alter1
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Input: alter1_db@alter1
 a                   	int                 	                    
 b                   	int                 	                    
 c                   	string              	                    
-PREHOOK: query: DROP TABLE alter1
+PREHOOK: query: DROP TABLE alter1_db.alter1
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: alter1_db@alter1
 PREHOOK: Output: alter1_db@alter1
-POSTHOOK: query: DROP TABLE alter1
+POSTHOOK: query: DROP TABLE alter1_db.alter1
 POSTHOOK: type: DROPTABLE
 POSTHOOK: Input: alter1_db@alter1
 POSTHOOK: Output: alter1_db@alter1
-PREHOOK: query: USE default
-PREHOOK: type: SWITCHDATABASE
-PREHOOK: Input: database:default
-POSTHOOK: query: USE default
-POSTHOOK: type: SWITCHDATABASE
-POSTHOOK: Input: database:default
 PREHOOK: query: DROP DATABASE alter1_db
 PREHOOK: type: DROPDATABASE
 PREHOOK: Input: database:alter1_db

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/alter_char1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/alter_char1.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/alter_char1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/alter_char1.q.out Thu Aug 28 03:15:13 2014
@@ -1,38 +1,40 @@
 PREHOOK: query: -- SORT_QUERY_RESULTS
 
-drop table alter_char_1
-PREHOOK: type: DROPTABLE
+create database ac
+PREHOOK: type: CREATEDATABASE
+PREHOOK: Output: database:ac
 POSTHOOK: query: -- SORT_QUERY_RESULTS
 
-drop table alter_char_1
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: create table alter_char_1 (key string, value string)
+create database ac
+POSTHOOK: type: CREATEDATABASE
+POSTHOOK: Output: database:ac
+PREHOOK: query: create table ac.alter_char_1 (key string, value string)
 PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@alter_char_1
-POSTHOOK: query: create table alter_char_1 (key string, value string)
+PREHOOK: Output: ac@alter_char_1
+PREHOOK: Output: database:ac
+POSTHOOK: query: create table ac.alter_char_1 (key string, value string)
 POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@alter_char_1
-PREHOOK: query: insert overwrite table alter_char_1
+POSTHOOK: Output: ac@alter_char_1
+POSTHOOK: Output: database:ac
+PREHOOK: query: insert overwrite table ac.alter_char_1
   select key, value from src order by key limit 5
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
-PREHOOK: Output: default@alter_char_1
-POSTHOOK: query: insert overwrite table alter_char_1
+PREHOOK: Output: ac@alter_char_1
+POSTHOOK: query: insert overwrite table ac.alter_char_1
   select key, value from src order by key limit 5
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
-POSTHOOK: Output: default@alter_char_1
+POSTHOOK: Output: ac@alter_char_1
 POSTHOOK: Lineage: alter_char_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: alter_char_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from alter_char_1
+PREHOOK: query: select * from ac.alter_char_1
 PREHOOK: type: QUERY
-PREHOOK: Input: default@alter_char_1
+PREHOOK: Input: ac@alter_char_1
 #### A masked pattern was here ####
-POSTHOOK: query: select * from alter_char_1
+POSTHOOK: query: select * from ac.alter_char_1
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alter_char_1
+POSTHOOK: Input: ac@alter_char_1
 #### A masked pattern was here ####
 0	val_0
 0	val_0
@@ -40,24 +42,24 @@ POSTHOOK: Input: default@alter_char_1
 10	val_10
 100	val_100
 PREHOOK: query: -- change column to char
-alter table alter_char_1 change column value value char(20)
+alter table ac.alter_char_1 change column value value char(20)
 PREHOOK: type: ALTERTABLE_RENAMECOL
-PREHOOK: Input: default@alter_char_1
-PREHOOK: Output: default@alter_char_1
+PREHOOK: Input: ac@alter_char_1
+PREHOOK: Output: ac@alter_char_1
 POSTHOOK: query: -- change column to char
-alter table alter_char_1 change column value value char(20)
+alter table ac.alter_char_1 change column value value char(20)
 POSTHOOK: type: ALTERTABLE_RENAMECOL
-POSTHOOK: Input: default@alter_char_1
-POSTHOOK: Output: default@alter_char_1
+POSTHOOK: Input: ac@alter_char_1
+POSTHOOK: Output: ac@alter_char_1
 PREHOOK: query: -- contents should still look the same
-select * from alter_char_1
+select * from ac.alter_char_1
 PREHOOK: type: QUERY
-PREHOOK: Input: default@alter_char_1
+PREHOOK: Input: ac@alter_char_1
 #### A masked pattern was here ####
 POSTHOOK: query: -- contents should still look the same
-select * from alter_char_1
+select * from ac.alter_char_1
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alter_char_1
+POSTHOOK: Input: ac@alter_char_1
 #### A masked pattern was here ####
 0	val_0               
 0	val_0               
@@ -65,24 +67,24 @@ POSTHOOK: Input: default@alter_char_1
 10	val_10              
 100	val_100             
 PREHOOK: query: -- change column to smaller char
-alter table alter_char_1 change column value value char(3)
+alter table ac.alter_char_1 change column value value char(3)
 PREHOOK: type: ALTERTABLE_RENAMECOL
-PREHOOK: Input: default@alter_char_1
-PREHOOK: Output: default@alter_char_1
+PREHOOK: Input: ac@alter_char_1
+PREHOOK: Output: ac@alter_char_1
 POSTHOOK: query: -- change column to smaller char
-alter table alter_char_1 change column value value char(3)
+alter table ac.alter_char_1 change column value value char(3)
 POSTHOOK: type: ALTERTABLE_RENAMECOL
-POSTHOOK: Input: default@alter_char_1
-POSTHOOK: Output: default@alter_char_1
+POSTHOOK: Input: ac@alter_char_1
+POSTHOOK: Output: ac@alter_char_1
 PREHOOK: query: -- value column should be truncated now
-select * from alter_char_1
+select * from ac.alter_char_1
 PREHOOK: type: QUERY
-PREHOOK: Input: default@alter_char_1
+PREHOOK: Input: ac@alter_char_1
 #### A masked pattern was here ####
 POSTHOOK: query: -- value column should be truncated now
-select * from alter_char_1
+select * from ac.alter_char_1
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alter_char_1
+POSTHOOK: Input: ac@alter_char_1
 #### A masked pattern was here ####
 0	val
 0	val
@@ -90,24 +92,24 @@ POSTHOOK: Input: default@alter_char_1
 10	val
 100	val
 PREHOOK: query: -- change back to bigger char
-alter table alter_char_1 change column value value char(20)
+alter table ac.alter_char_1 change column value value char(20)
 PREHOOK: type: ALTERTABLE_RENAMECOL
-PREHOOK: Input: default@alter_char_1
-PREHOOK: Output: default@alter_char_1
+PREHOOK: Input: ac@alter_char_1
+PREHOOK: Output: ac@alter_char_1
 POSTHOOK: query: -- change back to bigger char
-alter table alter_char_1 change column value value char(20)
+alter table ac.alter_char_1 change column value value char(20)
 POSTHOOK: type: ALTERTABLE_RENAMECOL
-POSTHOOK: Input: default@alter_char_1
-POSTHOOK: Output: default@alter_char_1
+POSTHOOK: Input: ac@alter_char_1
+POSTHOOK: Output: ac@alter_char_1
 PREHOOK: query: -- column values should be full size again
-select * from alter_char_1
+select * from ac.alter_char_1
 PREHOOK: type: QUERY
-PREHOOK: Input: default@alter_char_1
+PREHOOK: Input: ac@alter_char_1
 #### A masked pattern was here ####
 POSTHOOK: query: -- column values should be full size again
-select * from alter_char_1
+select * from ac.alter_char_1
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alter_char_1
+POSTHOOK: Input: ac@alter_char_1
 #### A masked pattern was here ####
 0	val_0               
 0	val_0               
@@ -115,60 +117,68 @@ POSTHOOK: Input: default@alter_char_1
 10	val_10              
 100	val_100             
 PREHOOK: query: -- add char column
-alter table alter_char_1 add columns (key2 int, value2 char(10))
+alter table ac.alter_char_1 add columns (key2 int, value2 char(10))
 PREHOOK: type: ALTERTABLE_ADDCOLS
-PREHOOK: Input: default@alter_char_1
-PREHOOK: Output: default@alter_char_1
+PREHOOK: Input: ac@alter_char_1
+PREHOOK: Output: ac@alter_char_1
 POSTHOOK: query: -- add char column
-alter table alter_char_1 add columns (key2 int, value2 char(10))
+alter table ac.alter_char_1 add columns (key2 int, value2 char(10))
 POSTHOOK: type: ALTERTABLE_ADDCOLS
-POSTHOOK: Input: default@alter_char_1
-POSTHOOK: Output: default@alter_char_1
-PREHOOK: query: select * from alter_char_1
+POSTHOOK: Input: ac@alter_char_1
+POSTHOOK: Output: ac@alter_char_1
+PREHOOK: query: select * from ac.alter_char_1
 PREHOOK: type: QUERY
-PREHOOK: Input: default@alter_char_1
+PREHOOK: Input: ac@alter_char_1
 #### A masked pattern was here ####
-POSTHOOK: query: select * from alter_char_1
+POSTHOOK: query: select * from ac.alter_char_1
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alter_char_1
+POSTHOOK: Input: ac@alter_char_1
 #### A masked pattern was here ####
 0	val_0               	NULL	NULL
 0	val_0               	NULL	NULL
 0	val_0               	NULL	NULL
 10	val_10              	NULL	NULL
 100	val_100             	NULL	NULL
-PREHOOK: query: insert overwrite table alter_char_1
+PREHOOK: query: insert overwrite table ac.alter_char_1
   select key, value, key, value from src order by key limit 5
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
-PREHOOK: Output: default@alter_char_1
-POSTHOOK: query: insert overwrite table alter_char_1
+PREHOOK: Output: ac@alter_char_1
+POSTHOOK: query: insert overwrite table ac.alter_char_1
   select key, value, key, value from src order by key limit 5
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
-POSTHOOK: Output: default@alter_char_1
+POSTHOOK: Output: ac@alter_char_1
 POSTHOOK: Lineage: alter_char_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: alter_char_1.key2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: alter_char_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: alter_char_1.value2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from alter_char_1
+PREHOOK: query: select * from ac.alter_char_1
 PREHOOK: type: QUERY
-PREHOOK: Input: default@alter_char_1
+PREHOOK: Input: ac@alter_char_1
 #### A masked pattern was here ####
-POSTHOOK: query: select * from alter_char_1
+POSTHOOK: query: select * from ac.alter_char_1
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alter_char_1
+POSTHOOK: Input: ac@alter_char_1
 #### A masked pattern was here ####
 0	val_0               	0	val_0     
 0	val_0               	0	val_0     
 0	val_0               	0	val_0     
 10	val_10              	10	val_10    
 100	val_100             	100	val_100   
-PREHOOK: query: drop table alter_char_1
+PREHOOK: query: drop table ac.alter_char_1
 PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@alter_char_1
-PREHOOK: Output: default@alter_char_1
-POSTHOOK: query: drop table alter_char_1
+PREHOOK: Input: ac@alter_char_1
+PREHOOK: Output: ac@alter_char_1
+POSTHOOK: query: drop table ac.alter_char_1
 POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@alter_char_1
-POSTHOOK: Output: default@alter_char_1
+POSTHOOK: Input: ac@alter_char_1
+POSTHOOK: Output: ac@alter_char_1
+PREHOOK: query: drop database ac
+PREHOOK: type: DROPDATABASE
+PREHOOK: Input: database:ac
+PREHOOK: Output: database:ac
+POSTHOOK: query: drop database ac
+POSTHOOK: type: DROPDATABASE
+POSTHOOK: Input: database:ac
+POSTHOOK: Output: database:ac

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/alter_index.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/alter_index.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/alter_index.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/alter_index.q.out Thu Aug 28 03:15:13 2014
@@ -4,10 +4,10 @@ PREHOOK: Input: default@src
 POSTHOOK: query: drop index src_index_8 on src
 POSTHOOK: type: DROPINDEX
 POSTHOOK: Input: default@src
-PREHOOK: query: create index src_index_8 on table src(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2")
+PREHOOK: query: create index src_index_8 on table default.src(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2")
 PREHOOK: type: CREATEINDEX
 PREHOOK: Input: default@src
-POSTHOOK: query: create index src_index_8 on table src(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2")
+POSTHOOK: query: create index src_index_8 on table default.src(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2")
 POSTHOOK: type: CREATEINDEX
 POSTHOOK: Input: default@src
 POSTHOOK: Output: default@default__src_src_index_8__
@@ -22,9 +22,9 @@ _bucketname         	string             
 _offsets            	array<bigint>       	                    
 	 	 
 #### A masked pattern was here ####
-PREHOOK: query: alter index src_index_8 on src set IDXPROPERTIES ("prop1"="val1_new", "prop3"="val3")
+PREHOOK: query: alter index src_index_8 on default.src set IDXPROPERTIES ("prop1"="val1_new", "prop3"="val3")
 PREHOOK: type: ALTERINDEX_PROPS
-POSTHOOK: query: alter index src_index_8 on src set IDXPROPERTIES ("prop1"="val1_new", "prop3"="val3")
+POSTHOOK: query: alter index src_index_8 on default.src set IDXPROPERTIES ("prop1"="val1_new", "prop3"="val3")
 POSTHOOK: type: ALTERINDEX_PROPS
 PREHOOK: query: desc extended default__src_src_index_8__
 PREHOOK: type: DESCTABLE
@@ -37,10 +37,10 @@ _bucketname         	string             
 _offsets            	array<bigint>       	                    
 	 	 
 #### A masked pattern was here ####
-PREHOOK: query: drop index src_index_8 on src
+PREHOOK: query: drop index src_index_8 on default.src
 PREHOOK: type: DROPINDEX
 PREHOOK: Input: default@src
-POSTHOOK: query: drop index src_index_8 on src
+POSTHOOK: query: drop index src_index_8 on default.src
 POSTHOOK: type: DROPINDEX
 POSTHOOK: Input: default@src
 PREHOOK: query: show tables

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/alter_partition_coltype.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/alter_partition_coltype.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/alter_partition_coltype.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/alter_partition_coltype.q.out Thu Aug 28 03:15:13 2014 differ

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/alter_rename_partition_authorization.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/alter_rename_partition_authorization.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/alter_rename_partition_authorization.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/alter_rename_partition_authorization.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/alter_rename_table.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/alter_rename_table.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/alter_rename_table.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/alter_rename_table.q.out Thu Aug 28 03:15:13 2014
@@ -13,11 +13,10 @@ POSTHOOK: Output: database:target
 PREHOOK: query: create table source.src like default.src
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:source
-PREHOOK: Output: source@source.src
+PREHOOK: Output: source@src
 POSTHOOK: query: create table source.src like default.src
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: database:source
-POSTHOOK: Output: source@source.src
 POSTHOOK: Output: source@src
 PREHOOK: query: load data local inpath '../../data/files/kv1.txt' overwrite into table source.src
 PREHOOK: type: LOAD
@@ -30,11 +29,10 @@ POSTHOOK: Output: source@src
 PREHOOK: query: create table source.srcpart like default.srcpart
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:source
-PREHOOK: Output: source@source.srcpart
+PREHOOK: Output: source@srcpart
 POSTHOOK: query: create table source.srcpart like default.srcpart
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: database:source
-POSTHOOK: Output: source@source.srcpart
 POSTHOOK: Output: source@srcpart
 PREHOOK: query: load data local inpath '../../data/files/kv1.txt' overwrite into table source.srcpart partition (ds='2008-04-08', hr='11')
 PREHOOK: type: LOAD
@@ -215,20 +213,18 @@ POSTHOOK: Input: target@srcpart@ds=2008-
 PREHOOK: query: create table source.src like default.src
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:source
-PREHOOK: Output: source@source.src
+PREHOOK: Output: source@src
 POSTHOOK: query: create table source.src like default.src
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: database:source
-POSTHOOK: Output: source@source.src
 POSTHOOK: Output: source@src
 PREHOOK: query: create table source.src1 like default.src
 PREHOOK: type: CREATETABLE
 PREHOOK: Output: database:source
-PREHOOK: Output: source@source.src1
+PREHOOK: Output: source@src1
 POSTHOOK: query: create table source.src1 like default.src
 POSTHOOK: type: CREATETABLE
 POSTHOOK: Output: database:source
-POSTHOOK: Output: source@source.src1
 POSTHOOK: Output: source@src1
 PREHOOK: query: load data local inpath '../../data/files/kv1.txt' overwrite into table source.src
 PREHOOK: type: LOAD

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/alter_skewed_table.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/alter_skewed_table.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/alter_skewed_table.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/alter_skewed_table.q.out Thu Aug 28 03:15:13 2014
@@ -92,27 +92,33 @@ POSTHOOK: query: drop table original
 POSTHOOK: type: DROPTABLE
 POSTHOOK: Input: default@original
 POSTHOOK: Output: default@original
-PREHOOK: query: create table original2 (key STRING, value STRING)
+PREHOOK: query: create database skew_test
+PREHOOK: type: CREATEDATABASE
+PREHOOK: Output: database:skew_test
+POSTHOOK: query: create database skew_test
+POSTHOOK: type: CREATEDATABASE
+POSTHOOK: Output: database:skew_test
+PREHOOK: query: create table skew_test.original2 (key STRING, value STRING)
 PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@original2
-POSTHOOK: query: create table original2 (key STRING, value STRING)
+PREHOOK: Output: database:skew_test
+PREHOOK: Output: skew_test@original2
+POSTHOOK: query: create table skew_test.original2 (key STRING, value STRING)
 POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@original2
-PREHOOK: query: describe formatted original2
+POSTHOOK: Output: database:skew_test
+POSTHOOK: Output: skew_test@original2
+PREHOOK: query: describe formatted skew_test.original2
 PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@original2
-POSTHOOK: query: describe formatted original2
+PREHOOK: Input: skew_test@original2
+POSTHOOK: query: describe formatted skew_test.original2
 POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@original2
+POSTHOOK: Input: skew_test@original2
 # col_name            	data_type           	comment             
 	 	 
 key                 	string              	                    
 value               	string              	                    
 	 	 
 # Detailed Table Information	 	 
-Database:           	default             	 
+Database:           	skew_test           	 
 #### A masked pattern was here ####
 Protect Mode:       	None                	 
 Retention:          	0                   	 
@@ -131,27 +137,27 @@ Bucket Columns:     	[]                 
 Sort Columns:       	[]                  	 
 Storage Desc Params:	 	 
 	serialization.format	1                   
-PREHOOK: query: alter table original2 SKEWED BY (key, value) ON ((1,1),(5,6))
+PREHOOK: query: alter table skew_test.original2 SKEWED BY (key, value) ON ((1,1),(5,6))
 PREHOOK: type: ALTERTABLE_SKEWED
-PREHOOK: Input: default@original2
-PREHOOK: Output: default@original2
-POSTHOOK: query: alter table original2 SKEWED BY (key, value) ON ((1,1),(5,6))
+PREHOOK: Input: skew_test@original2
+PREHOOK: Output: skew_test@original2
+POSTHOOK: query: alter table skew_test.original2 SKEWED BY (key, value) ON ((1,1),(5,6))
 POSTHOOK: type: ALTERTABLE_SKEWED
-POSTHOOK: Input: default@original2
-POSTHOOK: Output: default@original2
-PREHOOK: query: describe formatted original2
+POSTHOOK: Input: skew_test@original2
+POSTHOOK: Output: skew_test@original2
+PREHOOK: query: describe formatted skew_test.original2
 PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@original2
-POSTHOOK: query: describe formatted original2
+PREHOOK: Input: skew_test@original2
+POSTHOOK: query: describe formatted skew_test.original2
 POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@original2
+POSTHOOK: Input: skew_test@original2
 # col_name            	data_type           	comment             
 	 	 
 key                 	string              	                    
 value               	string              	                    
 	 	 
 # Detailed Table Information	 	 
-Database:           	default             	 
+Database:           	skew_test           	 
 #### A masked pattern was here ####
 Protect Mode:       	None                	 
 Retention:          	0                   	 
@@ -178,35 +184,35 @@ Skewed Columns:     	[key, value]       
 Skewed Values:      	[[1, 1], [5, 6]]    	 
 Storage Desc Params:	 	 
 	serialization.format	1                   
-PREHOOK: query: drop table original2
+PREHOOK: query: drop table skew_test.original2
 PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@original2
-PREHOOK: Output: default@original2
-POSTHOOK: query: drop table original2
+PREHOOK: Input: skew_test@original2
+PREHOOK: Output: skew_test@original2
+POSTHOOK: query: drop table skew_test.original2
 POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@original2
-POSTHOOK: Output: default@original2
-PREHOOK: query: create table original3 (key STRING, value STRING) SKEWED BY (key, value) ON ((1,1),(5,6))
+POSTHOOK: Input: skew_test@original2
+POSTHOOK: Output: skew_test@original2
+PREHOOK: query: create table skew_test.original3 (key STRING, value STRING) SKEWED BY (key, value) ON ((1,1),(5,6))
 PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@original3
-POSTHOOK: query: create table original3 (key STRING, value STRING) SKEWED BY (key, value) ON ((1,1),(5,6))
+PREHOOK: Output: database:skew_test
+PREHOOK: Output: skew_test@original3
+POSTHOOK: query: create table skew_test.original3 (key STRING, value STRING) SKEWED BY (key, value) ON ((1,1),(5,6))
 POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@original3
-PREHOOK: query: describe formatted original3
+POSTHOOK: Output: database:skew_test
+POSTHOOK: Output: skew_test@original3
+PREHOOK: query: describe formatted skew_test.original3
 PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@original3
-POSTHOOK: query: describe formatted original3
+PREHOOK: Input: skew_test@original3
+POSTHOOK: query: describe formatted skew_test.original3
 POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@original3
+POSTHOOK: Input: skew_test@original3
 # col_name            	data_type           	comment             
 	 	 
 key                 	string              	                    
 value               	string              	                    
 	 	 
 # Detailed Table Information	 	 
-Database:           	default             	 
+Database:           	skew_test           	 
 #### A masked pattern was here ####
 Protect Mode:       	None                	 
 Retention:          	0                   	 
@@ -227,27 +233,27 @@ Skewed Columns:     	[key, value]       
 Skewed Values:      	[[1, 1], [5, 6]]    	 
 Storage Desc Params:	 	 
 	serialization.format	1                   
-PREHOOK: query: alter table original3 not skewed
+PREHOOK: query: alter table skew_test.original3 not skewed
 PREHOOK: type: ALTERTABLE_SKEWED
-PREHOOK: Input: default@original3
-PREHOOK: Output: default@original3
-POSTHOOK: query: alter table original3 not skewed
+PREHOOK: Input: skew_test@original3
+PREHOOK: Output: skew_test@original3
+POSTHOOK: query: alter table skew_test.original3 not skewed
 POSTHOOK: type: ALTERTABLE_SKEWED
-POSTHOOK: Input: default@original3
-POSTHOOK: Output: default@original3
-PREHOOK: query: describe formatted original3
+POSTHOOK: Input: skew_test@original3
+POSTHOOK: Output: skew_test@original3
+PREHOOK: query: describe formatted skew_test.original3
 PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@original3
-POSTHOOK: query: describe formatted original3
+PREHOOK: Input: skew_test@original3
+POSTHOOK: query: describe formatted skew_test.original3
 POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@original3
+POSTHOOK: Input: skew_test@original3
 # col_name            	data_type           	comment             
 	 	 
 key                 	string              	                    
 value               	string              	                    
 	 	 
 # Detailed Table Information	 	 
-Database:           	default             	 
+Database:           	skew_test           	 
 #### A masked pattern was here ####
 Protect Mode:       	None                	 
 Retention:          	0                   	 
@@ -272,11 +278,19 @@ Bucket Columns:     	[]                 
 Sort Columns:       	[]                  	 
 Storage Desc Params:	 	 
 	serialization.format	1                   
-PREHOOK: query: drop table original3
+PREHOOK: query: drop table skew_test.original3
 PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@original3
-PREHOOK: Output: default@original3
-POSTHOOK: query: drop table original3
+PREHOOK: Input: skew_test@original3
+PREHOOK: Output: skew_test@original3
+POSTHOOK: query: drop table skew_test.original3
 POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@original3
-POSTHOOK: Output: default@original3
+POSTHOOK: Input: skew_test@original3
+POSTHOOK: Output: skew_test@original3
+PREHOOK: query: drop database skew_test
+PREHOOK: type: DROPDATABASE
+PREHOOK: Input: database:skew_test
+PREHOOK: Output: database:skew_test
+POSTHOOK: query: drop database skew_test
+POSTHOOK: type: DROPDATABASE
+POSTHOOK: Input: database:skew_test
+POSTHOOK: Output: database:skew_test

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/alter_table_update_status.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/alter_table_update_status.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/alter_table_update_status.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/alter_table_update_status.q.out Thu Aug 28 03:15:13 2014
@@ -1,9 +1,12 @@
 PREHOOK: query: create table src_stat as select * from src1
 PREHOOK: type: CREATETABLE_AS_SELECT
 PREHOOK: Input: default@src1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@src_stat
 POSTHOOK: query: create table src_stat as select * from src1
 POSTHOOK: type: CREATETABLE_AS_SELECT
 POSTHOOK: Input: default@src1
+POSTHOOK: Output: database:default
 POSTHOOK: Output: default@src_stat
 PREHOOK: query: create table src_stat_int (
   key         double,

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/alter_varchar1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/alter_varchar1.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/alter_varchar1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/alter_varchar1.q.out Thu Aug 28 03:15:13 2014
@@ -1,38 +1,40 @@
 PREHOOK: query: -- SORT_QUERY_RESULTS
 
-drop table alter_varchar_1
-PREHOOK: type: DROPTABLE
+create database avc
+PREHOOK: type: CREATEDATABASE
+PREHOOK: Output: database:avc
 POSTHOOK: query: -- SORT_QUERY_RESULTS
 
-drop table alter_varchar_1
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: create table alter_varchar_1 (key string, value string)
+create database avc
+POSTHOOK: type: CREATEDATABASE
+POSTHOOK: Output: database:avc
+PREHOOK: query: create table avc.alter_varchar_1 (key string, value string)
 PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@alter_varchar_1
-POSTHOOK: query: create table alter_varchar_1 (key string, value string)
+PREHOOK: Output: avc@alter_varchar_1
+PREHOOK: Output: database:avc
+POSTHOOK: query: create table avc.alter_varchar_1 (key string, value string)
 POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@alter_varchar_1
-PREHOOK: query: insert overwrite table alter_varchar_1
+POSTHOOK: Output: avc@alter_varchar_1
+POSTHOOK: Output: database:avc
+PREHOOK: query: insert overwrite table avc.alter_varchar_1
   select key, value from src order by key limit 5
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
-PREHOOK: Output: default@alter_varchar_1
-POSTHOOK: query: insert overwrite table alter_varchar_1
+PREHOOK: Output: avc@alter_varchar_1
+POSTHOOK: query: insert overwrite table avc.alter_varchar_1
   select key, value from src order by key limit 5
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
-POSTHOOK: Output: default@alter_varchar_1
+POSTHOOK: Output: avc@alter_varchar_1
 POSTHOOK: Lineage: alter_varchar_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: alter_varchar_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from alter_varchar_1
+PREHOOK: query: select * from avc.alter_varchar_1
 PREHOOK: type: QUERY
-PREHOOK: Input: default@alter_varchar_1
+PREHOOK: Input: avc@alter_varchar_1
 #### A masked pattern was here ####
-POSTHOOK: query: select * from alter_varchar_1
+POSTHOOK: query: select * from avc.alter_varchar_1
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alter_varchar_1
+POSTHOOK: Input: avc@alter_varchar_1
 #### A masked pattern was here ####
 0	val_0
 0	val_0
@@ -40,24 +42,24 @@ POSTHOOK: Input: default@alter_varchar_1
 10	val_10
 100	val_100
 PREHOOK: query: -- change column to varchar
-alter table alter_varchar_1 change column value value varchar(20)
+alter table avc.alter_varchar_1 change column value value varchar(20)
 PREHOOK: type: ALTERTABLE_RENAMECOL
-PREHOOK: Input: default@alter_varchar_1
-PREHOOK: Output: default@alter_varchar_1
+PREHOOK: Input: avc@alter_varchar_1
+PREHOOK: Output: avc@alter_varchar_1
 POSTHOOK: query: -- change column to varchar
-alter table alter_varchar_1 change column value value varchar(20)
+alter table avc.alter_varchar_1 change column value value varchar(20)
 POSTHOOK: type: ALTERTABLE_RENAMECOL
-POSTHOOK: Input: default@alter_varchar_1
-POSTHOOK: Output: default@alter_varchar_1
+POSTHOOK: Input: avc@alter_varchar_1
+POSTHOOK: Output: avc@alter_varchar_1
 PREHOOK: query: -- contents should still look the same
-select * from alter_varchar_1
+select * from avc.alter_varchar_1
 PREHOOK: type: QUERY
-PREHOOK: Input: default@alter_varchar_1
+PREHOOK: Input: avc@alter_varchar_1
 #### A masked pattern was here ####
 POSTHOOK: query: -- contents should still look the same
-select * from alter_varchar_1
+select * from avc.alter_varchar_1
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alter_varchar_1
+POSTHOOK: Input: avc@alter_varchar_1
 #### A masked pattern was here ####
 0	val_0
 0	val_0
@@ -65,24 +67,24 @@ POSTHOOK: Input: default@alter_varchar_1
 10	val_10
 100	val_100
 PREHOOK: query: -- change column to smaller varchar
-alter table alter_varchar_1 change column value value varchar(3)
+alter table avc.alter_varchar_1 change column value value varchar(3)
 PREHOOK: type: ALTERTABLE_RENAMECOL
-PREHOOK: Input: default@alter_varchar_1
-PREHOOK: Output: default@alter_varchar_1
+PREHOOK: Input: avc@alter_varchar_1
+PREHOOK: Output: avc@alter_varchar_1
 POSTHOOK: query: -- change column to smaller varchar
-alter table alter_varchar_1 change column value value varchar(3)
+alter table avc.alter_varchar_1 change column value value varchar(3)
 POSTHOOK: type: ALTERTABLE_RENAMECOL
-POSTHOOK: Input: default@alter_varchar_1
-POSTHOOK: Output: default@alter_varchar_1
+POSTHOOK: Input: avc@alter_varchar_1
+POSTHOOK: Output: avc@alter_varchar_1
 PREHOOK: query: -- value column should be truncated now
-select * from alter_varchar_1
+select * from avc.alter_varchar_1
 PREHOOK: type: QUERY
-PREHOOK: Input: default@alter_varchar_1
+PREHOOK: Input: avc@alter_varchar_1
 #### A masked pattern was here ####
 POSTHOOK: query: -- value column should be truncated now
-select * from alter_varchar_1
+select * from avc.alter_varchar_1
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alter_varchar_1
+POSTHOOK: Input: avc@alter_varchar_1
 #### A masked pattern was here ####
 0	val
 0	val
@@ -90,24 +92,24 @@ POSTHOOK: Input: default@alter_varchar_1
 10	val
 100	val
 PREHOOK: query: -- change back to bigger varchar
-alter table alter_varchar_1 change column value value varchar(20)
+alter table avc.alter_varchar_1 change column value value varchar(20)
 PREHOOK: type: ALTERTABLE_RENAMECOL
-PREHOOK: Input: default@alter_varchar_1
-PREHOOK: Output: default@alter_varchar_1
+PREHOOK: Input: avc@alter_varchar_1
+PREHOOK: Output: avc@alter_varchar_1
 POSTHOOK: query: -- change back to bigger varchar
-alter table alter_varchar_1 change column value value varchar(20)
+alter table avc.alter_varchar_1 change column value value varchar(20)
 POSTHOOK: type: ALTERTABLE_RENAMECOL
-POSTHOOK: Input: default@alter_varchar_1
-POSTHOOK: Output: default@alter_varchar_1
+POSTHOOK: Input: avc@alter_varchar_1
+POSTHOOK: Output: avc@alter_varchar_1
 PREHOOK: query: -- column values should be full size again
-select * from alter_varchar_1
+select * from avc.alter_varchar_1
 PREHOOK: type: QUERY
-PREHOOK: Input: default@alter_varchar_1
+PREHOOK: Input: avc@alter_varchar_1
 #### A masked pattern was here ####
 POSTHOOK: query: -- column values should be full size again
-select * from alter_varchar_1
+select * from avc.alter_varchar_1
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alter_varchar_1
+POSTHOOK: Input: avc@alter_varchar_1
 #### A masked pattern was here ####
 0	val_0
 0	val_0
@@ -115,60 +117,68 @@ POSTHOOK: Input: default@alter_varchar_1
 10	val_10
 100	val_100
 PREHOOK: query: -- add varchar column
-alter table alter_varchar_1 add columns (key2 int, value2 varchar(10))
+alter table avc.alter_varchar_1 add columns (key2 int, value2 varchar(10))
 PREHOOK: type: ALTERTABLE_ADDCOLS
-PREHOOK: Input: default@alter_varchar_1
-PREHOOK: Output: default@alter_varchar_1
+PREHOOK: Input: avc@alter_varchar_1
+PREHOOK: Output: avc@alter_varchar_1
 POSTHOOK: query: -- add varchar column
-alter table alter_varchar_1 add columns (key2 int, value2 varchar(10))
+alter table avc.alter_varchar_1 add columns (key2 int, value2 varchar(10))
 POSTHOOK: type: ALTERTABLE_ADDCOLS
-POSTHOOK: Input: default@alter_varchar_1
-POSTHOOK: Output: default@alter_varchar_1
-PREHOOK: query: select * from alter_varchar_1
+POSTHOOK: Input: avc@alter_varchar_1
+POSTHOOK: Output: avc@alter_varchar_1
+PREHOOK: query: select * from avc.alter_varchar_1
 PREHOOK: type: QUERY
-PREHOOK: Input: default@alter_varchar_1
+PREHOOK: Input: avc@alter_varchar_1
 #### A masked pattern was here ####
-POSTHOOK: query: select * from alter_varchar_1
+POSTHOOK: query: select * from avc.alter_varchar_1
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alter_varchar_1
+POSTHOOK: Input: avc@alter_varchar_1
 #### A masked pattern was here ####
 0	val_0	NULL	NULL
 0	val_0	NULL	NULL
 0	val_0	NULL	NULL
 10	val_10	NULL	NULL
 100	val_100	NULL	NULL
-PREHOOK: query: insert overwrite table alter_varchar_1
+PREHOOK: query: insert overwrite table avc.alter_varchar_1
   select key, value, key, value from src order by key limit 5
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
-PREHOOK: Output: default@alter_varchar_1
-POSTHOOK: query: insert overwrite table alter_varchar_1
+PREHOOK: Output: avc@alter_varchar_1
+POSTHOOK: query: insert overwrite table avc.alter_varchar_1
   select key, value, key, value from src order by key limit 5
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
-POSTHOOK: Output: default@alter_varchar_1
+POSTHOOK: Output: avc@alter_varchar_1
 POSTHOOK: Lineage: alter_varchar_1.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: alter_varchar_1.key2 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: alter_varchar_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: alter_varchar_1.value2 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: select * from alter_varchar_1
+PREHOOK: query: select * from avc.alter_varchar_1
 PREHOOK: type: QUERY
-PREHOOK: Input: default@alter_varchar_1
+PREHOOK: Input: avc@alter_varchar_1
 #### A masked pattern was here ####
-POSTHOOK: query: select * from alter_varchar_1
+POSTHOOK: query: select * from avc.alter_varchar_1
 POSTHOOK: type: QUERY
-POSTHOOK: Input: default@alter_varchar_1
+POSTHOOK: Input: avc@alter_varchar_1
 #### A masked pattern was here ####
 0	val_0	0	val_0
 0	val_0	0	val_0
 0	val_0	0	val_0
 10	val_10	10	val_10
 100	val_100	100	val_100
-PREHOOK: query: drop table alter_varchar_1
+PREHOOK: query: drop table avc.alter_varchar_1
 PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@alter_varchar_1
-PREHOOK: Output: default@alter_varchar_1
-POSTHOOK: query: drop table alter_varchar_1
+PREHOOK: Input: avc@alter_varchar_1
+PREHOOK: Output: avc@alter_varchar_1
+POSTHOOK: query: drop table avc.alter_varchar_1
 POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@alter_varchar_1
-POSTHOOK: Output: default@alter_varchar_1
+POSTHOOK: Input: avc@alter_varchar_1
+POSTHOOK: Output: avc@alter_varchar_1
+PREHOOK: query: drop database avc
+PREHOOK: type: DROPDATABASE
+PREHOOK: Input: database:avc
+PREHOOK: Output: database:avc
+POSTHOOK: query: drop database avc
+POSTHOOK: type: DROPDATABASE
+POSTHOOK: Input: database:avc
+POSTHOOK: Output: database:avc

Modified: hive/branches/cbo/ql/src/test/results/clientpositive/alter_view_as_select.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/alter_view_as_select.q.out?rev=1621031&r1=1621030&r2=1621031&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/alter_view_as_select.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/alter_view_as_select.q.out Thu Aug 28 03:15:13 2014
@@ -1,20 +1,25 @@
-PREHOOK: query: DROP VIEW testView
-PREHOOK: type: DROPVIEW
-POSTHOOK: query: DROP VIEW testView
-POSTHOOK: type: DROPVIEW
-PREHOOK: query: CREATE VIEW testView as SELECT * FROM srcpart
+PREHOOK: query: CREATE DATABASE tv
+PREHOOK: type: CREATEDATABASE
+PREHOOK: Output: database:tv
+POSTHOOK: query: CREATE DATABASE tv
+POSTHOOK: type: CREATEDATABASE
+POSTHOOK: Output: database:tv
+PREHOOK: query: CREATE VIEW tv.testView as SELECT * FROM srcpart
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@srcpart
-POSTHOOK: query: CREATE VIEW testView as SELECT * FROM srcpart
+PREHOOK: Output: database:tv
+PREHOOK: Output: tv@testView
+POSTHOOK: query: CREATE VIEW tv.testView as SELECT * FROM srcpart
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@srcpart
-POSTHOOK: Output: default@testView
-PREHOOK: query: DESCRIBE FORMATTED testView
+POSTHOOK: Output: database:tv
+POSTHOOK: Output: tv@testView
+PREHOOK: query: DESCRIBE FORMATTED tv.testView
 PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@testview
-POSTHOOK: query: DESCRIBE FORMATTED testView
+PREHOOK: Input: tv@testview
+POSTHOOK: query: DESCRIBE FORMATTED tv.testView
 POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@testview
+POSTHOOK: Input: tv@testview
 # col_name            	data_type           	comment             
 	 	 
 key                 	string              	                    
@@ -23,7 +28,7 @@ ds                  	string             
 hr                  	string              	                    
 	 	 
 # Detailed Table Information	 	 
-Database:           	default             	 
+Database:           	tv                  	 
 #### A masked pattern was here ####
 Protect Mode:       	None                	 
 Retention:          	0                   	 
@@ -43,25 +48,29 @@ 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: ALTER VIEW testView AS SELECT value FROM src WHERE key=86
+PREHOOK: query: ALTER VIEW tv.testView AS SELECT value FROM src WHERE key=86
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@src
-POSTHOOK: query: ALTER VIEW testView AS SELECT value FROM src WHERE key=86
+PREHOOK: Output: database:tv
+PREHOOK: Output: tv@testView
+POSTHOOK: query: ALTER VIEW tv.testView AS SELECT value FROM src WHERE key=86
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@src
-POSTHOOK: Output: default@testview
-PREHOOK: query: DESCRIBE FORMATTED testView
+POSTHOOK: Output: database:tv
+POSTHOOK: Output: tv@testView
+POSTHOOK: Output: tv@testview
+PREHOOK: query: DESCRIBE FORMATTED tv.testView
 PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@testview
-POSTHOOK: query: DESCRIBE FORMATTED testView
+PREHOOK: Input: tv@testview
+POSTHOOK: query: DESCRIBE FORMATTED tv.testView
 POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@testview
+POSTHOOK: Input: tv@testview
 # col_name            	data_type           	comment             
 	 	 
 value               	string              	                    
 	 	 
 # Detailed Table Information	 	 
-Database:           	default             	 
+Database:           	tv                  	 
 #### A masked pattern was here ####
 Protect Mode:       	None                	 
 Retention:          	0                   	 
@@ -81,34 +90,38 @@ Sort Columns:       	[]                 
 # View Information	 	 
 View Original Text: 	SELECT value FROM src WHERE key=86	 
 View Expanded Text: 	SELECT `src`.`value` FROM `default`.`src` WHERE `src`.`key`=86	 
-PREHOOK: query: ALTER VIEW testView AS
+PREHOOK: query: ALTER VIEW tv.testView AS
 SELECT * FROM src
 WHERE key > 80 AND key < 100
 ORDER BY key, value
 LIMIT 10
 PREHOOK: type: CREATEVIEW
 PREHOOK: Input: default@src
-POSTHOOK: query: ALTER VIEW testView AS
+PREHOOK: Output: database:tv
+PREHOOK: Output: tv@testView
+POSTHOOK: query: ALTER VIEW tv.testView AS
 SELECT * FROM src
 WHERE key > 80 AND key < 100
 ORDER BY key, value
 LIMIT 10
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Input: default@src
-POSTHOOK: Output: default@testview
-PREHOOK: query: DESCRIBE FORMATTED testView
+POSTHOOK: Output: database:tv
+POSTHOOK: Output: tv@testView
+POSTHOOK: Output: tv@testview
+PREHOOK: query: DESCRIBE FORMATTED tv.testView
 PREHOOK: type: DESCTABLE
-PREHOOK: Input: default@testview
-POSTHOOK: query: DESCRIBE FORMATTED testView
+PREHOOK: Input: tv@testview
+POSTHOOK: query: DESCRIBE FORMATTED tv.testView
 POSTHOOK: type: DESCTABLE
-POSTHOOK: Input: default@testview
+POSTHOOK: Input: tv@testview
 # col_name            	data_type           	comment             
 	 	 
 key                 	string              	                    
 value               	string              	                    
 	 	 
 # Detailed Table Information	 	 
-Database:           	default             	 
+Database:           	tv                  	 
 #### A masked pattern was here ####
 Protect Mode:       	None                	 
 Retention:          	0                   	 
@@ -134,3 +147,19 @@ View Expanded Text: 	SELECT `src`.`key`,
 WHERE `src`.`key` > 80 AND `src`.`key` < 100	 	 
 ORDER BY `src`.`key`, `src`.`value`	 	 
 LIMIT 10	 	 
+PREHOOK: query: DROP VIEW tv.testView
+PREHOOK: type: DROPVIEW
+PREHOOK: Input: tv@testview
+PREHOOK: Output: tv@testview
+POSTHOOK: query: DROP VIEW tv.testView
+POSTHOOK: type: DROPVIEW
+POSTHOOK: Input: tv@testview
+POSTHOOK: Output: tv@testview
+PREHOOK: query: DROP DATABASE tv
+PREHOOK: type: DROPDATABASE
+PREHOOK: Input: database:tv
+PREHOOK: Output: database:tv
+POSTHOOK: query: DROP DATABASE tv
+POSTHOOK: type: DROPDATABASE
+POSTHOOK: Input: database:tv
+POSTHOOK: Output: database:tv