[jira] [Updated] (KYLIN-4111) drop table failed with no valid privileges after KYLIN-3857

2019-09-17 Thread nichunen (Jira) 


 [ 
https://issues.apache.org/jira/browse/KYLIN-4111?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

nichunen updated KYLIN-4111:

Fix Version/s: v3.0.0-beta

> drop table failed with no valid privileges after KYLIN-3857
> ---
>
> Key: KYLIN-4111
> URL: https://issues.apache.org/jira/browse/KYLIN-4111
> Project: Kylin
>  Issue Type: Bug
>Reporter: Liu Shaohui
>Assignee: Liu Shaohui
>Priority: Major
> Fix For: v3.0.0-beta, v2.6.4
>
>
> After KYLIN-3857, there will be quote ` around database and table.
> The drop table sql will be:
> {code:java}
> DROP TABLE IF EXISTS 
> `kylin_onebox.kylin_intermediate_kylin_sales_cube_7be84be1_a153_07c4_3ce6_270e8d99ff85`;{code}
> Hive (1.2)with sentry will throw exception:
> {code:java}
> Error: Error while compiling statement: FAILED: HiveAccessControlException No 
> valid privileges
>  Required privileges for this query: 
> Server=server1->Db=`kylin_onebox->Table=kylin_intermediate_kylin_sales_cube_7be84be1_a153_07c4_3ce6_270e8d99ff85`->action=drop;
> Query log: 
> http://zjy-hadoop-prc-ct14.bj:18201/log?qid=898c7878-a961-443d-b120-cca0e2667d15_f486bd16-4bbd-4014-a0a7-c2ebfdbe6668
>  (state=42000,code=4)
> {code}
> The reason is that hive identify the databse be `kylin_onebox and table be: 
> kylin_intermediate_kylin_sales_cube_7be84be1_a153_07c4_3ce6_270e8d99ff85`
> May be we can fix it in hive and sentry. Just create a jira to show this 
> problem.
>  



--
This message was sent by Atlassian Jira
(v8.3.2#803003)

[jira] [Updated] (KYLIN-4111) drop table failed with no valid privileges after KYLIN-3857

2019-07-27 Thread Shaofeng SHI (JIRA) 


 [ 
https://issues.apache.org/jira/browse/KYLIN-4111?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Shaofeng SHI updated KYLIN-4111:

Fix Version/s: v2.6.4

> drop table failed with no valid privileges after KYLIN-3857
> ---
>
> Key: KYLIN-4111
> URL: https://issues.apache.org/jira/browse/KYLIN-4111
> Project: Kylin
>  Issue Type: Bug
>Reporter: Liu Shaohui
>Assignee: Liu Shaohui
>Priority: Major
> Fix For: v2.6.4
>
>
> After KYLIN-3857, there will be quote ` around database and table.
> The drop table sql will be:
> {code:java}
> DROP TABLE IF EXISTS 
> `kylin_onebox.kylin_intermediate_kylin_sales_cube_7be84be1_a153_07c4_3ce6_270e8d99ff85`;{code}
> Hive (1.2)with sentry will throw exception:
> {code:java}
> Error: Error while compiling statement: FAILED: HiveAccessControlException No 
> valid privileges
>  Required privileges for this query: 
> Server=server1->Db=`kylin_onebox->Table=kylin_intermediate_kylin_sales_cube_7be84be1_a153_07c4_3ce6_270e8d99ff85`->action=drop;
> Query log: 
> http://zjy-hadoop-prc-ct14.bj:18201/log?qid=898c7878-a961-443d-b120-cca0e2667d15_f486bd16-4bbd-4014-a0a7-c2ebfdbe6668
>  (state=42000,code=4)
> {code}
> The reason is that hive identify the databse be `kylin_onebox and table be: 
> kylin_intermediate_kylin_sales_cube_7be84be1_a153_07c4_3ce6_270e8d99ff85`
> May be we can fix it in hive and sentry. Just create a jira to show this 
> problem.
>  



--
This message was sent by Atlassian JIRA
(v7.6.14#76016)