phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Question regarding secondary indexes
Date Sat, 23 Jan 2016 16:37:32 GMT
Hi Venkat,
I believe this issue has been fixed in PHOENIX-2601. Please give our 4.7.0
a try as this fix is included there.
Thanks,
James

On Friday, January 22, 2016, Venkat Raman <vraman@gmail.com> wrote:

> Hi All,
>
> We are using secondary indexes and see the following issue. Consider main
> table ACT with primary key (K1, K2, K3) and column M1 and secondary index
> of form -
>
> CREATE INDEX IF NOT EXISTS act_idx ON ACT(K1, K3, K2);
>
> Then query of the following form gives incorrect results -
>
> select /*+ INDEX(ACT act_idx) */ K1, K2, K3 from ACT where K1 = ? and K3 =
> ? and M1 = ? order by K1,K3 limit 10;
>
> What seems to happen is filter on M1 is applied after the limit is applied
> rather than limit being applied after all the filters have applied. Is this
> an expected issue?
>
> I apologize if this question has been asked before.
>
> Regards,
> Venkat
>

Mime
View raw message