[
https://issues.apache.org/jira/browse/HADOOP-15364?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16427458#comment-16427458
]
Steve Loughran edited comment on HADOOP-15364 at 4/5/18 7:11 PM:
-----------------------------------------------------------------
Patch 001: initial implementation with docs, tests and the CLI.
* Adds new code in package
[org.apache.hadoop.fs.s3a.select|https://github.com/steveloughran/hadoop/tree/s3/HADOOP-15364-S3-select-trunk/hadoop-tools/hadoop-aws/src/main/java/org/apache/hadoop/fs/s3a/select]
* tests of S3AFileSystem.select() call, but not new CLI tool
* opens up some methods to be `protected` over package private in {{S3GuardTool
}}, {{S3AReadOpContext}}, {{S3ObjectAttributes}}.
* Has [initial
documentation|https://github.com/steveloughran/hadoop/blob/s3/HADOOP-15364-S3-select-trunk/hadoop-tools/hadoop-aws/src/site/markdown/tools/hadoop-aws/s3_select.md],
which seems to have a very thorough set of stack traces in its
troubleshooting, most of which come down to "you can't write SQL" :)
* Incorporates HADOOP-15346 as every SQL error triggers a 400 response; you
don't want to keep retrying them.
Also Increments AWS SDK Version to 1.11.309. Obviously that's a big change
which needs to be validated separately.
Testing: S3 ireland
was (Author: [email protected]):
Patch 001: initial implementation with docs, tests and the CLI.
* Adds new code in package
[org.apache.hadoop.fs.s3a.select|https://github.com/steveloughran/hadoop/tree/s3/HADOOP-15364-S3-select-trunk/hadoop-tools/hadoop-aws/src/main/java/org/apache/hadoop/fs/s3a/select]
* tests of S3AFileSystem.select() call, but not new CLI tool
* opens up some methods to be `protected` over package private in {{S3GuardTool
}}, {{S3AReadOpContext}}, {{S3ObjectAttributes}}.
* Has [initial
documentation|https://github.com/steveloughran/hadoop/blob/s3/HADOOP-15364-S3-select-trunk/hadoop-tools/hadoop-aws/src/site/markdown/tools/hadoop-aws/s3_select.md],
* Incorporates HADOOP-15346 as every SQL error triggers a 400 response; you
don't want to keep retrying them.
Also Increments AWS SDK Version to 1.11.309. Obviously that's a big change
which needs to be validated separately.
Testing: S3 ireland
> Add support for S3 Select to S3A
> --------------------------------
>
> Key: HADOOP-15364
> URL: https://issues.apache.org/jira/browse/HADOOP-15364
> Project: Hadoop Common
> Issue Type: Sub-task
> Components: fs/s3
> Reporter: Steve Loughran
> Assignee: Steve Loughran
> Priority: Major
> Attachments: HADOOP-15364-001.patch
>
>
> Expect a PoC patch for this in a couple of days;
> * it'll depend on an SDK update to work, plus a couple of of other minor
> changes
> * Adds command line option too
> {code}
> hadoop s3guard select -header use -compression gzip -limit 100
> s3a://landsat-pds/scene_list.gz" \
> "SELECT s.entityId FROM S3OBJECT s WHERE s.cloudCover = '0.0' "
> {code}
> For wider use we'll need to implement the HADOOP-15229 so that callers can
> pass down the expression along with any other parameters
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
