zhihan DCRcoder
akurkin
/ nested.sql
Last active
October 11, 2024 14:57
— forked from alexey-milovidov/nested.txt
Example of Nested data type in ClickHouse.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| :) CREATE TABLE test.nested (EventDate Date, UserID UInt64, Attrs Nested(Key String, Value String)) ENGINE = MergeTree(EventDate, UserID, 8192) | |
| CREATE TABLE test.nested | |
| ( | |
| EventDate Date, | |
| UserID UInt64, | |
| Attrs Nested( | |
| Key String, | |
| Value String) | |
| ) ENGINE = MergeTree(EventDate, UserID, 8192) |