You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "piby180 (via GitHub)" <gi...@apache.org> on 2023/10/12 19:29:12 UTC
[I] Unable to use Multi Stage Engine for Apache Pinot on Superset [superset]
piby180 opened a new issue, #25627:
URL: https://github.com/apache/superset/issues/25627
I would like to enable multi stage engine for Apache Pinot on Superset. As per PinotDB [docs](https://github.com/python-pinot-dbapi/pinot-dbapi#using-sqlalchemy), it is possible to enable multi stage engine by providing connect args in create_engine method of SQLAlchemy
```
from sqlalchemy.engine import create_engine
engine = create_engine(
"pinot://localhost:8000/query/sql?controller=http://localhost:9000/",
connect_args={"useMultistageEngine": "true"}
)
```
I have tried adding connect_args to Engine Parameters in Superset UI but multistage engine is still not enabled.
#### How to reproduce the bug
1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error
### Expected results
Multi stage queries which run fine by using pinotdb in python directly should run in Superset as well
### Actual results
Multi stage queries does not run in Superset
#### Screenshots
Here is one example!
DISTINCT * syntax runs fine in Python with multistage enabled. It also runs fine in Pinot Query Console. It does not work in Superset.
### Environment
(please complete the following information):
- browser type and version:
- superset version: `3.0.0`
- python version: `python --version`
- node.js version: `node -v`
- any feature flags active:
pinotdb>=5.1.0
psycopg2-binary==2.9.9
### 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.
I have deployed Superset on EKS using Helm chart.
--
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] Unable to use Multi Stage Engine for Apache Pinot on Superset [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #25627: Unable to use Multi Stage Engine for Apache Pinot on Superset
URL: https://github.com/apache/superset/issues/25627
--
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] Unable to use Multi Stage Engine for Apache Pinot on Superset [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #25627:
URL: https://github.com/apache/superset/issues/25627#issuecomment-1996603833
Looks like this was fixed on the linked Issue, but this one was never closed. @piby180 do you think this is something that should be added to the [Pinot docs page](https://superset.apache.org/docs/databases/pinot/)? Please feel free to make an edit!
--
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