[ 
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)

Reply via email to