[
https://issues.apache.org/jira/browse/IMPALA-2775?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tim Armstrong resolved IMPALA-2775.
-----------------------------------
Resolution: Won't Fix
> Randomly generated query fails with "Expressions in the ORDER BY clause must
> not be constant"
> ---------------------------------------------------------------------------------------------
>
> Key: IMPALA-2775
> URL: https://issues.apache.org/jira/browse/IMPALA-2775
> Project: IMPALA
> Issue Type: Bug
> Components: Infrastructure
> Affects Versions: Impala 2.3.0
> Reporter: Tim Armstrong
> Priority: Minor
> Labels: query_generator, stress
>
> A query generated for the stress test failed with the following error:
> {code}
> 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)))
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
