[IMPALA-5986] Impala test suite harness fails to reset some options in SQL sessions

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.9.0, Impala 2.10.0, Impala 2.11.0
• Fix Version/s: Impala 2.11.0
• Component/s: Infrastructure
• Epic Color: ghx-label-7
• Assignee: Tim Wood
• Reporter: Tim Wood
• Created: 26/Sep/17 19:58
• Updated: 12/Oct/17 15:52
• Resolved: 12/Oct/17 15:52

Description

This bug arose while characterizing TPC-DS tests that flap.

Runs of the full TPC-DS suite display results for various tests that variously fail or succeed in absence of code or environment changes. All failures are connected with displays of the scale of decimal values. Some tests contain SET DECIMAL_V2=1; statements. I theorized that this option was getting left on in SQL connections and exposed to subsequent tests.

The main test suite driver file, $IMPALA_HOME/tests/common/impala_test_suite.py, contains logic to reset options in the SQL session between tests, however its regex to detect these statements fails for statements that contain digits (SET_PATTERN = re.compile(...)).

Issue Links

• blocks: IMPALA-5376 Add all missing TPC-DS queries to functional tests
• relates to: IMPALA-5956 Add TPC-DS q31 and q89 to test suite