Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-18448

Drop Support For Indexes From Apache Hive

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • 3.0.0
    • Indexing
    • None

    Description

      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.

      Attachments

        1. HIVE-18448.01wip02.patch
          887 kB
          Zoltan Haindrich
        2. HIVE-18448.01wip03.patch
          881 kB
          Zoltan Haindrich
        3. HIVE-18448.01wip04.patch
          881 kB
          Zoltan Haindrich
        4. HIVE-18448.01wip05.patch
          875 kB
          Zoltan Haindrich
        5. HIVE-18448.01.patch
          952 kB
          Zoltan Haindrich

        Issue Links

        is related to

        Sub-task - The sub-task of the issue HIVE-18496 Create tests to cover add/alter/drop index methods

        • Major - Major loss of function.
        • Closed

        Improvement - An improvement or enhancement to an existing feature or task. HIVE-21968 Remove index related codes

        • Major - Major loss of function.
        • Closed

        Improvement - An improvement or enhancement to an existing feature or task. HIVE-24815 Remove "IDXS" Table from Metastore Schema

        • Major - Major loss of function.
        • Closed
        supercedes

        Improvement - An improvement or enhancement to an existing feature or task. HIVE-1502 finish the index design doc

        • Major - Major loss of function.
        • Resolved

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            kgyrtkirk Zoltan Haindrich Assign to me
            belugabehr David Mollitor
            Votes:
            2 Vote for this issue
            Watchers:
            11 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment