hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ashu Pachauri <a...@rocketfuelinc.com>
Subject Hive Join returns incorrect results on bigint=string
Date Mon, 06 Oct 2014 21:20:57 GMT
Recently, by mistake, I encountered a situation where I ended up doing a
join key comparison between a string and a bigint. The returned results are
incorrect  even though the strings have exactly same integer values as the
bigint values.

When I do a "Join on bigint = cast(string as bigint)", the results are
correct. Is this the expected behavior, or Hive is supposed to do an
automatic cast and compare as strings?


-- 
Thanks and Regards,
Ashu Pachauri
Rocket Scientist,
Rocket Fuel Inc.
1- 650 - 200- 5390

Mime
View raw message