[IMPALA-2775] Randomly generated query fails with "Expressions in the ORDER BY clause must not be constant"

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Won't Fix
• Affects Version/s: Impala 2.3.0
• Component/s: Infrastructure
• Labels: query_generator stress
• Assignee: Unassigned
• Reporter: Tim Armstrong
• Created: 15/Dec/15 21:06
• Updated: 06/Mar/19 22:46
• Resolved: 06/Feb/18 22:33

Description

A query generated for the stress test failed with the following error:

12:48:07 SELECT
12:48:07 IF(t2.boolean_col_1, t2.int_col_2, t1.int_col_2) AS int_col,
12:48:07 COALESCE(t1.int_col_2, t2.int_col_2, t2.int_col_2) AS int_col_1
12:48:07 FROM table_1 t1
12:48:07 INNER JOIN table_1 t2 ON ((t2.varchar0056_col_3) = (t1.varchar0056_col_3)) AND ((t2.decimal1802_col_4) = (t1.decimal1802_col_4))
12:48:07 Traceback (most recent call last):
12:48:07   File "tests/stress/concurrent_select.py", line 922, in populate_runtime_info_for_random_queries
12:48:07     timeout_secs=query_timeout_secs)
12:48:07   File "tests/stress/concurrent_select.py", line 1022, in populate_runtime_info
12:48:07     report = get_report()
12:48:07   File "tests/stress/concurrent_select.py", line 981, in get_report
12:48:07     raise QueryTimeout()
12:48:07 QueryTimeout
12:48:07 12:48:07 13604 140202811352832 INFO:concurrent_select[944]:Collecting runtime info for query: 
12:48:07 SELECT
12:48:07 t1.float_col_6,
12:48:07 (-161) IN (-60, -872) AS boolean_col,
12:48:07 (LEAD((866) - (864.9960081188), 36) OVER (ORDER BY t1.float_col_6 DESC, (-161) IN (-60, -872) DESC)) + (-545) AS decimal_col
12:48:07 FROM table_30 t1
12:48:07 WHERE
12:48:07 (314) NOT IN (157, -560)
12:48:08 12:48:08 13604 140202811352832 WARNING:concurrent_select[930]:Error running query (the test will continue)
12:48:08 AnalysisException: Expressions in the ORDER BY clause must not be constant: (-161) IN (-60, -872) (in (lead((866) - (864.9960081188), 36) OVER (ORDER BY t1.float_col_6 DESC, (-161) IN (-60, -872) DESC)))

Issue Links

• is related to: IMPALA-6323 Support a constant in a window specification