3 ms·
You can use materialized views in ClickHouse to simulate secondary indexes. See https://www.percona.com/blog/2019/01/14/should-you-use-clickhouse-as-a-main-oper
by hodgesrm 8y ago
You can use materialized views in ClickHouse to simulate secondary indexes. See https://www.percona.com/blog/2019/01/14/should-you-use-clickhouse-as-a-main-operational-database/ https://www.percona.com/blog/2019/01/14/should-you-use-click... for an example of this usage. It's about half-way through the article.
Disclaimer: I work for Altinity which is commercializing ClickHouse.