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

Support non-MR fetching for simple queries with select/limit/filter operations only

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Trivial
    • Resolution: Fixed
    • 0.10.0
    • 0.10.0
    • None
    • None
    • Reviewed

    Description

      It's trivial but frequently asked by end-users. Currently, select queries with simple conditions or limit should run MR job which takes some time especially for big tables, making the people irritated.

      For that kind of simple queries, using fetch task would make them happy.

      Attachments

        1. ASF.LICENSE.NOT.GRANTED--HIVE-2925.D2607.1.patch
          21 kB
          Phabricator
        2. ASF.LICENSE.NOT.GRANTED--HIVE-2925.D2607.2.patch
          24 kB
          Phabricator
        3. ASF.LICENSE.NOT.GRANTED--HIVE-2925.D2607.3.patch
          24 kB
          Phabricator
        4. ASF.LICENSE.NOT.GRANTED--HIVE-2925.D2607.4.patch
          24 kB
          Phabricator
        5. HIVE-2925.1.patch.txt
          112 kB
          Navis Ryu
        6. HIVE-2925.2.patch.txt
          121 kB
          Navis Ryu
        7. HIVE-2925.3.patch.txt
          144 kB
          Navis Ryu

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. HIVE-3045 Partition column values are not valid if any of virtual columns is selected

          • Major - Major loss of function.
          • Closed

          New Feature - A new feature of the product, which has yet to be developed. HIVE-887 Allow SELECT <col> without a mapreduce job

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

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-3990 Provide input threshold for direct-fetcher (HIVE-2925)

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Resolved

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-5718 Support direct fetch for lateral views, sub queries, etc.

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Resolved

          Activity

            People

              navis Navis Ryu
              navis Navis Ryu
              Votes:
              0 Vote for this issue
              Watchers:
              12 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: