Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_revoke_table_fail1.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_revoke_table_fail1.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_revoke_table_fail1.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_revoke_table_fail1.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator;
Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_revoke_table_fail2.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_revoke_table_fail2.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_revoke_table_fail2.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_revoke_table_fail2.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_cycles1.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_cycles1.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_cycles1.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_cycles1.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set user.name=hive_admin_user; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_cycles2.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_cycles2.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_cycles2.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_cycles2.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_grant.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_grant.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_grant.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_grant.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set user.name=hive_admin_user; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_grant2.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_grant2.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_grant2.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_grant2.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set user.name=hive_admin_user; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_grant_nosuchrole.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_grant_nosuchrole.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_grant_nosuchrole.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_grant_nosuchrole.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set user.name=hive_admin_user; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_grant_otherrole.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_grant_otherrole.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_grant_otherrole.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_grant_otherrole.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_grant_otheruser.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_grant_otheruser.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_grant_otheruser.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_role_grant_otheruser.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_rolehierarchy_privs.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_rolehierarchy_privs.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_rolehierarchy_privs.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_rolehierarchy_privs.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_select.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_select.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_select.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_select.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_select_view.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_select_view.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_select_view.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_select_view.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_set_role_neg1.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_set_role_neg1.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_set_role_neg1.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_set_role_neg1.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; -- an error should be thrown if 'set role ' is done for role that does not exist Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_set_role_neg2.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_set_role_neg2.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_set_role_neg2.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_set_role_neg2.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set user.name=hive_admin_user; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_grant_otherrole.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_grant_otherrole.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_grant_otherrole.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_grant_otherrole.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_grant_otheruser_all.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_grant_otheruser_all.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_grant_otheruser_all.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_grant_otheruser_all.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_grant_otheruser_alltabs.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_grant_otheruser_alltabs.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_grant_otheruser_alltabs.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_grant_otheruser_alltabs.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_grant_otheruser_wtab.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_grant_otheruser_wtab.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_grant_otheruser_wtab.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_grant_otheruser_wtab.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_parts_nosel.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_parts_nosel.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_parts_nosel.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_parts_nosel.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_role_principals_no_admin.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_role_principals_no_admin.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_role_principals_no_admin.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_role_principals_no_admin.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; -- This test will fail because hive_test_user is not in admin role show principals role1; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_roles_no_admin.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_roles_no_admin.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_roles_no_admin.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_show_roles_no_admin.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; -- This test will fail because hive_test_user is not in admin role show roles; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_table_grant_nosuchrole.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_table_grant_nosuchrole.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_table_grant_nosuchrole.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_table_grant_nosuchrole.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_truncate.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_truncate.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_truncate.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_truncate.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_add_partition.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_add_partition.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_add_partition.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_add_partition.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_alterpart_loc.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_alterpart_loc.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_alterpart_loc.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_alterpart_loc.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_altertab_setloc.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_altertab_setloc.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_altertab_setloc.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_altertab_setloc.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_create_table1.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_create_table1.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_create_table1.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_create_table1.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_create_table_ext.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_create_table_ext.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_create_table_ext.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_create_table_ext.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_createdb.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_createdb.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_createdb.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_createdb.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_index.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_index.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_index.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_index.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_insert.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_insert.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_insert.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_insert.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_insert_local.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_insert_local.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_insert_local.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_insert_local.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_load_data.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_load_data.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_load_data.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorization_uri_load_data.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/authorize_create_tbl.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/authorize_create_tbl.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/authorize_create_tbl.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/authorize_create_tbl.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; Modified: hive/branches/cbo/ql/src/test/queries/clientnegative/temp_table_authorize_create_tbl.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientnegative/temp_table_authorize_create_tbl.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientnegative/temp_table_authorize_create_tbl.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientnegative/temp_table_authorize_create_tbl.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/alter_rename_table.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/alter_rename_table.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/alter_rename_table.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/alter_rename_table.q Fri Aug 22 21:36:47 2014 @@ -26,3 +26,10 @@ ALTER TABLE source.srcpart RENAME TO tar ALTER TABLE source.srcpart RENAME TO target.srcpart; select * from target.srcpart tablesample (10 rows); + +create table source.src like default.src; +create table source.src1 like default.src; +load data local inpath '../../data/files/kv1.txt' overwrite into table source.src; + +ALTER TABLE source.src RENAME TO target.src1; +select * from target.src1 tablesample (10 rows); \ No newline at end of file Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_1_sql_std.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_1_sql_std.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_1_sql_std.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_1_sql_std.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set user.name=hive_admin_user; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_admin_almighty1.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_admin_almighty1.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_admin_almighty1.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_admin_almighty1.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set user.name=hive_test_user; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_admin_almighty2.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_admin_almighty2.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_admin_almighty2.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_admin_almighty2.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactory; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set user.name=hive_admin_user; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_create_func1.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_create_func1.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_create_func1.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_create_func1.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_create_macro1.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_create_macro1.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_create_macro1.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_create_macro1.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_create_table_owner_privs.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_create_table_owner_privs.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_create_table_owner_privs.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_create_table_owner_privs.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_create_temp_table.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_create_temp_table.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_create_temp_table.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_create_temp_table.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_grant_public_role.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_grant_public_role.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_grant_public_role.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_grant_public_role.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_grant_table_priv.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_grant_table_priv.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_grant_table_priv.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_grant_table_priv.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_index.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_index.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_index.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_index.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.stats.dbclass=fs; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_insert.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_insert.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_insert.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_insert.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_owner_actions.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_owner_actions.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_owner_actions.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_owner_actions.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_owner_actions_db.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_owner_actions_db.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_owner_actions_db.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_owner_actions_db.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_parts.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_parts.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_parts.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_parts.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_reset.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_reset.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_reset.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_reset.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_revoke_table_priv.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_revoke_table_priv.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_revoke_table_priv.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_revoke_table_priv.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_role_grant1.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_role_grant1.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_role_grant1.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_role_grant1.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set user.name=hive_admin_user; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_role_grant2.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_role_grant2.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_role_grant2.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_role_grant2.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_set_show_current_role.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_set_show_current_role.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_set_show_current_role.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_set_show_current_role.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set user.name=hive_admin_user; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_show_grant.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_show_grant.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_show_grant.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_show_grant.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_view_sqlstd.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_view_sqlstd.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_view_sqlstd.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/authorization_view_sqlstd.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +set hive.test.authz.sstd.hs2.mode=true; set hive.security.authorization.manager=org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactoryForTest; set hive.security.authenticator.manager=org.apache.hadoop.hive.ql.security.SessionStateConfigUserAuthenticator; set hive.security.authorization.enabled=true; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/literal_decimal.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/literal_decimal.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/literal_decimal.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/literal_decimal.q Fri Aug 22 21:36:47 2014 @@ -1,5 +1,5 @@ set hive.fetch.task.conversion=more; -EXPLAIN SELECT -1BD, 0BD, 1BD, 3.14BD, -3.14BD, 99999999999999999BD, 99999999999999999.9999999999999BD, 1E-99BD, 1E99BD FROM src LIMIT 1; +EXPLAIN SELECT -1BD, 0BD, 1BD, 3.14BD, -3.14BD, 99999999999999999BD, 99999999999999999.9999999999999BD, 1E99BD FROM src LIMIT 1; -SELECT -1BD, 0BD, 1BD, 3.14BD, -3.14BD, 99999999999999999BD, 99999999999999999.9999999999999BD, 1E-99BD, 1E99BD FROM src LIMIT 1; +SELECT -1BD, 0BD, 1BD, 3.14BD, -3.14BD, 99999999999999999BD, 99999999999999999.9999999999999BD, 1E99BD FROM src LIMIT 1; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/orc_ppd_decimal.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/orc_ppd_decimal.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/orc_ppd_decimal.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/orc_ppd_decimal.q Fri Aug 22 21:36:47 2014 @@ -85,6 +85,18 @@ set hive.optimize.index.filter=true; select sum(hash(*)) from newtypesorc where d<=cast('11.22' as float); set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypesorc where d<=cast('11.22' as decimal); + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypesorc where d<=cast('11.22' as decimal); + +set hive.optimize.index.filter=false; +select sum(hash(*)) from newtypesorc where d<=11.22BD; + +set hive.optimize.index.filter=true; +select sum(hash(*)) from newtypesorc where d<=11.22BD; + +set hive.optimize.index.filter=false; select sum(hash(*)) from newtypesorc where d<=12; set hive.optimize.index.filter=true; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/parquet_types.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/parquet_types.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/parquet_types.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/parquet_types.q Fri Aug 22 21:36:47 2014 @@ -8,7 +8,9 @@ CREATE TABLE parquet_types_staging ( cfloat float, cdouble double, cstring1 string, - t timestamp + t timestamp, + cchar char(5), + cvarchar varchar(10) ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'; @@ -19,7 +21,9 @@ CREATE TABLE parquet_types ( cfloat float, cdouble double, cstring1 string, - t timestamp + t timestamp, + cchar char(5), + cvarchar varchar(10) ) STORED AS PARQUET; LOAD DATA LOCAL INPATH '../../data/files/parquet_types.txt' OVERWRITE INTO TABLE parquet_types_staging; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/repair.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/repair.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/repair.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/repair.q Fri Aug 22 21:36:47 2014 @@ -8,10 +8,10 @@ dfs ${system:test.dfs.mkdir} ${system:te dfs ${system:test.dfs.mkdir} ${system:test.warehouse.dir}/repairtable/p1=b/p2=a; dfs -touchz ${system:test.warehouse.dir}/repairtable/p1=b/p2=a/datafile; -MSCK TABLE repairtable; +MSCK TABLE default.repairtable; -MSCK REPAIR TABLE repairtable; +MSCK REPAIR TABLE default.repairtable; MSCK TABLE repairtable; -DROP TABLE repairtable; +DROP TABLE default.repairtable; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/show_partitions.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/show_partitions.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/show_partitions.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/show_partitions.q Fri Aug 22 21:36:47 2014 @@ -3,3 +3,30 @@ SHOW PARTITIONS default.srcpart; SHOW PARTITIONS srcpart PARTITION(hr='11'); SHOW PARTITIONS srcpart PARTITION(ds='2008-04-08'); SHOW PARTITIONS srcpart PARTITION(ds='2008-04-08', hr='12'); + + +SHOW PARTITIONS default.srcpart; +SHOW PARTITIONS default.srcpart PARTITION(hr='11'); +SHOW PARTITIONS default.srcpart PARTITION(ds='2008-04-08'); +SHOW PARTITIONS default.srcpart PARTITION(ds='2008-04-08', hr='12'); + +CREATE DATABASE db1; +USE db1; + +CREATE TABLE srcpart (key1 INT, value1 STRING) PARTITIONED BY (ds STRING, hr STRING); +ALTER TABLE srcpart ADD PARTITION (ds='3', hr='3'); +ALTER TABLE srcpart ADD PARTITION (ds='4', hr='4'); +ALTER TABLE srcpart ADD PARTITION (ds='4', hr='5'); + +-- from db1 to default db +SHOW PARTITIONS default.srcpart PARTITION(hr='11'); +SHOW PARTITIONS default.srcpart PARTITION(ds='2008-04-08', hr='12'); + +-- from db1 to db1 +SHOW PARTITIONS srcpart PARTITION(ds='4'); +SHOW PARTITIONS srcpart PARTITION(ds='3', hr='3'); + +use default; +-- from default to db1 +SHOW PARTITIONS db1.srcpart PARTITION(ds='4'); +SHOW PARTITIONS db1.srcpart PARTITION(ds='3', hr='3'); \ No newline at end of file Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/show_tblproperties.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/show_tblproperties.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/show_tblproperties.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/show_tblproperties.q Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ create table tmpfoo (a String); show tblproperties tmpfoo("bar"); +show tblproperties default.tmpfoo("bar"); alter table tmpfoo set tblproperties ("bar" = "bar value"); alter table tmpfoo set tblproperties ("tmp" = "true"); @@ -8,4 +9,26 @@ alter table tmpfoo set tblproperties ("t show tblproperties tmpfoo; show tblproperties tmpfoo("bar"); -drop table tmpfoo; +show tblproperties default.tmpfoo; +show tblproperties default.tmpfoo("bar"); + +CREATE DATABASE db1; +USE db1; + +CREATE TABLE tmpfoo (b STRING); +alter table tmpfoo set tblproperties ("bar" = "bar value1"); +alter table tmpfoo set tblproperties ("tmp" = "true1"); + +-- from db1 to default db +show tblproperties default.tmpfoo; +show tblproperties default.tmpfoo("bar"); + +-- from db1 to db1 +show tblproperties tmpfoo; +show tblproperties tmpfoo("bar"); + +use default; +-- from default to db1 +show tblproperties db1.tmpfoo; +show tblproperties db1.tmpfoo("bar"); + Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/union.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/union.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/union.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/union.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +-- SORT_BEFORE_DIFF -- union case: both subqueries are map jobs on same input, followed by filesink EXPLAIN Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/union11.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/union11.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/union11.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/union11.q Fri Aug 22 21:36:47 2014 @@ -1,5 +1,5 @@ set hive.map.aggr = true; - +-- SORT_BEFORE_DIFF -- union case: all subqueries are a map-reduce jobs, 3 way union, same input for all sub-queries, followed by reducesink explain Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/union13.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/union13.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/union13.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/union13.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +-- SORT_BEFORE_DIFF -- union case: both subqueries are a map-only jobs, same input, followed by filesink explain Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/union14.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/union14.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/union14.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/union14.q Fri Aug 22 21:36:47 2014 @@ -1,5 +1,5 @@ set hive.map.aggr = true; - +-- SORT_BEFORE_DIFF -- union case: 1 subquery is a map-reduce job, different inputs for sub-queries, followed by reducesink explain Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/union15.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/union15.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/union15.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/union15.q Fri Aug 22 21:36:47 2014 @@ -1,5 +1,5 @@ set hive.map.aggr = true; - +-- SORT_BEFORE_DIFF -- union case: 1 subquery is a map-reduce job, different inputs for sub-queries, followed by reducesink explain Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/union16.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/union16.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/union16.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/union16.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +-- SORT_BEFORE_DIFF EXPLAIN SELECT count(1) FROM ( SELECT key, value FROM src UNION ALL Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/union17.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/union17.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/union17.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/union17.q Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ CREATE TABLE DEST1(key STRING, value STRING) STORED AS TEXTFILE; CREATE TABLE DEST2(key STRING, val1 STRING, val2 STRING) STORED AS TEXTFILE; +-- SORT_BEFORE_DIFF -- union case:map-reduce sub-queries followed by multi-table insert explain Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/union2.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/union2.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/union2.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/union2.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +-- SORT_BEFORE_DIFF -- union case: both subqueries are map-reduce jobs on same input, followed by reduce sink explain Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/union20.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/union20.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/union20.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/union20.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +-- SORT_BEFORE_DIFF -- union :map-reduce sub-queries followed by join explain Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/union21.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/union21.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/union21.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/union21.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +-- SORT_BEFORE_DIFF -- union of constants, udf outputs, and columns from text table and thrift table explain Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/union27.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/union27.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/union27.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/union27.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +-- SORT_BEFORE_DIFF create table jackson_sev_same as select * from src; create table dim_pho as select * from src; create table jackson_sev_add as select * from src; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/union3.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/union3.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/union3.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/union3.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +-- SORT_BEFORE_DIFF explain SELECT * Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/union33.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/union33.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/union33.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/union33.q Fri Aug 22 21:36:47 2014 @@ -1,5 +1,5 @@ set hive.groupby.skewindata=true; - +-- SORT_BEFORE_DIFF -- This tests that a union all with a map only subquery on one side and a -- subquery involving two map reduce jobs on the other runs correctly. Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/union5.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/union5.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/union5.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/union5.q Fri Aug 22 21:36:47 2014 @@ -1,5 +1,5 @@ set hive.map.aggr = true; - +-- SORT_BEFORE_DIFF -- union case: both subqueries are map-reduce jobs on same input, followed by reduce sink explain Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/union7.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/union7.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/union7.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/union7.q Fri Aug 22 21:36:47 2014 @@ -1,5 +1,6 @@ set hive.map.aggr = true; +-- SORT_BEFORE_DIFF -- union case: 1 subquery is a map-reduce job, different inputs for sub-queries, followed by reducesink explain Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/union8.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/union8.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/union8.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/union8.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +-- SORT_BEFORE_DIFF -- union case: all subqueries are a map-only jobs, 3 way union, same input for all sub-queries, followed by filesink explain Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/union9.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/union9.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/union9.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/union9.q Fri Aug 22 21:36:47 2014 @@ -1,3 +1,4 @@ +-- SORT_BEFORE_DIFF -- union case: all subqueries are a map-only jobs, 3 way union, same input for all sub-queries, followed by reducesink explain Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/union_null.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/union_null.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/union_null.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/union_null.q Fri Aug 22 21:36:47 2014 @@ -1,5 +1,7 @@ +-- SORT_BEFORE_DIFF + -- HIVE-2901 -select x from (select value as x from src union all select NULL as x from src)a limit 10; +select x from (select value as x from src order by x limit 5 union all select NULL as x from src limit 5) a; -- HIVE-4837 select * from (select null as N from src1 group by key UNION ALL select null as N from src1 group by key ) a; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/virtual_column.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/virtual_column.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/virtual_column.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/virtual_column.q Fri Aug 22 21:36:47 2014 @@ -14,6 +14,3 @@ CREATE TABLE src_index_test_rc (key int, set hive.io.rcfile.record.buffer.size = 1024; INSERT OVERWRITE TABLE src_index_test_rc SELECT * FROM src; select INPUT__FILE__NAME, key, BLOCK__OFFSET__INSIDE__FILE from src_index_test_rc order by key; - -DROP TABLE src_index_test_rc; -DROP INDEX src_index on src_index_test_rc; Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/windowing.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/windowing.q?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/windowing.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/windowing.q Fri Aug 22 21:36:47 2014 @@ -438,3 +438,9 @@ select p_mfgr, from part where p_mfgr = 'Manufacturer#6' ; + +-- 46. window sz is same as partition sz +select p_retailprice, avg(p_retailprice) over (partition by p_mfgr order by p_name rows between current row and 6 following), +sum(p_retailprice) over (partition by p_mfgr order by p_name rows between current row and 6 following) +from part +where p_mfgr='Manufacturer#1'; Modified: hive/branches/cbo/ql/src/test/results/clientnegative/add_partition_with_whitelist.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/add_partition_with_whitelist.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/add_partition_with_whitelist.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/add_partition_with_whitelist.q.out Fri Aug 22 21:36:47 2014 @@ -3,6 +3,7 @@ PREHOOK: query: -- This pattern matches CREATE TABLE part_whitelist_test (key STRING, value STRING) PARTITIONED BY (ds STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@part_whitelist_test POSTHOOK: query: -- This pattern matches all printable ASCII characters (disallow unicode) and disallows commas CREATE TABLE part_whitelist_test (key STRING, value STRING) PARTITIONED BY (ds STRING) Modified: hive/branches/cbo/ql/src/test/results/clientnegative/addpart1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/addpart1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/addpart1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/addpart1.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: create table addpart1 (a int) partitioned by (b string, c string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@addpart1 POSTHOOK: query: create table addpart1 (a int) partitioned by (b string, c string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientnegative/alter_concatenate_indexed_table.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/alter_concatenate_indexed_table.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/alter_concatenate_indexed_table.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/alter_concatenate_indexed_table.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: create table src_rc_concatenate_test(key int, value string) stored as rcfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@src_rc_concatenate_test POSTHOOK: query: create table src_rc_concatenate_test(key int, value string) stored as rcfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -66,8 +67,10 @@ POSTHOOK: Input: default@src_rc_concaten 214 -7678496319 PREHOOK: query: create index src_rc_concatenate_test_index on table src_rc_concatenate_test(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2") PREHOOK: type: CREATEINDEX +PREHOOK: Input: default@src_rc_concatenate_test POSTHOOK: query: create index src_rc_concatenate_test_index on table src_rc_concatenate_test(key) as 'compact' WITH DEFERRED REBUILD IDXPROPERTIES ("prop1"="val1", "prop2"="val2") POSTHOOK: type: CREATEINDEX +POSTHOOK: Input: default@src_rc_concatenate_test POSTHOOK: Output: default@default__src_rc_concatenate_test_src_rc_concatenate_test_index__ PREHOOK: query: show indexes on src_rc_concatenate_test PREHOOK: type: SHOWINDEXES Modified: hive/branches/cbo/ql/src/test/results/clientnegative/alter_file_format.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/alter_file_format.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/alter_file_format.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/alter_file_format.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: create table alter_file_format_test (key int, value string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@alter_file_format_test POSTHOOK: query: create table alter_file_format_test (key int, value string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientnegative/alter_non_native.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/alter_non_native.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/alter_non_native.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/alter_non_native.q.out Fri Aug 22 21:36:47 2014 @@ -2,6 +2,7 @@ PREHOOK: query: CREATE TABLE non_native1 STORED BY 'org.apache.hadoop.hive.ql.metadata.DefaultStorageHandler' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@non_native1 POSTHOOK: query: CREATE TABLE non_native1(key int, value string) STORED BY 'org.apache.hadoop.hive.ql.metadata.DefaultStorageHandler' POSTHOOK: type: CREATETABLE Modified: hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_coltype_2columns.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_coltype_2columns.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_coltype_2columns.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_coltype_2columns.q.out Fri Aug 22 21:36:47 2014 @@ -2,6 +2,7 @@ PREHOOK: query: -- create testing table create table alter_coltype(key string, value string) partitioned by (dt string, ts string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@alter_coltype POSTHOOK: query: -- create testing table create table alter_coltype(key string, value string) partitioned by (dt string, ts string) POSTHOOK: type: CREATETABLE Modified: hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_coltype_invalidcolname.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_coltype_invalidcolname.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_coltype_invalidcolname.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_coltype_invalidcolname.q.out Fri Aug 22 21:36:47 2014 @@ -2,6 +2,7 @@ PREHOOK: query: -- create testing table create table alter_coltype(key string, value string) partitioned by (dt string, ts string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@alter_coltype POSTHOOK: query: -- create testing table create table alter_coltype(key string, value string) partitioned by (dt string, ts string) POSTHOOK: type: CREATETABLE Modified: hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_coltype_invalidtype.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_coltype_invalidtype.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_coltype_invalidtype.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_coltype_invalidtype.q.out Fri Aug 22 21:36:47 2014 @@ -2,6 +2,7 @@ PREHOOK: query: -- create testing table create table alter_coltype(key string, value string) partitioned by (dt string, ts string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@alter_coltype POSTHOOK: query: -- create testing table create table alter_coltype(key string, value string) partitioned by (dt string, ts string) POSTHOOK: type: CREATETABLE Modified: hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_invalidspec.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_invalidspec.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_invalidspec.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_invalidspec.q.out Fri Aug 22 21:36:47 2014 @@ -2,6 +2,7 @@ PREHOOK: query: -- Create table create table if not exists alter_part_invalidspec(key string, value string ) partitioned by (year string, month string) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@alter_part_invalidspec POSTHOOK: query: -- Create table create table if not exists alter_part_invalidspec(key string, value string ) partitioned by (year string, month string) stored as textfile POSTHOOK: type: CREATETABLE Modified: hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_nodrop.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_nodrop.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_nodrop.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_nodrop.q.out Fri Aug 22 21:36:47 2014 @@ -2,6 +2,7 @@ PREHOOK: query: -- Create table create table if not exists alter_part_nodrop_part(key string, value string ) partitioned by (year string, month string) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@alter_part_nodrop_part POSTHOOK: query: -- Create table create table if not exists alter_part_nodrop_part(key string, value string ) partitioned by (year string, month string) stored as textfile POSTHOOK: type: CREATETABLE Modified: hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_nodrop_table.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_nodrop_table.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_nodrop_table.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_nodrop_table.q.out Fri Aug 22 21:36:47 2014 @@ -2,6 +2,7 @@ PREHOOK: query: -- Create table create table if not exists alter_part_nodrop_table(key string, value string ) partitioned by (year string, month string) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@alter_part_nodrop_table POSTHOOK: query: -- Create table create table if not exists alter_part_nodrop_table(key string, value string ) partitioned by (year string, month string) stored as textfile POSTHOOK: type: CREATETABLE Modified: hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_offline.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_offline.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_offline.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_offline.q.out Fri Aug 22 21:36:47 2014 @@ -2,6 +2,7 @@ PREHOOK: query: -- create table create table if not exists alter_part_offline (key string, value string ) partitioned by (year string, month string) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@alter_part_offline POSTHOOK: query: -- create table create table if not exists alter_part_offline (key string, value string ) partitioned by (year string, month string) stored as textfile POSTHOOK: type: CREATETABLE Modified: hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_with_whitelist.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_with_whitelist.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_with_whitelist.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/alter_partition_with_whitelist.q.out Fri Aug 22 21:36:47 2014 @@ -3,6 +3,7 @@ PREHOOK: query: -- This pattern matches CREATE TABLE part_whitelist_test (key STRING, value STRING) PARTITIONED BY (ds STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@part_whitelist_test POSTHOOK: query: -- This pattern matches all printable ASCII characters (disallow unicode) and disallows commas CREATE TABLE part_whitelist_test (key STRING, value STRING) PARTITIONED BY (ds STRING) Modified: hive/branches/cbo/ql/src/test/results/clientnegative/alter_rename_partition_failure.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/alter_rename_partition_failure.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/alter_rename_partition_failure.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/alter_rename_partition_failure.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: create table alter_rename_partition_src ( col1 string ) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@alter_rename_partition_src POSTHOOK: query: create table alter_rename_partition_src ( col1 string ) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -16,6 +17,7 @@ POSTHOOK: Output: default@alter_rename_p PREHOOK: query: create table alter_rename_partition ( col1 string ) partitioned by (pcol1 string , pcol2 string) stored as sequencefile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@alter_rename_partition POSTHOOK: query: create table alter_rename_partition ( col1 string ) partitioned by (pcol1 string , pcol2 string) stored as sequencefile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientnegative/alter_rename_partition_failure2.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/alter_rename_partition_failure2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/alter_rename_partition_failure2.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/alter_rename_partition_failure2.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: create table alter_rename_partition_src ( col1 string ) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@alter_rename_partition_src POSTHOOK: query: create table alter_rename_partition_src ( col1 string ) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -16,6 +17,7 @@ POSTHOOK: Output: default@alter_rename_p PREHOOK: query: create table alter_rename_partition ( col1 string ) partitioned by (pcol1 string , pcol2 string) stored as sequencefile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@alter_rename_partition POSTHOOK: query: create table alter_rename_partition ( col1 string ) partitioned by (pcol1 string , pcol2 string) stored as sequencefile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientnegative/alter_rename_partition_failure3.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientnegative/alter_rename_partition_failure3.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientnegative/alter_rename_partition_failure3.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientnegative/alter_rename_partition_failure3.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: create table alter_rename_partition_src ( col1 string ) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@alter_rename_partition_src POSTHOOK: query: create table alter_rename_partition_src ( col1 string ) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -16,6 +17,7 @@ POSTHOOK: Output: default@alter_rename_p PREHOOK: query: create table alter_rename_partition ( col1 string ) partitioned by (pcol1 string , pcol2 string) stored as sequencefile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@alter_rename_partition POSTHOOK: query: create table alter_rename_partition ( col1 string ) partitioned by (pcol1 string , pcol2 string) stored as sequencefile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default