sujiplr commented on issue #31913: URL: https://github.com/apache/superset/issues/31913#issuecomment-2623931199
@huafist , is there any specific reason why you are using the declare statement. As you mentioned the TOP command will cause issues, since you are using a declarative TSQL rather than a SQL statement. The requirement is looks like you are building certain intermediate dataset (as temp tables ) and wanted to use that in the final SQL statement for the chart data. This use case won't work with Superset Charts. You can make use of the CTE statements for this as an alternative. -- 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]
