Re: Hbase and Phoenix Performance improvement

2015-07-01 Thread Martin Pernollet
It sounds like you are scanning rather than getting rows based on a known row id. Am I wrong? One thing I am currently trying is to have indexed columns and hot content in one column family and let cold content in another family. It speed up scanning the table when you need to Le mer. 1 juil.

Re: Hbase and Phoenix Performance improvement

2015-07-01 Thread Nishant Patel
HI Puneet/Martin, Thanks for your response. Please see my answer as below. I have not specified any salt bucket. I have created Phoenix View on existing Hbase Table. Can I specify Salt bucket for Phoenix View? After loading Hbase data I alter table to use SNAPPY Compression. Are you talking

RE: Hbase and Phoenix Performance improvement

2015-07-01 Thread Puneet Kumar Ojha
...@gmail.com] Sent: Wednesday, July 01, 2015 4:33 PM To: user@phoenix.apache.org Subject: Re: Hbase and Phoenix Performance improvement HI Puneet/Martin, Thanks for your response. Please see my answer as below. I have not specified any salt bucket. I have created Phoenix View on existing Hbase Table. Can I

Re: Hbase and Phoenix Performance improvement

2015-07-01 Thread James Taylor
*To:* user@phoenix.apache.org *Subject:* Re: Hbase and Phoenix Performance improvement HI Puneet/Martin, Thanks for your response. Please see my answer as below. I have not specified any salt bucket. I have created Phoenix View on existing Hbase Table. Can I specify Salt bucket

RE: Hbase and Phoenix Performance improvement

2015-07-01 Thread Puneet Kumar Ojha
you have used along with the schema you used to create the table. I may help to optimize that. Thanks Puneet. From: Nishant Patel [mailto:nishant.k.pa...@gmail.com] Sent: Wednesday, July 01, 2015 10:26 AM To: user@phoenix.apache.org Subject: Hbase and Phoenix Performance improvement Hi, I am

Re: Hbase and Phoenix Performance improvement

2015-07-01 Thread Anil Gupta
...@gmail.com] Sent: Wednesday, July 01, 2015 4:33 PM To: user@phoenix.apache.org Subject: Re: Hbase and Phoenix Performance improvement HI Puneet/Martin, Thanks for your response. Please see my answer as below. I have not specified any salt bucket. I have created Phoenix View

Re: Hbase and Phoenix Performance improvement

2015-07-01 Thread Nishant Patel
Puneet. *From:* Nishant Patel [mailto:nishant.k.pa...@gmail.com] *Sent:* Wednesday, July 01, 2015 4:33 PM *To:* user@phoenix.apache.org *Subject:* Re: Hbase and Phoenix Performance improvement HI Puneet/Martin, Thanks for your response. Please see my answer as below. I have

Hbase and Phoenix Performance improvement

2015-06-30 Thread Nishant Patel
Hi, I am trying to measure performance for Hbase and Phoenix. I have generated 1000 records per day with combination of Column1 and Column2. I have created 5 different combination for column1 and column2 and created data for 365 days. Total records I have generated 5 * 5 * 365 * 1000 = 9125000