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

filtering via partition name should be done inside metastore server (implementation)

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • None
    • 0.13.0
    • Metastore
    • None

    Description

      Currently, if the filter pushdown is impossible (which is most cases), the client gets all partition names from metastore, filters them, and asks for partitions by names for the filtered set.

      Metastore server code should do that instead; it should check if pushdown is possible and do it if so; otherwise it should do name-based filtering.

      Saves the roundtrip with all partition names from the server to client, and also removes the need to have pushdown viability checking on both sides.

      Attachments

        1. HIVE-4914-only-no-gen.patch
          92 kB
          Sergey Shelukhin
        2. HIVE-4914-only.patch
          942 kB
          Sergey Shelukhin
        3. HIVE-4914.patch
          982 kB
          Sergey Shelukhin
        4. HIVE-4914.patch
          943 kB
          Sergey Shelukhin
        5. HIVE-4914.patch
          942 kB
          Sergey Shelukhin
        6. HIVE-4914.D12645.1.patch
          104 kB
          Phabricator
        7. HIVE-4914.D12561.4.patch
          101 kB
          Phabricator
        8. HIVE-4914.D12561.3.patch
          102 kB
          Phabricator
        9. HIVE-4914.D12561.2.patch
          104 kB
          Phabricator
        10. HIVE-4914.D12561.1.patch
          88 kB
          Phabricator
        11. HIVE-4914.07.patch
          690 kB
          Sergey Shelukhin
        12. HIVE-4914.06.patch
          691 kB
          Sergey Shelukhin
        13. HIVE-4914.05.patch
          693 kB
          Sergey Shelukhin
        14. HIVE-4914.04.patch
          690 kB
          Sergey Shelukhin
        15. HIVE-4914.03.patch
          691 kB
          Sergey Shelukhin
        16. HIVE-4914.02.patch
          687 kB
          Sergey Shelukhin
        17. HIVE-4914.01.patch
          942 kB
          Sergey Shelukhin
        18. D12561.7.patch
          101 kB
          Phabricator
        19. D12561.6.patch
          102 kB
          Phabricator
        20. D12561.5.patch
          104 kB
          Phabricator

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. HIVE-5134 add tests to partition filter JDO pushdown for like and make sure it works, or remove it

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-4888 listPartitionsByFilter doesn't support lt/gt/lte/gte

          • Major - Major loss of function.
          • Resolved
          contains

          Bug - A problem which impairs or prevents the functions of the product. HIVE-6028 Partition predicate literals are not interpreted correctly.

          • Major - Major loss of function.
          • Resolved
          is blocked by

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-4985 refactor/clean up partition name pruning to be usable inside metastore server

          • Major - Major loss of function.
          • Closed
          relates to

          Improvement - An improvement or enhancement to an existing feature or task. HIVE-5234 partition name filtering uses suboptimal datastructures

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              sershe Sergey Shelukhin
              sershe Sergey Shelukhin
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: