[DRILL-8402] Add REGEXP_EXTRACT Function

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.21.0
• Fix Version/s: 1.22.0
• Component/s: Functions - Drill
• Assignee: Charles Givre
• Reporter: Charles Givre
• Created: 21/Feb/23 03:58
• Updated: 06/Apr/23 10:08
• Resolved: 06/Apr/23 10:08

Description

This PR adds two UDFs to Drill:

regexp_extract(<text>, <pattern>) which returns an array of strings which were captured by capturing groups in the regex.

regexp_extract(<text>, <pattern>, <index>) returns the text captured by a specific capturing group.