[
https://issues.apache.org/jira/browse/BEAM-2255?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16006787#comment-16006787
]
ASF GitHub Bot commented on BEAM-2255:
--------------------------------------
GitHub user xumingming opened a pull request:
https://github.com/apache/beam/pull/3082
[BEAM-2255] implement ORDER BY
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/xumingming/beam BEAM-2255-order-by
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/beam/pull/3082.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #3082
----
commit 95ee7578f77577c60859776539e54a41103f94a4
Author: James Xu <[email protected]>
Date: 2017-05-11T17:07:18Z
implement ORDER BY
----
> support ORDER BY clause
> -----------------------
>
> Key: BEAM-2255
> URL: https://issues.apache.org/jira/browse/BEAM-2255
> Project: Beam
> Issue Type: New Feature
> Components: dsl-sql
> Reporter: James Xu
> Assignee: James Xu
>
> Currently Beam does not have `global sort` support[1]. So we will implement a
> limited version of `ORDER BY` using `org.apache.beam.sdk.transforms.Top` for
> now. So it will support sql like:
> {code:sql}
> select * from t order by id desc limit 10;
> {code}
> but not support `ORDER BY` without a `limit`:
> {code:sql}
> select * from t order by id desc
> {code}
> and also not support `ORDER BY` with a `offset`:
> {code:sql}
> select * from t order by id desc limit 10, 10;
> {code}
> [1].
> https://lists.apache.org/thread.html/bc0e65a3bb653b8fd0db96bcd4c9da5af71a71af5a5639a472167808@1464278191@%3Cdev.beam.apache.org%3E
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
