fowlerp397-tech commented on issue #38650: URL: https://github.com/apache/superset/issues/38650#issuecomment-4073760754
Any updates on this On Sat, Mar 14, 2026, 8:55 AM dosubot[bot] ***@***.***> wrote: > *dosubot[bot]* left a comment (apache/superset#38650) > <https://github.com/apache/superset/issues/38650#issuecomment-4060590098> > > This is a known limitation with how Superset processes SQL queries > differently between SQL Lab and charts. > > *Why it happens:* When creating charts, Superset wraps queries in > subqueries to apply limits and other transformations. SQL Server's OPTION > clauses must appear at the end of the *outermost* query, so when your > query gets wrapped, the OPTION (MAXDOP 1) ends up inside a subquery where > it's syntactically invalid. > > This is part of a broader pattern affecting T-SQL features > <https://github.com/apache/superset/issues/31913> since Superset adopted > sqlglot for SQL parsing in 4.1.0+. > > *Workarounds:* > > 1. *Create a database view* - Encapsulate your query with the OPTION > hint in a SQL Server view, then query that view from Superset charts > 2. *Set MAXDOP at the database level* - Configure query governor > settings in SQL Server itself rather than per-query hints > 3. *Use SQL Lab for reporting* - If you don't need the chart > visualization, SQL Lab can execute the query directly > > *To reply, just mention @dosu > <https://go.dosu.dev/dosubot?utm_source=github&utm_medium=bot-comment&utm_campaign=github-assistant&utm_content=brand-link>.* > ------------------------------ > > How did I do? Good > <https://app.dosu.dev/response-feedback/450659a3-0abf-4a4c-b25c-69c4a9fcd940?feedback_type=great_response&utm_source=github&utm_medium=bot-comment&utm_campaign=github-assistant&utm_content=feedback-great_response> > | Irrelevant > <https://app.dosu.dev/response-feedback/450659a3-0abf-4a4c-b25c-69c4a9fcd940?feedback_type=irrelevant_answer&utm_source=github&utm_medium=bot-comment&utm_campaign=github-assistant&utm_content=feedback-irrelevant_answer> > | Incorrect > <https://app.dosu.dev/response-feedback/450659a3-0abf-4a4c-b25c-69c4a9fcd940?feedback_type=incorrect_sources&utm_source=github&utm_medium=bot-comment&utm_campaign=github-assistant&utm_content=feedback-incorrect_sources> > | Verbose > <https://app.dosu.dev/response-feedback/450659a3-0abf-4a4c-b25c-69c4a9fcd940?feedback_type=too_verbose&utm_source=github&utm_medium=bot-comment&utm_campaign=github-assistant&utm_content=feedback-too_verbose> > | Hallucination > <https://app.dosu.dev/response-feedback/450659a3-0abf-4a4c-b25c-69c4a9fcd940?feedback_type=hallucination&utm_source=github&utm_medium=bot-comment&utm_campaign=github-assistant&utm_content=feedback-hallucination> > | Report 🐛 > <https://app.dosu.dev/response-feedback/450659a3-0abf-4a4c-b25c-69c4a9fcd940?feedback_type=bug_report&utm_source=github&utm_medium=bot-comment&utm_campaign=github-assistant&utm_content=feedback-bug_report> > | Other > <https://app.dosu.dev/response-feedback/450659a3-0abf-4a4c-b25c-69c4a9fcd940?feedback_type=other&utm_source=github&utm_medium=bot-comment&utm_campaign=github-assistant&utm_content=feedback-other> > > [image: Chat with Dosu] > <https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=github&utm_medium=bot-comment&utm_campaign=github-assistant&utm_content=chat-badge> > [image: Open in Cursor] > <https://cursor.com/link/prompt?text=This%20is%20a%20known%20limitation%20with%20how%20Superset%20processes%20SQL%20queries%20differently%20between%20SQL%20Lab%20and%20charts.%0A%0A%2A%2AWhy%20it%20happens%3A%2A%2A%20When%20creating%20charts%2C%20Superset%20wraps%20queries%20in%20subqueries%20to%20apply%20limits%20and%20other%20transformations.%20SQL%20Server%27s%20%60OPTION%60%20clauses%20must%20appear%20at%20the%20end%20of%20the%20%2Aoutermost%2A%20query%2C%20so%20when%20your%20query%20gets%20wrapped%2C%20the%20%60OPTION%20%28MAXDOP%201%29%60%20ends%20up%20inside%20a%20subquery%20where%20it%27s%20syntactically%20invalid.%0A%0AThis%20is%20part%20of%20a%20%5Bbroader%20pattern%20affecting%20T-SQL%20features%5D%28https%3A//github.com/apache/superset/issues/31913%29%20since%20Superset%20adopted%20sqlglot%20for%20SQL%20parsing%20in%204.1.0%2B.%0A%0A%2A%2AWorkarounds%3A%2A%2A%0A1.%20%2A%2ACreate%20a%20database%20view%2A%2A%20-%20Encapsulate%20your%20query%20with%20the%20OPTION%20hint %20in%20a%20SQL%20Server%20view%2C%20then%20query%20that%20view%20from%20Superset%20charts%0A2.%20%2A%2ASet%20MAXDOP%20at%20the%20database%20level%2A%2A%20-%20Configure%20query%20governor%20settings%20in%20SQL%20Server%20itself%20rather%20than%20per-query%20hints%0A3.%20%2A%2AUse%20SQL%20Lab%20for%20reporting%2A%2A%20-%20If%20you%20don%27t%20need%20the%20chart%20visualization%2C%20SQL%20Lab%20can%20execute%20the%20query%20directly> > [image: Join Discord] > <https://go.dosu.dev/discord-bot?utm_source=github&utm_medium=bot-comment&utm_campaign=github-assistant&utm_content=join-discord> > [image: Share on X] > <https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/38650> > > — > Reply to this email directly, view it on GitHub > <https://github.com/apache/superset/issues/38650#issuecomment-4060590098>, > or unsubscribe > <https://github.com/notifications/unsubscribe-auth/B72HASIDHZ6AQEU4NI7W37D4QVQE5AVCNFSM6AAAAACWR4XUDSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHM2DANRQGU4TAMBZHA> > . > You are receiving this because you are subscribed to this thread.Message > ID: ***@***.***> > -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
