You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@spark.apache.org by "L. C. Hsieh (Jira)" <ji...@apache.org> on 2020/09/09 21:50:00 UTC

[jira] [Commented] (SPARK-32825) CTE support on MSSQL

    [ https://issues.apache.org/jira/browse/SPARK-32825?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17193200#comment-17193200 ] 

L. C. Hsieh commented on SPARK-32825:
-------------------------------------

The user provided query should be a query that could be put in the FROM clause: https://spark.apache.org/docs/latest/sql-data-sources-jdbc.html

Currently this is a restriction on the option, not a bug.

> CTE support on MSSQL
> --------------------
>
>                 Key: SPARK-32825
>                 URL: https://issues.apache.org/jira/browse/SPARK-32825
>             Project: Spark
>          Issue Type: Bug
>          Components: Spark Core
>    Affects Versions: 2.4.6
>            Reporter: Ankit Sinha
>            Priority: Major
>
> The issue in detail along with stack trace is described over [here|https://github.com/microsoft/mssql-jdbc/issues/1340]. Summary is that WITH CTE clause does not work with MSSQL. This may be because WITH CTE is not supported in FROM clause of MSSQL.



--
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