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 |
Invokes a hash function to determine the distribution properties of the partitions.
Specifies that the distribution scheme depends on a binary tree.
create table sashdat.transactions{OPTIONS partition=(cust_id, year) hash=yes}
as select * from someschema.sometable;