[HIVE-24998] IS [NOT] DISTINCT FROM failing with SemanticException

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Component/s: CBO
• Labels: pull-request-available
• Assignee: Soumyakanti Das
• Reporter: Manthan B Y
• Created: 09/Apr/21 20:10
• Updated: 27/Feb/24 22:23
• Resolved: 28/Apr/21 15:55

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) 

 

Issue Links

• fixes: HIVE-25431 Enable CBO for null safe equality operator.
• links to: GitHub Pull Request #2163