Create a non-partitioned table group

This topic describes how to create a non-partitioned table group.

Syntax

CREATE TABLEGROUP [IF NOT EXISTS] tablegroupname [opt_tablegroup_option_list]

opt_tablegroup_option_list:
tablegroup_option [tablegroup_option]

tablegroup_option:
LOCALITY [=] locality_name
| PRIMARY_ZONE [=] primary_zone_name

Parameters

Examples

1. Create a table group named tgn.

   obclient> CREATE TABLEGROUP tgn;
   Query OK, 0 rows affected
   

2. View the created tgn table group.

   obclient> SHOW TABLEGROUPS WHERE Tablegroup_name='tgn';
   +-----------------+------------+---------------+
   | Tablegroup_name | Table_name | Database_name |
   +-----------------+------------+---------------+
   | tgn             | NULL       | NULL          |
   +-----------------+------------+---------------+
   1 row in set
   

3. View the created tgn table group.

   obclient> SHOW CREATE Tablegroup tgn\G
   *************************** 1. row ***************************
          Tablegroup: tgn
   Create Tablegroup: CREATE TABLEGROUP IF NOT EXISTS `tgn`  BINDING = FALSE
     partition by hash partitions 10
   1 row in set