phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: snapshot index when using HBase API for write
Date Wed, 28 Jan 2015 06:54:45 GMT
An index on a view created over an HBase table is not maintained by
Phoenix, as the updates to the table do not go through Phoenix APIs.

If you want to use secondary indexing, your best bet is to use Phoenix
tables, instead of views.

Thanks,
James

On Tue, Jan 27, 2015 at 9:51 PM, Chandu <chandugunturi@gmail.com> wrote:
> Hi,
>
> I am using existing HBase table. Created a view on that table & an index on
> top view.
>
> When I am updating the HBase table using HBase API, I couldn't see updated
> data in corresponding Phoenix view. Also, index isn't updated.
>
> If index is dropped, I can find the updated data in the view after each
> update using HBase API.
>
> My questions are,
> 1, Does the Phoenix uses timestamp (currnetSCN) when it is working on HBase
> table & have index?
> 2, Is there way to get my index updated on the fly rather than manually
> updating the index with update index  command?
>
> --
> Cheers,
> Chandu.

Mime
View raw message