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

HCatLoader should support predicate pushdown.

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsAdd voteVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Patch Available
    • Major
    • Resolution: Unresolved
    • 3.0.0
    • None
    • HCatalog
    • None

    Description

      When one uses HCatInputFormat/HCatLoader to read from file-formats that support predicate pushdown (such as ORC, with hive.optimize.index.filter=true), one sees that the predicates aren't actually pushed down into the storage layer.

      The forthcoming patch should allow for filter-pushdown, if any of the partitions being scanned with HCatLoader support the functionality. The patch should technically allow the same for users of HCatInputFormat, but I don't currently have a neat interface to build a compound predicate-expression. Will add this separately, if required.

      Attachments

        1. HIVE-11548.1.patch
          18 kB
          Mithun Radhakrishnan
        2. HIVE-11548.2.patch
          21 kB
          Mithun Radhakrishnan
        3. HIVE-11548.3.patch
          56 kB
          Mithun Radhakrishnan
        4. HIVE-11548.4.patch
          56 kB
          Mithun Radhakrishnan
        5. HIVE-11548.5.patch
          60 kB
          Mithun Radhakrishnan
        6. HIVE-11548.6.patch
          61 kB
          Mithun Radhakrishnan
        7. HIVE-11548.6-branch-2.patch
          61 kB
          Mithun Radhakrishnan
        8. HIVE-11548.6-branch-2.2.patch
          62 kB
          Mithun Radhakrishnan
        9. HIVE-11548.7.patch
          61 kB
          Mithun Radhakrishnan
        10. HIVE-11548.7-branch-2.patch
          62 kB
          Mithun Radhakrishnan
        11. HIVE-11548.7-branch-2.2.patch
          62 kB
          Mithun Radhakrishnan

        Issue Links

        blocks

        Bug - A problem which impairs or prevents the functions of the product. HIVE-17754 HCat InputJobInfo in Pig UDFContext is heavyweight, and causes OOMs in Tez AMs

        • Major - Major loss of function.
        • Patch Available

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            mithun Mithun Radhakrishnan Assign to me
            mithun Mithun Radhakrishnan
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Slack

                Issue deployment