You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Supun De Silva (Jira)" <ji...@apache.org> on 2021/04/07 23:03:00 UTC
[jira] [Comment Edited] (SPARK-34928) CTE Execution fails for Sql
Server
[ https://issues.apache.org/jira/browse/SPARK-34928?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17314428#comment-17314428 ]
Supun De Silva edited comment on SPARK-34928 at 4/7/21, 11:02 PM:
------------------------------------------------------------------
[~hyukjin.kwon]
I added the driver information incase it becomes handy to isolate the issue. We have a similar setup for Oracle where CTEs execute with no issues but it (oracle connection) uses slightly different driver.
was (Author: supun.t.desilva):
[~hyukjin.kwon]
I added the driver information incase it becomes handy to isolate the issue. We have a similar setup for Oracle where CTEs ececute with no issues but it (oracle connection) uses slightly different driver.
> 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
> Priority: Minor
>
> 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* (version 1.3.1)
> 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 a simplified version with renamed parameters)
>
> {code:sql}
> WITH OldChanges as (
> SELECT distinct
> SomeDate,
> Name
> FROM [dbo].[DateNameFoo] (nolock)
> WHERE SomeDate!= '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-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org