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;