[IMPALA-6736] stress test --filter-query-mem-ratio doesn't work

• Type: Task
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.8.0
• Fix Version/s: Impala 3.0, Impala 2.12.0
• Component/s: Infrastructure
• Target Version: Impala 2.12.0
• Epic Color: ghx-label-5
• Assignee: Michael Brown
• Reporter: Michael Brown
• Created: 24/Mar/18 22:28
• Updated: 27/Mar/18 18:47
• Resolved: 26/Mar/18 22:36

Description

In testing https://gerrit.cloudera.org/#/c/9758/ I noticed that TPC-DS Q67A at SF 300 takes 49525M to run without spilling. This is an order of magnitude larger than any other query. The query is too large for the cluster to also stress the cluster concurrency-wise.

The stress test has an option that in theory is supposed to catch this

  --filter-query-mem-ratio FILTER_QUERY_MEM_RATIO
                        Queries that require this ratio of total available
                        memory will be filtered. (default: 0.333)

but it's broken. Fix/improve the option.