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

Invalid splitting of nested AND expressions in Data Source filter API

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 1.5.2
    • Fix Version/s: 1.5.3, 1.6.0, 2.0.0
    • Component/s: SQL
    • Labels:
      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

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

              Dates

              • Created:
                Updated:
                Resolved: