phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <>
Subject Re: Phoenix Secondary index question
Date Wed, 04 Jan 2017 01:26:47 GMT
Hi Udit,
You'll need to use Phoenix APIs when you update your data if you want
Phoenix to keep you index in sync with your table.

On Tue, Jan 3, 2017 at 1:32 PM, Udit Mehta <> wrote:

> Hi All,
> I am facing an issue while working with secondary indexes on a Phoenix
> view/table that is created on top of an existing Hbase table.
> I basically have an existing Hbase table with a few rows and I then build
> a Phoenix view on this table. This works fine and any updates directly to
> the Hbase table are reflected in the Phoenix view. Now the problem arises
> the moment I create a secondary index on the phoenix table and then update
> the underlying Hbase table. I dont see the updates being reflected in
> either of the Phoenix tables ie the original one and the indexed one.
> Is this behavior or am I missing something?
> Also is it a good idea to have such a design where we update the Hbase
> table directly with a Phoenix table/view created on top of it? We had to
> choose this design due to the backup/snapshot features Hbase provides. I
> could not find any such mechanism in Phoenix so not sure what the best
> approach is here.
> Looking forward to your ideas.
> Thanks in advance,
> Udit

View raw message