You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by Nick Monetta <Ni...@inrix.com> on 2016/05/23 17:11:04 UTC

Amazon S3 folder connection errors

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