[STORM-2111] [Storm SQL] support 'LIKE' and 'SIMILAR TO'

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Component/s: storm-sql
• Epic Link: Storm SQL - cover the page 'SQL Reference' on Calcite
• Assignee: Jungtaek Lim
• Reporter: Jungtaek Lim
• Created: 21/Sep/16 23:54
• Updated: 26/Sep/16 02:10
• Resolved: 26/Sep/16 02:10

Description

Currently Storm SQL doesn't support 'LIKE' and 'SIMILAR TO' keywords.
Its implementation is existing on SqlFunctions so what we need to do is just registering them to ImpTable and make some unit tests.

NOT LIKE and NOT SIMILAR TO is represented as NOT(LIKE) and NOT(SIMILAR TO) so it should be automatically supported after.

Issue Links

• is superceded by: STORM-2125 Use Calcite's implementation of Rex Compiler
• links to: GitHub Pull Request #1704