You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@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)