metabase-clickhouse-driver
metabase-clickhouse-driver copied to clipboard
Incorrect count result when querying a View over a Distributed table
HI! I'm using metabase version 0.44.1 with version clickhouse driver 0.8.3. Found a problem that a simple query
select count(distinct(orderId)) from AttributedPartnerOrders
where partnerId = '...'
and createdDate >= '2023-01-01'
and createdDate <= '2023-01-31'
and clickedMinutesAgo < 1440
produces a result 6046, but if you repeat it, it gives 5971.
The numbers are constantly changing.
Through the standard clickhouse-client, the data is given correctly and the same. In the metabase logs we see only regular lines for this request
DEBUG middleware.log :: POST /api/dataset 202 [ASYNC: completed] 244.3 ms (6 DB calls) App DB connections: 1/15 Jetty threads: 2/50 (5 idle, 0 queued) (100 total active threads) Queries in flight: 1 (0 queued); clickhouse DB 2 connections: 0/1 (0 threads blocked)