Hive
  1. Hive
  2. HIVE-2925

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

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Trivial Trivial
    • Resolution: Fixed
    • Affects Version/s: 0.10.0
    • Fix Version/s: 0.10.0
    • Component/s: None
    • Labels:
      None
    • Hadoop Flags:
      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.

      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
      6. HIVE-2925.2.patch.txt
        121 kB
        Navis
      7. HIVE-2925.3.patch.txt
        144 kB
        Navis

        Issue Links

          Activity

          Navis created issue -
          Phabricator made changes -
          Field Original Value New Value
          Attachment HIVE-2925.D2607.1.patch [ 12521275 ]
          Phabricator made changes -
          Attachment HIVE-2925.D2607.2.patch [ 12521432 ]
          Phabricator made changes -
          Attachment HIVE-2925.D2607.3.patch [ 12526703 ]
          Phabricator made changes -
          Attachment HIVE-2925.D2607.4.patch [ 12526704 ]
          Navis made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Affects Version/s 0.10.0 [ 12320745 ]
          Navis made changes -
          Link This issue duplicates HIVE-887 [ HIVE-887 ]
          Namit Jain made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Navis made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Namit Jain made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Navis made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Namit Jain made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Navis made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Namit Jain made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Navis made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Namit Jain made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Namit Jain made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Navis made changes -
          Attachment HIVE-2925.1.patch.txt [ 12538878 ]
          Namit Jain made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Navis made changes -
          Attachment HIVE-2925.2.patch.txt [ 12539016 ]
          Navis made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Namit Jain made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Navis made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Namit Jain made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          Navis made changes -
          Attachment HIVE-2925.3.patch.txt [ 12541300 ]
          Navis made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Namit Jain made changes -
          Status Patch Available [ 10002 ] Resolved [ 5 ]
          Hadoop Flags Reviewed [ 10343 ]
          Resolution Fixed [ 1 ]
          Ashutosh Chauhan made changes -
          Fix Version/s 0.10.0 [ 12320745 ]
          Navis made changes -
          Link This issue duplicates HIVE-3045 [ HIVE-3045 ]
          Ashutosh Chauhan made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Lefty Leverenz made changes -
          Link This issue is related to HIVE-3990 [ HIVE-3990 ]
          Lefty Leverenz made changes -
          Link This issue is related to HIVE-5718 [ HIVE-5718 ]

            People

            • Assignee:
              Navis
              Reporter:
              Navis
            • Votes:
              0 Vote for this issue
              Watchers:
              12 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development