Recently, when creating custom columns in the GUI view, using the regexextract function is resulting in the error "Unsupported function regex-match-first", which is preventing me from saving the updates.
However, some of the previous questions I created that used the regexextract function are still working normally.
Have any of you encountered this situation before? How can I resolve this problem? I would greatly appreciate any help from the community!
MySQL，and the date type of this column is json.
Moreover, I have also tried using the regexextract expression on other data tables and column of different types, but I keep getting the same error message. Additionally, when entering the expression, I don't receive any input suggestions like I do with other expressions. It feels as if Metabase doesn't support this expression at all.
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/17.4.1 Safari/605.1.15",
"vendor": "Apple Computer, Inc."
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.22+7-post-Ubuntu-0ubuntu222.04.1",
"java.vendor": "Ubuntu",
"java.vendor.url": "https://ubuntu.com/",
"java.version": "11.0.22",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.22+7-post-Ubuntu-0ubuntu222.04.1",
"os.name": "Linux",
"os.version": "6.2.0-1017-aws",
"user.language": "en",
"user.timezone": "Etc/UTC"
"metabase-info": {
"databases": [
"h2",
"mysql",
"redshift",
"csv"
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "8.0.35"
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.7.10"
"run-mode": "prod",
"version": {
"date": "2024-04-11",
"tag": "v0.49.5",
"hash": "31c4887"
"settings": {
"report-timezone": null
All looks fine, I am really lost here ... Does it happen to every question? ... Can you share the whole screenshot of the GUI please.
Start just with a table and then try to apply the function
Yes, I am quite perplexed as well, this is really quite counter-intuitive.
Aaaaa -.- ... Can you go to Admin -> Databases and share with me a similar screenshot:
Want to confirm you are indeed connected to MYSQL ... and what other DBs you have, you mentioned redshift can you try the regex command on a redshift table as the source
