3 ms·
That's an interesting way to load data and then use with Materialized Views. However, I am curious how do you make efficient use of compression codecs[0] that C
by mr-karan 5y ago
That's an interesting way to load data and then use with Materialized Views. However, I am curious how do you make efficient use of compression codecs[0] that Clickhouse provides, or some neat features like TTL policies [1] using this method?
[0]: https://clickhouse.com/docs/en/sql-reference/data-types/lowcardinality/ https://clickhouse.com/docs/en/sql-reference/data-types/lowc...
[1]: https://clickhouse.com/docs/en/sql-reference/statements/alter/ttl/ https://clickhouse.com/docs/en/sql-reference/statements/alte...
- Redsquare 5y agoMaterialized views have a backing table where you can use the codecs. Can add ttl the ingestion table