[ https://issues.apache.org/jira/browse/FLINK-27013?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jark Wu closed FLINK-27013. --------------------------- Fix Version/s: 1.16.0 Assignee: luoyuxia Resolution: Fixed Fixed in master: dcc9cceab962c897c7a5e55deb868eb2d86468ec > Hive dialect supports IS_DISTINCT_FROM > -------------------------------------- > > Key: FLINK-27013 > URL: https://issues.apache.org/jira/browse/FLINK-27013 > Project: Flink > Issue Type: Sub-task > Components: Connectors / Hive > Reporter: luoyuxia > Assignee: luoyuxia > Priority: Major > Labels: pull-request-available > Fix For: 1.16.0 > > > It'll throw the exception with error message "Unsupported call: IS DISTINCT > FROM(STRING, STRING) " with the following SQL in Hive dialect: > > {code:java} > create table test(x string, y string); > select x <=> y, (x <=> y) = false from test; {code} > > And I found the IS_NOT_DISTINCT_FROM is supported in > ExprCodeGenerator.scala, but IS_ DISTINCT_FROM is not. The IS_ DISTINCT_FROM > should also be implemented in ExprCodeGenerator. > > Then, I also found such sql can work in Flink SQL > > {code:java} > f63 IS DISTINCT FROM f64 {code} > The reason is such sql will be converted to "AND(OR(IS NOT NULL($63), IS NOT > NULL($64)), IS NOT TRUE(=($63, $64)))" intead of "IS_DISTINCT_FROM". > > -- This message was sent by Atlassian Jira (v8.20.10#820010)