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/12 12:22:41 UTC
[GitHub] [superset] george-zubrienko opened a new issue, #20043: Deprecated trino library causing issues with Chart Explore
george-zubrienko opened a new issue, #20043:
URL: https://github.com/apache/superset/issues/20043
A clear and concise description of what the bug is.
#### How to reproduce the bug
0. Create any chart using Trino data source and place it on a dashboard.
0a. Install `trino==0.313.0` instead of `sqlalchemy-trino` (deprecated) in superset image. Check that trino queries still work as expected.
1. Go to that dashboard
2. Click on three dots on the chart widget to open up chart actions
3. Click `View chart in Explore`
4. See `An error occurred while opening Explore`
### Expected results
Chart opens in Explore.
### Actual results
Chart does not open and superset node prints:
```
Unable to load SQLAlchemy dialect <class 'pydruid.db.sqlalchemy.DruidHTTPSDialect'>: No module named 'sqlalchemy_trino'
2022-05-12 12:19:30,808:WARNING:superset.db_engine_specs:Unable to load SQLAlchemy dialect <class 'pydruid.db.sqlalchemy.DruidHTTPSDialect'>: No module named 'sqlalchemy_trino'
```
### Environment
- browser type and version: Chrome Version 101.0.4951.54 (Official Build) (64-bit)
- superset version: 1.5.0 (dockerhub image) via helm 0.6.1
- python version: `python --version`
```
superset@superset-6c55865fd6-vtv7k:/app$ python --version
Python 3.8.12
```
- node.js version: `node -v`: N/A
- any feature flags active:
```
FEATURE_FLAGS = {
'ENABLE_TEMPLATE_PROCESSING': True
}
```
and
```
SQL_VALIDATORS_BY_ENGINE = {
'presto': 'PrestoDBSQLValidator'
}
```
### 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.
--
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] kristysiu-finn commented on issue #20043: Deprecated trino library throwing errors in pydruid
Posted by GitBox <gi...@apache.org>.
kristysiu-finn commented on issue #20043:
URL: https://github.com/apache/superset/issues/20043#issuecomment-1162644921
I see the same Chart Explore bug in 1.5.1:
> 1. Go to that dashboard
> 2. Click on three dots on the chart widget to open up chart actions
> 3. Click View chart in Explore
> 4. See An error occurred while opening Explore
same with copy chart permalink.
The error I see on the frontend console is that the POST request returns a 403:
--
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 #20043: Deprecated trino library throwing errors in pydruid
Posted by GitBox <gi...@apache.org>.
rusackas commented on issue #20043:
URL: https://github.com/apache/superset/issues/20043#issuecomment-1125490944
Pinging @betodealmeida and @john-bodley in case either of you know a particularly elegant solution to this.
--
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] musicmuthu commented on issue #20043: Deprecated trino library throwing errors in pydruid
Posted by GitBox <gi...@apache.org>.
musicmuthu commented on issue #20043:
URL: https://github.com/apache/superset/issues/20043#issuecomment-1143516382
same issue i pick the latest image 01-06-2022
--
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] Deprecated trino library throwing errors in pydruid [superset]
Posted by "sfirke (via GitHub)" <gi...@apache.org>.
sfirke closed issue #20043: Deprecated trino library throwing errors in pydruid
URL: https://github.com/apache/superset/issues/20043
--
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] Deprecated trino library throwing errors in pydruid [superset]
Posted by "musicmuthu (via GitHub)" <gi...@apache.org>.
musicmuthu commented on issue #20043:
URL: https://github.com/apache/superset/issues/20043#issuecomment-2093485370
i have the same issue now in 3.1.1
Unable to load SQLAlchemy dialect <class 'pydruid.db.sqlalchemy.DruidHTTPSDialect'>: No module named 'google'
2024-04-30 14:57:22,628:WARNING:superset.db_engine_specs:Unable to load SQLAlchemy dialect <class 'pydruid.db.sqlalchemy.DruidHTTPSDialect'>: No module named 'google
my additional bootstrap:
bootstrapScript: |
#!/bin/bash
rm -rf /var/lib/apt/lists/* && \
pip install authlib==1.0.1 \
psycopg2==2.8.5 elasticsearch-dbapi==0.2.9 trino==0.321.0 cx_Oracle==8.3.0 gevent && \
if [ ! -f ~/bootstrap ]; then echo "Running Superset with uid 0" > ~/bootstrap; fi
--
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] Deprecated trino library throwing errors in pydruid [superset]
Posted by "sfirke (via GitHub)" <gi...@apache.org>.
sfirke commented on issue #20043:
URL: https://github.com/apache/superset/issues/20043#issuecomment-1936461566
I just reviewed a chunk of application logs from today and am not seeing this message anymore (running 3.0.1). That part, at least, seems to be addressed. I'll close this issue, if anyone is experiencing this problem in version >=3.0.3 of Superset please report with a new bug report and link back to this one.
--
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] Deprecated trino library throwing errors in pydruid [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #20043:
URL: https://github.com/apache/superset/issues/20043#issuecomment-1936451415
Are people still seeing this in Superset 3.0/3.1? This thread has been quiet for an awfully long time.
--
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] george-zubrienko commented on issue #20043: Deprecated trino library throwing errors in pydruid
Posted by GitBox <gi...@apache.org>.
george-zubrienko commented on issue #20043:
URL: https://github.com/apache/superset/issues/20043#issuecomment-1124965239
We did a bit of a digging here and this doesn't seem to be related to Chart Explore bug. However, still leaving the issue open as we have to keep legacy sqlalchemy-trino in superset image to get rid of this pydruid warning.
Renamed the issue and updated issue description. Sorry for the mess :(
--
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] alldoami commented on issue #20043: Deprecated trino library throwing errors in pydruid
Posted by GitBox <gi...@apache.org>.
alldoami commented on issue #20043:
URL: https://github.com/apache/superset/issues/20043#issuecomment-1175304829
I'm also seeing this error:
```
superset 2022-07-05 17:11:38,020:WARNING:superset.db_engine_specs:Unable to load dialect <class 'sqlalchemy.dialects.mssql.adodbapi.MSDialect_adodbapi'>: type object 'MSDialect_adodbapi' has no │
│ attribute 'dbapi' │
│ superset 2022-07-05 17:11:38,043:WARNING:superset.db_engine_specs:Unable to load SQLAlchemy dialect <class 'pydruid.db.sqlalchemy.DruidHTTPSDialect'>: No module named 'sqlalchemy_trino' │
│ s
```
--
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] sfirke commented on issue #20043: Deprecated trino library throwing errors in pydruid
Posted by GitBox <gi...@apache.org>.
sfirke commented on issue #20043:
URL: https://github.com/apache/superset/issues/20043#issuecomment-1190358969
I see a similar warning message in my Superset logs, even though I don't use Druid or Trino at all. Doesn't seem to be affecting the actual performance of my Superset instance but mitigating this would clean up the logs. Superset v1.5.1.
--
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