[
https://issues.apache.org/jira/browse/HIVE-17973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16243582#comment-16243582
]
liyunzhang commented on HIVE-17973:
-----------------------------------
for {{ct_noperm_loc.q.out}},
{code}
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;
dfs ${system:test.dfs.mkdir} hdfs:///tmp/ct_noperm_loc;
set user.name=user1;
create table foo0(id int) location 'hdfs:///tmp/ct_noperm_loc_foo0';
create table foo1 location 'hdfs:///tmp/ct_noperm_loc/foo1';
{code}
the output in my local env
{code}
#### A masked pattern was here ####
PREHOOK: type: CREATETABLE
#### A masked pattern was here ####
PREHOOK: Output: database:default
PREHOOK: Output: default@foo0
#### A masked pattern was here ####
POSTHOOK: type: CREATETABLE
#### A masked pattern was here ####
POSTHOOK: Output: database:default
POSTHOOK: Output: default@foo0
FAILED: SemanticException [Error 10043]: Either list of columns or a custom
serializer should be specified
{code}
the original ct_noperm_loc.q.out is empty. Very confused why there is not any
output for {{ct_noperm_loc.q}}, [~kgyrtkirk], do you know the reason why
[ct_noperm_loc.q.out|https://github.com/apache/hive/blob/master/ql/src/test/results/clientnegative/ct_noperm_loc.q.out]
is empty?
> Fix small bug in multi_insert_union_src.q
> -----------------------------------------
>
> Key: HIVE-17973
> URL: https://issues.apache.org/jira/browse/HIVE-17973
> Project: Hive
> Issue Type: Bug
> Reporter: liyunzhang
> Assignee: liyunzhang
> Priority: Trivial
> Attachments: HIVE-17973.2.patch, HIVE-17973.2.patch,
> HIVE-17973.patch, HVIE-17973.3.patch
>
>
> in ql\src\test\queries\clientpositive\multi_insert_union_src.q,
> There are two problems in the query file
> 1. It is strange to drop src_multi1 twice
> 2. {{src1}} is not created but used src1(Maybe we create src1 in other qfile)
> {code}
> set hive.mapred.mode=nonstrict;
> drop table if exists src2;
> drop table if exists src_multi1;
> drop table if exists src_multi1;
> set hive.stats.dbclass=fs;
> CREATE TABLE src2 as SELECT * FROM src;
> create table src_multi1 like src;
> create table src_multi2 like src;
> explain
> from (select * from src1 where key < 10 union all select * from src2 where
> key > 100) s
> insert overwrite table src_multi1 select key, value where key < 150 order by
> key
> insert overwrite table src_multi2 select key, value where key > 400 order by
> value;
> from (select * from src1 where key < 10 union all select * from src2 where
> key > 100) s
> insert overwrite table src_multi1 select key, value where key < 150 order by
> key
> insert overwrite table src_multi2 select key, value where key > 400 order by
> value;
> select * from src_multi1;
> select * from src_multi2;
> {code}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
