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

Support null filter within or clause for Anti Join

    XMLWordPrintableJSON

Details

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

    Description

      The current anti join conversion does not check for null filters on right side of join if it's within OR conditions. Only those filters separated by AND conditions are supported. For example queries like "select t1.fld from tbl1 t1 left join tbl2 t2 on t1.fld = t2.fld where t2.fld is null or t2.fld1 is null" are not converted to anti join. 

      Attachments

        Issue Links

          Activity

            People

              maheshk114 mahesh kumar behera
              maheshk114 mahesh kumar behera
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated: