DEFAULTSTORAGEGROUPS System Table Description

Description

This table contains table partition to storage group mappings created with the MAP PARTITION statement. See MAP PARTITION for more information.

Fields

Field Type Description

PARTITIONNAME

string

The name of the table partition mapped to the storage group specified in the STORAGEGROUP column by the MAP PARTITION statement.

STORAGEGROUP

string

The name of the storage group to which the table partition in the PARTITIONNAME column is mapped by the MAP PARTITION statement. This is the storage group for this partition, if no STORE IN clause is specified for the CREATE or ALTER TABLE command.

Indexes

Primary Index: DEFAULTSTORAGEGROUPS..PRIMARY_KEY on field: PARTITIONNAME

Example

In the example below, we map partition p_east to storage group sgeast and partition p_west to storage group sgwest. This means, by default, if you do not specify STORE IN, then data inserted into partition p_east will be stored in storage group sgeast and data inserted into partition p_west will be stored in sgwest.

MAP PARTITION p_east STORE IN sgeast;
MAP PARTITION p_west STORE IN sgwest;
SELECT * FROM system.defaultstoragegroups;

 PARTITIONNAME  STORAGEGROUP
 -------------- -------------

     P_EAST        SGEAST
     P_WEST        SGWEST

CREATE TABLE users (first STRING, last STRING, zip CHAR(5))
    PARTITION BY RANGE (zip)
        PARTITION p_east VALUES LESS THAN ('70000')
        PARTITION p_west VALUES LESS THAN (maxvalue);