Colocate Join

    1 How To Use:

    Simply add the property colocate_with when building a table. The value of colocate_with can be set to any one of the same set of colocate tables. However, you need to ensure that tables in the colocate_with attribute are created first.

    If you need to Colocate Join table t1 and t2, you can build tables according to the following statements:

    CREATE TABLE ( id int(11) COMMENT “”, ‘value id) DISTRIBUTED BY HASH(id`) BUCKETS 10 PROPERTIES ( “colocate_with” = “t1” );

    CREATE TABLE ( id int(11) COMMENT “”, ‘value id) DISTRIBUTED BY HASH(id`) BUCKETS 10 PROPERTIES ( “colocate_with” = “t1” );

    2 Colocate Join 目前的限制:

    1. Colcoate Table must be an OLAP-type table
    2. The number of copies of tables with the same colocate_with attribute must be the same

    Colocate Join is well suited for scenarios where tables are bucketed according to the same field and high frequency according to the same field Join.

    4 FAQ:

    Q: 支持多张表进行Colocate Join 吗?

    A: 25903;. 25345

    Q: Do you support Colocate table and normal table Join?

    A: 25903;. 25345

    A: Support: Join that does not meet Colocate Join criteria will use Shuffle Join or Broadcast Join

    Q: How do you determine that Join is executed according to Colocate Join?

    A: The child node of Hash Join in the result of explain is Colocate Join if it is OlapScanNode directly without Exchange Node.

    Q: How to modify the colocate_with attribute?

    A: ALTER TABLE example_db.my_table set (“colocate_with”=”target_table”);

    Q: 229144; colcoate join?

    keyword

    COLOCATE, JOIN, CREATE TABLE