Hi Mich, No, if you update HBase directly, the index will not be maintained. Actually I would suggest to ingest data using Phoenix CSV bulk load.
Thanks, Sergey. On Sat, Oct 22, 2016 at 12:49 AM, Mich Talebzadeh <mich.talebza...@gmail.com > wrote: > Thanks Sergey, > > In this case the phoenix view is defined on Hbase table. > > Hbase table is updated every 15 minutes via cron that uses > org.apache.hadoop.hbase.mapreduce.ImportTsv to bulk load data into Hbase > table, > > So if I create index on my view in Phoenix, will that index be maintained? > > regards > > Dr Mich Talebzadeh > > > > LinkedIn * > https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw > <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* > > > > http://talebzadehmich.wordpress.com > > > *Disclaimer:* Use it at your own risk. Any and all responsibility for any > loss, damage or destruction of data or any other property which may arise > from relying on this email's technical content is explicitly disclaimed. > The author will in no case be liable for any monetary damages arising from > such loss, damage or destruction. > > > > On 21 October 2016 at 23:35, Sergey Soldatov <sergeysolda...@gmail.com> > wrote: > >> Hi Mich, >> >> It's really depends on the query that you are going to use. If conditions >> will be applied only by time column you may create index like >> create index I on "marketDataHbase" ("timecreated") include ("ticker", >> "price"); >> If the conditions will be applied on others columns as well, you may use >> create index I on "marketDataHbase" ("timecreated","ticker", "price"); >> >> Index is updated together with the user table if you are using phoenix >> jdbc driver or phoenix bulk load tools to ingest the data. >> >> Thanks, >> Sergey >> >> On Fri, Oct 21, 2016 at 4:43 AM, Mich Talebzadeh < >> mich.talebza...@gmail.com> wrote: >> >>> >>> >>> Hi, >>> >>> I have a Phoenix table on Hbase as follows: >>> >>> [image: Inline images 1] >>> >>> I want to create a covered index to cover the three columns: ticker, >>> timecreated, price >>> >>> More importantly I want the index to be maintained when new rows are >>> added to Hbase table. >>> >>> What is the best way of achieving this? >>> >>> Thanks >>> >>> Dr Mich Talebzadeh >>> >>> >>> >>> LinkedIn * >>> https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw >>> <https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>* >>> >>> >>> >>> http://talebzadehmich.wordpress.com >>> >>> >>> *Disclaimer:* Use it at your own risk. Any and all responsibility for >>> any loss, damage or destruction of data or any other property which may >>> arise from relying on this email's technical content is explicitly >>> disclaimed. The author will in no case be liable for any monetary damages >>> arising from such loss, damage or destruction. >>> >>> >>> >> >> >
