Soumyakanti Das created HIVE-24998:
--------------------------------------

             Summary: 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


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