SAND CDBMS Administration Guide
Massively Parallel Processing (MPP)

MPP Mode

If a database user has a default partition, which is configured through the ALTER AUTHORIZATION...SET DEFAULT PARTITION command, that user is said to operate in "MPP mode", and certain MPP-related SQL commands are executed in the context of that default partition.

Some SQL commands are designed for MPP mode only, and others behave differently depending on whether the session is in MPP mode or not. There are also MPP-related commands that behave the same way regardless of the mode. These commands are summarized in the following table.

Command	MPP mode	non-MPP mode
ALTER TABLE... ADD DIMENSION	convert the table to a dimension table for the default partitioned table	—
ALTER TABLE... DIMENSION OF	—	convert the table to a dimension table for the specified partitioned table
CREATE DOMAIN	new dimension domain across all partition nodes for the default partitioned table	new local domain only
CREATE LOCAL DOMAIN	new local domain only	new local domain only
CREATE DOMAIN... DIMENSION OF	new dimension domain across all partition nodes for the specified partitioned table	new dimension domain across all partition nodes for the specified partitioned table
CREATE TABLE	new dimension table across all partition nodes	new local table only
CREATE LOCAL TABLE	new local table only	new local table only
CREATE PARTITION TABLE... (field definitions)	new partitioned table structure with the specified field definitions	—
CREATE PARTITION TABLE... (PARTITION ...)	new partitioned table with the specified partitions	new partitioned table with the specified partitions
CREATE TABLE...SELECT (querying partitioned table)	new partitioned table created	new standard (base) table created
INSERT...SELECT (from and to partitioned tables)	selected data is inserted into the remote tables associated with the specified partitioned table	selected data is inserted into the remote tables associated with the specified partitioned table
REFRESH DIMENSION TABLE	copy the local dimension table data to the remote dimension tables, replacing their existing records	copy the local dimension table data to the remote dimension tables, replacing their existing records