superset: [Question]Receive inconsistent query results when connected to Clickhouse(?)
Using the same Clickhouse database and the same SQL statement, the results obtained by superset and idea are inconsistent; Specifically, superset should only query some data, but I don’t know why
Expected results
When I used the pie chart to visualize the data in a Clickhouse database, I found this problem. The queried data was incorrect. To be exact, I only got some data, but I didn’t make any settings. I felt that there was a problem somewhere
Screenshots
Environment
(please complete the following information):
- superset version:
docker pull apache/superset:master - python version:
python --version 3.8
Checklist
Make sure to follow these steps before submitting your issue - thank you!
- I have checked the superset logs for python stacktraces and included it here as text if there are any.
- I have reproduced the issue with at least the latest released version of superset.
- I have checked the issue tracker for the same issue and I haven’t found one similar.
About this issue
- Original URL
- State: closed
- Created 3 years ago
- Comments: 15 (4 by maintainers)
Is it only happening in clickhouse data? What’s the expected results from your query? the ones showing in the spreadsheet screenshot? both results from Explore and SQL lab are incorrect? can you double check if any filters, same as in superset was added to your query in excel?
@zhaoyongjie please follow up in the issue, if it’s validated by the users with more info come back, let me know.