[CALCITE-6278] Add REGEXP, REGEXP_LIKE function (enabled in Spark library)

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.37.0
• Labels: pull-request-available
• Assignee: EveyWu
• Reporter: EveyWu
• Created: 22/Feb/24 13:13
• Updated: 12/Mar/24 01:59
• Resolved: 12/Mar/24 01:59

Description

Add Spark functions that have been implemented but have different OperandTypes/Returns.

Add Function REGEXP, REGEXP_LIKE

1. Since this function has the same implementation as the Spark RLIKE function, the implementation can be directly reused.
2. Since Spark 2.0, string literals (including regex patterns) are unescaped in SQL parser, also fix this bug in calcite.

 

 

Issue Links

• is a child of: CALCITE-6260 Add already implemented functions in Spark library
• is related to: CALCITE-6180 Append possibility to escape backslash in LIKE expression
• is related to: CALCITE-3574 Add RLIKE operator (similar to LIKE, but Hive- and Spark-specific)
• relates to: CALCITE-6320 Parse SQL with Hive-style and Spark-style unescaped character literals
• links to: GitHub Pull Request #3712