HASH= Table Option

Specifies that when partitioning data, the distribution of partitions is not determined by a tree, but by a hashing algorithm.

Category: Table Control
Default: NO
Interaction: Valid only with the PARTITION= table option.
Data source: SASHDAT file

Syntax

PARTITION=(column-list) HASH=[YES | NO]

Arguments

YES

Invokes a hash function to determine the distribution properties of the partitions.

NO

Specifies that the distribution scheme depends on a binary tree.

Details

Specifying HASH=YES is recommended when you work with high-cardinality partition keys (in the order of millions of partitions). When HASH=YES is used, the partitions are not as balanced, but result in lower memory usage.

Example

create table sashdat.transactions{OPTIONS partition=(cust_id, year) hash=yes}
as select * from someschema.sometable;

See Also

Table Options:
Last updated: February 23, 2017