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)