I’m trying to select all items from ClickHouse DB where the viewIds
array contains 341852351
.
I run this query:
SELECT *
FROM
array join viewIds
WHERE has(viewIds, '341852351')
But I get this error:
There is no supertype for types Int256, String because some of them
are String/FixedString and some of them are not: While processing
has(viewIds, ‘341852351’). (NO_COMMON_TYPE)
Please help me to fix this query.