Storagejoin Now Supports Join_any_take_last_row Setting That Allows Overwriting Existing Values of the Same Key

Why it matters

This feature addresses the problem of handling duplicate keys in StorageJoin. By allowing the last row for a key to overwrite previous values, it improves data accuracy and flexibility in join operations where later data should take precedence.

How to use it

Users can enable this behavior by setting join_any_take_last_row to true when creating or querying a StorageJoin. For example:

SET join_any_take_last_row = 1;
-- or in the table creation settings
CREATE TABLE join_table ENGINE = Join(settings join_any_take_last_row=1) AS ...