[jira] [Resolved] (IMPALA-5180) Non-deterministic exprs without slot refs cause HDFS query failure

["Zach Amsden (JIRA)" <ji...@apache.org>]

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

Zach Amsden resolved IMPALA-5180.
---------------------------------
       Resolution: Fixed
    Fix Version/s: Impala 2.9.0

https://gerrit.cloudera.org/#/c/6575/

> Non-deterministic exprs without slot refs cause HDFS query failure
> ------------------------------------------------------------------
>
>                 Key: IMPALA-5180
>                 URL: https://issues.apache.org/jira/browse/IMPALA-5180
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Frontend
>            Reporter: Zach Amsden
>            Assignee: Zach Amsden
>             Fix For: Impala 2.9.0
>
>
> Now that we do constant propagation, this query:
> {code}
> select count(*) from
>   (select * from functional.alltypes) T
> where (coalesce(NULL, T.int_col) + random() * T.int_col = 100 OR coalesce(NULL, T.int_col) + T.int_col = 20) and T.int_col = 10
> {code}
> Ends up returning:
> ERROR: NotImplementedException: Unsupported non-deterministic predicate: TRUE OR 10 + random() * 10 = 100
> The problem can be reproduced even before constant propagation with simpler expressions, we are just more likely to run into this now.  Example:
> {code}
> explain select count(*) from
>   (select * from functional.alltypes) T
> where random() = 100
> ERROR: NotImplementedException: Unsupported non-deterministic predicate: random() = 100
> {code}



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