[
https://issues.apache.org/jira/browse/HIVE-4579?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13669008#comment-13669008
]
Owen O'Malley commented on HIVE-4579:
-------------------------------------
Eric, thanks for the comments!
You're right that I was mistaken when I thought that 10 > NULL was FALSE. :( It
is NULL and NOT(NULL) is still NULL. Therefore, you are right that you can
translate NOT(COL > 10) to COL <= 10.
The "maybe" answers are the parts of the SARG that can't be answered
definitively by the information in the index. For example, if the SARG is "age
> 99" and the min age is 1 and the max age is 101, the value of the predicate
is "maybe."
{quote}
I think you mean that such clauses will be removed from the SARG and treated as
a residual.{quote}
Yes
{quote}
For "The primitive clauses will be
extended to include presence in a bloom filter" do you mean that bloom filters
will be added as a primitive clause type later?
{quote}
Yes
> Create a SARG interface for RecordReaders
> -----------------------------------------
>
> Key: HIVE-4579
> URL: https://issues.apache.org/jira/browse/HIVE-4579
> Project: Hive
> Issue Type: Improvement
> Reporter: Owen O'Malley
> Assignee: Owen O'Malley
> Attachments: h-4579.patch, pushdown.pdf
>
>
> I think we should create a SARG (http://en.wikipedia.org/wiki/Sargable)
> interface for RecordReaders. For a first pass, I'll create an API that uses
> the value stored in hive.io.filter.expr.serialized.
> The desire is to define an simpler interface that the direct AST expression
> that is provided by hive.io.filter.expr.serialized so that the code to
> evaluate expressions can be generalized instead of put inside a particular
> RecordReader.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
