[
https://issues.apache.org/jira/browse/HIVE-5986?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13844502#comment-13844502
]
Owen O'Malley commented on HIVE-5986:
-------------------------------------
The better fix is to remove the AND node from the expression.
> ORC SARG evaluation fails with NPE for UDFs or expressions in predicate
> condition
> ---------------------------------------------------------------------------------
>
> Key: HIVE-5986
> URL: https://issues.apache.org/jira/browse/HIVE-5986
> Project: Hive
> Issue Type: Bug
> Affects Versions: 0.13.0
> Reporter: Prasanth J
> Assignee: Prasanth J
> Labels: orcfile
> Attachments: HIVE-5986.1.patch, HIVE-5986.2.patch
>
>
> {code}select s from orctable where length(substr(s, 1, 2)) <= 2 and s like
> '%';{code} kind of queries generate empty child expressions for the operator
> (AND in this case). When child expressions are empty evaluate(TruthValue[]
> leaves) functions returns null which results in NPE during orc split
> elimination or row group elimination.
--
This message was sent by Atlassian JIRA
(v6.1.4#6159)
