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

Implement Indexing in Hive

    XMLWordPrintableJSON

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 0.3.0, 0.4.0, 0.6.0
    • Fix Version/s: 0.7.0
    • Component/s: Indexing, Metastore, Query Processor
    • Labels:
      None
    • Hadoop Flags:
      Reviewed
    • Release Note:
      Index support requires metastore schema upgrade (TBD).

      Description

      Implement indexing on Hive so that lookup and range queries are efficient.

        Attachments

        1. hive.indexing.11.patch
          1.34 MB
          He Yongqiang
        2. hive.indexing.12.patch
          2.78 MB
          He Yongqiang
        3. hive.indexing.13.patch
          2.78 MB
          He Yongqiang
        4. hive-417.proto.patch
          39 kB
          Prasad Chakka
        5. hive-417－2009-07-18.patch
          160 kB
          He Yongqiang
        6. hive-indexing.3.patch
          149 kB
          He Yongqiang
        7. hive-indexing.5.thrift.patch
          195 kB
          He Yongqiang
        8. hive-indexing-8-thrift-metastore-remodel.patch
          1.28 MB
          He Yongqiang
        9. idx2.png
          168 kB
          John Sichi
        10. indexing_with_ql_rewrites_trunk_953221.patch
          191 kB
          Prafulla T

          Issue Links

          is duplicated by

          New Feature - A new feature of the product, which has yet to be developed. HIVE-837 virtual column support (filename) in hive

          • Major - Major loss of function.
          • Resolved
          is related to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-1501 when generating reentrant INSERT for index rebuild, quote identifiers using backticks

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. CHUKWA-22 Need index for chukwa sequence files

          • Major - Major loss of function.
          • Open

          New Feature - A new feature of the product, which has yet to be developed. HIVE-1694 Accelerate GROUP BY execution using indexes

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. HIVE-1889 add an option (hive.index.compact.file.ignore.hdfs) to ignore HDFS location stored in index files.

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-1496 enhance CREATE INDEX to support immediate index build

          • Major - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-1499 allow index partitioning to be only a subset of base table partitioning

          • Major - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-1500 explicitly model index rebuild time

          • Major - Major loss of function.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-1503 additional validation for CREATE INDEX

          • Major - Major loss of function.
          • Open

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

          • Major - Major loss of function.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-1495 supply correct information to hooks and lineage for index rebuild

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-1497 support COMMENT clause on CREATE INDEX, and add new command for SHOW INDEXES

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-1498 support IDXPROPERTIES on CREATE INDEX

          • Major - Major loss of function.
          • Closed
          relates to

          New Feature - A new feature of the product, which has yet to be developed. HIVE-1803 Implement bitmap indexing in Hive

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. HIVE-1904 Create MetaStore schema upgrade scripts for changes made in HIVE-417

          • Blocker - Blocks development and/or testing work, production could not run
          • Closed
          There are no Sub-Tasks for this issue.

            Activity

              People

              • Assignee:
                he yongqiang He Yongqiang
                Reporter:
                prasadc Prasad Chakka
              • Votes:
                0 Vote for this issue
                Watchers:
                29 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: