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/09/13 07:40:01 UTC
[GitHub] [superset] gaetansnl opened a new issue #16681: can't create clickhouse dataset
gaetansnl opened a new issue #16681:
URL: https://github.com/apache/superset/issues/16681
### Expected results
Connecting to a clickhouse database from clickhouse tutorial
### Actual results
I can't create a dataset
![image](https://user-images.githubusercontent.com/8348807/133041822-6e5dd2e1-d76f-43e1-9b50-144a2b5d180a.png)
#### How to reproduce the bug
Start superset
```
FROM apache/superset
USER root
RUN pip install clickhouse-driver
RUN pip install clickhouse-sqlalchemy
USER superset
```
Follow this tutorial to setup the database https://clickhouse.tech/docs/en/operations/performance-test/
### 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.
```
2021-09-13 07:38:00,322:DEBUG:clickhouse_driver.connection:Connecting. Database: default. User: default
2021-09-13 07:38:00,322:DEBUG:clickhouse_driver.connection:Connecting to localhost:9000
2021-09-13 07:38:00,323:DEBUG:clickhouse_driver.connection:Connected to ClickHouse server version 21.10.1, revision: 54449
2021-09-13 07:38:00,323:DEBUG:clickhouse_driver.connection:Query: select version()
2021-09-13 07:38:00,324:DEBUG:clickhouse_driver.connection:Block "" send time: 0.000036
2021-09-13 07:38:00,326:DEBUG:clickhouse_driver.connection:Connecting. Database: default. User: default
2021-09-13 07:38:00,326:DEBUG:clickhouse_driver.connection:Connecting to localhost:9000
2021-09-13 07:38:00,327:DEBUG:clickhouse_driver.connection:Connected to ClickHouse server version 21.10.1, revision: 54449
2021-09-13 07:38:00,328:DEBUG:clickhouse_driver.connection:Query: DESCRIBE TABLE default.hits_100m_obfuscated
2021-09-13 07:38:00,328:DEBUG:clickhouse_driver.connection:Block "" send time: 0.000036
2021-09-13 07:38:00,342:DEBUG:clickhouse_driver.connection:Connecting. Database: default. User: default
2021-09-13 07:38:00,342:DEBUG:clickhouse_driver.connection:Connecting to localhost:9000
2021-09-13 07:38:00,343:DEBUG:clickhouse_driver.connection:Connected to ClickHouse server version 21.10.1, revision: 54449
2021-09-13 07:38:00,343:DEBUG:clickhouse_driver.connection:Query: SELECT name, engine_full, engine, partition_key, sorting_key, primary_key, sampling_key FROM system.tables WHERE database = 'default'
2021-09-13 07:38:00,344:DEBUG:clickhouse_driver.connection:Block "" send time: 0.000037
Got an error Element [<sqlalchemy.sql.elements.TextClause object at 0x7ff7608c3810>] is not a string name or column element validating table: hits_100m_obfuscated
2021-09-13 07:38:00,350:WARNING:superset.datasets.dao:Got an error Element [<sqlalchemy.sql.elements.TextClause object at 0x7ff7608c3810>] is not a string name or column element validating table: hits_100m_obfuscated
```
--
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] junlincc closed issue #16681: can't create clickhouse dataset
Posted by GitBox <gi...@apache.org>.
junlincc closed issue #16681:
URL: https://github.com/apache/superset/issues/16681
--
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