Skip to content
Advertisement

Tag: yandex-metrika

ClickHouse: How to store JSON data the right way?

I’m going to migrate data from PostgreSQL database to Yandex’s ClickHouse. One of the fields in a source table is of type JSON – called additional_data. So, PostgreSQL allows me to access json attributes during e.g. SELECT … queries with ->> and -> and so on. I need the same behavior to persist in my resulting table in ClickHouse storage.

Advertisement