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/08/30 15:00:56 UTC
[GitHub] [superset] piffall opened a new issue #16509: Error loading tables from Hive2/SparkSQL
piffall opened a new issue #16509:
URL: https://github.com/apache/superset/issues/16509
While adding a _dataset_ from Apache Spark SQL / Hive form incorrectly loads tables on **Add dataset** form. It affects to tables and views. The number of tables + number of views, the number of `default` on **Add dataset** select box (see screenshot).
In contrast, querying database using SQL Lab is working perfectly (see screenshot).
### Expected results
Add a dataset to Superset.
### Actual results
Cannot add the dataset to Superset. No errors or warnings in logs.
#### Screenshots
#### How to reproduce the bug
1. Add new database
2. Select Apache Spark SQL
3. Enter the SQLAlchemy URI: `hive://x.x.x.x:10000/default` (tested withoud db name also)
4. Click on Connect
5. Go to Datasets and add new dataset
6. Select the new connection
7. Select the Schema
8. Table select will be populated with `default` table names.
### Environment
Running the latest version of `docker-compose-non-dev.yaml`
--
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] piffall commented on issue #16509: Error loading tables from Hive2/SparkSQL
Posted by GitBox <gi...@apache.org>.
piffall commented on issue #16509:
URL: https://github.com/apache/superset/issues/16509#issuecomment-908998721
Thanks @danielewood , that worked for me!
--
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] PayneZx commented on issue #16509: Error loading tables from Hive2/SparkSQL
Posted by GitBox <gi...@apache.org>.
PayneZx commented on issue #16509:
URL: https://github.com/apache/superset/issues/16509#issuecomment-946630646
> This should be resolved with the changes I upstreamed to the impyla connector.
>
> try impala:// or ascend://
>
> Both use the impyla driver, the difference is the ascend connection string uses postgres date formats.
>
> `ascend://{username}:{password}@{hostname}:{port}/{database}?auth_mechanism=PLAIN;use_ssl=true`
I also used this method, but the `Databases` edit function cannot be used。
--
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] piffall commented on issue #16509: Error loading tables from Hive2/SparkSQL
Posted by GitBox <gi...@apache.org>.
piffall commented on issue #16509:
URL: https://github.com/apache/superset/issues/16509#issuecomment-908998721
Thanks @danielewood , that worked for me!
--
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] danielewood commented on issue #16509: Error loading tables from Hive2/SparkSQL
Posted by GitBox <gi...@apache.org>.
danielewood commented on issue #16509:
URL: https://github.com/apache/superset/issues/16509#issuecomment-908673029
This should be resolved with the changes I upstreamed to the impyla connector.
try impala:// or ascend://
Both use the impyla driver, the difference is the ascend connection string uses postgres date formats.
```ascend://{username}:{password}@{hostname}:{port}/{database}?auth_mechanism=PLAIN;use_ssl=true```
--
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] danielewood commented on issue #16509: Error loading tables from Hive2/SparkSQL
Posted by GitBox <gi...@apache.org>.
danielewood commented on issue #16509:
URL: https://github.com/apache/superset/issues/16509#issuecomment-908673029
This should be resolved with the changes I upstreamed to the impyla connector.
try impala:// or ascend://
Both use the impyla driver, the difference is the ascend connection string uses postgres date formats.
```ascend://{username}:{password}@{hostname}:{port}/{database}?auth_mechanism=PLAIN;use_ssl=true```
--
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