Hi David,
Apologies I missed the fact that the column needed to be part of the PK to be used for partitioning.
Regarding the use of ARRAYs, I realised there was some ambiguity there.
One possible use of ARRAYs would be to replace columns like d1, d2, and d3 with a single d column defined as an ARRAY.
A different use of ARRAYs would be what is described in Optimizing storage for historic time-series data - Tutorials - CrateDB Community , you may find the approach described in that article interesting if it is something you had not seen before.
1 Like