Re: Indexing array type

2015-06-22 Thread Leon Prouger
That's interesting, I had a similar idea. But first we would like to model the array with two tables, which sound to be simpler. I contact you If I'll have time to work on the issue. On Mon, Jun 22, 2015 at 12:10 AM James Taylor jamestay...@apache.org wrote: Hey Leon, I filed PHOENIX-1544 a

Re: Indexing array type

2015-06-21 Thread Leon Prouger
Hey James, thank you for replying. Yes you're right, this option is pretty useless is our case. We've been thinking to create a separate table which will model the array with one to many relation, then index it and perform join with the main table for every query. Like: Main table: PK(id), data

Re: Indexing array type

2015-06-17 Thread James Taylor
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