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)