Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
Description
Hive: INSERT statements failing with UDFArgumentException and SemanticException
Problem Statement:
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)
Attachments
Issue Links
- fixes
-
HIVE-25431 Enable CBO for null safe equality operator.
- Resolved
- links to