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

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

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment