Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: pass (nike.apache.org: domain of ananthu2050@gmail.com
 designates 209.85.217.169 as permitted sender)
MIME-Version: 1.0
From: AnandaVelMurugan Chandra Mohan <ananthu2050@gmail.com>
Date: Fri, 29 Jun 2012 11:50:33 +0530
Message-ID: 
 <CAKJYuqHZHwbcC_ww37Twofbs72Cr+K23nSm8WYW-voU3hY0T9w@mail.gmail.com>
Subject: ways to improve performance of Scan with
 SingleColumnValueFilter..Please
 help!!!
To: user@hbase.apache.org
Content-Type: multipart/alternative; boundary=e89a8f2346ff50da4404c396739a

--e89a8f2346ff50da4404c396739a
Content-Type: text/plain; charset=ISO-8859-1

Hi,

I am using HBase client API to access HBase. My HBase version is 0.92.1 and
I have three nodes in my Hadoop cluster. Two nodes are in US and one node
in India. HBase master is in one of the node in US.

In this HBase set up, I have a table with 1200+ rows. I am developing a web
application which uses HBase client java API to retrieve data  from this
table. This is a GWT web application deployed in JBoss (running in a server
farm in India). When I retrieve data from Hbase table based on a column
value, it takes 6 mins. In code, I am doing a scan on table with
"SingleColumnValueFilter". Given the number of rows, this performance is
very bad (6 mins for 1200 records). Is there any way to improve the
performance?

Any help would be greatly appreciated.

-- 
Regards,
Anand

--e89a8f2346ff50da4404c396739a--