Partitioning is available
only when you create tables.
Partition keys are derived
based on formatted values in the order of the column names in the
column-list.
All of the rows with the same partition key are stored in a single
block. This ensures that all the data for a partition is loaded into
memory on a single machine in the cluster. The blocks are replicated
according to the default replication factor or the value that you
specify in the COPIES= table option.
The partitioning columns,
whether they are numeric or character, are formatted by applying SAS
formatting rules.
For more information, see FedSQL Formats. If user-defined formats are used,
then the format name is stored with the table, but not the format.
The format for the column must be available to the SAS LASR Analytic
Server when the table is loaded into memory.
The key construction
is not hierarchical. That is, PARTITION=(A, B) implies that any unique
concatenation of formatted values for columns A and B defines a partition.
There is no ordering
of the rows within a partition. You can create ordering within a partition
by specifying the ORDERBY= option.