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

Chua Tianxiang commented on DRILL-5391:
---------------------------------------

That's correct, here's the error message while I'm creating the external table 
in hive.

java.sql.SQLException: Error while processing statement: FAILED: Execution 
Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. 
MetaException(message:java.security.AccessControlException: Permission denied: 
user=hive, access=WRITE, inode="/tmp/table":root:hdfs:drwxrwxr-x

> Difference in directory permissions when using CREATE TABLE AS on HDFS 
> storage plugin
> -------------------------------------------------------------------------------------
>
>                 Key: DRILL-5391
>                 URL: https://issues.apache.org/jira/browse/DRILL-5391
>             Project: Apache Drill
>          Issue Type: Bug
>    Affects Versions: 1.9.0, 1.10.0
>         Environment: CentOS 7, HDP 2.4
>            Reporter: Chua Tianxiang
>            Priority: Minor
>         Attachments: Drill-1-10.PNG, Drill-1-9.PNG
>
>
> In Drill 1.9, CREATE TABLE AS creates a folder with permissions 777, while on 
> Drill 1.10, the same commands creates a folder with permission 775. Both 
> drills are started with root user, installed on the same servers and accesses 
> the same HDFS.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to