hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Sichi (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-2036) Update bitmap indexes for automatic usage
Date Wed, 08 Jun 2011 04:37:58 GMT

    [ 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

Mime
View raw message