[FLINK-3640] Add support for SQL queries in DataSet programs

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Implemented
• Affects Version/s: 1.1.0
• Fix Version/s: 1.1.0
• Component/s: Table SQL / API
• Assignee: Vasia Kalavri
• Reporter: Vasia Kalavri
• Created: 21/Mar/16 13:20
• Updated: 11/Apr/16 16:04
• Resolved: 11/Apr/16 16:04

Description

This issue covers the task of supporting SQL queries embedded in DataSet programs. In this mode, the input and output of a SQL query is a Table. For this issue, we need to make the following additions to the Table API:

• add a tEnv.sql(query: String): Table method for converting a query result into a Table
• integrate Calcite's SQL parser into the batch Table API translation process.