Created 06-05-2017 01:02 AM
For coming out of this statement, it taking 3 mint, it taking lot of time to complete ?if this table grant already exist getting below error
hive>set role admin; hive>grant select on table database.tablename to role role1with grant option; FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Error granting privileges: null
Please check the output of the following:
$ hive -e 'set -v;' > set_v.out $ hive -e 'show grant on all;' > grant_all.out $ hive -e 'show current roles;' > grant_current_`echo $UESR`.out
Post HDP 2.2.4 where SQL Authorization is disabled for Hive Cli. Which HDP release are you using?
Try using Beeline to see if there is any difference.
Additionally as you mentioned that the grant is taking lots of time.If you see granting is taking little longer then you can try setting the following values to lower limits as following: