News for hackers. Stuff that matters.
Re:Using PostgreSQL’s JSONB for NoSQL (2019) [video] by hodgesrm on Sunday September 05, 2021 @01:44PM (#28426142)
JSON blob + columns is the recommended approach for handling semi-structured data in ClickHouse. It's easy to add columns on the fly, since you just give the expression to haul out the data using a DEFAULT clause. ClickHouse applies it automatically on older blocks without rewriting them. For new blocks it materializes the data as rows are inserted.

There are no comments on this comment yet.