hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jitendra Nath Pandey (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-6508) Mismatched results between vector and non-vector mode with decimal field
Date Thu, 06 Mar 2014 17:24:44 GMT

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

Jitendra Nath Pandey commented on HIVE-6508:
--------------------------------------------

+1. The patch looks good to me.

> Mismatched results between vector and non-vector mode with decimal field
> ------------------------------------------------------------------------
>
>                 Key: HIVE-6508
>                 URL: https://issues.apache.org/jira/browse/HIVE-6508
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>    Affects Versions: 0.13.0
>            Reporter: Remus Rusanu
>            Assignee: Remus Rusanu
>         Attachments: HIVE-6508.1.patch
>
>
> Following query has a little mismatch in result as compared to the non-vector mode.
> {code}
> select d_year, i_brand_id, i_brand,
>        sum(ss_ext_sales_price) as sum_agg
> from date_dim
> join store_sales on date_dim.d_date_sk = store_sales.ss_sold_date_sk
> join item on store_sales.ss_item_sk = item.i_item_sk
> where i_manufact_id = 128
>   and d_moy = 11
> group by d_year, i_brand, i_brand_id
> order by d_year, sum_agg desc, i_brand_id
> limit 100;
> {code}
> This query is on tpcds data.
> The field ss_ext_sales_price is of type decimal(7,2) and everything else is an integer.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message