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
Can you give more examples on the sharding_key other than rand() in the distributed table? In case I add new shard to the cluster, how to rebalance the existing data and/or the new incoming data based on the disk usage of the nodes? Thanks!
sharding key could be any field which will have better data locality, customer_id for SaaS as an example, currently, re-balancing data part is not supported, but you can subscribe to github.com/CIickHouse/ClickHouse/issues/13574 and watch to discussion
@@roberthodges1480 Please do a talk on building some system which has like real-time inserts and updates are coming. What are the options of inserting them in clickhouse realtime and create a metrics view on top of it.
You prolly dont give a shit but does someone know a way to get back into an Instagram account?? I stupidly forgot the account password. I appreciate any tricks you can offer me
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
Can you give more examples on the sharding_key other than rand() in the distributed table? In case I add new shard to the cluster, how to rebalance the existing data and/or the new incoming data based on the disk usage of the nodes? Thanks!
sharding key could be any field which will have better data locality, customer_id for SaaS as an example, currently, re-balancing data part is not supported, but you can subscribe to github.com/CIickHouse/ClickHouse/issues/13574 and watch to discussion
@@Altinity This issue disappeared - did it get implemented?
Good talk. can we use distributed over the normal tables(without replication) without running the zookeeper?
Yes. Distributed tables just depend on the server names in the tag in config.xml. They do not require access to Zookeeper for queries.
@@roberthodges1480 Please do a talk on building some system which has like real-time inserts and updates are coming. What are the options of inserting them in clickhouse realtime and create a metrics view on top of it.
@@shubhamgoyal7596 That's a great idea. I'll add it to the list of topics to cover.
You prolly dont give a shit but does someone know a way to get back into an Instagram account??
I stupidly forgot the account password. I appreciate any tricks you can offer me
@Ulises Ricky Instablaster =)
How to install and configure zookeeper on my Linux server