[ https://issues.apache.org/jira/browse/FLINK-16201?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17419575#comment-17419575 ]
Ingo Bürk commented on FLINK-16201: ----------------------------------- [~lzljs3620320] The SQL standard specifically doesn't allow this. JSON_VALUE is only for (JSON) scalar values, and NULL must be returned for non-scalar values. I also double-checked that e.g. Oracle behaves the same way. For non-scalar values there is JSON_QUERY. > Support JSON_VALUE > ------------------ > > Key: FLINK-16201 > URL: https://issues.apache.org/jira/browse/FLINK-16201 > Project: Flink > Issue Type: Sub-task > Components: Table SQL / API > Reporter: Zili Chen > Assignee: Ingo Bürk > Priority: Major > Labels: pull-request-available, sprint > Fix For: 1.14.0 > > Time Spent: 10m > Remaining Estimate: 0h > > Support JSON_VALUE for both SQL and Table API. -- This message was sent by Atlassian Jira (v8.3.4#803005)