[
https://issues.apache.org/jira/browse/HIVE-417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12728900#action_12728900
]
Prasad Chakka commented on HIVE-417:
------------------------------------
One thing that isn't mentioned is that in List<bucketname, List<offset>>
column, offsets are sorted.
Another thing missing is, when an index on a partition is built then a new
partition will be created for that index table (similar to that of creating a
partition for a regular table).
We can distinguish index tables and regular tables by having a table parameter.
We can skip partition specific indexes in the first phase if it reduces amount
of work and assume indexes defined on a table can be created on all partitions.
> Implement Indexing in Hive
> --------------------------
>
> Key: HIVE-417
> URL: https://issues.apache.org/jira/browse/HIVE-417
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Metastore, Query Processor
> Affects Versions: 0.2.0, 0.3.0, 0.3.1, 0.4.0
> Reporter: Prasad Chakka
> Assignee: Yongqiang He
> Attachments: hive-417.proto.patch
>
>
> Implement indexing on Hive so that lookup and range queries are efficient.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.