You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Ashutosh Chauhan (JIRA)" <ji...@apache.org> on 2018/01/19 17:30:00 UTC

[jira] [Commented] (HIVE-18448) Drop Support For Indexes From Apache Hive

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

Ashutosh Chauhan commented on HIVE-18448:
-----------------------------------------

This is a good idea. Its not clear if indexes are ever useful in Hive. Further, its a source of confusion for users since they expect it to work in a certain way.

> Drop Support For Indexes From Apache Hive
> -----------------------------------------
>
>                 Key: HIVE-18448
>                 URL: https://issues.apache.org/jira/browse/HIVE-18448
>             Project: Hive
>          Issue Type: Improvement
>          Components: Indexing
>            Reporter: BELUGA BEHR
>            Priority: Minor
>
> If a user needs to look up a small subset of records quickly, they can use Apache HBase, if they need fast retrieval of larger sets of data, or fast joins, aggregations, they can use Apache Impala.  It seems to me that Hive indexes do not serve much of a role in the future of Hive.
> Even without moving workloads to other products, columnar file formats with their statistics achieve similar goals as Hive indexes.
> Please consider dropping Indexes from the Apache Hive project.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)