执行的查询语句:
SELECT
COUNT( DISTINCT table_22.customer_id )
FROM
buffet.`dws_cha_second_chance_sd_ck_1604262339` AS table_22
LEFT JOIN buffet.`dws_cha_chance_sd_ck_1604269193` AS table_23 ON table_22.customer_id = table_23.customer_id
WHERE
(hasAny ( splitByString (',',COALESCE ( toString(table_23.project), 'null' ) ), splitByString (',','100001,9,16,17,18,100175,100177,100905,100931,100943,100945,101141' ) ) = 1)
AND
(hasAny ( splitByString (',',COALESCE ( toString(table_22.category_child_id), 'null' ) ), splitByString (',','0,1' ) ) = 1);
报错信息:
Code: 44, e.displayText() = DB::Exception: Illegal column String of first argument of function splitByString. Must be constant string. (version 20.7.2.30 (official build))
两个条件单独执行是没问题的,,,,但是组合到一起执行就会报这个错误。