hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ashu Pachauri <>
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

View raw message