You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Russell Melick (JIRA)" <ji...@apache.org> on 2011/04/01 06:56:05 UTC

[jira] [Commented] (HIVE-1644) use filter pushdown for automatically accessing indexes

    [ https://issues.apache.org/jira/browse/HIVE-1644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13014394#comment-13014394 ] 

Russell Melick commented on HIVE-1644:
--------------------------------------

I'm having trouble getting the partitions from an Index.  I do not know how to get back to the index table, so I cannot use getPartCols()

I would like to do something like this, but I don't know how to get the indexTable.

{code:java}
for (Index index : indexes.get(part.getTable())) {
        Table indexTable;
        indexTable = ???
        List<FieldSchema> indexPartitions = indexTable.getPartCols();
        for (FieldSchema col : part.getCols()) {
          if (! indexPartitions.contains(col)) {
            return null;
          }
        }
      }
{code}

> use filter pushdown for automatically accessing indexes
> -------------------------------------------------------
>
>                 Key: HIVE-1644
>                 URL: https://issues.apache.org/jira/browse/HIVE-1644
>             Project: Hive
>          Issue Type: Improvement
>          Components: Indexing
>    Affects Versions: 0.7.0
>            Reporter: John Sichi
>            Assignee: Russell Melick
>         Attachments: HIVE-1644.1.patch, HIVE-1644.10.patch, HIVE-1644.11.patch, HIVE-1644.2.patch, HIVE-1644.3.patch, HIVE-1644.4.patch, HIVE-1644.5.patch, HIVE-1644.6.patch, HIVE-1644.7.patch, HIVE-1644.8.patch, HIVE-1644.9.patch
>
>
> HIVE-1226 provides utilities for analyzing filters which have been pushed down to a table scan.  The next step is to use these for selecting available indexes and generating access plans for those indexes.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira