Size: a a a
b
D
max_bytes_before_external_group_by = 10Гб, то потребление оперативки падает до 3,5ГбKS
D
V
D
SELECT r.hashKey
FROM data_vault_raw.evoRuEdsQueue_docs_order_hash AS l
RIGHT JOIN
(
SELECT hashKey
FROM temp_tables.ap828_evoRuEdsQueue_docs_order_source_hash
) AS r ON l.hashKey = r.hashKey
WHERE empty(l.hashKey)
D
A
V
D
D
SELECT r.hashKey
FROM data_vault_raw.evoRuEdsQueue_docs_order_hash AS l
RIGHT JOIN
(
SELECT hashKey
FROM temp_tables.ap828_evoRuEdsQueue_docs_order_source_hash
) AS r ON l.hashKey = r.hashKey
WHERE empty(l.hashKey) Format Null
D
V
V
V
D
[dwh-ch2.mailru.prod] 2020.07.15 14:27:46.923959 {ab94c45c-b2da-4c00-8b42-1b0444643264} [ 78 ] <Debug> CreatingSetsBlockInputStream: Created. Join with 14523 entries from 119951 rows. In 0.019 sec.
[dwh-ch2.mailru.prod] 2020.07.15 14:27:47.393286 {ab94c45c-b2da-4c00-8b42-1b0444643264} [ 72 ] <Debug> MemoryTracker: Current memory usage: 1.01 GiB.
SELECT rr.* FROM data_vault_raw.evoRuEdsQueue_docs_order_hash rr
where (rr.hashKey) IN
(
SELECT r.hashKey
FROM data_vault_raw.evoRuEdsQueue_docs_order_hash AS l
RIGHT JOIN
(
SELECT hashKey
FROM temp_tables.ap828_evoRuEdsQueue_docs_order_source_hash
) AS r ON l.hashKey = r.hashKey
WHERE empty(l.hashKey)
)
Format Null
WK
D
DT
WK