You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "haitangfan (JIRA)" <ji...@apache.org> on 2014/03/27 07:22:14 UTC

[jira] [Updated] (HIVE-6764) when set hive.security.authorization.enabled=true,hive start up with errors.

     [ 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)