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

Wrong simplification in query with multiple IN clauses

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 3.2.0, 4.0.0-alpha-1
    • CBO
    • None

    Description

      Simple test to reproduce:

      select * from table1 where name IN(‘g’,‘r’) AND name IN(‘a’,‘b’);

      Attachments

        1. HIVE-21685.patch
          4 kB
          jcamachorodriguez
        2. HIVE-21685.patch
          4 kB
          jcamachorodriguez
        3. HIVE-21685.patch
          4 kB
          jcamachorodriguez
        4. HIVE-21685.patch
          4 kB
          jcamachorodriguez

        Issue Links

          is duplicated by

          Bug - A problem which impairs or prevents the functions of the product. HIVE-26209 HIVE CBO. Wrong results with Hive SQL query with MULTIPLE IN conditions in where clause if CBO enabled

          • Critical - Crashes, loss of data, severe memory leak.
          • Resolved

          Activity

            People

              jcamacho Jesús Camacho Rodríguez
              odraese Oliver Draese
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: