[
https://issues.apache.org/jira/browse/HIVE-8745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14200636#comment-14200636
]
Jason Dere commented on HIVE-8745:
----------------------------------
{quote}
Nevertheless, I think the serde should be able to trim the zeros and pad it
back as long as it has the right metadata. It seems it does have the metadata
for each colomns.
{quote}
We have the metadata for the column, but not for individual values in each row.
If you have a decimal(10,5) column, but the values
{noformat}
1
1.0
1.00
{noformat}
The only thing we could get from the column metadata is the precision=5, so we
could pad everything to 1.00000. To know how many extra zeros we need for each
value of the column, we would have to save something for each value.
> 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)
