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] [Created] (HIVE-8541) Decimal values contains extra trailing zeros when vectorization is on
Date Tue, 21 Oct 2014 17:52:34 GMT
Sergio Peña created HIVE-8541:
---------------------------------

             Summary: 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