Clickhouse的Docker版本查询。

1
2
3
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