[
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: [email protected]
For additional commands, e-mail: [email protected]
