- last edited on
I am seeing different value at Teradata and Hive when I trigger same query.
SELECT CASE WHEN 6240.00 <> 0 AND (30/(6240.00)) > 0 THEN Y ELSE N END AS "Col1"
SELECT CASE WHEN 6240 <> 0 AND (30/6240) > 0 THEN Y ELSE N END AS "Col1"
Can anyone please help me solving this? I need Hive result to be written as Teradata one.
This is resolved. Issue was with round off function.