1.0

PARTITION BY LIST Clause on page 457 ( column-name )
(
VALUES ( value [ , value ]* )
[ , VALUES ( value [ , value ]* ) ]*
)
|
PARTITION BY (
PARTITION BY Expression Clauses on page 457 )
}
[
COLOCATE WITH Clause on page 458 ( table-name ) ]
[
REDUNDANCY Clause on page 460
integer-constant ]
[
BUCKETS Attribute on page 460
integer-constant ]
[
RECOVERYDELAY Clause on page 460
integer-constant ]
[
MAXPARTSIZE Attribute on page 460
integer-constant ]
If the partitioning clause is not specified and the default table type (property table-default-partitioned
is "true") is partitioned, then the system determines the partitioning scheme on its own based on a certain set of
rules described below.
If the default table type property is not overridden and no partitioning clause is specified, then the table is
replicated on all the members of the server groups of the table. REPLICATE can also be explicitly used to create
a replicated table.
PARTITION BY COLUMN Clause
Use the PARTITION BY COLUMN clause to provide a set of column names that will determine the partitioning.
As a shortcut you can use PRIMARY KEY to refer to the primary key columns. The hash function is an internal
function that typically returns the EXCLUSIVE OR of the hashcode() return values for the columns' underlying
Java types.
Example with PARTITION BY COLUMN Clause
-- partition by primary key
CREATE TABLE HOTELAVAILABILITY
( HOTEL_ID INT NOT NULL,
BOOKING_DATE DATE NOT NULL,
ROOMS_TAKEN INT DEFAULT 0,
PRIMARY KEY (HOTEL_ID, BOOKING_DATE)
) PARTITION BY PRIMARY KEY
-- partition by column (booking date only)
CREATE TABLE HOTELAVAILABILITY
( HOTEL_ID INT NOT NULL,
BOOKING_DATE DATE NOT NULL,
ROOMS_TAKEN INT DEFAULT 0,
vFabric SQLFire User's Guide456
vFabric SQLFire Reference