How to improve sql select query execution time?
I have clickhouse 24.11 and this is table structure that AI helped me to do:
clickhouse support for using azure blob storage as cold disk ( does the performance of this match with aws s3 as cold disk )
clickhouse to use azure blob storage as disk will this configuration where type is azure_blob_storage, is this still the case where performance of this type isn’t matched when used with type as s3 for aws, accordingly to this artical https://engineering.contentsquare.com/2023/clickhouse-on-azure/ it is recommended to use s3proxy with azure blob storage.
Improving performance of UniqExact in ClickHouse
I have a table with more than 500 million rows. When I perform aggregation like sum() or avg() on these rows, it’s very fast. But when I use uniqExact() function on a columns with higher cardinality, it is very slow. How to speed up the performance of uniqExact function? I don’t see blogs related to this.
Clickhouse certificate revocation list (CRL) support
I looked inside the Clickhouse’s github repo and couldn’t find anything related to CRL or OCSP except the underlying openssl library clickhouse uses.
Clickhouse certificate revocation list (CRL) support
I looked inside the Clickhouse’s github repo and couldn’t find anything related to CRL or OCSP except the underlying openssl library clickhouse uses.
SummingMergeTree + TTL on total sum breaks when records are left unmerged
I have a SummingMerge table in Clickhouse that collects some counters that are streamed in from some source
SummingMergeTree + TTL on total sum breaks when records are left unmerged
I have a SummingMerge table in Clickhouse that collects some counters that are streamed in from some source
SummingMergeTree + TTL on total sum breaks when records are left unmerged
I have a SummingMerge table in Clickhouse that collects some counters that are streamed in from some source
SummingMergeTree + TTL on total sum breaks when records are left unmerged
I have a SummingMerge table in Clickhouse that collects some counters that are streamed in from some source
Efficient/fast way to store array of tuples?
I’m storing items that are tied to a time of day associated with an “impact”.