JustGui commented on issue #31768: URL: https://github.com/apache/superset/issues/31768#issuecomment-2615403771
@betodealmeida I've seen that a new version of sqlglot with a fix has been released, so I tried installing it and run Superset with it I no longer have an issue with the OMIT but I have a new one <img width="444" alt="Image" src="https://github.com/user-attachments/assets/e0c698c0-d1dd-41d6-8f02-b1b6c5b3a3ec"; /> Here is my query: ```JSON_QUERY(aggregatedJSON, 'lax $.serialnumber[*].value' WITH ARRAY WRAPPER)``` Seems like sqlglot doesn't know how to handle WITH and WITHOUT in a JSON_QUERY Do you replicate ? -- 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]
