Re: Slow metadata update queries during upsert

2016-03-28 Thread James Taylor
Hi Ankur, Try setting the UPDATE_CACHE_FREQUENCY on your table (4.7.0 or above) to prevent the client from checking with the server on whether or not your table metadata is up to date. See here[1] for more information. You can issue a command like this which will hold on to your metadata on the

Re: Slow metadata update queries during upsert

2016-03-28 Thread Ankur Jain
org<mailto:user@phoenix.apache.org>> Subject: Slow metadata update queries during upsert Hi We are using phoenix as our transactional data store(though we are not yet using its latest transaction feature yet). Earlier we had our own custom query layer built on top of hbase that we are

Slow metadata update queries during upsert

2016-03-28 Thread ankur jain
Hi  We are using phoenix as our transactional data store(though we are not yet using its latest transaction feature yet). Earlier we had our own custom query layer built on top of hbase that we are trying to replace. During tests we found that inserts are very slow as compared to regular hbase

Slow metadata update queries during upsert

2016-03-28 Thread ankur jain
Hi  We are using phoenix as our transactional data store(though we are not yet using its latest transaction feature yet). Earlier we had our own custom query layer built on top of hbase that we are trying to replace. During tests we found that inserts are very slow as compared to regular