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