drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From François Méthot <fmetho...@gmail.com>
Subject Re: Permission denied for queries on individual file.
Date Wed, 27 Apr 2016 19:24:44 GMT
Has anyone experienced the same issue?  We are Using HDFS managed by
Cloudera Manager.

A simple upgrade to 1.6 caused queries done directly on individual files to
fail with "Permission denied: user=drill, access=EXECUTE" error.
Also, Using filter with "dir0" file structure also causes the issue to
   ex: select col1 from hdfs.`/datasrc/` where dir0>= 1234567;

We ended up giving "execute" access to all the data file.

We would really like to know if this is the intend to have drill to expect
execute access permission on data files.


On Tue, Apr 26, 2016 at 11:23 AM, François Méthot <fmethot78@gmail.com>

> Hi,
>   We just switched to version 1.6. Using java 1.7_60
> We noticed that we can no longer query individual files stored in HDFS
> from CLI and WebUI.
> select col1 from hdfs.`/data/file1.parquet`;
> Error: SYSTEM ERROR: RemoteException: Permission denied: user=drill,
> access=EXECUTE inode=/data/file1.parquet":mygroup:drill:-rw-rw-r--
> If we give execution permission to the file
> hdfs fs -chmod +x /data/file1.parquet
> Then the query works.
> If we query the parent folder (hdfs.`/data/`), the query works as well.
> Is it the expected behavior in 1.6?
> Francois

  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message