[
https://issues.apache.org/jira/browse/HIVE-417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12884685#action_12884685
]
Ashish Thusoo commented on HIVE-417:
------------------------------------
Looked at the code and have some questions...
Can you explain how the metastore object model is laid out. It seems that the
table names of the index are stored in key value properties of the table that
the index is created on. Is that correct? Would it be better to put a key
reference from the index table to the base table instead (similar to what is
done for partitions)?
Also, how would this be used to query the table? Can you give an example?
Is the idea here to select from the index an then pass the offsets to another
query to look up the table? An example or a test which shows the query on the
base table would be useful.
> 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.3.0, 0.3.1, 0.4.0, 0.6.0
> Reporter: Prasad Chakka
> Assignee: He Yongqiang
> Attachments: hive-417.proto.patch, hive-417－2009-07-18.patch,
> hive-indexing.3.patch, hive-indexing.5.thrift.patch,
> indexing_with_ql_rewrites_trunk_953221.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.
