Question: I thought Clickhouse already has native support for flattening JSON [1], although it was released recently (version 22.3.1). Did you start working on it [2] before that? Or is it a different take? I'm curious about the pros and cons of each one.
[1] https://clickhouse.com/docs/en/integrations/data-formats/jso... [2] https://scratchdb.com/blog/flatten-json/
Here's a more factual one:
- We don't use tuples for nested JSON. We just use underscores to show parent_child relationships in keys.
- We don't use arrays. Instead, we make it easy to split into multiple rows so you can use regular SQL.
I haven't directly compared Clickhouse's all of different JSON treatments compared to what I've implemented, but my goal was to build something that you could run and would "just work the way it should."
Big fan of CH on my end. Will follow your project closely.
{
"some_key": "1"
"some": {
"key": "2"
}
}(This hasn't come up with existing customers because theoretically it could and we should handle it.)
some_key =1
some__key = 2
Double it again.
some_key = 1
some__key = 2
some____key = 3
This is analogous to what C#11 does to allow raw string literal quotes containing those same quotes. https://learn.microsoft.com/en-us/dotnet/csharp/language-ref...