[BEAM-2255] support ORDER BY clause

• Type: New Feature
• Status: Resolved
• Priority: P2
• Resolution: Fixed
• Fix Version/s: Not applicable
• Component/s: dsl-sql
• Assignee: James Xu
• Reporter: James Xu
• Created: 11/May/17 07:47
• Updated: 16/May/20 13:46
• Resolved: 17/May/17 02:38

Description

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:

select * from t order by id desc limit 10;

but not support `ORDER BY` without a `limit`:

select * from t order by id desc

and also not support `ORDER BY` with a `offset`:

select * from t order by id desc limit 10, 10;

[1]. https://lists.apache.org/thread.html/bc0e65a3bb653b8fd0db96bcd4c9da5af71a71af5a5639a472167808@1464278191@%3Cdev.beam.apache.org%3E

Issue Links

• links to: GitHub Pull Request #3082