[SPARK-32825] CTE support on MSSQL

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Invalid
• Affects Version/s: 2.4.6
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Ankit Sinha
• Created: 08/Sep/20 17:56
• Updated: 10/Sep/20 02:45
• Resolved: 10/Sep/20 02:45

Description

The issue in detail along with stack trace is described over here. 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.