Single Table #
| Syntax | Description | Type |
|---|---|---|
| COUNT SINGLE_TABLE RULE | Query the number of single tables, this syntax will be deprecated in future versions | RQL |
| SHOW SINGLE TABLES | View all loaded single tables | RQL |
| SET DEFAULT SINGLE TABLE STORAGE UNIT = xx | Set the storage unit for a single table | RAL |
| SHOW DEFAULT SINGLE TABLE STORAGE UNIT | View the default storage unit configuration for single tables | RQL |
| LOAD SINGLE TABLE | Load existing single tables from storage nodes into the logical library | RDL |
| UNLOAD SINGLE TABLE | Unload existing single tables from the logical library into storage nodes | RDL |
| SHOW UNLOADED SINGLE TABLES | View all unloaded single tables | RQL |
1. Query The Number Of Single Tables #
COUNT SINGLE_TABLE RULE;
Example
COUNT SINGLE_TABLE RULE;
2. View All Loaded Single Tables #
SHOW SINGLE TABLES
Example
SHOW SINGLE TABLES
3. Set Single Table Storage Node #
SET 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
SET DEFAULT SINGLE TABLE STORAGE UNIT = ds_0
SET DEFAULT SINGLE TABLE STORAGE UNIT = RANDOM
4. View Single Table Default Storage Node Configuration #
SHOW DEFAULT SINGLE TABLE STORAGE UNIT;
Example
SHOW DEFAULT SINGLE TABLE STORAGE UNIT;
- Load Existing Single Tables from Storage Nodes into the Logical Library
LOAD SINGLE TABLE
Examples
- Load a specific single table
load single table ds_1.t_single_2;
- Load all single tables from a specific storage unit
load single table ds_1.*;
- Load all single tables from all storage units
load single table *.*;
- Unload Existing Single Tables from the Logical Library into Storage Nodes
UNLOAD SINGLE TABLE
Examples
- Unload a specific single table
unload single table ds_1.t_single_2;
- Unload all single tables from a specific storage unit
unload single table ds_1.*;
- Unload all single tables from all storage units
unload single table *.*;
- View All Unloaded Single Tables
SHOW UNLOADED SINGLE TABLES
Example
show unloaded single tables;