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

          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

            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: