clickHouse查询问题

Question

在使用clickHouse查询时报如下错误

SQL 错误 [62]: ClickHouse exception, code: 62, host: 172.16.45.35, port: 8123; Code: 62, e.displayText() = DB::Exception: Syntax error: failed at position 175

具体sql如下：

SELECT SUM(deviceState) as onlineTome from vc_device.devicehistorystatic d where 1=1
AND createTime BETWEEN '2023-06-25 00:00:00' AND '2023-07-25 23:59:59'
AND POSITION ('1ebccad6-8478-4e43-a8f3-7ecf3032415d,21e54e29-b94c-4482-904c-f6d7d6dd7182,bd4cff75-4b3f-11eb-9007-9c5c8e320598,e6f2c325-215b-48ab-898c-7914099fe661,bd4cff75-4b3f-11eb-9007-9c5c8e320573,bd4cff75-4b3f-11eb-9007-9c5c8e320826,baa9b86a-27ae-49b4-93a5-fdd38c383ed5,a866b302-659a-41df-acec-de60680875cg,e4f7f886-aee3-4d34-ae92-ae68043a34a9,460172fb-22e8-4699-a613-5f9c0f936656,bd4cff75-4b3f-11eb-9007-9c5c8e320598,bd4cff75-4b3f-11eb-9007-9c5c8e320587,b855af29-4239-4815-a4fd-19072c4af6e3,bd4cff75-4b3f-11eb-9007-9c5c8e320678,e69ab51f-96e1-4515-ae64-39c915534ead,4642ab88-3249-49e0-9e19-11d034f02d10,bd4cff75-4b3f-11eb-9007-9c5c8e320599,bd4cff75-4b3f-11eb-9007-9c5c8e320586,b77e19d1-bc73-4655-8090-f1392b45ac0a,bd4cff75-4b3f-11eb-9007-9c5c8e320677,'
;no)
其中POSITION (' str',no)中str对应30000多个参数

Answer 1

SELECT SUM(deviceState) as onlineTome from vc_device.devicehistorystatic d 
WHERE 1=1
AND createTime BETWEEN '2023-06-25 00:00:00' AND '2023-07-25 23:59:59'
AND some_field IN ('value1', 'value2', 'value3', ...);