[CALCITE-4454] Calcite SQLParser: Provide support for RLIKE expressions

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 1.27.0
• Component/s: spark
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: shradha
• Created: 05/Jan/21 06:06
• Updated: 18/Jun/21 08:43
• Resolved: 08/Jan/21 01:46

Description

Enhance Calcite SQLParser to support SPARK SQL queries expressions   - RLIKE 

Current Behavior : Parsing queries having rlike expression throws exception

val query1 = "select cola from tableA where MAX(realm_email) rlike '.@.\\\\..+'"

StatementMetadataFragment(com.intuit.superglue.pipeline.parsers.CalciteStatementParser,UNKNOWN,List(),List(),List(org.apache.calcite.sql.parser.SqlParseException: Encountered "rlike" at line 1, column 48.

All these queries are correctly being parsed via SPARK SQL . But calcite's parser grammer file doesn't suport these tokens

Since this is SPARK SQL specific , these changes will be implemented in BABEL Parser

Issue Links

• duplicates: CALCITE-3574 Add RLIKE operator (similar to LIKE, but Hive- and Spark-specific)
• links to: GitHub Pull Request #2314