[IMPALA-5950] Q35a and Q48 test files don't match standard qualification queries

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.10.0
• Fix Version/s: Impala 3.1.0
• Component/s: Infrastructure
• Labels: TPCDS
• Target Version: Impala 2.13.0, Impala 3.2.0
• Epic Color: ghx-label-6
• Assignee: Tim Armstrong
• Reporter: Tim Wood
• Created: 18/Sep/17 19:01
• Updated: 02/Nov/18 18:29
• Resolved: 01/Nov/18 16:06

Description

Results of q35a (in ttq.218.out) disagree with same query run on Postgres, Vertica and Netezza.

Results of q48 disagree with expected TPC-DS result data. Q48 was passing for a long time, then this intermittent failure began occurring at least by 10/5/2017, 16:17PT on Jenkins--see attached pre-review-consoleText.

https://github.com/gregrahn/tpcds-kit/tree/master/answer_sets

Issue Links

• is related to: IMPALA-5956 Add TPC-DS q31 and q89 to test suite