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