Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
Currently a non DB__ROOT user granted MANAGE_STATISTICS privilege on a hive table fails with error 2017 - no privilege.
To reproduce:
as DB__ROOT:
unregister hive table hive.hive.item;
grant component privilege "MANAGE" on sql_operations to sql_user1;
As sql_user1:
update statistics for table hive.hive.item on every column;
-
-
- ERROR[9200] UPDATE STATISTICS for table HIVE.HIVE.ITEM encountered an error (1017) from statement register hive table.
-
-
-
- ERROR[1017] You are not authorized to perform this operation.
-
-
-
- ERROR[8839] Transaction was aborted.
-
-
-
- ERROR[4082] Object HIVE.HIVE.ITEM does not exist or is inaccessible.
-
— SQL operation failed with errors.
update statistics for table hive.hive.item on every column;
-
-
- ERROR[9200] UPDATE STATISTICS for table HIVE.HIVE.ITEM encountered an error (1017) from statement register hive table.
-
-
-
- ERROR[1017] You are not authorized to perform this operation.
-
-
-
- ERROR[8839] Transaction was aborted.
-
-
-
- ERROR[4082] Object HIVE.HIVE.ITEM does not exist or is inaccessible.
-
— SQL operation failed with errors.