[
https://issues.apache.org/jira/browse/HIVE-6764?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
haitangfan updated HIVE-6764:
-----------------------------
Description:
1、set hive.security.authorization.enabled=true;
2、startup hive,find some errors in the log:
notice: /Stage[2]/Hdp-hcat::Hcat::Service_check/Exec[hcatSmoke.sh
prepare]/returns: FAILED:AuthorizationException No privilege 'Create' found for
inputs { database:default,
table:hcatsmokeida8c00f0b_date432614}
err: /Stage[2]/Hdp-hcat::Hcat::Service_check/Exec[hcatSmoke.sh
prepare]/returns: change from notrun to 0
failed: su - ambari-qa -c 'sh /tmp/hcatSmoke.sh hcatsmokeida8c00f0b_date432614
prepare' returned 64 instead of
one of [0] at
/var/lib/ambari-agent/puppet/modules/hdp-hcat/manifests/hcat/service_check.pp:54
notice:
/Stage[2]/Hdp-hive::Hive::Service_check/Exec[/tmp/hiveserver2Smoke.sh]/returns:
Smoke test of
hiveserver2 passed
notice:
/Stage[2]/Hdp-hive::Hive::Service_check/Exec[/tmp/hiveserver2Smoke.sh]/returns:
executed successfully
3、the /tmp/hcatSmoke.sh contents
export tablename=$1case "$2" in
prepare)
hcat -e "show tables"
hcat -e "drop table IF EXISTS ${tablename}"
hcat -e "create table ${tablename} ( id INT, name string ) stored as rcfile ;"
;;
cleanup)
hcat -e "drop table IF EXISTS ${tablename}"
;;
esac
4、try to grant to user ambari-qa,faild.
hive> grant all on database default to user ambari-qa;FAILED: ParseException
line 1:44 missing EOF at '-' near 'ambari'
How to fix it?
> when set hive.security.authorization.enabled=true,hive start up with errors.
> ----------------------------------------------------------------------------
>
> Key: HIVE-6764
> URL: https://issues.apache.org/jira/browse/HIVE-6764
> Project: Hive
> Issue Type: Bug
> Components: Authorization
> Reporter: haitangfan
>
> 1、set hive.security.authorization.enabled=true;
> 2、startup hive,find some errors in the log:
> notice: /Stage[2]/Hdp-hcat::Hcat::Service_check/Exec[hcatSmoke.sh
> prepare]/returns: FAILED:AuthorizationException No privilege 'Create' found
> for inputs { database:default,
> table:hcatsmokeida8c00f0b_date432614}
> err: /Stage[2]/Hdp-hcat::Hcat::Service_check/Exec[hcatSmoke.sh
> prepare]/returns: change from notrun to 0
> failed: su - ambari-qa -c 'sh /tmp/hcatSmoke.sh
> hcatsmokeida8c00f0b_date432614 prepare' returned 64 instead of
> one of [0] at
> /var/lib/ambari-agent/puppet/modules/hdp-hcat/manifests/hcat/service_check.pp:54
> notice:
> /Stage[2]/Hdp-hive::Hive::Service_check/Exec[/tmp/hiveserver2Smoke.sh]/returns:
> Smoke test of
> hiveserver2 passed
> notice:
> /Stage[2]/Hdp-hive::Hive::Service_check/Exec[/tmp/hiveserver2Smoke.sh]/returns:
> executed successfully
> 3、the /tmp/hcatSmoke.sh contents
> export tablename=$1case "$2" in
> prepare)
> hcat -e "show tables"
> hcat -e "drop table IF EXISTS ${tablename}"
> hcat -e "create table ${tablename} ( id INT, name string ) stored as rcfile
> ;"
> ;;
> cleanup)
> hcat -e "drop table IF EXISTS ${tablename}"
> ;;
> esac
> 4、try to grant to user ambari-qa,faild.
> hive> grant all on database default to user ambari-qa;FAILED: ParseException
> line 1:44 missing EOF at '-' near 'ambari'
> How to fix it?
--
This message was sent by Atlassian JIRA
(v6.2#6252)
