select jsonMergePatch(toJSONString(body_json), toJSONString(body_json_promoted)) from distributed_logs_v2 
SETTINGS output_format_native_write_json_as_string=1, min_bytes_to_use_direct_io = 1, max_threads = 5, use_query_cache = 0, enable_filesystem_cache = 0, use_query_condition_cache = 0

Showed 1000 out of 639918444 rows.

639918444 rows in set. Elapsed: 35.342 sec. Processed 639.92 million rows, 10.24 GB (18.11 million rows/s., 289.70 MB/s.)
Peak memory usage: 57.38 MiB.

select jsonMergePatch(body_json::String, body_json_promoted::String) from distributed_logs_v2 
SETTINGS output_format_native_write_json_as_string=1, min_bytes_to_use_direct_io = 1, max_threads = 5, use_query_cache = 0, enable_filesystem_cache = 0, use_query_condition_cache = 0

Showed 1000 out of 639918444 rows.

639918444 rows in set. Elapsed: 34.946 sec. Processed 639.92 million rows, 10.24 GB (18.31 million rows/s., 292.98 MB/s.)
Peak memory usage: 55.73 MiB.

select body_json, body_json_promoted from distributed_logs_v2 
SETTINGS output_format_native_write_json_as_string=1, min_bytes_to_use_direct_io = 1, max_threads = 5, use_query_cache = 0, enable_filesystem_cache = 0, use_query_condition_cache = 0

639918444 rows in set. Elapsed: 346.043 sec. Processed 639.92 million rows, 10.24 GB (1.85 million rows/s., 29.59 MB/s.)
Peak memory usage: 58.36 MiB.

feat: Can two json bodies be merged at the query time #9802

Description

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions