mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-08-18 12:08:22 +00:00
d7f1233f77
* refactor(json2): add JSON2 storage layout settings Signed-off-by: luofucong <luofc@foxmail.com> * resolve PR comments Signed-off-by: luofucong <luofc@foxmail.com> --------- Signed-off-by: luofucong <luofc@foxmail.com>
12 lines
301 B
SQL
12 lines
301 B
SQL
CREATE TABLE t_json2_storage_layout_settings (
|
|
ts TIMESTAMP TIME INDEX,
|
|
j JSON2(max_auto_expanded_paths = 0)
|
|
) WITH (
|
|
'append_mode' = 'true'
|
|
);
|
|
|
|
INSERT INTO t_json2_storage_layout_settings VALUES
|
|
('2026-08-17 00:00:00+0000', '{"a": 1}');
|
|
|
|
ADMIN FLUSH_TABLE('t_json2_storage_layout_settings');
|