when using formatter in clickhouse script "AS" removed.
create LIVE VIEW ahe.lv_ahe_commands (`create_time` DateTime('Asia/Tehran'), `cnt` UInt64) as
select create_time, count() as cnt
from ahe.ahe_commands
where (create_time > addMinutes(now('Asia/Tehran'), -60)) and (is_expire = 0) and (is_processed = 0)
group by create_time
order by create_time ASC;
hi.
when using formatter in clickhouse script "AS" removed.