[KYLIN-4111] drop table failed with no valid privileges after KYLIN-3857

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: v3.0.0-beta, v2.6.4
• Assignee: Shaohui Liu
• Reporter: Shaohui Liu
• Created: 25/Jul/19 05:14
• Updated: 13/Oct/19 00:37
• Resolved: 17/Sep/19 15:44

Description

After KYLIN-3857, there will be quote ` around database and table.

The drop table sql will be:

DROP TABLE IF EXISTS `kylin_onebox.kylin_intermediate_kylin_sales_cube_7be84be1_a153_07c4_3ce6_270e8d99ff85`;

Hive (1.2)with sentry will throw exception:

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=40000)

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.

 

Issue Links

• links to: GitHub Pull Request #773