hi:
   I'm working on phoenix-4.7-hbase-1.1  on hbase-1.1.3.


1. I have a hbase table :    create 'test', 'cf'

2. then create phoenix view create view "test" (pk varchar primary key, "cf"."column").

for now, everything works fine, I put data through hbase shell: put 'test', 'row1', 'cf:column', 'value1'
I can select it from phoenix sqlline.


3. I create secondary index on phoenix view. create index idx on "test" ("cf"."column");

Now comes the problem:

*every thing updates with hbase is no longer sync to view or index.*

put 'test', 'row2', 'cf:column', 'value2'
put 'test', 'row3', 'cf:column', 'value3'

I can't select row2/row3 from view or index, there is only one row before the index was created.

Can anyone explain why this happens?

Reply via email to