[
https://issues.apache.org/jira/browse/HIVE-8541?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14179358#comment-14179358
]
Matt McCline commented on HIVE-8541:
------------------------------------
See HIVE-8461.
> 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)
