Serg
unread,Mar 21, 2023, 11:01:15 AMMar 21Sign in to reply to author
Sign in to forward
Sign in to report message as abuse
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to click...@googlegroups.com
I am using DateTime64 - let's assume a timestamp field, which is
calculated like follows:
fromUnixTimestamp64Nano(CAST(1679409792.9786744*1000000000, 'Int64'))
When inserting automatically using rsyslog, this produces error
CANNOT_PARSE_INPUT_ASSERTION_FAILED (checked with `SELECT * FROM
system.errors`). Even though, the row is still inserted into the table.
When trying to insert row manually, no error is produced:
:) INSERT INTO logging.caddy_logs (timestamp) VALUES
(fromUnixTimestamp64Nano(CAST(1679409792.9786744*1000000000, 'Int64')));
INSERT INTO logging.caddy_logs (timestamp) FORMAT Values
Query id: 7adc3ebc-c3a0-4a50-bc17-aacba684643c
Ok.
1 row in set. Elapsed: 0.004 sec.
Information regarding environment:
ClickHouse client version 23.2.4.12 (official build).
Connecting to localhost:9000 as user default.
Connected to ClickHouse server version 23.2.4 revision 54461.