You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by GitBox <gi...@apache.org> on 2022/05/13 20:15:13 UTC
[GitHub] [superset] adolitos opened a new issue, #20065: Chart Error- Querying AWS Redshift Spectrum nested tables with Superset
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: notifications-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Chart Error- Querying AWS Redshift Spectrum nested tables with Superset [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #20065:
URL: https://github.com/apache/superset/issues/20065#issuecomment-1930703766
Closing this as stale since it's been silent for so long, and we're trying to steer toward a more actionable Issues backlog. If people are still encountering this in current versions (currently 3.x) please open a new Issue or a PR to address the problem.
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] Chart Error- Querying AWS Redshift Spectrum nested tables with Superset [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #20065: Chart Error- Querying AWS Redshift Spectrum nested tables with Superset
URL: https://github.com/apache/superset/issues/20065
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] rusackas commented on issue #20065: Chart Error- Querying AWS Redshift Spectrum nested tables with Superset
Posted by GitBox <gi...@apache.org>.
rusackas commented on issue #20065:
URL: https://github.com/apache/superset/issues/20065#issuecomment-1130120661
My initial hunch here is that this is a peculiarity of how Redshift (Spectrum) works. But I'm not sure. I'm asking around to see if I can find someone who knows that DB ¯\\\_(ツ)_/¯
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] betodealmeida commented on issue #20065: Chart Error- Querying AWS Redshift Spectrum nested tables with Superset
Posted by GitBox <gi...@apache.org>.
betodealmeida commented on issue #20065:
URL: https://github.com/apache/superset/issues/20065#issuecomment-1130242056
@adolitos can you share the query that is produced in the 3rd screenshot? You can get it by clicking the hamburger menu (☰) in the top right.
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] serelk commented on issue #20065: Chart Error- Querying AWS Redshift Spectrum nested tables with Superset
Posted by GitBox <gi...@apache.org>.
serelk commented on issue #20065:
URL: https://github.com/apache/superset/issues/20065#issuecomment-1135611618
have similar issue
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] rusackas commented on issue #20065: Chart Error- Querying AWS Redshift Spectrum nested tables with Superset
Posted by GitBox <gi...@apache.org>.
rusackas commented on issue #20065:
URL: https://github.com/apache/superset/issues/20065#issuecomment-1135958533
> have similar issue
Can you share any details, queries, or steps to reproduce the issue?
--
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: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org