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”条件下输入了不止一个值,它工作得很好。请建议,是点击屋的错误还是什么我错过了。。。
1条答案
按热度按时间toe950271#
尝试使用1.1.54343和更高版本,您的错误消息当前不存在于clickhouse服务器源上,可能它当前已修复