You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Vremake (via GitHub)" <gi...@apache.org> on 2025/11/17 04:38:33 UTC
[I] Did Doris version doris-2.1.8-rc01-018ba5371f 不支持(not support) regexp-extract-all? [doris-website]
Vremake opened a new issue, #3100:
URL: https://github.com/apache/doris-website/issues/3100
Path:/zh-CN/docs/2.1/sql-manual/sql-functions/scalar-functions/string-functions/regexp-extract-all
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [I] Did Doris version doris-2.1.8-rc01-018ba5371f 不支持(not support) regexp-extract-all? [doris-website]
Posted by "boluor (via GitHub)" <gi...@apache.org>.
boluor commented on issue #3100:
URL: https://github.com/apache/doris-website/issues/3100#issuecomment-4525796160
\`regexp_extract_all\` is present in branch-2.1 — verified in \`BuiltinScalarFunctions.java\` (\`scalar(RegexpExtractAll.class, \"regexp_extract_all\")\`) and behaves as documented when called.
The thing to know: the function returns matches of the **first capture group** in the pattern, not the whole match. So the pattern must contain \`(...)\`:
\`\`\`sql
SELECT regexp_extract_all('abc123xyz456', '[0-9]+'); -- returns '' (no capture group)
SELECT regexp_extract_all('abc123xyz456', '([0-9]+)'); -- returns ['123','456']
\`\`\`
The doc's own examples all use capture groups for this reason; the description line says \"extract all the parts that match the first sub - pattern of the specified \`pattern\`\".
If you were getting empty results on 2.1.8-rc01, please share the exact call so we can confirm it's the same case. Otherwise this can be closed.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org