Logo
Single Table

Single Table #

SyntaxDescriptionType
COUNT SINGLE_TABLE RULEQuery the number of single tables, this syntax will be deprecated in future versionsRQL
SHOW SINGLE TABLESView all loaded single tablesRQL
SET DEFAULT SINGLE TABLE STORAGE UNIT = xxSet the storage unit for a single tableRAL
SHOW DEFAULT SINGLE TABLE STORAGE UNITView the default storage unit configuration for single tablesRQL
LOAD SINGLE TABLELoad existing single tables from storage nodes into the logical libraryRDL
UNLOAD SINGLE TABLEUnload existing single tables from the logical library into storage nodesRDL
SHOW UNLOADED SINGLE TABLESView all unloaded single tablesRQL

1. Query The Number Of Single Tables #

copyCOUNT SINGLE_TABLE RULE;

Example

copyCOUNT SINGLE_TABLE RULE;

2. View All Loaded Single Tables #

copySHOW SINGLE TABLES

Example

copySHOW SINGLE TABLES

3. Set Single Table Storage Node #

copySET DEFAULT SINGLE TABLE STORAGE UNIT = (storageUnitName | RANDOM)

Parameter Explanation

storageUnitName is the storage unit to use for RDL management. RANDOM stands for Random Storage.

Example

copySET DEFAULT SINGLE TABLE STORAGE UNIT = ds_0

SET DEFAULT SINGLE TABLE STORAGE UNIT = RANDOM

4. View Single Table Default Storage Node Configuration #

copySHOW DEFAULT SINGLE TABLE STORAGE UNIT;

Example

copySHOW DEFAULT SINGLE TABLE STORAGE UNIT;
  1. Load Existing Single Tables from Storage Nodes into the Logical Library
copyLOAD SINGLE TABLE

Examples

  • Load a specific single table
copyload single table ds_1.t_single_2;
  • Load all single tables from a specific storage unit
copyload single table ds_1.*;
  • Load all single tables from all storage units
copyload single table *.*;
  1. Unload Existing Single Tables from the Logical Library into Storage Nodes
copyUNLOAD SINGLE TABLE

Examples

  • Unload a specific single table
copyunload single table ds_1.t_single_2;
  • Unload all single tables from a specific storage unit
copyunload single table ds_1.*;
  • Unload all single tables from all storage units
copyunload single table *.*;
  1. View All Unloaded Single Tables
copySHOW UNLOADED SINGLE TABLES

Example

copyshow unloaded single tables;