[
https://issues.apache.org/jira/browse/HIVE-2036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13045770#comment-13045770
]
John Sichi commented on HIVE-2036:
----------------------------------
I'll take a look at the new patch tomorrow. index_auto_partitioned.q does not
actually include a predicate on the partitioning column, so it should be
enhanced to do that.
The way it works for the compact index handler is that if we have a predicate
like
{noformat}
WHERE part_col = 1 AND index_col = 2 AND some_other_col = 3
{noformat}
then it should generate
{noformat}
WHERE part_col = 1 AND index_col = 2
{noformat}
in the internal query against the index table. That's the reason that
getIndexPredicateAnalyzer walks through all the partitions and adds the
predicate columns via allowColumnName. (The way it does it isn't so great
since it repeats it for each partition, when in fact one partition should be
good enough.)
> Update bitmap indexes for automatic usage
> -----------------------------------------
>
> Key: HIVE-2036
> URL: https://issues.apache.org/jira/browse/HIVE-2036
> Project: Hive
> Issue Type: Improvement
> Components: Indexing
> Affects Versions: 0.8.0
> Reporter: Russell Melick
> Assignee: Syed S. Albiz
> Attachments: HIVE-2036.1.patch
>
>
> HIVE-1644 will provide automatic usage of indexes, and HIVE-1803 adds bitmap
> index support. The bitmap code will need to be extended after it is
> committed to enable automatic use of indexing. Most work will be focused in
> the BitmapIndexHandler, which needs to generate the re-entrant QL index
> query. There may also be significant work in the IndexPredicateAnalyzer to
> support predicates with OR's, instead of just AND's as it is currently.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
