Clickhouse query error: Unknown data type family: INT8. Maybe you meant: ['Int8','UInt8']

1

I’we try querying Clcikhouse table (connected trough ARP connector).

Very simple query like:

SELECT customUserId, e.dtEvent, e.tsEvent
FROM "clickhouse-datamart".sandbox."gid_mt_custom_events" as e

wotks.

But when I’ve tried to add where:

SELECT customUserId, e.dtEvent, e.tsEvent
FROM "clickhouse-datamart".sandbox."gid_mt_custom_events" as e
WHERE
    e.tsEvent = 1681547655
ORDER BY dtEvent DESC

Fails with:

Source 'MT-clickhouse-datamart' returned error 'Code: 50. DB::Exception: Unknown data type family: INT8. Maybe you meant: ['Int8','UInt8']: While processing CAST(tsEvent, 'INT8') = 1681547655. (UNKNOWN_TYPE) (version 22.3.3.44 (official build))

Looks like inner types cast incorrectly.

I’ve tried also casting manually in manner CAST(e.tsEvent as UInt8) = 1681547655, but that also filed with Unknown identifier 'UInt8'

So, please help me cast correctly in this case.