My table is :
CREATE STABLE basedb.actionlog (addtime TIMESTAMP, action_ip binary(32), modelname binary(32), acttype binary(8), remark nchar(255)) TAGS (user_id INT,username nchar(16));
The query statement is :
SELECT acttype,count(acttype) as countact FROM actionlog WHERE addtime>'2018-10-03 14:38:05.000' INTERVAL(1d) group by acttype
Then there is an error:
invalid SQL: column projection is not compatible with interval (0.000235s)
I cann't tell what the reason is.
