2 ms·

Great to see it in ClickHouse. Snowflake released a white paper before its IPO days and mentioned this same feature (secretly exploding JSON into columns). Exp

Great to see it in ClickHouse. Snowflake released a white paper before its IPO days and mentioned this same feature (secretly exploding JSON into columns). Explains how snowflake feels faster than it should, they’ve secretly done a lot of amazing things and just offered it as a polished product like Apple.

statictype 2y ago
Do you have a link to the Snowflake whitepaper?
- JosephRedfern 2y ago
  Perhaps this: https://event.cwi.nl/lsde/papers/p215-dageville-snowflake.pdf https://event.cwi.nl/lsde/papers/p215-dageville-snowflake.pd...
leetrout 2y ago
Scratch data does this as well with duckdb https://github.com/scratchdata/scratchdata https://github.com/scratchdata/scratchdata
nojvek 2y ago
Singlestore has been doing json -> column expansion for a while as well. https://www.singlestore.com/blog/json-builtins-over-columnstore/ https://www.singlestore.com/blog/json-builtins-over-columnst... For a colstore database, dealing with json as strings is a big perf hit.