dosubot[bot] commented on issue #33075: URL: https://github.com/apache/superset/issues/33075#issuecomment-2791713926
<!-- Answer --> The error message "ODPS error: InstanceTunnel cannot be opened at a non-select SQL Task" suggests that the ODPS database does not support executing non-select SQL tasks using the "WITH AS SELECT" syntax. This could be due to limitations in the ODPS SQL dialect or the way Superset handles query execution contexts for ODPS databases. Unfortunately, specific details about how Superset manages ODPS connections or handles such queries are not available in the repository <sup>[[1]](https://github.com/apache/superset/blob/master/superset-frontend/packages/superset-ui-core/src/query/types/Query.ts)</sup><sup>[[2]](https://github.com/apache/superset/blob/master/superset/errors.py)</sup><sup>[[3]](https://github.com/apache/superset/blob/master/superset/db_engine_specs/presto.py)</sup><sup>[[4]](https://github.com/apache/superset/blob/master/superset-frontend/packages/superset-ui-core/src/query/getClientErrorObject.ts)</sup>. To address this issue, you might consider checking the ODPS documentation for any restrictions on SQL syntax or exploring alternative query structures that are compatible with ODPS. Additionally, reviewing Superset's configuration settings related to ODPS might provide insights into any adjustments needed for successful query execution. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/13df1a97-ab45-4ff8-ab9c-8296912e05a7?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/13df1a97-ab45-4ff8-ab9c-8296912e05a7?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/13df1a97-ab45-4ff8-ab9c-8296912e05a7?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/13df1a97-ab45-4ff8-ab9c-8296912e05a7?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/13df1a97-ab45-4ff8-ab9c-8296912e05a7?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/13df1a97-ab45-4ff8-ab9c-8296912e05a7?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/13df1a97-ab45-4ff8-ab9c-8296912e05a7?feedback_type=other)</sup> -- 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]
