Есть такой запрос создания мат вью
CREATE MATERIALIZED VIEW loadstat_agg_view TO loadstat_agg
ENGINE = AggregatingMergeTree(date, (host, date), 8192) POPULATE AS
SELECT
host,
date,
countState() AS hitCount,
countState(if(load = 0, host, NULL)) AS badCount,
uniqState(ip) AS hostCount,
uniqState(host) AS siteCount,
uniqState(userAgent) AS uniqCount,
avgState(
if(
((resolved - opened) > 0)
AND ((resolved - opened) <= 60000),
resolved - opened,
NULL
) / 1000
) AS avgLoadTime
FROM
loadstat
GROUP BY
host,
date

Ругается:
Code: 62, e.displayText() = DB::Exception: Syntax error: failed at position 99 (line 2, col 1): ENGINE = AggregatingMergeTree(date, (host, date), 8192) POPULATE AS
SELECT
host,
date,
countState() AS hitCount,
countState(if(load = 0, host, NULL)) AS. Expected one of: token, OpeningRoundBracket, AS, e.what() = DB::Exception

Что не так?

Если убрать "ENGINE = AggregatingMergeTree(date, (host, date), 8192) POPULATE" запрос отрабатывает