Clickhouse database is only inserting numbers 0 and dates 1970-01-01

Question

I created replacing merge table, kafka_table and materialview. I am throwing json into kafka to insert data. But if I select materialview, a row is added in which 0 is written in the number type column, and 1970-01-01 00:00:00 is written in the datetime type.

This is the information in the table

this is the json:

I don't know why it writes to the database like that, or if something was done wrong?

Answer 1

Ensure columns are same case per comment above. ClickHouse columns are case sensitive.