Hi,
I have a Hbase table that is populated via
org.apache.hadoop.hbase.mapreduce.ImportTsv
through bulk load ever 15 minutes. This works fine.
In Phoenix I created a view on this table
jdbc:phoenix:rhes564:2181> create index marketDataHbase_idx on
"marketDataHbase" ("price_info"."ticker", "price_info"."price",
"price_info"."timecreated");
This also does what is supposed to do and shows correct count.
I then created an index in Phoenix as below
create index index_dx1 on "marketDataHbase"
("price_info"."timecreated","price_info"."ticker", "price_info"."price");
that showed the records OK at that time. I verified this using explain
0: jdbc:phoenix:rhes564:2181> explain select count(1) from
"marketDataHbase";
+---------------------------------------------------------+
| PLAN |
+---------------------------------------------------------+
| CLIENT 1-CHUNK PARALLEL 1-WAY FULL SCAN OVER INDEX_DX1 |
| SERVER FILTER BY FIRST KEY ONLY |
| SERVER AGGREGATE INTO SINGLE ROW |
+---------------------------------------------------------+
Now the issue is that the above does not show new data since build in Hbase
table unless I do the following:
0: jdbc:phoenix:rhes564:2181> alter index INDEX_DX1 on "marketDataHbase"
rebuild;
Which is not what an index should do (The covered index should be
maintained automatically).
The simple issue is how to overcome this problem?
As I understand the index in Phoenix ia another file independent of the
original phoenix view so I assume that this index file is not updated for
one reason or other?
Thanks
