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

Optimize: Transform IN clauses to = when there's only one element

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 3.0.0
    • 3.0.0
    • Logical Optimizer
    • None

    Description

      (col1) IN (col2) can be transformed to (col1) = (col2), to avoid the hash-set implementation.

      Attachments

        1. HIVE-18713.4.patch
          58 kB
          Gopal Vijayaraghavan
        2. HIVE-18713.3.patch
          41 kB
          Gopal Vijayaraghavan
        3. HIVE-18713.2.patch
          13 kB
          Gopal Vijayaraghavan
        4. HIVE-18713.1.patch
          1 kB
          Gopal Vijayaraghavan

        Activity

          People

            gopalv Gopal Vijayaraghavan
            gopalv Gopal Vijayaraghavan
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: