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/23 15:44:04 UTC

[jira] [Resolved] (IMPALA-4900) "row_number() over order by random()" crashes Impala

     [ https://issues.apache.org/jira/browse/IMPALA-4900?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Thomas Tauber-Marshall resolved IMPALA-4900.
--------------------------------------------
    Resolution: Fixed

This was fixed by IMPALA-4731.

The issue here was that with only 'row_number()'/'dense_rank()' and 'random()'/'uuid()', nothing was getting materialized into the sort tuple, resulting in a tuple size of 0 and division by 0 in the sorter.

This can no longer happen as IMPALA-4731 ensures that any function call being ordered on will be materialized into the sort tuple.

> "row_number() over order by random()" crashes Impala
> ----------------------------------------------------
>
>                 Key: IMPALA-4900
>                 URL: https://issues.apache.org/jira/browse/IMPALA-4900
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Backend
>    Affects Versions: Impala 2.9.0
>            Reporter: Thomas Tauber-Marshall
>            Assignee: Thomas Tauber-Marshall
>            Priority: Critical
>              Labels: crash
>
> Impala crashes on:
> select row_number() over (order by random()) from functional.alltypes



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