[
https://issues.apache.org/jira/browse/HIVE-417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12710248#action_12710248
]
He Yongqiang commented on HIVE-417:
-----------------------------------
Prasad,the index you designed is a kind of hash index? And it requires to scan
the whole table for either lookup/range-query.
Sort based query will only need to scan part of the index table, but it also
has problems as i posted in the previous comment.
bq. Since this index can be created in sorted order, we can create sparse index
how? I think sort based index can not be sparse index, and only can be dense
index.
bq. I also looked at it and not sure how it fits into Hive. Katta is more like
an distributed index server.
yes, we do not need to fit katta into Hive. But we can integrate lucene index
into Hive. But right now i think we can put this on the last part of our
schedule.
> 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: He Yongqiang
>
> 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.
