[
https://issues.apache.org/jira/browse/HIVE-11864?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14802838#comment-14802838
]
Chetna Chaudhari commented on HIVE-11864:
-----------------------------------------
[~Hison Huang] : Unable to reproduce this. If user has permissions on /tmp
location, then create external table is creating table without any error (And
its expected behaviour.).
Please grant permissions on /tmp directory to your hive user, and check.
> If the specific location does not exist while creating table, tip information
> is ambiguous.
> -------------------------------------------------------------------------------------------
>
> Key: HIVE-11864
> URL: https://issues.apache.org/jira/browse/HIVE-11864
> Project: Hive
> Issue Type: Bug
> Components: SQLStandardAuthorization
> Affects Versions: 0.13.1, 1.1.0
> Reporter: Hison Huang
> Priority: Trivial
>
> If the specific location does not exist while creating table, tip information
> is ambiguous.
> > create external table exttbl_bad(id int, name string) row format delimited
> > fields terminated by ',' stored as textfile location '/tmp/tmptbl';
> Error: Error while compiling statement: FAILED: HiveAccessControlException
> Permission denied. Principal [name=admin, type=USER] does not have following
> privileges on Object [type=DFS_URI, name=/tmp/tmptbl] for operation
> CREATETABLE : [SELECT, INSERT, DELETE, OBJECT OWNERSHIP]
> (state=42000,code=40000)
> The error message explain that permission to access the path is not
> satisfied, however, the path does not exist at all.
> So it should be reasonable to show message like "path does not exists".
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
