Support Questions
Find answers, ask questions, and share your expertise

Hive and Teradata mismatch

Hive and Teradata mismatch

Explorer

Hello Community, 

 

I am seeing different value at Teradata and Hive when I trigger same query.

 

Teradata: 

SELECT CASE WHEN 6240.00 <> 0 AND (30/(6240.00)) > 0 THEN Y ELSE N END AS "Col1"

Output: N

Hive:

SELECT CASE WHEN 6240 <> 0 AND (30/6240) > 0 THEN Y ELSE N END AS "Col1"

Output: Y

 

Can anyone please help me solving this? I need Hive result to be written as Teradata one. 

 

Thank you. 

1 REPLY 1
Highlighted

Re: Hive and Teradata mismatch

Explorer

This is resolved. Issue was with round off function.