(Illegal type DateTime64(3) [ while pushing to view default.DNS_PROTOCOL] Latest Version(v0.9.7) DNS-Monster Showing Error while send data to Click-House about dnsmonster HOT 9 CLOSED

unfortunately yes. it's a limitation of ClickHouse :(

from dnsmonster.

Hi there.

what's the version of ClickHouse and dnsmonster running

from dnsmonster.

ClickHouse server version 22.12.3
dnsmonster version: v0.9.7

from dnsmonster.

if you've upgraded dnsmonster from an older version, it's required to re-create the tables on clickhouse based on the new table schema. That's an unfortunate limitation of Clickhouse that the primary key of the table can't have it's typed modified.

from dnsmonster.

i did not upgrade dnsmonster from older version , just installed fresh both in new VM .

from dnsmonster.

did you use the autobuild.sh script or re-created the folders. Also, if you're using Linux, you can use the build artifact from the latest commit here

from dnsmonster.

also have a look on 0.9.9.

from dnsmonster.

Okey buddy !!!
I will check and share Positive Result.

from dnsmonster.

we need to re-create DNS_LOG table and DNS_PROTOCOL after installation of 0.9.9. ????
because problem is still persist.

from dnsmonster.