adolitos opened a new issue, #20065: URL: https://github.com/apache/superset/issues/20065
Hi guys, I'm using Superset 1.4.0 from my Windows 10 I'm trying to create a chart using a small dataset from AWS Redshift  The yellow marked columns comes from tag_set struct column. I can reproduce the same query on Superset SQL Lab  I started getting errors when move to Chart step  Unexpected error Error: Spectrum nested query error DETAIL: ----------------------------------------------- error: Spectrum nested query error code: 8001 context: A subquery that refers to a nested table cannot contain ORDER BY clause. query: 0 location: nested_query_rewriter.cpp:775 process: padbmaster [pid=10014] ----------------------------------------------- I have changed the query, removing group by, order by and limit clauses... and It worked, but I'm affraid to face scenarios in future where I can get rid of this operations. Like using ctes, subqueries, jinja templates... Can you guys help me with that? Regards, André Santos -- 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]
