George Leonard
09/04/2025, 1:50 PMFlink 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>Giannis Polyzos
09/04/2025, 2:05 PMSELECT 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-functionsGeorge Leonard
09/04/2025, 2:07 PM