The following hash index is distributed on its primary index o_custkey and stored in row-hash order on o_custkey:
CREATE HASH INDEX ord_hidx_2 (o_custkey) ON orders BY (o_custkey) ORDER BY HASH (o_custkey);
This creates an index that is equivalent in structure to the following join index:
CREATE JOIN INDEX ord_jidx_2 AS SELECT (o_custkey), (o_orderkey, orders.ROWID) FROM orders PRIMARY INDEX (o_custkey);