Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-16923 Hive-on-Spark DPP Improvements
  3. HIVE-17238

DPP isn't trigger for partitioned to partitioned join within a subquery

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsAdd voteVotersWatch issueWatchersConvert to IssueMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • Spark
    • None

    Description

      Queries such as:

      EXPLAIN SELECT count(*) FROM partitioned_table1 WHERE partitioned_table1.part_col IN (
      SELECT partitioned_table2.col FROM partitioned_table2 JOIN partitioned_table3 ON
      partitioned_table3.col = partitioned_table2.part_col AND partitioned_table2.col > 1);
      

      Don't seem to trigger DPP from pt2 to pt3.

      Attachments

        Activity

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

          People

            janulatha Janaki Lahorani Assign to me
            stakiar Sahil Takiar

            Dates

              Created:
              Updated:

              Slack

                Issue deployment