hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sergio Peña (JIRA) <j...@apache.org>
Subject [jira] [Commented] (HIVE-8541) Decimal values contains extra trailing zeros when vectorization is on
Date Wed, 22 Oct 2014 14:39:34 GMT

    [ https://issues.apache.org/jira/browse/HIVE-8541?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14179966#comment-14179966
] 

Sergio Peña commented on HIVE-8541:
-----------------------------------

Thanks Matt.
I will set this bug as won't fix then. 

> Decimal values contains extra trailing zeros when vectorization is on
> ---------------------------------------------------------------------
>
>                 Key: HIVE-8541
>                 URL: https://issues.apache.org/jira/browse/HIVE-8541
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 0.13.1
>            Reporter: Sergio Peña
>            Assignee: Sergio Peña
>
> The fix done on HIVE-7373 preserves the trailing zeroes from decimal values
> as they are read from the table files, but when vectorization is on, these
> values contain extra tralinig zeroes up to what the scale allows when aggregation
> expressions are used.
> Here's an example (data gotten from vector_decimal_aggregate.q):
> {noformat}
> hive> SET hive.vectorized.execution.enabled=false;
> hive> SELECT cint, MAX(cdecimal2) max FROM decimal_vgby GROUP BY cint HAVING COUNT(*)
> 1;
> +------------+---------------------+--+
> |    cint    |         max         |
> +------------+---------------------+--+
> | NULL       | 11160.715384615385  |
> | -3728      | 6984454.211097692   |
> | -563       | -617.5607769230769  |
> | 762        | 6984454.211097692   |
> | 6981       | 6984454.211097692   |
> | 253665376  | 11697.969230769231  |
> | 528534767  | 6984454.211097692   |
> | 626923679  | 11645.746153846154  |
> +------------+---------------------+--+
> hive> SET hive.vectorized.execution.enabled=true;
> hive> SELECT cint, MAX(cdecimal2) max FROM decimal_vgby GROUP BY cint HAVING COUNT(*)
> 1;
> +------------+-------------------------+--+
> |    cint    |          max2           |
> +------------+-------------------------+--+
> | NULL       | 11160.71538461538500    |
> | -3728      | 6984454.21109769200000  |
> | -563       | -617.56077692307690     |
> | 762        | 6984454.21109769200000  |
> | 6981       | 6984454.211097692       |
> | 253665376  | 11697.96923076923100    |
> | 528534767  | 6984454.21109769200000  |
> | 626923679  | 11645.74615384615400    |
> +------------+-------------------------+--+
> {noformat}
> Hive should not add trailing zeroes when aggregation functions are used.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message