Modified: hive/branches/spark/ql/src/test/results/clientpositive/authorization_1.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/authorization_1.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/authorization_1.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/authorization_1.q.out Sat Aug 30 06:44:46 2014 @@ -3,11 +3,14 @@ PREHOOK: query: -- SORT_BEFORE_DIFF create table src_autho_test as select * from src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@src_autho_test POSTHOOK: query: -- SORT_BEFORE_DIFF create table src_autho_test as select * from src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@src_autho_test PREHOOK: query: --table grant to user @@ -254,40 +257,40 @@ PREHOOK: type: SHOW_GRANT POSTHOOK: query: show grant group hive_test_group1 on table src_autho_test(key) POSTHOOK: type: SHOW_GRANT PREHOOK: query: --role -create role src_role +create role sRc_roLE PREHOOK: type: CREATEROLE POSTHOOK: query: --role -create role src_role +create role sRc_roLE POSTHOOK: type: CREATEROLE -PREHOOK: query: grant role src_role to user hive_test_user +PREHOOK: query: grant role sRc_roLE to user hive_test_user PREHOOK: type: GRANT_ROLE -POSTHOOK: query: grant role src_role to user hive_test_user +POSTHOOK: query: grant role sRc_roLE to user hive_test_user POSTHOOK: type: GRANT_ROLE PREHOOK: query: show role grant user hive_test_user PREHOOK: type: SHOW_ROLE_GRANT POSTHOOK: query: show role grant user hive_test_user POSTHOOK: type: SHOW_ROLE_GRANT public false -1 -src_role false -1 hive_test_user +sRc_roLE false -1 hive_test_user PREHOOK: query: --column grant to role -grant select(key) on table src_autho_test to role src_role +grant select(key) on table src_autho_test to role sRc_roLE PREHOOK: type: GRANT_PRIVILEGE PREHOOK: Output: default@src_autho_test POSTHOOK: query: --column grant to role -grant select(key) on table src_autho_test to role src_role +grant select(key) on table src_autho_test to role sRc_roLE POSTHOOK: type: GRANT_PRIVILEGE POSTHOOK: Output: default@src_autho_test -PREHOOK: query: show grant role src_role on table src_autho_test +PREHOOK: query: show grant role sRc_roLE on table src_autho_test PREHOOK: type: SHOW_GRANT -POSTHOOK: query: show grant role src_role on table src_autho_test +POSTHOOK: query: show grant role sRc_roLE on table src_autho_test POSTHOOK: type: SHOW_GRANT -PREHOOK: query: show grant role src_role on table src_autho_test(key) +PREHOOK: query: show grant role sRc_roLE on table src_autho_test(key) PREHOOK: type: SHOW_GRANT -POSTHOOK: query: show grant role src_role on table src_autho_test(key) +POSTHOOK: query: show grant role sRc_roLE on table src_autho_test(key) POSTHOOK: type: SHOW_GRANT -default src_autho_test [key] src_role ROLE SELECT false -1 hive_test_user +default src_autho_test [key] sRc_roLE ROLE SELECT false -1 hive_test_user PREHOOK: query: select key from src_autho_test order by key limit 20 PREHOOK: type: QUERY PREHOOK: Input: default@src_autho_test @@ -316,20 +319,20 @@ POSTHOOK: Input: default@src_autho_test 118 118 119 -PREHOOK: query: revoke select(key) on table src_autho_test from role src_role +PREHOOK: query: revoke select(key) on table src_autho_test from role sRc_roLE PREHOOK: type: REVOKE_PRIVILEGE PREHOOK: Output: default@src_autho_test -POSTHOOK: query: revoke select(key) on table src_autho_test from role src_role +POSTHOOK: query: revoke select(key) on table src_autho_test from role sRc_roLE POSTHOOK: type: REVOKE_PRIVILEGE POSTHOOK: Output: default@src_autho_test PREHOOK: query: --table grant to role -grant select on table src_autho_test to role src_role +grant select on table src_autho_test to role sRc_roLE PREHOOK: type: GRANT_PRIVILEGE PREHOOK: Output: default@src_autho_test POSTHOOK: query: --table grant to role -grant select on table src_autho_test to role src_role +grant select on table src_autho_test to role sRc_roLE POSTHOOK: type: GRANT_PRIVILEGE POSTHOOK: Output: default@src_autho_test PREHOOK: query: select key from src_autho_test order by key limit 20 @@ -360,26 +363,26 @@ POSTHOOK: Input: default@src_autho_test 118 118 119 -PREHOOK: query: show grant role src_role on table src_autho_test +PREHOOK: query: show grant role sRc_roLE on table src_autho_test PREHOOK: type: SHOW_GRANT -POSTHOOK: query: show grant role src_role on table src_autho_test +POSTHOOK: query: show grant role sRc_roLE on table src_autho_test POSTHOOK: type: SHOW_GRANT -default src_autho_test src_role ROLE SELECT false -1 hive_test_user -PREHOOK: query: show grant role src_role on table src_autho_test(key) +default src_autho_test sRc_roLE ROLE SELECT false -1 hive_test_user +PREHOOK: query: show grant role sRc_roLE on table src_autho_test(key) PREHOOK: type: SHOW_GRANT -POSTHOOK: query: show grant role src_role on table src_autho_test(key) +POSTHOOK: query: show grant role sRc_roLE on table src_autho_test(key) POSTHOOK: type: SHOW_GRANT -PREHOOK: query: revoke select on table src_autho_test from role src_role +PREHOOK: query: revoke select on table src_autho_test from role sRc_roLE PREHOOK: type: REVOKE_PRIVILEGE PREHOOK: Output: default@src_autho_test -POSTHOOK: query: revoke select on table src_autho_test from role src_role +POSTHOOK: query: revoke select on table src_autho_test from role sRc_roLE POSTHOOK: type: REVOKE_PRIVILEGE POSTHOOK: Output: default@src_autho_test PREHOOK: query: -- drop role -drop role src_role +drop role sRc_roLE PREHOOK: type: DROPROLE POSTHOOK: query: -- drop role -drop role src_role +drop role sRc_roLE POSTHOOK: type: DROPROLE PREHOOK: query: drop table src_autho_test PREHOOK: type: DROPTABLE
Modified: hive/branches/spark/ql/src/test/results/clientpositive/authorization_2.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/authorization_2.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/authorization_2.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/authorization_2.q.out Sat Aug 30 06:44:46 2014 @@ -13,9 +13,12 @@ POSTHOOK: Output: default@authorization_ PREHOOK: query: create table src_auth_tmp as select * from src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@src_auth_tmp POSTHOOK: query: create table src_auth_tmp as select * from src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@src_auth_tmp PREHOOK: query: ALTER TABLE authorization_part SET TBLPROPERTIES ("PARTITION_LEVEL_PRIVILEGE"="TRUE") PREHOOK: type: ALTERTABLE_PROPERTIES Modified: hive/branches/spark/ql/src/test/results/clientpositive/authorization_3.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/authorization_3.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/authorization_3.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/authorization_3.q.out Sat Aug 30 06:44:46 2014 @@ -3,11 +3,14 @@ PREHOOK: query: -- SORT_BEFORE_DIFF create table src_autho_test as select * from src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@src_autho_test POSTHOOK: query: -- SORT_BEFORE_DIFF create table src_autho_test as select * from src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@src_autho_test PREHOOK: query: grant drop on table src_autho_test to user hive_test_user PREHOOK: type: GRANT_PRIVILEGE Modified: hive/branches/spark/ql/src/test/results/clientpositive/authorization_4.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/authorization_4.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/authorization_4.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/authorization_4.q.out Sat Aug 30 06:44:46 2014 @@ -3,11 +3,14 @@ PREHOOK: query: -- SORT_BEFORE_DIFF create table src_autho_test as select * from src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@src_autho_test POSTHOOK: query: -- SORT_BEFORE_DIFF create table src_autho_test as select * from src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@src_autho_test PREHOOK: query: grant All on table src_autho_test to user hive_test_user PREHOOK: type: GRANT_PRIVILEGE Modified: hive/branches/spark/ql/src/test/results/clientpositive/authorization_5.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/authorization_5.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/authorization_5.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/authorization_5.q.out Sat Aug 30 06:44:46 2014 @@ -28,34 +28,34 @@ POSTHOOK: query: SHOW GRANT USER hive_te POSTHOOK: type: SHOW_GRANT test_db hive_test_user USER DROP false -1 hive_test_user test_db hive_test_user USER SELECT false -1 hive_test_user -PREHOOK: query: CREATE ROLE db_test_role +PREHOOK: query: CREATE ROLE db_TEST_Role PREHOOK: type: CREATEROLE -POSTHOOK: query: CREATE ROLE db_test_role +POSTHOOK: query: CREATE ROLE db_TEST_Role POSTHOOK: type: CREATEROLE -PREHOOK: query: GRANT ROLE db_test_role TO USER hive_test_user +PREHOOK: query: GRANT ROLE db_TEST_Role TO USER hive_test_user PREHOOK: type: GRANT_ROLE -POSTHOOK: query: GRANT ROLE db_test_role TO USER hive_test_user +POSTHOOK: query: GRANT ROLE db_TEST_Role TO USER hive_test_user POSTHOOK: type: GRANT_ROLE PREHOOK: query: SHOW ROLE GRANT USER hive_test_user PREHOOK: type: SHOW_ROLE_GRANT POSTHOOK: query: SHOW ROLE GRANT USER hive_test_user POSTHOOK: type: SHOW_ROLE_GRANT -db_test_role false -1 hive_test_user +db_TEST_Role false -1 hive_test_user public false -1 -PREHOOK: query: GRANT drop ON DATABASE test_db TO ROLE db_test_role +PREHOOK: query: GRANT drop ON DATABASE test_db TO ROLE db_TEST_Role PREHOOK: type: GRANT_PRIVILEGE -POSTHOOK: query: GRANT drop ON DATABASE test_db TO ROLE db_test_role +POSTHOOK: query: GRANT drop ON DATABASE test_db TO ROLE db_TEST_Role POSTHOOK: type: GRANT_PRIVILEGE -PREHOOK: query: GRANT select ON DATABASE test_db TO ROLE db_test_role +PREHOOK: query: GRANT select ON DATABASE test_db TO ROLE db_TEST_Role PREHOOK: type: GRANT_PRIVILEGE -POSTHOOK: query: GRANT select ON DATABASE test_db TO ROLE db_test_role +POSTHOOK: query: GRANT select ON DATABASE test_db TO ROLE db_TEST_Role POSTHOOK: type: GRANT_PRIVILEGE -PREHOOK: query: SHOW GRANT ROLE db_test_role ON DATABASE test_db +PREHOOK: query: SHOW GRANT ROLE db_TEST_Role ON DATABASE test_db PREHOOK: type: SHOW_GRANT -POSTHOOK: query: SHOW GRANT ROLE db_test_role ON DATABASE test_db +POSTHOOK: query: SHOW GRANT ROLE db_TEST_Role ON DATABASE test_db POSTHOOK: type: SHOW_GRANT -test_db db_test_role ROLE DROP false -1 hive_test_user -test_db db_test_role ROLE SELECT false -1 hive_test_user +test_db db_TEST_Role ROLE DROP false -1 hive_test_user +test_db db_TEST_Role ROLE SELECT false -1 hive_test_user PREHOOK: query: DROP DATABASE IF EXISTS test_db PREHOOK: type: DROPDATABASE PREHOOK: Input: database:test_db Modified: hive/branches/spark/ql/src/test/results/clientpositive/authorization_6.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/authorization_6.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/authorization_6.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/authorization_6.q.out Sat Aug 30 06:44:46 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/spark/ql/src/test/results/clientpositive/authorization_8.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/authorization_8.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/authorization_8.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/authorization_8.q.out Sat Aug 30 06:44:46 2014 @@ -13,9 +13,12 @@ POSTHOOK: Output: default@tbl_j5jbymsx8e PREHOOK: query: CREATE VIEW view_j5jbymsx8e_1 as SELECT * FROM tbl_j5jbymsx8e PREHOOK: type: CREATEVIEW PREHOOK: Input: default@tbl_j5jbymsx8e +PREHOOK: Output: database:default +PREHOOK: Output: default@view_j5jbymsx8e_1 POSTHOOK: query: CREATE VIEW view_j5jbymsx8e_1 as SELECT * FROM tbl_j5jbymsx8e POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@tbl_j5jbymsx8e +POSTHOOK: Output: database:default POSTHOOK: Output: default@view_j5jbymsx8e_1 PREHOOK: query: DESCRIBE view_j5jbymsx8e_1 PREHOOK: type: DESCTABLE Modified: hive/branches/spark/ql/src/test/results/clientpositive/authorization_cli_createtab.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/authorization_cli_createtab.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/authorization_cli_createtab.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/authorization_cli_createtab.q.out Sat Aug 30 06:44:46 2014 @@ -23,9 +23,12 @@ default t_cli hive_test_user USER UPDA PREHOOK: query: create view v_cli (i) as select i from t_cli PREHOOK: type: CREATEVIEW PREHOOK: Input: default@t_cli +PREHOOK: Output: database:default +PREHOOK: Output: default@v_cli POSTHOOK: query: create view v_cli (i) as select i from t_cli POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@t_cli +POSTHOOK: Output: database:default POSTHOOK: Output: default@v_cli PREHOOK: query: show grant user hive_test_user on v_cli PREHOOK: type: SHOW_GRANT Modified: hive/branches/spark/ql/src/test/results/clientpositive/authorization_create_temp_table.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/authorization_create_temp_table.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/authorization_create_temp_table.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/authorization_create_temp_table.q.out Sat Aug 30 06:44:46 2014 @@ -1,9 +1,12 @@ PREHOOK: query: create table authorization_create_temp_table_1 as select * from src limit 10 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@authorization_create_temp_table_1 POSTHOOK: query: create table authorization_create_temp_table_1 as select * from src limit 10 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@authorization_create_temp_table_1 PREHOOK: query: grant select on authorization_create_temp_table_1 to user user1 PREHOOK: type: GRANT_PRIVILEGE Modified: hive/branches/spark/ql/src/test/results/clientpositive/authorization_grant_public_role.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/authorization_grant_public_role.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/authorization_grant_public_role.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/authorization_grant_public_role.q.out Sat Aug 30 06:44:46 2014 @@ -12,12 +12,12 @@ POSTHOOK: Output: database:default POSTHOOK: Output: default@t_gpr1 PREHOOK: query: -- all privileges should have been set for user -GRANT ALL ON t_gpr1 TO ROLE public +GRANT ALL ON t_gpr1 TO ROLE pubLic PREHOOK: type: GRANT_PRIVILEGE PREHOOK: Output: default@t_gpr1 POSTHOOK: query: -- all privileges should have been set for user -GRANT ALL ON t_gpr1 TO ROLE public +GRANT ALL ON t_gpr1 TO ROLE pubLic POSTHOOK: type: GRANT_PRIVILEGE POSTHOOK: Output: default@t_gpr1 PREHOOK: query: SHOW GRANT USER user1 ON TABLE t_gpr1 @@ -28,9 +28,9 @@ default t_gpr1 user1 USER DELETE true default t_gpr1 user1 USER INSERT true -1 user1 default t_gpr1 user1 USER SELECT true -1 user1 default t_gpr1 user1 USER UPDATE true -1 user1 -PREHOOK: query: SHOW GRANT ROLE public ON TABLE t_gpr1 +PREHOOK: query: SHOW GRANT ROLE pubLic ON TABLE t_gpr1 PREHOOK: type: SHOW_GRANT -POSTHOOK: query: SHOW GRANT ROLE public ON TABLE t_gpr1 +POSTHOOK: query: SHOW GRANT ROLE pubLic ON TABLE t_gpr1 POSTHOOK: type: SHOW_GRANT default t_gpr1 public ROLE DELETE false -1 user1 default t_gpr1 public ROLE INSERT false -1 user1 Modified: hive/branches/spark/ql/src/test/results/clientpositive/authorization_owner_actions.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/authorization_owner_actions.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/authorization_owner_actions.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/authorization_owner_actions.q.out Sat Aug 30 06:44:46 2014 @@ -35,9 +35,12 @@ POSTHOOK: Output: default@t1 PREHOOK: query: create view vt1 as select * from t1 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@t1 +PREHOOK: Output: database:default +PREHOOK: Output: default@vt1 POSTHOOK: query: create view vt1 as select * from t1 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@t1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@vt1 PREHOOK: query: drop view vt1 PREHOOK: type: DROPVIEW Modified: hive/branches/spark/ql/src/test/results/clientpositive/authorization_role_grant2.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/authorization_role_grant2.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/authorization_role_grant2.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/authorization_role_grant2.q.out Sat Aug 30 06:44:46 2014 @@ -60,9 +60,9 @@ PREHOOK: type: GRANT_ROLE POSTHOOK: query: -- grant role to another role grant src_role_wadmin to role sRc_role2 POSTHOOK: type: GRANT_ROLE -PREHOOK: query: set role ADMIN +PREHOOK: query: set role ADMIn PREHOOK: type: SHOW_ROLES -POSTHOOK: query: set role ADMIN +POSTHOOK: query: set role ADMIn POSTHOOK: type: SHOW_ROLES PREHOOK: query: grant src_role2 to user user3 PREHOOK: type: GRANT_ROLE Modified: hive/branches/spark/ql/src/test/results/clientpositive/authorization_view_sqlstd.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/authorization_view_sqlstd.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/authorization_view_sqlstd.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/authorization_view_sqlstd.q.out Sat Aug 30 06:44:46 2014 @@ -22,19 +22,25 @@ PREHOOK: query: -- protecting certain co create view vt1 as select i,k from t1 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@t1 +PREHOOK: Output: database:default +PREHOOK: Output: default@vt1 POSTHOOK: query: -- protecting certain columns create view vt1 as select i,k from t1 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@t1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@vt1 PREHOOK: query: -- protecting certain rows create view vt2 as select * from t1 where i > 1 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@t1 +PREHOOK: Output: database:default +PREHOOK: Output: default@vt2 POSTHOOK: query: -- protecting certain rows create view vt2 as select * from t1 where i > 1 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@t1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@vt2 PREHOOK: query: show grant user user1 on all PREHOOK: type: SHOW_GRANT Modified: hive/branches/spark/ql/src/test/results/clientpositive/autogen_colalias.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/autogen_colalias.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/autogen_colalias.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/autogen_colalias.q.out Sat Aug 30 06:44:46 2014 @@ -10,12 +10,15 @@ PREHOOK: query: create table dest_groupe from src group by src.key PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@dest_grouped_old1 POSTHOOK: query: create table dest_grouped_old1 as select 1+1, 2+2 as zz, src.key, test_max(length(src.value)), count(src.value), sin(count(src.value)), count(sin(src.value)), unix_timestamp(), CAST(SUM(IF(value > 10, value, 1)) AS INT), if(src.key > 1, 1, 0) from src group by src.key POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@dest_grouped_old1 PREHOOK: query: describe dest_grouped_old1 PREHOOK: type: DESCTABLE @@ -36,9 +39,12 @@ _c9 int PREHOOK: query: create table dest_grouped_old2 as select distinct src.key from src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@dest_grouped_old2 POSTHOOK: query: create table dest_grouped_old2 as select distinct src.key from src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@dest_grouped_old2 PREHOOK: query: describe dest_grouped_old2 PREHOOK: type: DESCTABLE @@ -53,12 +59,15 @@ PREHOOK: query: create table dest_groupe from src group by src.key PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@dest_grouped_new1 POSTHOOK: query: create table dest_grouped_new1 as select 1+1, 2+2 as zz, ((src.key % 2)+2)/2, test_max(length(src.value)), count(src.value), sin(count(src.value)), count(sin(src.value)), unix_timestamp(), CAST(SUM(IF(value > 10, value, 1)) AS INT), if(src.key > 10, (src.key +5) % 2, 0) from src group by src.key POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@dest_grouped_new1 PREHOOK: query: describe dest_grouped_new1 PREHOOK: type: DESCTABLE @@ -79,9 +88,12 @@ if_src_key_10_src_ke_9 double PREHOOK: query: create table dest_grouped_new2 as select distinct src.key from src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@dest_grouped_new2 POSTHOOK: query: create table dest_grouped_new2 as select distinct src.key from src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@dest_grouped_new2 PREHOOK: query: describe dest_grouped_new2 PREHOOK: type: DESCTABLE Modified: hive/branches/spark/ql/src/test/results/clientpositive/char_nested_types.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/char_nested_types.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/char_nested_types.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/char_nested_types.q.out Sat Aug 30 06:44:46 2014 @@ -164,11 +164,14 @@ create table char_nested_cta as select * from char_nested_struct PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@char_nested_struct +PREHOOK: Output: database:default +PREHOOK: Output: default@char_nested_cta POSTHOOK: query: -- nested type with create table as create table char_nested_cta as select * from char_nested_struct POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@char_nested_struct +POSTHOOK: Output: database:default POSTHOOK: Output: default@char_nested_cta PREHOOK: query: describe char_nested_cta PREHOOK: type: DESCTABLE @@ -191,11 +194,14 @@ create table char_nested_view as select * from char_nested_struct PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@char_nested_struct +PREHOOK: Output: database:default +PREHOOK: Output: default@char_nested_view POSTHOOK: query: -- nested type with view create table char_nested_view as select * from char_nested_struct POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@char_nested_struct +POSTHOOK: Output: database:default POSTHOOK: Output: default@char_nested_view PREHOOK: query: describe char_nested_view PREHOOK: type: DESCTABLE Modified: hive/branches/spark/ql/src/test/results/clientpositive/colstats_all_nulls.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/colstats_all_nulls.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/colstats_all_nulls.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/colstats_all_nulls.q.out Sat Aug 30 06:44:46 2014 @@ -17,9 +17,12 @@ POSTHOOK: Output: default@src_null PREHOOK: query: create table all_nulls as SELECT a, cast(a as double) as b, cast(a as decimal) as c FROM src_null where a is null limit 5 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src_null +PREHOOK: Output: database:default +PREHOOK: Output: default@all_nulls POSTHOOK: query: create table all_nulls as SELECT a, cast(a as double) as b, cast(a as decimal) as c FROM src_null where a is null limit 5 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src_null +POSTHOOK: Output: database:default POSTHOOK: Output: default@all_nulls PREHOOK: query: analyze table all_nulls compute statistics for columns PREHOOK: type: QUERY Modified: hive/branches/spark/ql/src/test/results/clientpositive/create_big_view.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/create_big_view.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/create_big_view.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/create_big_view.q.out Sat Aug 30 06:44:46 2014 @@ -243,6 +243,8 @@ CREATE VIEW big_view AS SELECT FROM src PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@big_view POSTHOOK: query: -- Define a view with long SQL text to test metastore and other limits. CREATE VIEW big_view AS SELECT @@ -484,6 +486,7 @@ CREATE VIEW big_view AS SELECT FROM src POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@big_view PREHOOK: query: SELECT a FROM big_view LIMIT 1 Modified: hive/branches/spark/ql/src/test/results/clientpositive/create_default_prop.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/create_default_prop.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/create_default_prop.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/create_default_prop.q.out Sat Aug 30 06:44:46 2014 @@ -35,9 +35,12 @@ a string PREHOOK: query: CREATE TABLE table_p3 AS SELECT * FROM table_p1 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@table_p1 +PREHOOK: Output: database:default +PREHOOK: Output: default@table_p3 POSTHOOK: query: CREATE TABLE table_p3 AS SELECT * FROM table_p1 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@table_p1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@table_p3 PREHOOK: query: DESC EXTENDED table_p3 PREHOOK: type: DESCTABLE Modified: hive/branches/spark/ql/src/test/results/clientpositive/create_like_tbl_props.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/create_like_tbl_props.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/create_like_tbl_props.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/create_like_tbl_props.q.out Sat Aug 30 06:44:46 2014 @@ -181,11 +181,14 @@ PREHOOK: query: --Test that CREATE TALBE CREATE VIEW test_view (key, value) AS SELECT * FROM src PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@test_view POSTHOOK: query: --Test that CREATE TALBE LIKE on a view can take explicit table properties CREATE VIEW test_view (key, value) AS SELECT * FROM src POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@test_view PREHOOK: query: CREATE TABLE test_table4 LIKE test_view TBLPROPERTIES('key'='value') PREHOOK: type: CREATETABLE Modified: hive/branches/spark/ql/src/test/results/clientpositive/create_like_view.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/create_like_view.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/create_like_view.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/create_like_view.q.out Sat Aug 30 06:44:46 2014 @@ -68,9 +68,12 @@ Storage Desc Params: PREHOOK: query: CREATE VIEW view1 AS SELECT * FROM table1 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@table1 +PREHOOK: Output: database:default +PREHOOK: Output: default@view1 POSTHOOK: query: CREATE VIEW view1 AS SELECT * FROM table1 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@table1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@view1 PREHOOK: query: CREATE TABLE table2 LIKE view1 PREHOOK: type: CREATETABLE @@ -242,10 +245,13 @@ PREHOOK: query: -- check partitions create view view1 partitioned on (ds, hr) as select * from srcpart PREHOOK: type: CREATEVIEW PREHOOK: Input: default@srcpart +PREHOOK: Output: database:default +PREHOOK: Output: default@view1 POSTHOOK: query: -- check partitions create view view1 partitioned on (ds, hr) as select * from srcpart POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@srcpart +POSTHOOK: Output: database:default POSTHOOK: Output: default@view1 PREHOOK: query: create table table1 like view1 PREHOOK: type: CREATETABLE Modified: hive/branches/spark/ql/src/test/results/clientpositive/create_or_replace_view.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/create_or_replace_view.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/create_or_replace_view.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/create_or_replace_view.q.out Sat Aug 30 06:44:46 2014 @@ -1,20 +1,25 @@ -PREHOOK: query: drop view v -PREHOOK: type: DROPVIEW -POSTHOOK: query: drop view v -POSTHOOK: type: DROPVIEW -PREHOOK: query: create view v as select * from srcpart +PREHOOK: query: create database vt +PREHOOK: type: CREATEDATABASE +PREHOOK: Output: database:vt +POSTHOOK: query: create database vt +POSTHOOK: type: CREATEDATABASE +POSTHOOK: Output: database:vt +PREHOOK: query: create view vt.v as select * from srcpart PREHOOK: type: CREATEVIEW PREHOOK: Input: default@srcpart -POSTHOOK: query: create view v as select * from srcpart +PREHOOK: Output: database:vt +PREHOOK: Output: vt@v +POSTHOOK: query: create view vt.v as select * from srcpart POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@srcpart -POSTHOOK: Output: default@v -PREHOOK: query: describe formatted v +POSTHOOK: Output: database:vt +POSTHOOK: Output: vt@v +PREHOOK: query: describe formatted vt.v PREHOOK: type: DESCTABLE -PREHOOK: Input: default@v -POSTHOOK: query: describe formatted v +PREHOOK: Input: vt@v +POSTHOOK: query: describe formatted vt.v POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@v +POSTHOOK: Input: vt@v # col_name data_type comment key string @@ -23,7 +28,7 @@ ds string hr string # Detailed Table Information -Database: default +Database: vt #### A masked pattern was here #### Protect Mode: None Retention: 0 @@ -44,61 +49,64 @@ Sort Columns: [] View Original Text: select * from srcpart View Expanded Text: select `srcpart`.`key`, `srcpart`.`value`, `srcpart`.`ds`, `srcpart`.`hr` from `default`.`srcpart` PREHOOK: query: -- modifying definition of unpartitioned view -create or replace view v partitioned on (ds, hr) as select * from srcpart +create or replace view vt.v partitioned on (ds, hr) as select * from srcpart PREHOOK: type: CREATEVIEW PREHOOK: Input: default@srcpart +PREHOOK: Output: database:vt +PREHOOK: Output: vt@v POSTHOOK: query: -- modifying definition of unpartitioned view -create or replace view v partitioned on (ds, hr) as select * from srcpart +create or replace view vt.v partitioned on (ds, hr) as select * from srcpart POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@srcpart -POSTHOOK: Output: default@v -PREHOOK: query: alter view v add partition (ds='2008-04-08',hr='11') +POSTHOOK: Output: database:vt +POSTHOOK: Output: vt@v +PREHOOK: query: alter view vt.v add partition (ds='2008-04-08',hr='11') PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Input: default@srcpart PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -PREHOOK: Input: default@v -PREHOOK: Output: default@v -POSTHOOK: query: alter view v add partition (ds='2008-04-08',hr='11') +PREHOOK: Input: vt@v +PREHOOK: Output: vt@v +POSTHOOK: query: alter view vt.v add partition (ds='2008-04-08',hr='11') POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -POSTHOOK: Input: default@v -POSTHOOK: Output: default@v -POSTHOOK: Output: default@v@ds=2008-04-08/hr=11 -PREHOOK: query: alter view v add partition (ds='2008-04-08',hr='12') +POSTHOOK: Input: vt@v +POSTHOOK: Output: vt@v +POSTHOOK: Output: vt@v@ds=2008-04-08/hr=11 +PREHOOK: query: alter view vt.v add partition (ds='2008-04-08',hr='12') PREHOOK: type: ALTERTABLE_ADDPARTS PREHOOK: Input: default@srcpart PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 -PREHOOK: Input: default@v -PREHOOK: Output: default@v -POSTHOOK: query: alter view v add partition (ds='2008-04-08',hr='12') +PREHOOK: Input: vt@v +PREHOOK: Output: vt@v +POSTHOOK: query: alter view vt.v add partition (ds='2008-04-08',hr='12') POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 -POSTHOOK: Input: default@v -POSTHOOK: Output: default@v -POSTHOOK: Output: default@v@ds=2008-04-08/hr=12 -PREHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11' +POSTHOOK: Input: vt@v +POSTHOOK: Output: vt@v +POSTHOOK: Output: vt@v@ds=2008-04-08/hr=12 +PREHOOK: query: select * from vt.v where value='val_409' and ds='2008-04-08' and hr='11' PREHOOK: type: QUERY PREHOOK: Input: default@srcpart PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -PREHOOK: Input: default@v +PREHOOK: Input: vt@v #### A masked pattern was here #### -POSTHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11' +POSTHOOK: query: select * from vt.v where value='val_409' and ds='2008-04-08' and hr='11' POSTHOOK: type: QUERY POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -POSTHOOK: Input: default@v +POSTHOOK: Input: vt@v #### A masked pattern was here #### 409 val_409 2008-04-08 11 409 val_409 2008-04-08 11 409 val_409 2008-04-08 11 -PREHOOK: query: describe formatted v +PREHOOK: query: describe formatted vt.v PREHOOK: type: DESCTABLE -PREHOOK: Input: default@v -POSTHOOK: query: describe formatted v +PREHOOK: Input: vt@v +POSTHOOK: query: describe formatted vt.v POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@v +POSTHOOK: Input: vt@v # col_name data_type comment key string @@ -111,7 +119,7 @@ ds string hr string # Detailed Table Information -Database: default +Database: vt #### A masked pattern was here #### Protect Mode: None Retention: 0 @@ -131,44 +139,69 @@ Sort Columns: [] # View Information View Original Text: select * from srcpart View Expanded Text: select `srcpart`.`key`, `srcpart`.`value`, `srcpart`.`ds`, `srcpart`.`hr` from `default`.`srcpart` -PREHOOK: query: show partitions v +PREHOOK: query: show partitions vt.v PREHOOK: type: SHOWPARTITIONS -PREHOOK: Input: default@v -POSTHOOK: query: show partitions v +PREHOOK: Input: vt@v +POSTHOOK: query: show partitions vt.v POSTHOOK: type: SHOWPARTITIONS -POSTHOOK: Input: default@v +POSTHOOK: Input: vt@v ds=2008-04-08/hr=11 ds=2008-04-08/hr=12 +PREHOOK: query: alter view vt.v drop partition (ds='2008-04-08',hr='11') +PREHOOK: type: ALTERTABLE_DROPPARTS +PREHOOK: Input: vt@v +PREHOOK: Output: vt@v@ds=2008-04-08/hr=11 +POSTHOOK: query: alter view vt.v drop partition (ds='2008-04-08',hr='11') +POSTHOOK: type: ALTERTABLE_DROPPARTS +POSTHOOK: Input: vt@v +POSTHOOK: Output: vt@v@ds=2008-04-08/hr=11 +PREHOOK: query: alter view vt.v drop partition (ds='2008-04-08',hr='12') +PREHOOK: type: ALTERTABLE_DROPPARTS +PREHOOK: Input: vt@v +PREHOOK: Output: vt@v@ds=2008-04-08/hr=12 +POSTHOOK: query: alter view vt.v drop partition (ds='2008-04-08',hr='12') +POSTHOOK: type: ALTERTABLE_DROPPARTS +POSTHOOK: Input: vt@v +POSTHOOK: Output: vt@v@ds=2008-04-08/hr=12 +PREHOOK: query: show partitions vt.v +PREHOOK: type: SHOWPARTITIONS +PREHOOK: Input: vt@v +POSTHOOK: query: show partitions vt.v +POSTHOOK: type: SHOWPARTITIONS +POSTHOOK: Input: vt@v PREHOOK: query: -- altering partitioned view 1 -create or replace view v partitioned on (ds, hr) as select value, ds, hr from srcpart +create or replace view vt.v partitioned on (ds, hr) as select value, ds, hr from srcpart PREHOOK: type: CREATEVIEW PREHOOK: Input: default@srcpart +PREHOOK: Output: database:vt +PREHOOK: Output: vt@v POSTHOOK: query: -- altering partitioned view 1 -create or replace view v partitioned on (ds, hr) as select value, ds, hr from srcpart +create or replace view vt.v partitioned on (ds, hr) as select value, ds, hr from srcpart POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@srcpart -POSTHOOK: Output: default@v -PREHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11' +POSTHOOK: Output: database:vt +POSTHOOK: Output: vt@v +PREHOOK: query: select * from vt.v where value='val_409' and ds='2008-04-08' and hr='11' PREHOOK: type: QUERY PREHOOK: Input: default@srcpart PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -PREHOOK: Input: default@v +PREHOOK: Input: vt@v #### A masked pattern was here #### -POSTHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11' +POSTHOOK: query: select * from vt.v where value='val_409' and ds='2008-04-08' and hr='11' POSTHOOK: type: QUERY POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -POSTHOOK: Input: default@v +POSTHOOK: Input: vt@v #### A masked pattern was here #### val_409 2008-04-08 11 val_409 2008-04-08 11 val_409 2008-04-08 11 -PREHOOK: query: describe formatted v +PREHOOK: query: describe formatted vt.v PREHOOK: type: DESCTABLE -PREHOOK: Input: default@v -POSTHOOK: query: describe formatted v +PREHOOK: Input: vt@v +POSTHOOK: query: describe formatted vt.v POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@v +POSTHOOK: Input: vt@v # col_name data_type comment value string @@ -180,7 +213,7 @@ ds string hr string # Detailed Table Information -Database: default +Database: vt #### A masked pattern was here #### Protect Mode: None Retention: 0 @@ -200,44 +233,45 @@ Sort Columns: [] # View Information View Original Text: select value, ds, hr from srcpart View Expanded Text: select `srcpart`.`value`, `srcpart`.`ds`, `srcpart`.`hr` from `default`.`srcpart` -PREHOOK: query: show partitions v +PREHOOK: query: show partitions vt.v PREHOOK: type: SHOWPARTITIONS -PREHOOK: Input: default@v -POSTHOOK: query: show partitions v +PREHOOK: Input: vt@v +POSTHOOK: query: show partitions vt.v POSTHOOK: type: SHOWPARTITIONS -POSTHOOK: Input: default@v -ds=2008-04-08/hr=11 -ds=2008-04-08/hr=12 +POSTHOOK: Input: vt@v PREHOOK: query: -- altering partitioned view 2 -create or replace view v partitioned on (ds, hr) as select key, value, ds, hr from srcpart +create or replace view vt.v partitioned on (ds, hr) as select key, value, ds, hr from srcpart PREHOOK: type: CREATEVIEW PREHOOK: Input: default@srcpart +PREHOOK: Output: database:vt +PREHOOK: Output: vt@v POSTHOOK: query: -- altering partitioned view 2 -create or replace view v partitioned on (ds, hr) as select key, value, ds, hr from srcpart +create or replace view vt.v partitioned on (ds, hr) as select key, value, ds, hr from srcpart POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@srcpart -POSTHOOK: Output: default@v -PREHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11' +POSTHOOK: Output: database:vt +POSTHOOK: Output: vt@v +PREHOOK: query: select * from vt.v where value='val_409' and ds='2008-04-08' and hr='11' PREHOOK: type: QUERY PREHOOK: Input: default@srcpart PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -PREHOOK: Input: default@v +PREHOOK: Input: vt@v #### A masked pattern was here #### -POSTHOOK: query: select * from v where value='val_409' and ds='2008-04-08' and hr='11' +POSTHOOK: query: select * from vt.v where value='val_409' and ds='2008-04-08' and hr='11' POSTHOOK: type: QUERY POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 -POSTHOOK: Input: default@v +POSTHOOK: Input: vt@v #### A masked pattern was here #### 409 val_409 2008-04-08 11 409 val_409 2008-04-08 11 409 val_409 2008-04-08 11 -PREHOOK: query: describe formatted v +PREHOOK: query: describe formatted vt.v PREHOOK: type: DESCTABLE -PREHOOK: Input: default@v -POSTHOOK: query: describe formatted v +PREHOOK: Input: vt@v +POSTHOOK: query: describe formatted vt.v POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@v +POSTHOOK: Input: vt@v # col_name data_type comment key string @@ -250,7 +284,7 @@ ds string hr string # Detailed Table Information -Database: default +Database: vt #### A masked pattern was here #### Protect Mode: None Retention: 0 @@ -270,22 +304,20 @@ Sort Columns: [] # View Information View Original Text: select key, value, ds, hr from srcpart View Expanded Text: select `srcpart`.`key`, `srcpart`.`value`, `srcpart`.`ds`, `srcpart`.`hr` from `default`.`srcpart` -PREHOOK: query: show partitions v +PREHOOK: query: show partitions vt.v PREHOOK: type: SHOWPARTITIONS -PREHOOK: Input: default@v -POSTHOOK: query: show partitions v +PREHOOK: Input: vt@v +POSTHOOK: query: show partitions vt.v POSTHOOK: type: SHOWPARTITIONS -POSTHOOK: Input: default@v -ds=2008-04-08/hr=11 -ds=2008-04-08/hr=12 -PREHOOK: query: drop view v +POSTHOOK: Input: vt@v +PREHOOK: query: drop view vt.v PREHOOK: type: DROPVIEW -PREHOOK: Input: default@v -PREHOOK: Output: default@v -POSTHOOK: query: drop view v +PREHOOK: Input: vt@v +PREHOOK: Output: vt@v +POSTHOOK: query: drop view vt.v POSTHOOK: type: DROPVIEW -POSTHOOK: Input: default@v -POSTHOOK: Output: default@v +POSTHOOK: Input: vt@v +POSTHOOK: Output: vt@v PREHOOK: query: -- updating to fix view with invalid definition create table srcpart_temp like srcpart PREHOOK: type: CREATETABLE @@ -296,13 +328,16 @@ create table srcpart_temp like srcpart POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@srcpart_temp -PREHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart_temp +PREHOOK: query: create view vt.v partitioned on (ds, hr) as select * from srcpart_temp PREHOOK: type: CREATEVIEW PREHOOK: Input: default@srcpart_temp -POSTHOOK: query: create view v partitioned on (ds, hr) as select * from srcpart_temp +PREHOOK: Output: database:vt +PREHOOK: Output: vt@v +POSTHOOK: query: create view vt.v partitioned on (ds, hr) as select * from srcpart_temp POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@srcpart_temp -POSTHOOK: Output: default@v +POSTHOOK: Output: database:vt +POSTHOOK: Output: vt@v PREHOOK: query: drop table srcpart_temp PREHOOK: type: DROPTABLE PREHOOK: Input: default@srcpart_temp @@ -311,21 +346,24 @@ POSTHOOK: query: drop table srcpart_temp POSTHOOK: type: DROPTABLE POSTHOOK: Input: default@srcpart_temp POSTHOOK: Output: default@srcpart_temp -PREHOOK: query: -- v is now invalid -create or replace view v partitioned on (ds, hr) as select * from srcpart +PREHOOK: query: -- vt.v is now invalid +create or replace view vt.v partitioned on (ds, hr) as select * from srcpart PREHOOK: type: CREATEVIEW PREHOOK: Input: default@srcpart -POSTHOOK: query: -- v is now invalid -create or replace view v partitioned on (ds, hr) as select * from srcpart +PREHOOK: Output: database:vt +PREHOOK: Output: vt@v +POSTHOOK: query: -- vt.v is now invalid +create or replace view vt.v partitioned on (ds, hr) as select * from srcpart POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@srcpart -POSTHOOK: Output: default@v -PREHOOK: query: describe formatted v +POSTHOOK: Output: database:vt +POSTHOOK: Output: vt@v +PREHOOK: query: describe formatted vt.v PREHOOK: type: DESCTABLE -PREHOOK: Input: default@v -POSTHOOK: query: describe formatted v +PREHOOK: Input: vt@v +POSTHOOK: query: describe formatted vt.v POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@v +POSTHOOK: Input: vt@v # col_name data_type comment key string @@ -338,7 +376,7 @@ ds string hr string # Detailed Table Information -Database: default +Database: vt #### A masked pattern was here #### Protect Mode: None Retention: 0 @@ -358,11 +396,19 @@ Sort Columns: [] # View Information View Original Text: select * from srcpart View Expanded Text: select `srcpart`.`key`, `srcpart`.`value`, `srcpart`.`ds`, `srcpart`.`hr` from `default`.`srcpart` -PREHOOK: query: drop view v +PREHOOK: query: drop view vt.v PREHOOK: type: DROPVIEW -PREHOOK: Input: default@v -PREHOOK: Output: default@v -POSTHOOK: query: drop view v +PREHOOK: Input: vt@v +PREHOOK: Output: vt@v +POSTHOOK: query: drop view vt.v POSTHOOK: type: DROPVIEW -POSTHOOK: Input: default@v -POSTHOOK: Output: default@v +POSTHOOK: Input: vt@v +POSTHOOK: Output: vt@v +PREHOOK: query: drop database vt +PREHOOK: type: DROPDATABASE +PREHOOK: Input: database:vt +PREHOOK: Output: database:vt +POSTHOOK: query: drop database vt +POSTHOOK: type: DROPDATABASE +POSTHOOK: Input: database:vt +POSTHOOK: Output: database:vt Modified: hive/branches/spark/ql/src/test/results/clientpositive/create_union_table.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/create_union_table.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/create_union_table.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/create_union_table.q.out Sat Aug 30 06:44:46 2014 @@ -15,7 +15,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: abc + name: default.abc PREHOOK: query: create table abc(mydata uniontype<int,double,array<string>,struct<a:int,b:string>>, strct struct<a:int, b:string, c:string>) Modified: hive/branches/spark/ql/src/test/results/clientpositive/create_view.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/create_view.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/create_view.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/create_view.q.out Sat Aug 30 06:44:46 2014 @@ -86,27 +86,36 @@ POSTHOOK: Input: default@src PREHOOK: query: CREATE VIEW view1 AS SELECT value FROM src WHERE key=86 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view1 POSTHOOK: query: CREATE VIEW view1 AS SELECT value FROM src WHERE key=86 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view1 PREHOOK: query: CREATE VIEW view2 AS SELECT * FROM src PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view2 POSTHOOK: query: CREATE VIEW view2 AS SELECT * FROM src POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view2 PREHOOK: query: CREATE VIEW view3(valoo) TBLPROPERTIES ("fear" = "factor") AS SELECT upper(value) FROM src WHERE key=86 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view3 POSTHOOK: query: CREATE VIEW view3(valoo) TBLPROPERTIES ("fear" = "factor") AS SELECT upper(value) FROM src WHERE key=86 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view3 PREHOOK: query: SELECT * from view1 PREHOOK: type: QUERY @@ -159,8 +168,8 @@ STAGE PLANS: Create View or replace: false columns: valoo string - expanded text: SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `default`.`src` WHERE `src`.`key`=86) `view0` - name: view0 + expanded text: SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `default`.`src` WHERE `src`.`key`=86) `default.view0` + name: default.view0 original text: SELECT upper(value) FROM src WHERE key=86 PREHOOK: query: -- make sure EXPLAIN works with a query which references a view @@ -354,7 +363,7 @@ Sort Columns: [] # View Information View Original Text: SELECT upper(value) FROM src WHERE key=86 -View Expanded Text: SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `default`.`src` WHERE `src`.`key`=86) `view3` +View Expanded Text: SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `default`.`src` WHERE `src`.`key`=86) `default.view3` PREHOOK: query: ALTER VIEW view3 SET TBLPROPERTIES ("biggest" = "loser") PREHOOK: type: ALTERVIEW_PROPERTIES PREHOOK: Input: default@view3 @@ -404,7 +413,7 @@ Sort Columns: [] # View Information View Original Text: SELECT upper(value) FROM src WHERE key=86 -View Expanded Text: SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `default`.`src` WHERE `src`.`key`=86) `view3` +View Expanded Text: SELECT `_c0` AS `valoo` FROM (SELECT upper(`src`.`value`) FROM `default`.`src` WHERE `src`.`key`=86) `default.view3` PREHOOK: query: CREATE TABLE table1 (key int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default @@ -470,9 +479,12 @@ POSTHOOK: Input: default@table1 PREHOOK: query: CREATE VIEW view4 AS SELECT * FROM table1 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@table1 +PREHOOK: Output: database:default +PREHOOK: Output: default@view4 POSTHOOK: query: CREATE VIEW view4 AS SELECT * FROM table1 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@table1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@view4 PREHOOK: query: SELECT * FROM view4 PREHOOK: type: QUERY @@ -540,11 +552,14 @@ FROM view4 v1 join view4 v2 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@table1 PREHOOK: Input: default@view4 +PREHOOK: Output: database:default +PREHOOK: Output: default@view5 POSTHOOK: query: CREATE VIEW view5 AS SELECT v1.key as key1, v2.key as key2 FROM view4 v1 join view4 v2 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@table1 POSTHOOK: Input: default@view4 +POSTHOOK: Output: database:default POSTHOOK: Output: default@view5 Warning: Shuffle Join JOIN[6][tables = [v1, v2]] in Stage 'Stage-1:MAPRED' is a cross product PREHOOK: query: SELECT * FROM view5 @@ -574,12 +589,15 @@ CREATE VIEW view6(valoo COMMENT 'I canno SELECT upper(value) as blarg FROM src WHERE key=86 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view6 POSTHOOK: query: -- verify that column name and comment in DDL portion -- overrides column alias in SELECT CREATE VIEW view6(valoo COMMENT 'I cannot spell') AS SELECT upper(value) as blarg FROM src WHERE key=86 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view6 PREHOOK: query: DESCRIBE view6 PREHOOK: type: DESCTABLE @@ -596,6 +614,8 @@ ORDER BY key, value LIMIT 10 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view7 POSTHOOK: query: -- verify that ORDER BY and LIMIT are both supported in view def CREATE VIEW view7 AS SELECT * FROM src @@ -604,6 +624,7 @@ ORDER BY key, value LIMIT 10 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view7 PREHOOK: query: SELECT * FROM view7 PREHOOK: type: QUERY @@ -705,11 +726,14 @@ SELECT test_translate('abc', 'a', 'b') FROM table1 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@table1 +PREHOOK: Output: database:default +PREHOOK: Output: default@view8 POSTHOOK: query: CREATE VIEW view8(c) AS SELECT test_translate('abc', 'a', 'b') FROM table1 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@table1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@view8 PREHOOK: query: DESCRIBE EXTENDED view8 PREHOOK: type: DESCTABLE @@ -721,7 +745,7 @@ c string #### A masked pattern was here #### FROM table1, viewExpandedText:SELECT `_c0` AS `c` FROM (SELECT `test_translate`('abc', 'a', 'b') -FROM `default`.`table1`) `view8`, tableType:VIRTUAL_VIEW) +FROM `default`.`table1`) `default.view8`, tableType:VIRTUAL_VIEW) PREHOOK: query: DESCRIBE FORMATTED view8 PREHOOK: type: DESCTABLE PREHOOK: Input: default@view8 @@ -754,7 +778,7 @@ Sort Columns: [] View Original Text: SELECT test_translate('abc', 'a', 'b') FROM table1 View Expanded Text: SELECT `_c0` AS `c` FROM (SELECT `test_translate`('abc', 'a', 'b') -FROM `default`.`table1`) `view8` +FROM `default`.`table1`) `default.view8` PREHOOK: query: SELECT * FROM view8 PREHOOK: type: QUERY PREHOOK: Input: default@table1 @@ -782,12 +806,15 @@ SELECT test_max(length(value)) FROM src PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view9 POSTHOOK: query: -- disable map-side aggregation CREATE VIEW view9(m) AS SELECT test_max(length(value)) FROM src POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view9 PREHOOK: query: DESCRIBE EXTENDED view9 PREHOOK: type: DESCTABLE @@ -799,7 +826,7 @@ m int #### A masked pattern was here #### FROM src, viewExpandedText:SELECT `_c0` AS `m` FROM (SELECT `test_max`(length(`src`.`value`)) -FROM `default`.`src`) `view9`, tableType:VIRTUAL_VIEW) +FROM `default`.`src`) `default.view9`, tableType:VIRTUAL_VIEW) PREHOOK: query: DESCRIBE FORMATTED view9 PREHOOK: type: DESCTABLE PREHOOK: Input: default@view9 @@ -832,7 +859,7 @@ Sort Columns: [] View Original Text: SELECT test_max(length(value)) FROM src View Expanded Text: SELECT `_c0` AS `m` FROM (SELECT `test_max`(length(`src`.`value`)) -FROM `default`.`src`) `view9` +FROM `default`.`src`) `default.view9` PREHOOK: query: SELECT * FROM view9 PREHOOK: type: QUERY PREHOOK: Input: default@src @@ -858,12 +885,15 @@ SELECT test_max(length(value)) FROM src PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view9 POSTHOOK: query: -- enable map-side aggregation CREATE VIEW view9(m) AS SELECT test_max(length(value)) FROM src POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view9 PREHOOK: query: DESCRIBE EXTENDED view9 PREHOOK: type: DESCTABLE @@ -875,7 +905,7 @@ m int #### A masked pattern was here #### FROM src, viewExpandedText:SELECT `_c0` AS `m` FROM (SELECT `test_max`(length(`src`.`value`)) -FROM `default`.`src`) `view9`, tableType:VIRTUAL_VIEW) +FROM `default`.`src`) `default.view9`, tableType:VIRTUAL_VIEW) PREHOOK: query: DESCRIBE FORMATTED view9 PREHOOK: type: DESCTABLE PREHOOK: Input: default@view9 @@ -908,7 +938,7 @@ Sort Columns: [] View Original Text: SELECT test_max(length(value)) FROM src View Expanded Text: SELECT `_c0` AS `m` FROM (SELECT `test_max`(length(`src`.`value`)) -FROM `default`.`src`) `view9` +FROM `default`.`src`) `default.view9` PREHOOK: query: SELECT * FROM view9 PREHOOK: type: QUERY PREHOOK: Input: default@src @@ -925,11 +955,14 @@ CREATE VIEW view10 AS SELECT slurp.* FROM (SELECT * FROM src WHERE key=86) slurp PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view10 POSTHOOK: query: -- test usage of a subselect within a view CREATE VIEW view10 AS SELECT slurp.* FROM (SELECT * FROM src WHERE key=86) slurp POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view10 PREHOOK: query: DESCRIBE EXTENDED view10 PREHOOK: type: DESCTABLE @@ -999,11 +1032,14 @@ SELECT test_explode(array(1,2,3)) AS (bo FROM table1 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@table1 +PREHOOK: Output: database:default +PREHOOK: Output: default@view11 POSTHOOK: query: CREATE VIEW view11 AS SELECT test_explode(array(1,2,3)) AS (boom) FROM table1 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@table1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@view11 PREHOOK: query: DESCRIBE EXTENDED view11 PREHOOK: type: DESCTABLE @@ -1067,11 +1103,14 @@ CREATE VIEW view12 AS SELECT * FROM src LATERAL VIEW explode(array(1,2,3)) myTable AS myCol PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view12 POSTHOOK: query: -- test usage of LATERAL within a view CREATE VIEW view12 AS SELECT * FROM src LATERAL VIEW explode(array(1,2,3)) myTable AS myCol POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view12 PREHOOK: query: DESCRIBE EXTENDED view12 PREHOOK: type: DESCTABLE @@ -1151,12 +1190,15 @@ SELECT s.key FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 ON key) s PREHOOK: type: CREATEVIEW PREHOOK: Input: default@srcbucket +PREHOOK: Output: database:default +PREHOOK: Output: default@view13 POSTHOOK: query: -- test usage of TABLESAMPLE within a view CREATE VIEW view13 AS SELECT s.key FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 ON key) s POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@srcbucket +POSTHOOK: Output: database:default POSTHOOK: Output: default@view13 PREHOOK: query: DESCRIBE EXTENDED view13 PREHOOK: type: DESCTABLE @@ -1240,6 +1282,8 @@ JOIN ON (unionsrc1.key = unionsrc2.key) PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view14 POSTHOOK: query: -- test usage of JOIN+UNION+AGG all within same view CREATE VIEW view14 AS SELECT unionsrc1.key as k1, unionsrc1.value as v1, @@ -1254,6 +1298,7 @@ JOIN ON (unionsrc1.key = unionsrc2.key) POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view14 PREHOOK: query: DESCRIBE EXTENDED view14 PREHOOK: type: DESCTABLE @@ -1379,6 +1424,8 @@ FROM src GROUP BY key PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view15 POSTHOOK: query: -- test usage of GROUP BY within view CREATE VIEW view15 AS SELECT key,COUNT(value) AS value_count @@ -1386,6 +1433,7 @@ FROM src GROUP BY key POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view15 PREHOOK: query: DESCRIBE EXTENDED view15 PREHOOK: type: DESCTABLE @@ -1467,12 +1515,15 @@ SELECT DISTINCT value FROM src PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@view16 POSTHOOK: query: -- test usage of DISTINCT within view CREATE VIEW view16 AS SELECT DISTINCT value FROM src POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@view16 PREHOOK: query: DESCRIBE EXTENDED view16 PREHOOK: type: DESCTABLE Modified: hive/branches/spark/ql/src/test/results/clientpositive/create_view_partitioned.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/create_view_partitioned.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/create_view_partitioned.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/create_view_partitioned.q.out Sat Aug 30 06:44:46 2014 @@ -20,6 +20,8 @@ FROM src WHERE key=86 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@vp1 POSTHOOK: query: -- test partitioned view definition -- (underlying table is not actually partitioned) CREATE VIEW vp1 @@ -30,6 +32,7 @@ FROM src WHERE key=86 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@vp1 PREHOOK: query: DESCRIBE EXTENDED vp1 PREHOOK: type: DESCTABLE @@ -245,6 +248,8 @@ PARTITIONED ON (hr) AS SELECT * FROM srcpart WHERE key < 10 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@srcpart +PREHOOK: Output: database:default +PREHOOK: Output: default@vp2 POSTHOOK: query: -- test a partitioned view on top of an underlying partitioned table, -- but with only a suffix of the partitioning columns CREATE VIEW vp2 @@ -252,6 +257,7 @@ PARTITIONED ON (hr) AS SELECT * FROM srcpart WHERE key < 10 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@srcpart +POSTHOOK: Output: database:default POSTHOOK: Output: default@vp2 PREHOOK: query: DESCRIBE FORMATTED vp2 PREHOOK: type: DESCTABLE @@ -355,6 +361,8 @@ FROM src WHERE key=86 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@vp3 POSTHOOK: query: -- test a partitioned view where the PARTITIONED ON clause references -- an imposed column name CREATE VIEW vp3(k,v) @@ -365,6 +373,7 @@ FROM src WHERE key=86 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@vp3 PREHOOK: query: DESCRIBE FORMATTED vp3 PREHOOK: type: DESCTABLE @@ -405,7 +414,7 @@ FROM src WHERE key=86 View Expanded Text: SELECT `key` AS `k`, `value` AS `v` FROM (SELECT `src`.`key`, `src`.`value` FROM `default`.`src` -WHERE `src`.`key`=86) `vp3` +WHERE `src`.`key`=86) `default.vp3` PREHOOK: query: ALTER VIEW vp3 ADD PARTITION (v='val_86') PREHOOK: type: ALTERTABLE_ADDPARTS Modified: hive/branches/spark/ql/src/test/results/clientpositive/create_view_translate.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/create_view_translate.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/create_view_translate.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/create_view_translate.q.out Sat Aug 30 06:44:46 2014 @@ -9,9 +9,12 @@ POSTHOOK: type: DROPVIEW PREHOOK: query: create view v as select cast(key as string) from src PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@v POSTHOOK: query: create view v as select cast(key as string) from src POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@v PREHOOK: query: describe formatted v PREHOOK: type: DESCTABLE @@ -49,11 +52,14 @@ PREHOOK: query: create view w as select ) a PREHOOK: type: CREATEVIEW PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@w POSTHOOK: query: create view w as select key, value from ( select key, value from src ) a POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@w PREHOOK: query: describe formatted w PREHOOK: type: DESCTABLE @@ -135,15 +141,18 @@ STAGE PLANS: or replace: false columns: id int, _c1 string expanded text: SELECT `items`.`id`, `items`.`info`['price'] FROM `default`.`items` - name: priceview + name: default.priceview original text: SELECT items.id, items.info['price'] FROM items PREHOOK: query: CREATE VIEW priceview AS SELECT items.id, items.info['price'] FROM items PREHOOK: type: CREATEVIEW PREHOOK: Input: default@items +PREHOOK: Output: database:default +PREHOOK: Output: default@priceview POSTHOOK: query: CREATE VIEW priceview AS SELECT items.id, items.info['price'] FROM items POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@items +POSTHOOK: Output: database:default POSTHOOK: Output: default@priceview PREHOOK: query: select * from priceview PREHOOK: type: QUERY Modified: hive/branches/spark/ql/src/test/results/clientpositive/cross_product_check_1.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/cross_product_check_1.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/cross_product_check_1.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/cross_product_check_1.q.out Sat Aug 30 06:44:46 2014 @@ -2,21 +2,27 @@ PREHOOK: query: create table A as select * from src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@A POSTHOOK: query: create table A as select * from src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@A PREHOOK: query: create table B as select * from src limit 10 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@B POSTHOOK: query: create table B as select * from src limit 10 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@B Warning: Shuffle Join JOIN[4][tables = [a, b]] in Stage 'Stage-1:MAPRED' is a cross product PREHOOK: query: explain select * from A join B Modified: hive/branches/spark/ql/src/test/results/clientpositive/cross_product_check_2.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/cross_product_check_2.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/cross_product_check_2.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/cross_product_check_2.q.out Sat Aug 30 06:44:46 2014 @@ -2,21 +2,27 @@ PREHOOK: query: create table A as select * from src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@A POSTHOOK: query: create table A as select * from src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@A PREHOOK: query: create table B as select * from src limit 10 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@B POSTHOOK: query: create table B as select * from src limit 10 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@B Warning: Map Join MAPJOIN[7][bigTable=a] in task 'Stage-3:MAPRED' is a cross product PREHOOK: query: explain select * from A join B Modified: hive/branches/spark/ql/src/test/results/clientpositive/ctas.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/ctas.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/ctas.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/ctas.q.out Sat Aug 30 06:44:46 2014 @@ -97,7 +97,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: nzhang_CTAS1 + name: default.nzhang_CTAS1 Stage: Stage-3 Stats-Aggr Operator @@ -105,9 +105,12 @@ STAGE PLANS: PREHOOK: query: create table nzhang_CTAS1 as select key k, value from src sort by k, value limit 10 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@nzhang_CTAS1 POSTHOOK: query: create table nzhang_CTAS1 as select key k, value from src sort by k, value limit 10 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@nzhang_CTAS1 PREHOOK: query: select * from nzhang_CTAS1 PREHOOK: type: QUERY @@ -242,7 +245,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: nzhang_ctas2 + name: default.nzhang_ctas2 Stage: Stage-3 Stats-Aggr Operator @@ -250,9 +253,12 @@ STAGE PLANS: PREHOOK: query: create table nzhang_ctas2 as select * from src sort by key, value limit 10 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@nzhang_ctas2 POSTHOOK: query: create table nzhang_ctas2 as select * from src sort by key, value limit 10 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@nzhang_ctas2 PREHOOK: query: select * from nzhang_ctas2 PREHOOK: type: QUERY @@ -387,7 +393,7 @@ STAGE PLANS: input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat serde name: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe - name: nzhang_ctas3 + name: default.nzhang_ctas3 Stage: Stage-3 Stats-Aggr Operator @@ -395,9 +401,12 @@ STAGE PLANS: PREHOOK: query: create table nzhang_ctas3 row format serde "org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe" stored as RCFile as select key/2 half_key, concat(value, "_con") conb from src sort by half_key, conb limit 10 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@nzhang_ctas3 POSTHOOK: query: create table nzhang_ctas3 row format serde "org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe" stored as RCFile as select key/2 half_key, concat(value, "_con") conb from src sort by half_key, conb limit 10 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@nzhang_ctas3 PREHOOK: query: select * from nzhang_ctas3 PREHOOK: type: QUERY @@ -598,7 +607,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: nzhang_ctas4 + name: default.nzhang_ctas4 Stage: Stage-3 Stats-Aggr Operator @@ -606,9 +615,12 @@ STAGE PLANS: PREHOOK: query: create table nzhang_ctas4 row format delimited fields terminated by ',' stored as textfile as select key, value from src sort by key, value limit 10 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@nzhang_ctas4 POSTHOOK: query: create table nzhang_ctas4 row format delimited fields terminated by ',' stored as textfile as select key, value from src sort by key, value limit 10 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@nzhang_ctas4 PREHOOK: query: select * from nzhang_ctas4 PREHOOK: type: QUERY @@ -897,7 +909,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: nzhang_ctas5 + name: default.nzhang_ctas5 Stage: Stage-3 Stats-Aggr Operator @@ -906,9 +918,12 @@ STAGE PLANS: PREHOOK: query: create table nzhang_ctas5 row format delimited fields terminated by ',' lines terminated by '\012' stored as textfile as select key, value from src sort by key, value limit 10 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@nzhang_ctas5 POSTHOOK: query: create table nzhang_ctas5 row format delimited fields terminated by ',' lines terminated by '\012' stored as textfile as select key, value from src sort by key, value limit 10 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@nzhang_ctas5 PREHOOK: query: create table nzhang_ctas6 (key string, `to` string) PREHOOK: type: CREATETABLE @@ -931,7 +946,10 @@ POSTHOOK: Lineage: nzhang_ctas6.to SIMPL PREHOOK: query: create table nzhang_ctas7 as select key, `to` from nzhang_ctas6 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@nzhang_ctas6 +PREHOOK: Output: database:default +PREHOOK: Output: default@nzhang_ctas7 POSTHOOK: query: create table nzhang_ctas7 as select key, `to` from nzhang_ctas6 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@nzhang_ctas6 +POSTHOOK: Output: database:default POSTHOOK: Output: default@nzhang_ctas7 Modified: hive/branches/spark/ql/src/test/results/clientpositive/ctas_char.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/ctas_char.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/ctas_char.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/ctas_char.q.out Sat Aug 30 06:44:46 2014 @@ -34,19 +34,25 @@ PREHOOK: query: -- create table as with create table ctas_char_2 as select key, value from ctas_char_1 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@ctas_char_1 +PREHOOK: Output: database:default +PREHOOK: Output: default@ctas_char_2 POSTHOOK: query: -- create table as with char column create table ctas_char_2 as select key, value from ctas_char_1 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@ctas_char_1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@ctas_char_2 PREHOOK: query: -- view with char column create view ctas_char_3 as select key, value from ctas_char_2 PREHOOK: type: CREATEVIEW PREHOOK: Input: default@ctas_char_2 +PREHOOK: Output: database:default +PREHOOK: Output: default@ctas_char_3 POSTHOOK: query: -- view with char column create view ctas_char_3 as select key, value from ctas_char_2 POSTHOOK: type: CREATEVIEW POSTHOOK: Input: default@ctas_char_2 +POSTHOOK: Output: database:default POSTHOOK: Output: default@ctas_char_3 PREHOOK: query: select key, value from ctas_char_1 PREHOOK: type: QUERY Modified: hive/branches/spark/ql/src/test/results/clientpositive/ctas_colname.q.out URL: http://svn.apache.org/viewvc/hive/branches/spark/ql/src/test/results/clientpositive/ctas_colname.q.out?rev=1621416&r1=1621415&r2=1621416&view=diff ============================================================================== --- hive/branches/spark/ql/src/test/results/clientpositive/ctas_colname.q.out (original) +++ hive/branches/spark/ql/src/test/results/clientpositive/ctas_colname.q.out Sat Aug 30 06:44:46 2014 @@ -72,7 +72,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: summary + name: default.summary Stage: Stage-2 Stats-Aggr Operator @@ -80,9 +80,12 @@ STAGE PLANS: PREHOOK: query: create table summary as select *, sum(key), count(value) from src PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@summary POSTHOOK: query: create table summary as select *, sum(key), count(value) from src POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@summary PREHOOK: query: describe formatted summary PREHOOK: type: DESCTABLE @@ -189,7 +192,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: x4 + name: default.x4 Stage: Stage-2 Stats-Aggr Operator @@ -197,9 +200,12 @@ STAGE PLANS: PREHOOK: query: create table x4 as select *, rank() over(partition by key order by value) as rr from src1 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src1 +PREHOOK: Output: database:default +PREHOOK: Output: default@x4 POSTHOOK: query: create table x4 as select *, rank() over(partition by key order by value) as rr from src1 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@x4 PREHOOK: query: describe formatted x4 PREHOOK: type: DESCTABLE @@ -354,7 +360,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: x5 + name: default.x5 Stage: Stage-3 Stats-Aggr Operator @@ -362,9 +368,12 @@ STAGE PLANS: PREHOOK: query: create table x5 as select *, lead(key,1) over(partition by key order by value) as lead1 from src limit 20 PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@x5 POSTHOOK: query: create table x5 as select *, lead(key,1) over(partition by key order by value) as lead1 from src limit 20 POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@x5 PREHOOK: query: describe formatted x5 PREHOOK: type: DESCTABLE @@ -497,7 +506,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: x6 + name: default.x6 Stage: Stage-2 Stats-Aggr Operator @@ -505,9 +514,12 @@ STAGE PLANS: PREHOOK: query: create table x6 as select * from (select *, max(key) from src1) a PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src1 +PREHOOK: Output: database:default +PREHOOK: Output: default@x6 POSTHOOK: query: create table x6 as select * from (select *, max(key) from src1) a POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src1 +POSTHOOK: Output: database:default POSTHOOK: Output: default@x6 PREHOOK: query: describe formatted x6 PREHOOK: type: DESCTABLE @@ -619,7 +631,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: x7 + name: default.x7 Stage: Stage-2 Stats-Aggr Operator @@ -627,9 +639,12 @@ STAGE PLANS: PREHOOK: query: create table x7 as select * from (select * from src group by key) a PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@x7 POSTHOOK: query: create table x7 as select * from (select * from src group by key) a POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@x7 PREHOOK: query: describe formatted x7 PREHOOK: type: DESCTABLE @@ -1051,7 +1066,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: x8 + name: default.x8 Stage: Stage-2 Stats-Aggr Operator @@ -1059,9 +1074,12 @@ STAGE PLANS: PREHOOK: query: create table x8 as select * from (select * from src group by key having key < 9) a PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@x8 POSTHOOK: query: create table x8 as select * from (select * from src group by key having key < 9) a POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@x8 PREHOOK: query: describe formatted x8 PREHOOK: type: DESCTABLE @@ -1185,7 +1203,7 @@ STAGE PLANS: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: x9 + name: default.x9 Stage: Stage-2 Stats-Aggr Operator @@ -1193,9 +1211,12 @@ STAGE PLANS: PREHOOK: query: create table x9 as select * from (select max(value),key from src group by key having key < 9 AND max(value) IS NOT NULL) a PREHOOK: type: CREATETABLE_AS_SELECT PREHOOK: Input: default@src +PREHOOK: Output: database:default +PREHOOK: Output: default@x9 POSTHOOK: query: create table x9 as select * from (select max(value),key from src group by key having key < 9 AND max(value) IS NOT NULL) a POSTHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: Input: default@src +POSTHOOK: Output: database:default POSTHOOK: Output: default@x9 PREHOOK: query: describe formatted x9 PREHOOK: type: DESCTABLE
