You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Paul Rogers (JIRA)" <ji...@apache.org> on 2017/10/04 18:35:01 UTC

[jira] [Resolved] (DRILL-5438) Amazon S3 bucket can't be queried directly at root

     [ https://issues.apache.org/jira/browse/DRILL-5438?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Paul Rogers resolved DRILL-5438.
--------------------------------
    Resolution: Fixed

> Amazon S3 bucket can't be queried directly at root
> --------------------------------------------------
>
>                 Key: DRILL-5438
>                 URL: https://issues.apache.org/jira/browse/DRILL-5438
>             Project: Apache Drill
>          Issue Type: Bug
>    Affects Versions: 1.10.0
>            Reporter: Alon P
>              Labels: S3Plugin
>
> It is not possible to query the root directory of Amazon S3 bucket.
> For example, the contents of the bucket are:
> /a/file1.json
> /b/file2.json
> /c/file3.json
> and I'd like to do something like that: select * from s3.`root`; 
> and that it'll return the contents of file1.json+file2.json+file3.json
> I couldn't find how to make it work.
> ---
> This is a major issue as I believe many Amazon S3 users put files directly into the root of the bucket or use a hash prefix as suggested by Amazon for a good performance in a high request rate configuration (http://docs.aws.amazon.com/AmazonS3/latest/dev/request-rate-perf-considerations.html).



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)