• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. SQL Reference
  5. SQL Syntax
  6. CREATE BARRIER

CREATE BARRIER

Function

Creates a barrier for cluster nodes. The barrier can be used for data restoration.

Precautions

Before creating a barrier, ensure that gtm_backup_barrier is set to on for the CN and DN nodes in the cluster.

Syntax

CREATE BARRIER [ barrier_name  ] ;

Parameter Description

barrier_name

(Optional) Indicates the name of a barrier.

Value range: A string. It must comply with the naming convention rule.

Examples

-- Create a barrier without specifying its name:
CREATE BARRIER;

-- Specify a barrier name:
CREATE BARRIER 'barrier1';