[STORM-2125] Use Calcite's implementation of Rex Compiler

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0.0, 1.1.0
• Component/s: storm-sql
• Epic Link: Storm SQL - cover the page 'SQL Reference' on Calcite
• Assignee: Jungtaek Lim
• Reporter: Jungtaek Lim
• Created: 25/Sep/16 23:55
• Updated: 19/Oct/16 05:05
• Resolved: 12/Oct/16 09:50

Description

Looking into Calcite more, I found that Calcite has its own interpreter, and also has Rex Compiler.
In other words, we don't need to handle Rex operation by ourselves. We can just borrow this and it will provide all of what Calcite supports Rex handling.

After pulling this, we just need to make tests to check that Storm SQL provides all the functionalities on SQL reference on Calcite page: http://calcite.apache.org/docs/reference.html.

Issue Links

• blocks: STORM-2135 [StormSQL] document covered features of SQL reference in Calcite
• incorporates: STORM-2115 [Storm SQL] 'IN' with subquery making implicit aggregate calls which is having 'null' as name
• supercedes: STORM-2113 [Storm SQL] 'OR' and 'AND' operators cannot handle more than 2 operands
• supercedes: STORM-2111 [Storm SQL] support 'LIKE' and 'SIMILAR TO'
• supercedes: STORM-2114 [Storm SQL] Support 'Date' and 'Timestamp' literal
• supercedes: STORM-2116 [Storm SQL] Support 'CASE' statement
• links to: GitHub Pull Request #1714
• mentioned in: Page Loading...