正则表达式 – 在蜂巢中正则表达式

要提取完整匹配,请使用0：

select REGEXP_EXTRACT( 'Hello,'Ben',0)

要提取捕获组值,请使用组索引,例如

select REGEXP_EXTRACT( 'Hello,'name is (w+)',1)

将提取本.

见this reference：

regexp_extract(string subject,string pattern,int index)
Returns the string extracted using the pattern. For example,regexp_extract('foothebar','foo(.*?)(bar)',2) returns 'bar.' Note that some care is necessary in using predefined character classes: using 's' as the second argument will match the letter s; 's' is necessary to match whitespace,etc. The 'index' parameter is the Java regex Matcher group() method index. See docs/api/java/util/regex/Matcher.html for more information on the 'index' or Java regex group() method.