Supun De Silva created SPARK-34928:
--------------------------------------
Summary: CTE Execution fails for Sql Server
Key: SPARK-34928
URL: https://issues.apache.org/jira/browse/SPARK-34928
Project: Spark
Issue Type: Bug
Components: Spark Core
Affects Versions: 3.0.1
Reporter: Supun De Silva
h2. Issue
We have a simple Sql statement that we intend to execute on SQL Server. This
has a CTE component.
Execution of this yields to an error that looks like follows
{code:java}
java.sql.SQLException: Incorrect syntax near the keyword 'WITH'.{code}
We are using the jdbc driver *net.sourceforge.jtds.jdbc.Driver*
This is a particularly annoying issue and due to this we are having to write
inner queries that are fair bit inefficient.
h2. SQL statement
(not the actual one but simplified renamed parameters)
{code:sql}
WITH OldChanges as (
SELECT distinct
Date,
Name
FROM [dbo].[DateNameFoo] (nolock)
WHERE Date != '2021-03-30'
AND convert(date, UpdateDateTime) = '2021-03-31'
SELECT * from OldChanges {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
