mytable.test AS e INNER JOIN (SELECT src, dstion, srcPnt, dstPnt, max(thisTime) AS time
FROM mytable.test...AS e INNER JOIN (SELECT src, dstion, srcPnt, dstPnt, max(thisTime) AS time
FROM mytable.mytable_book...AS e INNER JOIN (SELECT src, dstion, srcPnt, dstPnt, max(thisTime) AS time
FROM mytable.mytable_book...> SELECT * FROM
12、clickhouse多个字段作为分区
PARTITION BY (toYYYYMMDD(thisTime),
infoType...() AS count
FROM mytable.mytable
GROUP BY day, src, dstion, ruleId, devIp, infoType;
三、总结
以上就是就是关于clickhouse