[IMPALA-5956] Add TPC-DS q31 and q89 to test suite

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: Impala 3.1.0
• Component/s: Infrastructure
• Labels: tpcds
• Epic Color: ghx-label-9
• Assignee: Tim Armstrong
• Reporter: Tim Wood
• Created: 19/Sep/17 00:25
• Updated: 05/Nov/18 17:15
• Resolved: 02/Nov/18 22:12

Description

When run esp. as part of the TPC-DS suite, query #89 returns varying results in the LSD of a calculation. Using the output of the previous run as the expected result for the next run fails. This SELECT item is a ROUND() expression, so it's not clear why the result is not deterministic.

Issue Links

• is related to: IMPALA-5986 Impala test suite harness fails to reset some options in SQL sessions
• is related to: IMPALA-6183 Converting Decimal to Double loses precision
• relates to: IMPALA-6106 test_tpcds_q53 extremely flaky because of decimal_v2 not being reset
• relates to: IMPALA-5950 Q35a and Q48 test files don't match standard qualification queries