dosubot[bot] commented on issue #34700: URL: https://github.com/apache/superset/issues/34700#issuecomment-3188658477
<!-- Greeting --> Hi @NickTick92! I'm [Dosu](https://go.dosu.dev/dosubot) and I’m helping the superset team. <!-- Answer --> This issue happens because Superset 5.0.0 maps the Pinot engine to the MySQL dialect in its SQLGlot integration, which causes queries to be generated with MySQL-style syntax (like backticks and schema.table notation). Pinot doesn't support this syntax, so queries fail to run as expected. This mapping is hardcoded in Superset's code and there isn't a user-facing config or workaround to change the dialect mapping or quoting behavior for Pinot datasources in 5.0.0 [[source](https://github.com/apache/superset/blob/829e4d92d91ceae4b43b1ed3b063ffe45377799c/superset/sql/parse.py)]. There's nothing missing in your installation or configuration—this is a limitation in how Superset currently handles Pinot SQL dialects. Fixing it would require either a dedicated Pinot dialect in SQLGlot, a custom override in Superset's Pinot engine spec, or a change to the central dialect mapping in the codebase. For now, the only workaround is to manually edit queries before running them, or to track for future updates that address Pinot dialect support. <!-- Dosu Comment Footer --> *To reply, just mention [@dosu](https://go.dosu.dev/dosubot).* --- <sup>How did I do? [Good](https://app.dosu.dev/response-feedback/9e1d0d8a-8aec-4e10-95c7-2812f7d9f746?feedback_type=great_response) | [Irrelevant](https://app.dosu.dev/response-feedback/9e1d0d8a-8aec-4e10-95c7-2812f7d9f746?feedback_type=irrelevant_answer) | [Incorrect](https://app.dosu.dev/response-feedback/9e1d0d8a-8aec-4e10-95c7-2812f7d9f746?feedback_type=incorrect_sources) | [Verbose](https://app.dosu.dev/response-feedback/9e1d0d8a-8aec-4e10-95c7-2812f7d9f746?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/9e1d0d8a-8aec-4e10-95c7-2812f7d9f746?feedback_type=hallucination) | [Report 🐛](https://app.dosu.dev/response-feedback/9e1d0d8a-8aec-4e10-95c7-2812f7d9f746?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/9e1d0d8a-8aec-4e10-95c7-2812f7d9f746?feedback_type=other)</sup> [](https://app.dosu.dev/a28d3c7e-a9d3-459e-9fb6-3a6f9ff4f357/ask?utm_source=githu b) [](https://go.dosu.dev/discord-bot) [](https://twitter.com/intent/tweet?text=%40dosu_ai%20helped%20me%20solve%20this%20issue!&url=https%3A//github.com/apache/superset/issues/34700) -- 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]
