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

CommonJoinOperator optimize the case of 1:1 join

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • 0.7.0
    • None
    • None
    • Reviewed

    Description

      CommonJoinOperator.genObject() is expensive. It does a recursive and keeps lots of states because it has to:
      1. handle null cases for outer joins
      2. handle the case of duplicated keys from one join party
      We can do a minor optimization to detect a 1:1 join (which is quite common) before calling CommonJoinOperator.genObject() and forward columns in a simple for-loop if we are sure neither of 1 or 2 will happen.

      Attachments

        1. HIVE-1783.1.patch
          4 kB
          Siying Dong
        2. HIVE-1783.2.patch
          32 kB
          Siying Dong
        3. HIVE-1783.3.patch
          32 kB
          Siying Dong
        4. HIVE-1783.4.patch
          54 kB
          Siying Dong

        Activity

          People

            sdong Siying Dong
            sdong Siying Dong
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: