Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-12218

Invalid splitting of nested AND expressions in Data Source filter API

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Blocker
    • Resolution: Fixed
    • 1.5.2
    • 1.5.3, 1.6.0, 2.0.0
    • SQL
    • None

    Description

      Two identical queries produce different results

      In [2]: sqlContext.read.parquet('prp_enh1').where(" LoanID=62231 and not( PaymentsReceived=0 and ExplicitRoll in ('PreviouslyPaidOff', 'PreviouslyChargedOff'))").count()

      Out[2]: 18

      In [3]: sqlContext.read.parquet('prp_enh1').where(" LoanID=62231 and ( not(PaymentsReceived=0) or not (ExplicitRoll in ('PreviouslyPaidOff', 'PreviouslyChargedOff')))").count()
      Out[3]: 28

      Attachments

        Activity

          People

            yhuai Yin Huai
            imachabeli Irakli Machabeli
            Votes:
            0 Vote for this issue
            Watchers:
            10 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: