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

Implement Indexing in Hive

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

                • 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-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: