LOAD SINGLE TABLE

Description

The LOAD SINGLE TABLE syntax is used to load single table from storage unit.

Syntax

Grammar Railroad diagram

  1. loadSingleTable ::=
  2. 'LOAD' 'SINGLE' 'TABLE' tableDefinition
  3. tableDefinition ::=
  4. tableIdentifier (',' tableIdentifier)*
  5. tableIdentifier ::=
  6. '*.*' | '*.*.*' | storageUnitName '.*' | storageUnitName '.*.*' | storageUnitName '.' schemaName '.*' | storageUnitName '.' tableName | storageUnitName '.' schemaName '.' tableName
  7. storageUnitName ::=
  8. identifier
  9. schemaName ::=
  10. identifier
  11. tableName ::=
  12. identifier

Supplement

  • support specifying schemaName in PostgreSQL and OpenGauss protocols

Example

  • Load specified single table
  1. LOAD SINGLE TABLE ds_0.t_single;
  • Load all single tables in the specified storage unit
  1. LOAD SINGLE TABLE ds_0.*;
  • Load all single tables
  1. LOAD SINGLE TABLE *.*;

Reserved word

LOAD, SINGLE, TABLE