CREATE BROADCAST TABLE RULE

Description

The CREATE BROADCAST TABLE RULE syntax is used to create broadcast table rules for tables that need to be broadcast (broadcast tables)

Syntax

CreateBroadcastTableRule ::=
  'CREATE' 'BROADCAST' 'TABLE' 'RULE' ifNotExists? tableName (',' tableName)* 

ifNotExists ::=
  'IF' 'NOT' 'EXISTS'

tableName ::=
  identifier

Supplement

• tableName can use an existing table or a table that will be created;
• ifNotExists clause is used to avoid Duplicate Broadcast rule error.

Example

Create broadcast table rule

-- Add t_province, t_city to broadcast table rules
CREATE BROADCAST TABLE RULE t_province, t_city;

Create broadcast table rule with ifNotExists clause

CREATE BROADCAST TABLE RULE IF NOT EXISTS t_province, t_city;

Reserved word

CREATE, BROADCAST, TABLE, RULE

Related links

• Reserved word