Hi Drill Community, I'm Akshay and I'm using Drill for a project I'm working on.
There is this particular use case I want to implement - I want to know if its possible. 1) Currently, we have a partition of file system and we create a view on top of it. For example, we have below directory structure - /home/product/product_name/year/month/day/*parquet /home/product/product_name_2/year/month/day/*parquet /home/product/product_name_3/year/month/day/*parquetdev Now, we create a view over it - Create view temp AS SELECT `dir0` AS prod, `dir1` as year, `dir2` as month, `dir3` as day, * from dfs.`/home/product`; Then, we can query all the data dynamically - SELECT * from temp LIMIT 5; 2) Now I want to replicate this behavior via s3. I want to ask if its possible - I was able to create a logical directory. But s3 inherently does not support directories only objects. Therefore, I was curious to know if it is supported/way to do this. I was unable to find any documentation on your website related to partitioning data on s3. Thanks for your help. Best, Akshay
