clickhosue 对json_contans函数不支持

[qiujunlin]

包含选项范围请求：

{  "User[]": {    "count": 3,    "User": {      "contactIdList<>": 38710    }  }}

解析后的

SELECT * FROM `sys`.`apijson_user` WHERE ( (`contactIdList` is NOT null AND (json_contains(`contactIdList`, '38710'))) ) LIMIT 3

报错 没有对应函数

修改为clickhouse中相应函数，查询不出来

SELECT * FROM `test`.`apijson_user` WHERE ( (`contactIdList` is NOT null AND (JSONHas(`contactIdList`, '38710'))) ) LIMIT 3
SELECT * FROM `test`.`apijson_user` WHERE ( (`contactIdList` is NOT null AND (visitParamHas(`contactIdList`, '38710'))) ) LIMIT3

解决办法 参考

chenyanlann/APIJSONDemo_ClickHouse#2