JOIN Two Big Tables, each being some terabytes.

subhas_hati — Tue, 11 Feb 2025 21:34:19 GMT

What is the strategy for joinning two big tables, each being some terrabytes.

Re: JOIN Two Big Tables, each being some terabytes.

Alberto_Umana — Tue, 11 Feb 2025 21:47:47 GMT

Enable AQE to dynamically optimize the join strategy at runtime based on the actual data distribution. This can help in choosing the best join strategy automatically

If you are using Delta tables, you can leverage the MERGE statement with schema evolution and other optimizations:

MERGE INTO target_table AS tgt
USING source_table AS src
ON tgt.key = src.key
WHEN MATCHED THEN UPDATE SET tgt.col1 = src.col1
WHEN NOT MATCHED THEN INSERT (key, col1) VALUES (src.key, src.col1);

https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-qry-select-hints.html#join-hint-types

topic Re: JOIN Two Big Tables, each being some terabytes. in Data Engineering

JOIN Two Big Tables, each being some terabytes.

Re: JOIN Two Big Tables, each being some terabytes.