4 ms·
We store billions of JSON in CH and it performs beautifully. Not sure where you’re getting your experience from.
by nojito 5y ago
We store billions of JSON in CH and it performs beautifully.
Not sure where you’re getting your experience from.
- barrkel 5y agoIf you look up a single blob by id, you're going to have a bad time. My experience comes from using CH as an secondary store for relational data where it could be filtered, sorted and aggregated much faster. The downside was that pulling out all the columns resulted in poor performance - like I said, it was just as slow as a relational store when doing a SELECT *.
- nojito 5y agoThis is impossible. I suggest reading through CH's json functions and seeing how they combine with materialized views. ex: https://eng.uber.com/logging/ https://eng.uber.com/logging/