Return-Path: 
 <user-return-4253-apmail-accumulo-user-archive=accumulo.apache.org@accumulo.apache.org>
X-Original-To: apmail-accumulo-user-archive@www.apache.org
Delivered-To: apmail-accumulo-user-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 1443D1175B
	for <apmail-accumulo-user-archive@www.apache.org>;
 Mon, 12 May 2014 22:50:51 +0000 (UTC)
Received: (qmail 87574 invoked by uid 500); 12 May 2014 22:24:11 -0000
Delivered-To: apmail-accumulo-user-archive@accumulo.apache.org
Received: (qmail 87363 invoked by uid 500); 12 May 2014 22:24:11 -0000
Mailing-List: contact user-help@accumulo.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@accumulo.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@accumulo.apache.org>
List-Post: <mailto:user@accumulo.apache.org>
List-Id: <user.accumulo.apache.org>
Reply-To: user@accumulo.apache.org
Delivered-To: mailing list user@accumulo.apache.org
Received: (qmail 87228 invoked by uid 99); 12 May 2014 22:24:11 -0000
Received: from Unknown (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 12 May 2014 22:24:11 +0000
X-ASF-Spam-Status: No, hits=-1.0 required=5.0
	tests=RCVD_IN_DNSWL_MED,SPF_PASS,URI_HEX
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of Bob.Thorman@l-3com.com
 designates 128.170.207.112 as permitted sender)
Received: from [128.170.207.112] (HELO smtp4out.l-3com.com) (128.170.207.112)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 12 May 2014 22:24:06 +0000
X-filenames: 
X-filesizes: None
X-filetypes: 
X-ExtLoop1: 1
X-IronPort-AV: E=Sophos;i="4.97,1038,1389744000";
   d="scan'208";a="227062115"
Received: from generichost.l-3com.com (HELO CAS1.Comcept.L-3Com.com)
 ([128.170.184.74])
  by smtp4out.l-3com.com with ESMTP; 12 May 2014 22:23:41 +0000
Received: from MX3.Comcept.L-3Com.com ([169.254.2.179]) by
 CAS1.Comcept.L-3Com.com ([128.170.184.74]) with mapi id 14.03.0174.001; Mon,
 12 May 2014 17:23:41 -0500
From: <Bob.Thorman@l-3com.com>
To: <user@accumulo.apache.org>
Subject: RE: Delete All Data In Table
Thread-Topic: Delete All Data In Table
Thread-Index: AQHPbeZlDZ8wdJCZc0GUUV/0m7LLzJs9BfUwgAB3xICAAAf78A==
Date: Mon, 12 May 2014 22:23:40 +0000
Message-ID: <2E8698DBE7D995488D2F568EDDAF43D81842C80B@MX3.Comcept.L-3Com.com>
References: <1399901021696-9748.post@n5.nabble.com>
 <CAOiJXP7D5gZ85n2F-hPVcpO_3Py3zPD_sPTnZW+X95EN_8BYww@mail.gmail.com>
 <1399905923495-9764.post@n5.nabble.com>
 <1399913675837-9774.post@n5.nabble.com>
In-Reply-To: <1399913675837-9774.post@n5.nabble.com>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
x-originating-ip: [128.170.184.196]
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-Virus-Checked: Checked by ClamAV on apache.org

When/if you do the speed comparison would you mind sharing the results?

-----Original Message-----
From: BlackJack76 [mailto:justin.loy@gmail.com]=20
Sent: Monday, May 12, 2014 5:22 PM
To: user@accumulo.apache.org
Subject: Re: Delete All Data In Table

Josh,

Thanks for the tip!  I was able to delete the data and keep the splits usin=
g the following code:

    String dataTableName =3D "dataTable";
    String iteratorName =3D "devNull";
   =20
    if(conn.tableOperations().exists(dataTableName))=20
    {
      IteratorSetting setting =3D new IteratorSetting(25, iteratorName, Dev=
Null.class);

      EnumSet<IteratorScope> scopes =3D EnumSet.noneOf(IteratorScope.class)=
;
      scopes.add(IteratorScope.minc);
      scopes.add(IteratorScope.majc);
      scopes.add(IteratorScope.scan);

      conn.tableOperations().attachIterator(dataTableName, setting, scopes)=
;
     =20
      conn.tableOperations().compact(dataTableName, null, null, true, true)=
;

      conn.tableOperations().removeIterator(dataTableName, iteratorName, sc=
opes);=20
    }

I haven't tested out the speed yet to see how it compares to BatchDeleter b=
ut it definitely works.  Thanks for your help!





--
View this message in context: http://apache-accumulo.1065345.n5.nabble.com/=
Delete-All-Data-In-Table-tp9748p9774.html
Sent from the Users mailing list archive at Nabble.com.