Fwd: Error: (state=08000,code=101) while indexing

2014-08-13 Thread yeshwanth kumar
hi Jeffrey, just want to know whether the indexing will start from initial state or will it be resumed from the last checkpoint. thanks, yeshwanth

Re: Error: (state=08000,code=101) while indexing

2014-08-13 Thread Jeffrey Zhong
Hey Yeshwanth, There are two ways to get out of this state is 1) using alter index statement with rebuild option to rebuild index2) (hack way) use hbase client to update index_state to OEa¹ so that the index can be used for queries. In the meantime, I will file a JIRA to log more errors in client

Re: squirrel sql client to connect to phoenix got TimeOutException

2014-08-13 Thread Russell, Bob
What does your URL look like? It should be in the form: jdbc:phoenix [ : [ : ] [ : ] ] e.g. jdbc:phoenix:zookeeper1:2181:/hbase-unsecure Since squirrel typically doesn't have access to hbase-site.xml, you need to specify port and root node if they are not the defaults. I believe the default

Re: Re: Squirrel Sql Client to phoenix

2014-08-13 Thread su...@certusnet.com.cn
Hi, Thanks so much for your reply. The phoenix version used is phoenix-4.0.0-incubating-src. And the Hbase version is Version 0.98.3-hadoop2. I had no idea what the problem is. Looking forward for your reply. CertusNet 赛特斯信息科技股份有限公司 孙福林 Add: 江苏省南京市玄武区玄武大道699-22号18幢 赛特斯大楼 Mobile: 158507103

Re: Squirrel Sql Client to phoenix

2014-08-13 Thread Gabriel Reid
Could you post the version of phoenix that you're using, as well as the version of HBase that you're using on the server? This looks like a mismatch between the version of HBase that Phoenix is built for and the version of HBase running on the server. On Wed, Aug 13, 2014 at 7:21 AM, su...@certusn

squirrel sql client to connect to phoenix got TimeOutException

2014-08-13 Thread su...@certusnet.com.cn
Hi Here is some exception information when I am trying to use squirrel sql client to connect to phoenix. I have no idea why there is such timeout exception. Anybody had ever encountered such problem? I strictly followed the instructions as here: http://phoenix.apache.org/download.html But when