I'm having trouble connecting to deeper folder paths in Amazon s3. When using 
'show files', I can't get lower than that 'data' folder.

Storage plugin: "s3n://inrixprod-tapp-archive/"

Example path to data s3:
"data/year=2016/month=02/day=28/part-r-00299-f2b42e00-ff01-4d82-84e3-c75aafa007ae.gz.parquet
 "

Drill query example:

1)      This works:

use `s3-inrixprod-tapp-archive`;
               show files;

      2). This works:
         show files in `s3-inrixprod-tapp-archive`.`data`;

      3). This does NOT work:
         show files in `s3-inrixprod-tapp-archive`.`data`.`year=2016`;
         Error message: Validation Error: Invalid From/IN clause

Appreciate the help!
-Nick

Reply via email to