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 2021/01/26 10:04:02 UTC
[GitHub] [superset] dz902 opened a new issue #12765: Unable to connect to athena and unable to find detailed logs
dz902 opened a new issue #12765:
URL: https://github.com/apache/superset/issues/12765
Hi,
I followed official guide to use `docker-compose` to start superset.
I added "PyAthena>1.2.0" to `./docker/requirements-local.txt` and then `docker-compose up`, from the log PyAthena was installed correctly.
Then I access Superset, log in and add an database using connection string like `awsathena+rest://AKIAXXXX:XXXXXXXXXX@athena.us-east-1.amazonaws.com/AwsDataCatalog`, only to see:
```
HTTP 422
{
"message": "Unexpected error occurred, please check your logs for details"
}
```
Then I go to the console and only sees:
```
DEBUG:superset.models.core:Database.get_sqla_engine(). Masked URL: awsathena+rest://AKIAXXXX:XXXXXXXXXX@athena.us-east-1.amazonaws.com/AwsDataCatalog
DEBUG:superset.stats_logger:[stats_logger] (incr) DatabaseRestApi.test_connection.error
DEBUG:superset.stats_logger:[stats_logger] (timing) DatabaseRestApi.test_connection.time | 7.465301001502667
172.19.0.1 - - [26/Jan/2021 09:55:03] "POST /api/v1/database/test_connection HTTP/1.1" 422 -
INFO:werkzeug:172.19.0.1 - - [26/Jan/2021 09:55:03] "POST /api/v1/database/test_connection HTTP/1.1" 422 -
```
With no further info. No matter what I use for the connection string after `rest://` I get the same error.
I searched for a long time and was to no avail.
Is there a way to debug this situation? Thanks.
----------------------------------------------------------------
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.
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] dz902 closed issue #12765: Unable to connect to athena and unable to find detailed logs
Posted by GitBox <gi...@apache.org>.
dz902 closed issue #12765:
URL: https://github.com/apache/superset/issues/12765
----------------------------------------------------------------
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.
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] dz902 commented on issue #12765: Unable to connect to athena and unable to find detailed logs
Posted by GitBox <gi...@apache.org>.
dz902 commented on issue #12765:
URL: https://github.com/apache/superset/issues/12765#issuecomment-767469049
Just found that the appending of `?s3_staging_dir=s3://xxx` is required to make it work.
Still I think this could use a better error message. Not sure whether this is to be done by the connector or superset.
Closing now.
----------------------------------------------------------------
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.
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] junlincc commented on issue #12765: Unable to connect to athena and unable to find detailed logs
Posted by GitBox <gi...@apache.org>.
junlincc commented on issue #12765:
URL: https://github.com/apache/superset/issues/12765#issuecomment-767902200
@srinify
----------------------------------------------------------------
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.
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