Given the following SQL (which maps to target kafk...
# troubleshooting
p
Given the following SQL (which maps to target kafka topic, where JSON based objects should be inserted)
Copy code
CREATE TABLE my_sink (
    my_prop ROWid INT, value STRING
) WITH (...)
How do I actually insert the
id
and
value
? As a result, I'd like to have a JSON object like this in the target kafka topic
Copy code
{
  my_prop: {
    id: 5,
    value: "hello world"
  }
}
Ok, I actually found the documentation finally myself. What I need to use is this https://nightlies.apache.org/flink/flink-docs-master/docs/dev/table/functions/systemfunctions/#value-construction-functions
πŸ‘€ 1