This repository has been archived by the owner on Jul 6, 2022. It is now read-only.

formatter remove as in clickhouse script ! #83

Open

mbtolou opened this issue Apr 16, 2022 · 0 comments

Labels

mbtolou commented Apr 16, 2022

hi.

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;

mbtolou added the enhancement label

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.