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 happen. 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. Thanks On Tue, Apr 26, 2016 at 11:23 AM, François Méthot <[email protected]> wrote: > 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 > >
