Hive Join returns incorrect results if the join is (bigint = string)
--------------------------------------------------------------------
Key: HIVE-1627
URL: https://issues.apache.org/jira/browse/HIVE-1627
Project: Hadoop Hive
Issue Type: Bug
Components: Query Processor
Affects Versions: 0.5.0
Reporter: Abhinav Gupta
I was running a query joining on bigint column with string column.
And, result was incorrect because only "16 bytes seemed to be compared". The
length of value more than 16 bytes when represented as base-10.
The problem was fixed once I changed the join to (bigint = cast (string as
bigint))
Is the bug because of type conversion on join keys?
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
