You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Chandu <ch...@gmail.com> on 2015/01/28 06:51:07 UTC
snapshot index when using HBase API for write
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.
Re: snapshot index when using HBase API for write
Posted by James Taylor <ja...@apache.org>.
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 <ch...@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.