[ https://issues.apache.org/jira/browse/HIVE-24998?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
ASF GitHub Bot updated HIVE-24998: ---------------------------------- Labels: pull-request-available (was: ) > IS [NOT] DISTINCT FROM failing with SemanticException > ----------------------------------------------------- > > Key: HIVE-24998 > URL: https://issues.apache.org/jira/browse/HIVE-24998 > Project: Hive > Issue Type: Bug > Components: CBO > Reporter: Soumyakanti Das > Assignee: Soumyakanti Das > Priority: Major > Labels: pull-request-available > Time Spent: 10m > Remaining Estimate: 0h > > Hive: INSERT statements failing with UDFArgumentException and > SemanticException > Problem Statement: > {code:java} > CREATE TABLE t2(c0 boolean , c1 FLOAT ); > INSERT INTO t2(c0) VALUES (NOT (0.379 IS NOT DISTINCT FROM 641)); > -- Insert failing with: Error: Error while compiling statement: FAILED: > UDFArgumentException UDF tables only one argument (state=42000,code=40000) > INSERT INTO t2(c0,c1) VALUES (NOT (0.379 IS NOT DISTINCT FROM 641), 0.2); > -- Insert failing with: SemanticException 0:0 Expected 2 columns for > insclause-0/database52@t2; select produces 1 columns. Error encountered near > token '0.2' (state=42000,code=40000) {code} > -- This message was sent by Atlassian Jira (v8.3.4#803005)