How to store JSON object in ClickHouse DB?

Question

Python

I have data that is stored as JSON objects that can store arrays, for example:

{
    "name":"test1",
    "info":{"ver":"beta"},
    "addresses":[
        {"ip":"134.83.91.28", "port":80},
        {"ip":"134.83.92.73", "port":8080}
    ]
}

Of course, there are no problems with saving such fields as name , with such fields as ver , in principle, too (I just created a field add column info.ver String), but I can’t figure it out with saving arrays with objects.
Are there any ideas / ready-made solutions? I would also be glad if you tell me how to implement this using the clickhouse_driver python module

Answer 1

Throw addresses in a field like https://clickhouse.yandex/docs/ru/data_types/array/,
in the form "134.83.91.28:80".