[jira] [Created] (BEAM-2255) support ORDER BY clause

[James Xu (JIRA)]

James Xu created BEAM-2255:
------------------------------

             Summary: 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)