Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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. 

Don't have an account?
Coming from Hortonworks? Activate your account here