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/06/16 09:47:01 UTC
[GitHub] [superset] Stephane-Thales opened a new issue #15190: Trreemap don't show data on Clickhouse when filtered
Stephane-Thales opened a new issue #15190:
URL: https://github.com/apache/superset/issues/15190
When using the TreeMap object, with filter, there is 2 lines that are excluded.
### Expected results
Filter 1 value, show 1 square, filter 2 values, show 2, filter 3 show 3, filter 4 show 4 ....
### Actual results
Filter 1 value, show no data
filter 2 values, show no data
filter 3 show 1 square
filter 4 show 2 suare ....
#### How to reproduce the bug
1. With a clickhouse database connection, and a table
2. Create a TreeMap, using the defaut count(*) metrics, one text fields as Group By
3. Add a Filter on this Text Field, IN, and type one value (or few other for the above cases)
4. See that the data returned and the chart is not displaying the right information
Note, when cpy past the SQL generated in clickhouse directly, the right number of lines are returned.
### Environment
(please complete the following information):
Docker install with version 3.7 of the docker-compose-non-dev.yml (as 2021-06-16)
--
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] Stephane-Thales commented on issue #15190: Clickhouse queries return miss the first two rows
Posted by GitBox <gi...@apache.org>.
Stephane-Thales commented on issue #15190:
URL: https://github.com/apache/superset/issues/15190#issuecomment-863911504
It look like a SQLAchemy issue
`https://github.com/xzkostyan/clickhouse-sqlalchemy/issues/14`
Here a possible solution, using the +native driver, but I can't make it work. Need more investigation :
`https://github.com/xzkostyan/clickhouse-sqlalchemy/issues/84#issuecomment-596543932`
--
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] Stephane-Thales closed issue #15190: Clickhouse queries return miss the first two rows
Posted by GitBox <gi...@apache.org>.
Stephane-Thales closed issue #15190:
URL: https://github.com/apache/superset/issues/15190
--
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] Stephane-Thales edited a comment on issue #15190: Clickhouse queries return miss the first two rows
Posted by GitBox <gi...@apache.org>.
Stephane-Thales edited a comment on issue #15190:
URL: https://github.com/apache/superset/issues/15190#issuecomment-863911504
--
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