ClickHouse常见问题之使用另一个表中的值更新行 - Java技术债务

ALTER TABLE B
    UPDATE campaign_name =
    (
        SELECT campaign_name FROM B b
        JOIN A a ON b.campaign_id = a.campaign_id
    ) WHERE campaign_id in (ids)

DB::Exception: Unknown identifier: a.campaign_id , context: required_names: 'a.campaign_id' source_tables: table_aliases: private_aliases: column_aliases: public_columns: masked_columns: array_join_columns: source_columns: .

CREATE TABLE A_join as states Engine = Join(ANY, LEFT, statefp);

INSERT INTO A_join SELECT * from A;

ALTER TABLE B UPDATE campaign_name = joinGet('A_join', 'campaign_name', statefp))
WHERE campaign_id in (ids);

DROP TABLE A_join;