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

["Hison Huang (JIRA)" <ji...@apache.org>]

Hison Huang created HIVE-11864:
----------------------------------

             Summary: 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: 1.1.0, 0.13.1
            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)