LOAD SINGLE TABLE
Description
The LOAD SINGLE TABLE
syntax is used to load single table from storage unit.
Syntax
Grammar Railroad diagram
loadSingleTable ::=
'LOAD' 'SINGLE' 'TABLE' tableDefinition
tableDefinition ::=
tableIdentifier (',' tableIdentifier)*
tableIdentifier ::=
'*.*' | '*.*.*' | storageUnitName '.*' | storageUnitName '.*.*' | storageUnitName '.' schemaName '.*' | storageUnitName '.' tableName | storageUnitName '.' schemaName '.' tableName
storageUnitName ::=
identifier
schemaName ::=
identifier
tableName ::=
identifier
Supplement
- support specifying schemaName in PostgreSQL and OpenGauss protocols
Example
- Load specified single table
LOAD SINGLE TABLE ds_0.t_single;
- Load all single tables in the specified storage unit
LOAD SINGLE TABLE ds_0.*;
- Load all single tables
LOAD SINGLE TABLE *.*;
Reserved word
LOAD
, SINGLE
, TABLE
Related links
当前内容版权归 ShardingSphere 或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问 ShardingSphere .