[jira] [Commented] (HIVE-11864) If the specific location does not exist while creating table, tip information is ambiguous.

["Thejas M Nair (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-11864?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16206421#comment-16206421 ] 

Thejas M Nair commented on HIVE-11864:
--------------------------------------

This is likely fixed in 2.1.0 and later versions.


> 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.4.14#64029)