In Hive 0.13 when I do a tablesample query on an ORC table, such as
select x from orc_table tablesample (bucket 32 out of 64) where date=1106;
I'll get the following error saying I'm trying to run with EXECUTE access
but the files have only READ access for non owner. Why would a simple
select query require EXECUTE access? The same query on a table with the
same setting would work for Hive 0.12. Also, the problem won't happen if I
do this on a table in TEXTFILE.
Thanks!
Error message:
Logging initialized using configuration in
file:/etc/hive/conf/hive-log4j.properties
Total jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
14/11/14 19:05:57 WARN mapreduce.JobSubmitter: Hadoop command-line option
parsing not performed. Implement the Tool interface and execute your
application with ToolRunner to remedy this.
org.apache.hadoop.security.AccessControlException: Permission denied:
user=<user>, access=EXECUTE,
inode="/orc_table/date=1106/000031_0":<user>:<group>:-rw-r--r--
at
org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkFsPermission(FSPermissionChecker.java:271)
at
org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPermissionChecker.java:257)
at
org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkTraverse(FSPermissionChecker.java:208)
at
org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkPermission(FSPermissionChecker.java:171)
at
org.apache.hadoop.hdfs.server.namenode.FSNamesystem.checkPermission(FSNamesystem.java:5904)
at
org.apache.hadoop.hdfs.server.namenode.FSNamesystem.getFileInfo(FSNamesystem.java:3691)
at
org.apache.hadoop.hdfs.server.namenode.NameNodeRpcServer.getFileInfo(NameNodeRpcServer.java:803)
at
org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolServerSideTranslatorPB.getFileInfo(ClientNamenodeProtocolServerSideTranslatorPB.java:779)
