Re:Show HN: ScratchDB – Open-Source Snowflake on ClickHouse
by dicriseg on Friday October 27, 2023 @07:38PM
(#38045353)
The convention when flattening is exactly that I thought - an underscore per level of nesting. This is what I would expect to see too.
Re:Show HN: ScratchDB – Open-Source Snowflake on ClickHouse
by memset on Friday October 27, 2023 @07:26PM
(#38045261)
Agree. (What if the original users key has the double underscore?) maybe this can be defined as a param?
Re:Show HN: ScratchDB – Open-Source Snowflake on ClickHouse
by namtab00 on Friday October 27, 2023 @07:53PM
(#38045457)
> What if the original users key has the double underscore?
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...
some_key =1
some__key = 2