The following hash index is distributed on its primary index o_orderdate and stored in value order on o_orderdate.
CREATE HASH INDEX ord_hidx_1 (o_orderdate) ON orders BY (o_orderdate) ORDER BY (o_orderdate);
You could also specify ORDER BY VALUES instead of ORDER BY.
Note that the ORDER BY column list complies with the rules that it be limited to a single column, that the column must be in the column_name_1 list, must be a numeric type, and must be four or fewer bytes.
This creates an index that is equivalent in structure to the following single-table join index:
CREATE JOIN INDEX ord_jidx_1 AS SELECT (o_orderdate), (o_orderkey, orders.ROWID) FROM orders ORDER BY o_orderdate PRIMARY INDEX (o_orderdate);