Specifies one or more column names to use in the DISTRIBUTE ON clause of the CREATE TABLE statement.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Category: | Data Set Control |
| Alias: | DISTRIBUTE= |
| Default: | none |
| Data source: | Netezza |
Table of Contents
specifies one or more DBMS column names. Separate multiple column names with commas.
specifies that data is distributed evenly. The Netezza Performance Server does this across all SPUs. This is known as round-robin distribution.
You can use this option to specify a column name to use in the DISTRIBUTE ON= clause of the CREATE TABLE statement. Each table in the database must have a distribution key that consists of one to four columns. If you do not specify this option, the DBMS selects a distribution key.
proc sql;
create table netlib.customtab(DISTRIBUTE_ON='partno')
as select partno, customer, orderdat from saslib.orders;
quit;For more than one column, separate the columns with commas.
data netlib.mytab(DISTRIBUTE_ON='col1,col2');
col1=1;col2=12345;col4='mytest';col5=98.45;
run;data netlib.foo(distribute_on=random);
mycol1=1;mycol2='test';
run;