Hi,
I am trying to use the json_table function but I am getting error:
SELECT * FROM JSON_TABLE(’[ {“c1”: null} ]’,’$[*]’ COLUMNS( c1 INT PATH ‘$.c1’ ERROR ON ERROR )) as jt;
with error from Metabase:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘(’[ {“c1”: null} ]’,’$[*]’ COLUMNS( c1 INT PATH ‘$.c1’ ERROR ON ERROR )) as jt; ’ at line 18
Does it mean the json_table is not supported?
Thanks
Hi @ivobrabec
Please post “Diagnostic Info” from Admin > Troubleshooting, and which version of MySQL you’re querying.
The query is sent to your MySQL server, so check if the server has the function - or try with another tool like DBeaver.io