Want to be the smartest ClickHouse developer in the room? Then sign up to our newsletter to get ClickHouse tips and tricks straight to your inbox. Sign up here: hubs.ly/Q02pp8vh0
08:10 - Read S3 data fast with wildcards and named collections 15:25 - Reduce storage size using codecs and compression 24:30 - Repeat time column in ORDER BY to speed up time-based queries 32:55 - Handle mutable data with ReplacingMergeTree 41:40 - Store RBAC model in zookepper ( or clickhouse keepper ) 48:10 - Use aggregation to simulate joins
If you want to see the TTL values for specific data, run a query on system.parts. There are columns listing all currently applicable TTL limits for each part. (It does not work if the table is empty because there aren’t any parts yet.) See kb article here: kb.altinity.com/altinity-kb-queries-and-syntax/ttl/what-are-my-ttls/ PS: have other questions? Ask away in our slack channel (altinity.com/slack). We also do free 45 min help calls (don’t worry, we won’t try to sell you anything). Just fill in the form and book a time here: hubs.la/Q02GGt9x0
The order for the table (around 30:00): Wouldn’t it be even more optimal if we put the toStartIfDay at first place? If we had a where condition in our select that limits the results to user_id, the given sort order would be best. But we don’t
Want to be the smartest ClickHouse developer in the room?
Then sign up to our newsletter to get ClickHouse tips and tricks straight to your inbox. Sign up here: hubs.ly/Q02pp8vh0
Interesting! Thanks for sharing
08:10 - Read S3 data fast with wildcards and named collections
15:25 - Reduce storage size using codecs and compression
24:30 - Repeat time column in ORDER BY to speed up time-based queries
32:55 - Handle mutable data with ReplacingMergeTree
41:40 - Store RBAC model in zookepper ( or clickhouse keepper )
48:10 - Use aggregation to simulate joins
how can I see the the actual TTL values for specific data?
If you want to see the TTL values for specific data, run a query on system.parts. There are columns listing all currently applicable TTL limits for each part. (It does not work if the table is empty because there aren’t any parts yet.)
See kb article here: kb.altinity.com/altinity-kb-queries-and-syntax/ttl/what-are-my-ttls/
PS: have other questions? Ask away in our slack channel (altinity.com/slack).
We also do free 45 min help calls (don’t worry, we won’t try to sell you anything). Just fill in the form and book a time here: hubs.la/Q02GGt9x0
The order for the table (around 30:00): Wouldn’t it be even more optimal if we put the toStartIfDay at first place?
If we had a where condition in our select that limits the results to user_id, the given sort order would be best. But we don’t