Clickhouse的Docker版本查询。
select service, count(service) as cnt from x_main_all where date > '2021-01-01' and date <'2022-01-27' group by service order by cnt desc limit 1000;
select product, count(product) as cnt from x_main_all where date > '2021-01-01' and date <'2022-01-27' group by product order by cnt desc limit 1000;
docker run -it --rm yandex/clickhouse-client -h xxx.cn --port 9000 -m -u username --password passwd -d usern