The following hash index is distributed implicitly on l_orderkey, the primary index for the base table lineitem, and also stored implicitly in hash order on l_orderkey:
CREATE HASH INDEX line_hidx_4 (l_shipdate) ON lineitem;
This creates an index that is equivalent in structure to the following join index:
CREATE JOIN INDEX line_jidx_4 AS SELECT (l_orderkey), (l_shipdate, lineitem.ROWID) FROM lineitem PRIMARY INDEX (l_orderkey);