[IMPALA-4370] DECIMAL divide result type (Impala TPC-DS query 11 result lost one row)

• Type: Sub-task
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: Impala 2.8.0
• Fix Version/s: Impala 2.9.0
• Component/s: Frontend
• Labels: correctness
• Target Version: Impala 2.9.0
• Assignee: Daniel Hecht
• Reporter: Yuanhao Luo
• Created: 26/Oct/16 09:18
• Updated: 15/Feb/17 22:24
• Resolved: 15/Feb/17 22:24

Description

The result of TPC-DS query 11 in Impala is wrong. It lost a record :
"AAAAAAAAOPDLAAAA | Ann | Pence N"

I'm using tpcds 1g validation dataset generated by command:
"./dsdgen -sc 1 -terminate N -validate Y"
with tpc-ds-2.3.0

Attachments are the query string, result of Impala and tpc-ds answer set.

Note: I have also run this query in PostgreSQL and it gives the same result as tpc-ds result set.

Issue Links

• is related to: IMPALA-4940 DECIMAL V2 multiply result type