In flink sql, I create a table backed by JDBC conn...
# troubleshooting
j
In flink sql, I create a table backed by JDBC connector and pull in a BLOB column. This blob contains JSON and I can cast as a string for example. But I want to stream this into Kafka so I create a Kafka connector table CTAS select
json
from jdbc_table; How do I get this to be a json object in the kafka value (which is json) and not a string?
SELECT JSON(CAST(
json
AS STRING)) AS
json
FROM source_db says: org.apache.calcite.sql.validate.SqlValidatorException: No match found for function signature JSON(<CHARACTER>)
Any thoughts anyone?