Hive
  1. Hive
  2. HIVE-6508

Mismatched results between vector and non-vector mode with decimal field

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 0.13.0
    • Fix Version/s: 0.13.0, 0.14.0
    • Component/s: Query Processor
    • Labels:
      None

      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.

      1. HIVE-6508.1.patch
        41 kB
        Remus Rusanu
      2. HIVE-6508.1.patch
        41 kB
        Jitendra Nath Pandey

        Activity

          People

          • Assignee:
            Remus Rusanu
            Reporter:
            Remus Rusanu
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development