[GitHub] [superset] zhaoyongjie commented on issue #17073: The results returned by the superset and clickhouse clients are different, and the client is correct

[GitBox <gi...@apache.org>]

zhaoyongjie commented on issue #17073:
URL: https://github.com/apache/superset/issues/17073#issuecomment-941834516


   > superset 1.3.0 jdbc:clickhouse-driver==0.2.0 clickhouse-sqlalchemy==0.1.6 A clear and concise description of what the bug is.
   > 
   > I have two fields 'pid' and 'eid'
   > 
   > 1.group by pid & eid,I got data like this（Part of the data） ![image](https://user-images.githubusercontent.com/31892927/136934599-14c5f294-e79b-4838-abed-92e768860c89.png)
   > 
   > 2.add fliter 'pid in 6909' then run the query ,I got data like this, only one row , but I should get at least two rows for eid = '302' or '304'
   > 
   > ![image](https://user-images.githubusercontent.com/31892927/136947927-ca5d63ea-e87a-49e7-89e0-c5f3e4939076.png)
   > 
   > ![image](https://user-images.githubusercontent.com/31892927/136934985-4ce7caed-3174-43a8-bcec-d39a7688a9aa.png)
   > 
   > 3.view query and run it in client ![image](https://user-images.githubusercontent.com/31892927/136935863-4b7f4716-bd1e-480c-9cf7-179dbe049764.png)
   > 
   > we can get diferent values from superset and client,maybe is the jdbc bug,I am not sure. Its there anyone else has something about this?
   
   Could you post SQL generation from Superset? Did you have `eid == 303` records?


-- 
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