[
https://issues.apache.org/jira/browse/HCATALOG-141?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13134505#comment-13134505
]
Thejas M Nair commented on HCATALOG-141:
----------------------------------------
The problem described in this jira, HCATALOG-140 and HCATALOG-139 are also
applicable to table commands (create/drop table).
> drop database fails in unsecure mode with permission denied error
> -----------------------------------------------------------------
>
> Key: HCATALOG-141
> URL: https://issues.apache.org/jira/browse/HCATALOG-141
> Project: HCatalog
> Issue Type: Bug
> Affects Versions: 0.2
> Reporter: Thejas M Nair
>
> hcat user is the user hcat server is running as. The db dir got created using
> that username instead of the user who invoked the command. But the 'drop
> database' command still fails.
> {code}
> $ hadoop fs -ls /user/hortonth/dbdir/|grep testdb
> Warning: $HADOOP_HOME is deprecated.
> drwx------ - hcat supergroup 0 2011-10-24 20:58
> /user/hortonth/dbdir/testdb.db
> $ hcat -e 'drop database testdb;'
> Hive history
> file=/tmp/hortonth/hive_job_log_hortonth_201110242105_891466409.txt
> FAILED: Error in semantic analysis: org.apache.hcatalog.common.HCatException
> : 3000 : Permission denied
> {code}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
