- strat docker-compose
- Run
com.nsheremet.trino.ApplicationTest.deduplicatesit will create and populate tables - Run sql
select count(*) as total, 'iceberg' as catalog from iceberg.temp.ns_mytable
union all
select count(*) as total, 'clickhouse' as catalog from clickhouse.dev.ns_mytable
It should return 19481297 for both tables but it returns:
| total | catalog |
|---|---|
| 38962594 | clickhouse |
| 19481297 | iceberg |
So ClickHouse has twice more data then Trino