[FLINK-9990] Add regexp_extract supported in TableAPI and SQL

• Type: Sub-task
• Status: Resolved
• Priority: Minor
• Resolution: Implemented
• Component/s: Table SQL / API
• Labels: pull-request-available
• Assignee: vinoyang
• Reporter: vinoyang
• Created: 29/Jul/18 02:48
• Updated: 14/Oct/18 16:32
• Resolved: 14/Oct/18 16:32

Description

regex_extract is a very useful function, it returns a string based on a regex pattern and a index.

For example : 

regexp_extract('foothebar', 'foo(.*?)(bar)', 2) // returns 'bar.'

It is provided as a UDF in Hive, more details please see[1].

[1]: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF

Issue Links

• is related to: FLINK-10216 Add REGEXP_MATCH in TableAPI and SQL
• links to: GitHub Pull Request #6448