GitHub user dosubot[bot] added a comment to the discussion: Sunburst chart remove row from case-when query results
<!-- Answer --> The error message "Custom SQL fields cannot contain sub-queries" suggests that your SQL query might be interpreted as containing a sub-query, which is not allowed in custom SQL fields unless the feature flag "ALLOW_ADHOC_SUBQUERY" is enabled <sup>[[1]](https://github.com/apache/superset/blob/master/superset/translations/de/LC_MESSAGES/messages.po)</sup>. To resolve this, ensure that your SQL query does not include any sub-queries. The query I provided earlier should not contain sub-queries, so the error might be due to another part of your setup. Double-check your query to ensure it matches the structure provided, and verify that there are no additional sub-queries elsewhere in your configuration. If the issue persists, consider checking if the feature flag "ALLOW_ADHOC_SUBQUERY" is enabled in your Superset configuration. <!-- 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/36955d05-7819-45a8-a36e-08188d121044?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/36955d05-7819-45a8-a36e-08188d121044?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/36955d05-7819-45a8-a36e-08188d121044?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/36955d05-7819-45a8-a36e-08188d121044?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/36955d05-7819-45a8-a36e-08188d121044?feedback_type=hallucination) | [Bug Report](https://app.dosu.dev/response-feedback/36955d05-7819-45a8-a36e-08188d121044?feedback_type=bug_report) | [Other](https://app.dosu.dev/response-feedback/36955d05-7819-45a8-a36e-08188d121044?feedback_type=other)</sup> GitHub link: https://github.com/apache/superset/discussions/32895#discussioncomment-12650974 ---- This is an automatically sent email for notifications@superset.apache.org. To unsubscribe, please send an email to: notifications-unsubscr...@superset.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: notifications-unsubscr...@superset.apache.org For additional commands, e-mail: notifications-h...@superset.apache.org
