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: sou...@source.src +PREHOOK: Output: source@src POSTHOOK: query: create table source.src like default.src POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:source -POSTHOOK: Output: sou...@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: sou...@source.src +PREHOOK: Output: source@src POSTHOOK: query: create table source.src like default.src POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:source -POSTHOOK: Output: sou...@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