Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-47361 Improve JDBC data sources
  3. SPARK-47440

SQLServer does not support LIKE operator in binary comparison

Attach filesAttach ScreenshotVotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    Description

      When pushing Spark query to MsSqlServer engine we sometimes construct SQL query that has a LIKE operator as a part of the binary comparison operation, which is not permitted in SQL Server syntax. 

      For example a query 

      SELECT * FROM people WHERE (name LIKE "s%") = 1

      will not execute on MsSQLServer.

      These queries should be detected and not pushed to execution in MsSqlServer.

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            stefanbuk-db Stefan Bukorovic
            stefanbuk-db Stefan Bukorovic
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment