index creation partly succeeds if it times out

I just tried to create an index on a column for a table with 200M rows. Creating the index timed out: 0: jdbc:phoenix:172.31.31.143> CREATE INDEX idx_lastname ON loadtest.testing (lastname); Error: Operation timed out (state=TIM01,code=6000) java.sql.SQLTimeoutException: Operation

Re: index creation partly succeeds if it times out

Hi James, You can drop the partially created index and try following steps 1) Add the following property to hbase-site.xml at phoenix client side. phoenix.query.timeoutMs double of default value 2) Export the HBASE_CONF_PATH with the configuration directory where hbase-site.xml present. 3)

Re: index creation partly succeeds if it times out

James, It should be in building state. Can you check what's the state of it? Thanks, Rajeshbabu. On Fri, Sep 11, 2015 at 4:04 PM, James Heather wrote: > Hi Rajeshbabu, > > Thanks--yes--I've done that. I'm now recreating the index with a long > timeout. > > I

Re: index creation partly succeeds if it times out

Ah, too late, I'm afraid. I dropped it. James On 11/09/15 11:41, rajeshb...@apache.org wrote: James, It should be in building state. Can you check what's the state of it? Thanks, Rajeshbabu. On Fri, Sep 11, 2015 at 4:04 PM, James Heather

Re: index creation partly succeeds if it times out

Hi Rajeshbabu, Thanks--yes--I've done that. I'm now recreating the index with a long timeout. I reported it because it seemed to me to be a bug: Phoenix thinks that the index is there, but it's not. It ought to get cleaned up after a timeout. James On 11/09/15 11:32,