[ https://issues.apache.org/jira/browse/FLINK-34898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yubin Li updated FLINK-34898: ----------------------------- Attachment: image-2024-03-21-12-00-00-183.png > Cannot create named STRUCT with a single field > ---------------------------------------------- > > Key: FLINK-34898 > URL: https://issues.apache.org/jira/browse/FLINK-34898 > Project: Flink > Issue Type: Bug > Reporter: Chloe He > Priority: Major > Attachments: image-2024-03-21-12-00-00-183.png > > > I'm trying to create named structs using Flink SQL and I found a previous > ticket https://issues.apache.org/jira/browse/FLINK-9161 that mentions the use > of the following syntax: > {code:java} > SELECT CAST(('a', 1) as ROW<a STRING, b INT>) AS row1; > {code} > However, my named struct has a single field and effectively it should look > something like `\{"a": 1}`. I can't seem to be able to find a way to > construct this. I have experimented with a few different syntax and it either > throws parsing error or casting error: > {code:java} > Cast function cannot convert value of type INTEGER to type > RecordType(VARCHAR(2147483647) a) {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)