phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Index in Phoenix view on Hbase is not updated
Date Sat, 22 Oct 2016 16:59:29 GMT
Hi Mich,
Phoenix indexes are only updated if you use Phoenix APIs to input the data.
Thanks,
James

On Saturday, October 22, 2016, Ted Yu <yuzhihong@gmail.com> wrote:

> The first statement creates index, not view.
>
> Can you check ?
>
> Cheers
>
> > On Oct 22, 2016, at 1:51 AM, Mich Talebzadeh <mich.talebzadeh@gmail.com
> <javascript:;>> wrote:
> >
> > 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
>

Mime
View raw message