Permission denied for queries on individual file.

[François Méthot]

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