Details
-
Bug
-
Status: Resolved
-
Critical
-
Resolution: Fixed
-
Impala 2.6.0, Impala 2.7.0, Impala 2.8.0, Impala 2.9.0, Impala 2.10.0, Impala 2.11.0
-
ghx-label-8
Description
A recent change IMPALA-4728 added materialization of sort expressions for performance and to solve an issue with sorting on non-deterministic expressions.
However, this change doesn't materialize sort exprs when you have an inline view combined with an analytic function.
Example:
select id, r, last_value(r) over (order by r) from (select id, random() r from functional.alltypestiny) x
A query like the above can lead to a crash just like in IMPALA-4731.
Attachments
Issue Links
- is duplicated by
-
IMPALA-6639 Crash with 'ORDER BY' in 'OVER' clause with 'RANDOM'
- Resolved