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.