[SPARK-34376] Support regexp as a function

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.4.7, 3.0.1, 3.1.0
• Fix Version/s: 3.2.0
• Component/s: SQL
• Assignee: Kent Yao 2
• Reporter: Kent Yao 2
• Created: 05/Feb/21 09:00
• Updated: 12/Dec/22 18:10
• Resolved: 05/Mar/21 03:09

Description

We have equality in SqlBase.g4 for RLIKE: 'RLIKE' | 'REGEXP';
We seemed to miss adding REGEXP as a SQL function just like RLIKE

This is also registered in Hive as a function, we can reduce the migration pain for those users

Issue Links

• links to: [Github] Pull Request #31488 (yaooqinn)