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

Remove semijoin optimization if the tables involved have PK-FK relationship

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None
    • None

    Description

      If a semijoin optimization is created on tables which have PK-FK relationship on join keys(e.g. customer-order ) then the reduction will not take place.
      Remove the optimization in such cases.

      Attachments

        Activity

          People

            djaiswal Deepak Jaiswal
            djaiswal Deepak Jaiswal
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: