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

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

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: 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
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment