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 jdcryans@gmail.com designates
 209.85.215.41 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:sender:in-reply-to:references:date
         :x-google-sender-auth:message-id:subject:from:to:content-type
         :content-transfer-encoding;
        b=cadg3LxVmoYjWlKUMSbKcE8v9kK1j+mPYmBGefdqBCJk4HC07rV8tuq0slvmsIldMw
         tlA98IILqkip1THNnjyiwPxKbNJCENUEGYjGxIcKgjg5WCVB5NZmgUhsVFDbnKriLy5I
         OM37D1LZNjBwahH9jOvT+O6cVJUSPnNK3tz6M=
MIME-Version: 1.0
Sender: jdcryans@gmail.com
In-Reply-To: 
 <321C2E54215EEB41A581FDD9DAECBC5DFCD94ACF@IRV1EXMB01.eLiberation.com>
References: <AANLkTikJge3vEaawZHfW+ROMzYD6qWznzW-pemcJL1RJ@mail.gmail.com>
	<AANLkTikD8FT1MHTR-HWaxhGrYxFcw5Ziz3=yC93is5xa@mail.gmail.com>
	<321C2E54215EEB41A581FDD9DAECBC5DFCD94AC7@IRV1EXMB01.eLiberation.com>
	<AANLkTimW7bXKjwagw7dEWgY=5Tc1eeRdQGkw7=VGFV6e@mail.gmail.com>
	<321C2E54215EEB41A581FDD9DAECBC5DFCD94ACF@IRV1EXMB01.eLiberation.com>
Date: Mon, 14 Feb 2011 10:20:07 -0800
Message-ID: <AANLkTim4R9+723+HVzK+QAnsN9rVskp+mdKv8zU4z=4_@mail.gmail.com>
Subject: Re: Truncate tables
From: Jean-Daniel Cryans <jdcryans@apache.org>
To: user@hbase.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Can you enable DEBUG for HBase, run your code, and post the output in
a pastebin?

J-D

On Mon, Feb 14, 2011 at 10:14 AM, Peter Haidinyak <phaidinyak@local.com> wr=
ote:
> Each table is taking 30 seconds. Without looking at the HBase code I assu=
med it was doing the same process as I am. Just quicker.
>
> Thanks
>
> -Pete
>
> -----Original Message-----
> From: jdcryans@gmail.com [mailto:jdcryans@gmail.com] On Behalf Of Jean-Da=
niel Cryans
> Sent: Monday, February 14, 2011 10:12 AM
> To: user@hbase.apache.org
> Subject: Re: Truncate tables
>
> Erm well could it be that your script is truncating a bunch of tables
> whereas in the shell it only does one? Apart from that I can't think
> of anything obvious, the truncate command really does the same thing
> as you.
>
> J-D
>
> On Mon, Feb 14, 2011 at 9:43 AM, Peter Haidinyak <phaidinyak@local.com> w=
rote:
>> Hi,
>> =A0 =A0 =A0 =A0I've setup a little utility to truncate my tables during =
development but I found that if I truncate a table from the HBase shell it =
takes 2.5 seconds, from my program it take 30 seconds. The code to truncate=
 is pretty simple. Any ideas on what I've done wrong?
>>
>> Thanks
>>
>> -Pete
>>
>> =A0private void truncateTables()
>> =A0 =A0throws IOException
>> =A0{
>> =A0 =A0m_hbaseConnection =3D new HbaseConnection();
>> =A0 =A0m_hbaseConnection.setupHBaseConnection();
>> =A0 =A0final HBaseAdmin hBaseAdmin =3D m_hbaseConnection.getAdmin();
>>
>> =A0 =A0int counter =3D 1;
>> =A0 =A0for (final String tableName : CLUSTER_TABLES)
>> =A0 =A0{
>> =A0 =A0 =A0final HTableDescriptor hTableDescriptor =3D hBaseAdmin.getTab=
leDescriptor(tableName.getBytes());
>> =A0 =A0 =A0m_logger.info("Truncating Table {}.",tableName);
>> =A0 =A0 =A0hBaseAdmin.disableTable(tableName);
>> =A0 =A0 =A0hBaseAdmin.deleteTable(tableName);
>> =A0 =A0 =A0hBaseAdmin.createTable(hTableDescriptor);
>> =A0 =A0 =A0m_logger.info("Truncated Table {}.", tableName);
>> =A0 =A0 =A0m_logger.info("Finished {} of {} Tables.", counter++, CLUSTER=
_TABLES.length);
>>
>> =A0 =A0} // - End for each table.
>>
>> =A0} // - End truncateTables Method.
>>
>>
>> =A0public void setupHBaseConnection()
>> =A0 =A0throws IOException
>> =A0{
>> =A0 =A0m_hbaseConfiguration =3D HBaseConfiguration.create();
>> =A0 =A0m_hbaseConfiguration.clear();
>>
>> // - Get the m_hbaseConfiguration properties from the Command line -D pa=
rameters.
>> =A0 =A0m_hbaseConfiguration.set("hbase.zookeeper.quorum", System.getProp=
erty("hbase.zookeeper.quorum"));
>> =A0 =A0m_hbaseConfiguration.set("hbase.zookeeper.property.clientPort", S=
ystem.getProperty("hbase.zookeeper.property.clientPort"));
>>
>> =A0 =A0m_logger.info("Using hbase.zookeeper.quorum : {}", m_hbaseConfigu=
ration.get("hbase.zookeeper.quorum"));
>> =A0 =A0m_logger.info("Using hbase.zookeeper.property.clientPort : {}", m=
_hbaseConfiguration.get("hbase.zookeeper.property.clientPort"));
>>
>> =A0} // - End setupHBaseConnection Method.
>>
>>
>