in version 1.20.2 ```Flink SQL> SELECT JSON_AR...
# troubleshooting
g
in version 1.20.2
Copy code
Flink SQL> SELECT JSON_ARRAY(JSON('{"nested_json": {"value": 42}}'));
[ERROR] Could not execute SQL statement. Reason:
org.apache.calcite.sql.validate.SqlValidatorException: No match found for function signature JSON(<CHARACTER>)

Flink SQL>
g
use
Copy code
SELECT JSON_ARRAY('{"nested_json": {"value": 42}}');
if you check 1.20.2 docs, there is no JSON function https://nightlies.apache.org/flink/flink-docs-release-1.20/docs/dev/table/functions/systemfunctions/#json-functions
g
yes... the example above is directly out of confluents docs. guessing they referencing flink 2.x