v22.8.6.73-clib
Release v22.8.6.73-clib
Image is published at icr.io/clickhouse/clickhouse:22.8.6.73-1-clib-ibm
- This Release is on top of v22.8.6.71-lts
- From branch Kusto-phase3
October 25, 2022
KQL implemented features
New Operators
-
count
Customers | count;
Customers | where Age< 30 | count;
Customers | where Age< 30 | limit 2 | count;
Customers | where Age< 30 | limit 2 | count | project Count; -
top
Customers | top 3 by Age;
Customers | top 3 by Age desc;
Customers | top 3 by Age asc | order by FirstName;
Customers | top 3 by FirstName desc nulls first;
Customers | top 3 by FirstName desc nulls last;
Customers | top 3 by Age | top 2 by FirstName; -
top-hitters
Customers | top-hitters a = 2 of Age by extra;
Customers | top-hitters 2 of Age;
Customers | top-hitters 2 of Age by extra | top-hitters 2 of Age | order by Age;
Customers | top-hitters 2 of Age by extra | where Age > 30;
Customers | top-hitters 2 of Age by extra | where approximate_sum_extra < 200;
Customers | top-hitters 2 of Age | where approximate_count_Age > 2;