ClickHouse 对付单表上亿条记录分组查询秒出, OLAP应用秒杀其他数据库_在线工具

docker run -d --name ch-server --ulimit nofile=262144:262144 -p 8123:8123 -p 9000:9000 -p 9009:9009 yandex/clickhouse-server
或者加一个Mount
docker run -d --name ch-server --ulimit nofile=262144:262144 -p 8123:8123 -p 9000:9000 -p 9009:9009  -v e:\\taobao:/usr/src/app/  yandex/clickhouse-server

http://localhost:8123/?query=SELECT%20%27Hello,%20ClickHouse!%27

clickhouse-client --query='INSERT INTO tblSale FORMAT CSV' < /usr/src/app/tblsale_in.csv

clickhouse-client --query='INSERT INTO tblSale FORMAT CSV' < /usr/src/app/tblsale_in.csv# Code: 117. DB::Exception: Expected end of line: (at row 1)  Row 1: Column 0,   name: id,          type: UInt32,   parsed text: "1" Column 1,   name: prod_id,     type: UInt32,   parsed text: "1" Column 2,   name: user_id,     type: UInt32,   parsed text: "1" Column 3,   name: cnt,         type: UInt32,   parsed text: "1" Column 4,   name: total_price, type: Float32,  parsed text: "1.00" Column 5,   name: date,        type: DateTime, parsed text: "2022-04-22 17:56:00" ERROR: garbage after DateTime: ".783<CARRIAGE RETURN><LINE FEED>2,2," ERROR: DateTime must be in YYYY-MM-DD hh:mm:ss or NNNNNNNNNN (unix timestamp, exactly 10 digits) format.  : While executing CSVRowInputFormat: data for INSERT was parsed from stdin: (in query: INSERT INTO tblSale FORMAT CSV). (INCORRECT_DATA)

bcp "SELECT  [id],[prod_id],[user_id] ,[cnt],[total_price],Convert(varchar(20) , date, 120) as date FROM [taobao].[dbo].[tblSale_in]" queryout tblSale_in.csv -c -t , -T -S .\SQLExpress

Code: 209. DB::NetException: Timeout exceeded while reading from socket (127.0.0.1:9000, 300000 ms). (SOCKET_TIMEOUT)

--统计每日销量，2000w数据 SQLServer 17秒   SELECT Convert(varchar(8) , date, 112) as date,count(*) as dayCnt   FROM [taobao].[dbo].[tblSale] group by Convert(varchar(8) , date, 112)    order by  Convert(varchar(8) , date, 112) 

--按日统计数量, ClickHouse 2500w数据第一次用时8.35秒,第二次用时0.3秒 SELECT toYYYYMMDD(date), count(*) as dayCnt  FROM tblSale  group by toYYYYMMDD(date) order by toYYYYMMDD(date)