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
