If I update the phoenix to 3.3.1 and keep hbase on 0.94.27, the 'REBUID' action will be a little quickly? or , it will run backgroud?
2015-08-19 11:49 GMT+08:00 James Taylor <[email protected]>: > Other than upgrading, my advice would be: > - set your time outs very high when rebuilding your index to prevent time > outs (phoenix.query.timeoutMs on the client side and > hbase.regionserver.lease.period on the server side). > - query the system table (either SYSTEM."TABLE" or SYSTEM.CATALOG) to > check on the status of an index: > SELECT index_state FROM SYSTEM."TABLE" WHERE tenant_id is null AND > table_schem=<your table schema> AND table_name=<your table name> > > Not sure if tenant_id was defined before or after 2.2.3, but just remove > that clause if it's not defined. > > Thanks, > James > > On Tue, Aug 18, 2015 at 8:38 PM, 刘春珲 <[email protected]> wrote: > >> Agreed. >> >> But, It's a existing system. I have not more time to upgrade it. I need >> to make it online asap, then I will update to a new version of Phoenix and >> Hbase. >> >> Is there any suggestions? >> >> Thanks, >> Chunhui >> >> 2015-08-19 11:32 GMT+08:00 James Taylor <[email protected]>: >> >>> I'd recommend updating to a new version of Phoenix and HBase. The >>> Phoenix 2.2.3 release is about 1.5 years old and there are probably more >>> than 400 bug fixes between then and now (not to mention many performance >>> improvements and tons of new features). >>> Thanks, >>> James >>> >>> On Tue, Aug 18, 2015 at 8:20 PM, 刘春珲 <[email protected]> wrote: >>> >>>> Hi, >>>> recently, one of my table's index does not work any more. So, I try to >>>> rebuild it. >>>> >>>> ' alter index my_index on my_table rebuild' >>>> >>>> after few hours rebuilding, index always does not work. >>>> >>>> So, I want to know, How to check the index's status. and how to fix >>>> this problem. >>>> >>>> btw, I created a new table with the index, it does work. >>>> >>>> Phoneix: 2.2.3 >>>> Hbase: 0.94.27 >>>> Hadoop: cdh4.5.0 >>>> >>>> Thanks >>>> >>>> >>> >> >
