I've a nested query: SELECT time, host, sum(v) FROM ( SELECT $__dateBin(time) AS time, "shardID", concat_ws(' ', ... actually it's the other way round, the data used in the SQL SUM() operation is ...