Creating a partitioned table

solidDB Help : solidDB Grid : Working with grids : Creating tables in a grid : Creating a partitioned table

Note Check the solidDB Release Notes for any limitations that are associated with using a grid in the current release.

Complete the following steps to create a partitioned table on a grid. For details of schema requirements and limitations that are associated with partitioned tables, see Schema requirements and recommendations.

1 Connect to one of the nodes in the grid by using a grid connection. For example:

solsql "grid tcp myhost1 1964" dba dba

For more information, see Connecting to a grid.

2 Run the CREATE TABLE statement with the PARTITION BY and REPLICATION FACTOR clauses.

▪ Use PARTITION BY to specify the partitioning key for the table.

▪ Use REPLICATION FACTOR to specify the number of copies of each row of the table that the grid should maintain.

For example:

CREATE TABLE GRID_PARTITIONED(
  I INTEGER NOT NULL PRIMARY KEY,
  J INTEGER NOT NULL,
  C VARCHAR)
PARTITION BY (I)
REPLICATION FACTOR 3;

For the complete syntax, see CREATE TABLE.

You can now add data to the table by using a grid connection from your application or the solidDB solloado utility, see solidDB Speed Loader (solloado and solload).

Go up to

Creating tables in a grid