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.
[ Parent
| on HN ]
There are no comments on this comment yet.