[ https://issues.apache.org/jira/browse/HIVE-26433?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Denys Kuzmenko resolved HIVE-26433. ----------------------------------- Resolution: Fixed > StorageHandler authorization doesn't work with "METASTORE" db type > ------------------------------------------------------------------ > > Key: HIVE-26433 > URL: https://issues.apache.org/jira/browse/HIVE-26433 > Project: Hive > Issue Type: Task > Reporter: Denys Kuzmenko > Assignee: Denys Kuzmenko > Priority: Major > Labels: pull-request-available > Time Spent: 1h 10m > Remaining Estimate: 0h > > StorageHandler Authorization doesn't work with the "METASTORE" db type: > {code} > CREATE EXTERNAL TABLE IF NOT EXISTS `SYS`.`HIVE_LOCKS` ( > `HL_LOCK_EXT_ID` bigint, > `HL_LOCK_INT_ID` bigint, > `HL_TXNID` bigint, > `HL_DB` string, > `HL_TABLE` string, > `HL_PARTITION` string, > `HL_LOCK_STATE` string, > `HL_LOCK_TYPE` string, > `HL_LAST_HEARTBEAT` bigint, > `HL_ACQUIRED_AT` bigint, > `HL_USER` string, > `HL_HOST` string, > `HL_HEARTBEAT_COUNT` int, > `HL_AGENT_INFO` string, > `HL_BLOCKEDBY_EXT_ID` bigint, > `HL_BLOCKEDBY_INT_ID` bigint > ) > STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler' > TBLPROPERTIES ( > "hive.sql.database.type" = "METASTORE", > "hive.sql.query" = > "SELECT > \"HL_LOCK_EXT_ID\", > \"HL_LOCK_INT_ID\", > \"HL_TXNID\", > \"HL_DB\", > \"HL_TABLE\", > \"HL_PARTITION\", > \"HL_LOCK_STATE\", > \"HL_LOCK_TYPE\", > \"HL_LAST_HEARTBEAT\", > \"HL_ACQUIRED_AT\", > \"HL_USER\", > \"HL_HOST\", > \"HL_HEARTBEAT_COUNT\", > \"HL_AGENT_INFO\", > \"HL_BLOCKEDBY_EXT_ID\", > \"HL_BLOCKEDBY_INT_ID\" > FROM \"HIVE_LOCKS\"" > ); > {code} > Exception thrown: > {code} > Error: Error while compiling statement: FAILED: HiveAccessControlException > Permission denied: user [hive] does not have [RWSTORAGE] privilege on > [null/null] (state=42000,code=40000) > {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)