hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jason Dere (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-8745) Joins on decimal keys return different results whether they are run as reduce join or map join
Date Thu, 06 Nov 2014 18:49:36 GMT

    [ 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)

Mime
View raw message