dosubot[bot] commented on issue #31768: URL: https://github.com/apache/superset/issues/31768#issuecomment-2580713014
<!-- Greeting --> Hey @JustGui! I'm here to help you with the Trino function issue you're experiencing. I can assist with bug fixes, answer questions, and guide you on becoming a contributor. Let's dive into the details and work on resolving the issue together. <!-- Answer --> The issues you're experiencing with Trino queries using functions like `JSON_QUERY` in Superset version 4.1.0 and later could be related to changes in how SQL parsing and query execution are handled in these versions. There have been several updates and fixes related to SQL parsing, including handling Jinja templating and partition extraction, which might affect how certain queries are processed <sup>[[1]](https://github.com/apache/superset/blob/master/CHANGELOG/4.1.0.md)</sup>. The "Allow DDL and DML" setting in SQL Lab is specifically for enabling or disabling Data Definition Language (DDL) and Data Manipulation Language (DML) operations within SQL Lab. This setting does not affect chart visualizations, which is why enabling it resolves the issue in SQL Lab but not in charts. The error messages you're encountering, such as "DB engine Error" and "Unexpected error: Error parsing near 'OMIT'", suggest that there might be specific parsing or execution logic changes affecting JSON functions in newer versions. Unfortunately, I couldn't find specific documentation on changes to JSON function handling in Trino queries for these versions. To address these issues, you might consider: 1. Reviewing the SQL parsing changes in the Superset changelog for any relevant updates. 2. Testing the queries with different configurations or syntax adjustments to see if they bypass the parsing errors. 3. Checking if there are any updates or patches available for the version you are using that address these specific issues. <!-- 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/061d5d88-4759-4492-8729-17f74c0eafe4?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/061d5d88-4759-4492-8729-17f74c0eafe4?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/061d5d88-4759-4492-8729-17f74c0eafe4?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/061d5d88-4759-4492-8729-17f74c0eafe4?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/061d5d88-4759-4492-8729-17f74c0eafe4?feedback_type=hallucination) | [Other](https://app.dosu.dev/response-feedback/061d5d88-4759-4492-8729-17f74c0eafe4?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]
