I have a question about partitioning/clustering specs that I'm wondering if anyone had any thoughts about.
So in a cross join (which I am implementing), the result should technically have the clustering spec of both the left and right sides of the join. However, if they are clustered differently, there's no way of currently specifying a clustering spec that is both, say, hash and range clustered. This leads me to two questions:
1. is there a good choice of what side's clustering spec to use in this case?
2. should we modify our clustering specs to allow multiple clustering methods?