[IMPALA-6160] tpcds-q22a.test breaks run-workload.py

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.11.0
• Fix Version/s: Impala 3.0
• Component/s: Infrastructure
• Epic Color: ghx-label-1
• Assignee: Unassigned
• Reporter: Jim Apple
• Created: 05/Nov/17 18:43
• Updated: 02/Nov/18 18:58
• Resolved: 02/Nov/18 18:58

Description

From single_node_perf_run.py:

[scheduler] [tpcds20_parquet Thread 0]: Running Query: TPCDS-Q22A
[query_exec_functions] [tpcds20_parquet Thread 0]: Connected to localhost:21001
[query_exec_functions] [tpcds20_parquet Thread 0]: ImpalaBeeswaxException:
 INNER EXCEPTION: <class 'beeswaxd.ttypes.BeeswaxException'>
 MESSAGE: AnalysisException: Syntax error in line 3:
set decimal_v2=1;
^
Encountered: SET
Expected: CREATE, DELETE, INSERT, SELECT, UPDATE, UPSERT, VALUES, WITH

CAUSED BY: Exception: Syntax error

[query_exec_functions] [tpcds20_parquet Thread 0]: Connected to localhost:21001
[query_exec_functions] [tpcds20_parquet Thread 0]: ImpalaBeeswaxException:
 INNER EXCEPTION: <class 'beeswaxd.ttypes.BeeswaxException'>
 MESSAGE: AnalysisException: Syntax error in line 4:
with results as
^
Encountered: WITH
Expected

CAUSED BY: Exception: Syntax error

Traceback (most recent call last):
  File "./bin/single_node_perf_run.py", line 314, in <module>
    main()
  File "./bin/single_node_perf_run.py", line 304, in main
    perf_ab_test(options, args)
  File "./bin/single_node_perf_run.py", line 228, in perf_ab_test
    run_workload(temp_dir, workloads, options)
  File "./bin/single_node_perf_run.py", line 127, in run_workload
    subprocess.check_call(run_workload)
  File "/usr/lib/python2.7/subprocess.py", line 541, in check_call
    raise CalledProcessError(retcode, cmd)
subprocess.CalledProcessError: Command '['/home/ubuntu/Impala/bin/run-workload.py', '--workloads=tpch:20,targeted-perf:20,tpcds:20', '--impalads=localhost:21000,localhost:21001,localhost:21002', '--results_json_file=/home/ubuntu/Impala/perf_results/perf_run_d_73x1/6b37a793a0af74ba01c67bb5ac7285af7c5c4d52.json', '--query_iterations=50', '--table_formats=parquet/none', '--plan_first', '--query_names=.*']' returned non-zero exit status 1