[ https://issues.apache.org/jira/browse/HIVE-8745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14199713#comment-14199713 ]
Xuefu Zhang commented on HIVE-8745: ----------------------------------- I don't thinking reverting HIVE-7373 is a viable option. That's the trigger but not the root cause of the problem. The root cause is that BinarySortableSerde should be able to serailize decimal values in such way that comparison can be performed at byte level w/o requiring values be trailed for zeroes. I don't know how to do this, but I think that's the direction into which we should look. If the serde needs to remove trailing zeros during serialization, this is fine as long as it can get them back upon deserialization. > Joins on decimal keys return different results whether they are run as reduce > join or map join > ---------------------------------------------------------------------------------------------- > > Key: HIVE-8745 > URL: https://issues.apache.org/jira/browse/HIVE-8745 > Project: Hive > Issue Type: Bug > Affects Versions: 0.14.0 > Reporter: Gunther Hagleitner > Assignee: Jason Dere > Priority: Critical > Fix For: 0.14.0 > > Attachments: join_test.q > > > See attached .q file to reproduce. The difference seems to be whether > trailing 0s are considered the same value or not. -- This message was sent by Atlassian JIRA (v6.3.4#6332)