0%

ClickHouse使用总结

物理视图

create materialized view bi_run_analyse engine=SummingMergeTree() order by log_date SETTINGS index_granularity = 8192 POPULATE as select log_date, count() as log_count, sum(if(request_retry_time>0,1,0)) as retry_log_count from bi_log_oss group by log_date;