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. >> >> >> > >
