Hey Leon, You can have an array in an index, but it has to be at the end of the PK constraint which is not very useful and likely not what you want - it'd essentially be equivalent of having the array at the end of your primary key constraint.
The other alternative I can think of that may be more useful is to use functional indexing[1] on specific array elements. You'd need to know the position of the element that you're indexing and querying against in advance, though. [1] http://phoenix.apache.org/secondary_indexing.html#Functional_Index On Wed, Jun 17, 2015 at 4:43 AM, Leon Prouger <[email protected]> wrote: > Hey folks, > > Maybe I'm asking too much but I couldn't find a straight answer. Is this > possible to index an array type with Phoenix? > > If I can't does anybody tried any alternatives? Like keeping another table > for the array many to one relation
