This function returns a string resulting from the concatenation, or joining, of two or more string values in an end-to-end manner. It separates those concatenated string values with the delimiter ...
SELECT time, host, sum(v) FROM ( SELECT $__dateBin(time) AS time, "shardID", concat_ws(' ', split_part(host, '-', 6), split_part(host, '-', 7)) AS host, max ...