clickhouse | where in condition with single value(点击房屋|此处,条件为单值)

9w11ddsr  于 2021-07-15  发布在  ClickHouse
关注(0)|答案(1)|浏览(903)

clickhouse客户端版本:1.1.54318这是我的查询

SELECT toDayOfWeek(event_date) as dd,event_date,toString(toDateTime(toString(event_time))) as event_time,severity
from tbl_sla_alert 
PREWHERE sla_id = 94 AND  event_time >= '2018-02-27 14:55:00' AND (event_time >= '2018-02-27 00:00:00' AND event_time <= '2018-02-27 23:59:59') AND (dd in (4)) 
ORDER BY event_date,event_time

执行此查询时,出现以下错误:

DB::Exception: Received from localhost:9000, ::1. DB::Exception: Set for IN is not created yet!.

但我在“in”条件下输入了不止一个值,它工作得很好。请建议,是点击屋的错误还是什么我错过了。。。

toe95027

toe950271#

尝试使用1.1.54343和更高版本,您的错误消息当前不存在于clickhouse服务器源上,可能它当前已修复

相关问题