[
https://issues.apache.org/jira/browse/HIVE-11726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14989121#comment-14989121
]
Jesus Camacho Rodriguez commented on HIVE-11726:
------------------------------------------------
[~hsubramaniyan], last version of the patch removed part concerning OR/AND
predicates transformation into IN (which you already covered in HIVE-11634).
Thus, this patch will enable pushing the IN predicates directly to the
metastore.
Could you take a look? Thanks
> Pushed IN predicates to the metastore
> -------------------------------------
>
> Key: HIVE-11726
> URL: https://issues.apache.org/jira/browse/HIVE-11726
> Project: Hive
> Issue Type: Bug
> Affects Versions: 2.0.0
> Reporter: Jesus Camacho Rodriguez
> Assignee: Jesus Camacho Rodriguez
> Attachments: HIVE-11726.01.patch, HIVE-11726.patch
>
>
> The PointLookupOptimizer can turn off some of the optimizations due to its
> use of tuple IN() clauses.
> HIVE-11573 introduced the extraction of sub-clauses that could be pushed down
> till the TableScan operators, though they wouldn't be pushed down to the
> metastore.
> In this issue, we tackle this problem by extending the filter parser of the
> metastore to support IN clauses, including multiple columns. This allows to
> push those additional predicates down throw directSQL to the metastore.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
