[IMPALA-5180] Non-deterministic exprs without slot refs cause HDFS query failure

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: Impala 2.9.0
• Component/s: Frontend
• Target Version: Impala 2.9.0
• Epic Color: ghx-label-5
• Assignee: Zach Amsden
• Reporter: Zach Amsden
• Created: 06/Apr/17 23:30
• Updated: 14/Mar/18 23:28
• Resolved: 19/May/17 19:10

Description

Now that we do constant propagation, this query:

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

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:

explain select count(*) from
  (select * from functional.alltypes) T
where random() = 100
ERROR: NotImplementedException: Unsupported non-deterministic predicate: random() = 100

Issue Links

• is a parent of: IMPALA-5003 Add 'constant propagation' for Views with a partition filter