You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@impala.apache.org by "Thomas Tauber-Marshall (JIRA)" <ji...@apache.org> on 2017/05/01 23:12:04 UTC

[jira] [Created] (IMPALA-5270) Sort materialization doesn't work with inline view + analytic fn

Thomas Tauber-Marshall created IMPALA-5270:
----------------------------------------------

             Summary: Sort materialization doesn't work with inline view + analytic fn
                 Key: IMPALA-5270
                 URL: https://issues.apache.org/jira/browse/IMPALA-5270
             Project: IMPALA
          Issue Type: Bug
          Components: Frontend
    Affects Versions: Impala 2.9.0
            Reporter: Thomas Tauber-Marshall


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 fn, for example:
select id, r, last_value(r) over (order by r) from (select id, random() r from functional.alltypestiny) x;



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)