[ 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)