[FLINK-2099] Add a SQL API

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Done
• Fix Version/s: 1.1.0
• Component/s: Table SQL / API
• Labels: requires-design-doc
• Assignee: Timo Walther
• Reporter: Timo Walther
• Created: 27/May/15 12:31
• Updated: 02/Oct/19 17:43
• Resolved: 02/May/16 12:44

Description

From the mailing list:

Fabian: Flink's Table API is pretty close to what SQL provides. IMO, the best
approach would be to leverage that and build a SQL parser (maybe together
with a logical optimizer) on top of the Table API. Parser (and optimizer)
could be built using Apache Calcite which is providing exactly this.
Since the Table API is still a fairly new component and not very feature
rich, it might make sense to extend and strengthen it before putting
something major on top.

Ted: It would also be relatively simple (I think) to retarget drill to Flink if
Flink doesn't provide enough typing meta-data to do traditional SQL.

Issue Links

• Blocked: FLINK-3221 Move Table API on top of Apache Calcite
• requires: FLINK-2971 Add outer joins to the Table API
• requires: FLINK-2946 Add orderBy() to Table API
• requires: FLINK-3152 Support all comparisons for Date type
• requires: FLINK-3139 NULL values handling in Table API
• requires: FLINK-3153 Support all comparisons for String type