You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "zhaorui2022 (via GitHub)" <gi...@apache.org> on 2023/08/31 21:30:24 UTC
[GitHub] [superset] zhaorui2022 opened a new issue, #25155: Custom SQL with sub queries no longer works
zhaorui2022 opened a new issue, #25155:
URL: https://github.com/apache/superset/issues/25155
We have some charts with sub queries in custom SQL. It was working in 2.0.0, but not in 3.0.0rc3. Not completely sure if it is expected behavior or a regression. We are using Presto as backend.
#### How to reproduce the bug
1. Create a chart, and in the custom SQL filter, use a sub query
2. Refresh the page and see error
### Expected results
Chart renders as expected as in 2.0.0
### Actual results
Chart fails to render
#### Screenshots
In 3.0.0rc3
In 2.0.0
### Environment
(please complete the following information):
- browser type and version: Chrome latest stable version
- superset version: `superset version` 3.0.0rc3
- python version: `python --version` 3.9
- node.js version: `node -v`
- any feature flags active: I don't find any related feature flag
### Checklist
Make sure to follow these steps before submitting your issue - thank you!
- [x] I have checked the superset logs for python stacktraces and included it here as text if there are any.
- [x] I have reproduced the issue with at least the latest released version of superset.
- [x] I have checked the issue tracker for the same issue and I haven't found one similar.
### Additional context
Add any other context about the problem here.
--
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
[GitHub] [superset] michael-s-molina closed issue #25155: Custom SQL with sub queries no longer works
Posted by "michael-s-molina (via GitHub)" <gi...@apache.org>.
michael-s-molina closed issue #25155: Custom SQL with sub queries no longer works
URL: https://github.com/apache/superset/issues/25155
--
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] michael-s-molina commented on issue #25155: Custom SQL with sub queries no longer works
Posted by "michael-s-molina (via GitHub)" <gi...@apache.org>.
michael-s-molina commented on issue #25155:
URL: https://github.com/apache/superset/issues/25155#issuecomment-1702689020
I submitted https://github.com/apache/superset/pull/25161 to include a note in `UPDATING.md` about that change.
--
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] michael-s-molina commented on issue #25155: Custom SQL with sub queries no longer works
Posted by "michael-s-molina (via GitHub)" <gi...@apache.org>.
michael-s-molina commented on issue #25155:
URL: https://github.com/apache/superset/issues/25155#issuecomment-1702690275
@zhaorui2022 Closing this as I believe the feature flag configuration will resolve your problem. Feel free to reopen the issue if that's not the case.
--
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] michael-s-molina commented on issue #25155: Custom SQL with sub queries no longer works
Posted by "michael-s-molina (via GitHub)" <gi...@apache.org>.
michael-s-molina commented on issue #25155:
URL: https://github.com/apache/superset/issues/25155#issuecomment-1702627064
Hi @zhaorui2022. Does setting `ALLOW_ADHOC_SUBQUERY = True` resolves this issue? It's `False` by default.
--
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