Resources

DataStore aggregation functions - ClickHouse Documentation

Clickhouse

from chdb.datastore import F, Field# Sum only high value ordershigh_value_sum = F.sum_if(Field('amount'), Field('amount') > 1000)# Count active usersactive_count = F.count_if(Field('status') == 'active')# In groupby contextresult = ds.groupby('region').agg({ 'total': ('amount', 'sum'), 'high_value': ('amount', F.sum_if(Field('amount') > 1000)),}) Click House-specific functions that collect values.

Visit Site