There is some limited indexing you can do on an array by creating a
functional index for a particular array element. For example:
CREATE TABLE T (K VARCHAR PRIMARY KEY, A BIGINT ARRAY);
CREATE INDEX IDX ON T (A[3]);
In this case, the following query would use the index:
SELECT K FROM T WHERE A[3] = 5;
Does this help for your usage?
Thanks,
James
On Tue, Jan 5, 2016 at 2:51 PM, Kumar Palaniappan <
[email protected]> wrote:
>
>
> We have a table with a data type BIGINT[], Since phoenix doesnt support to
> index this data type, our queries are doing a full table scan when we have
> to do filtering on this field.
>
> What are the alternate approaches? Tried looking into Views, but nope.
>
> Appreciate your time.
>
> Kumar
>