[HIVE-6508] Mismatched results between vector and non-vector mode with decimal field

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.13.0
• Fix Version/s: 0.13.0, 0.14.0
• Component/s: Query Processor
• Assignee: Remus Rusanu
• Reporter: Remus Rusanu
• Created: 26/Feb/14 07:30
• Updated: 13/Nov/14 19:42
• Resolved: 08/Mar/14 23:05

Description

Following query has a little mismatch in result as compared to the non-vector mode.

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;

This query is on tpcds data.
The field ss_ext_sales_price is of type decimal(7,2) and everything else is an integer.