Mailing-List: contact user-help@accumulo.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@accumulo.apache.org
Received-SPF: pass (nike.apache.org: domain of spines83@gmail.com designates
 74.125.82.169 as permitted sender)
MIME-Version: 1.0
Date: Wed, 9 May 2012 10:31:46 -0400
Message-ID: 
 <CALog2MRtGZbQNCVa4HKc2ZO0YqRVgpL62OAXzUjUYy478pJrVQ@mail.gmail.com>
Subject: Deleting rows from the Java API
From: Sean Pines <spines83@gmail.com>
To: user@accumulo.apache.org
Content-Type: multipart/alternative; boundary=f46d043be272f3b33004bf9b5cb9

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

*<http://accumulo.apache.org/1.4/apidocs/org/apache/accumulo/core/client/admin/TableOperations.html#deleteRows%28java.lang.String,%20org.apache.hadoop.io.Text,%20org.apache.hadoop.io.Text%29>
*I have a use case that involves me removing a record from Accumulo based
on the Row ID and the Column Family.

In the shell, I noticed the command "deletemany" which allows you to
specify column family/column qualifier. Is there an equivalent of this in
the Java API?

In the Java API, I noticed the method:
deleteRows(String tableName, org.apache.hadoop.io.Text start,
org.apache.hadoop.io.Text end)
         Delete rows between (start, end]

However that only seems to work for deleting a range of RowIDs

I would also imagine that deleting rows is costly; is there a better way to
approach something like this?
The workaround I have for now is to just overwrite the row with an empty
string in the value field and ignore any entries that have that. However
this just leaves lingering rows for each "delete" and I'd like to avoid
that if at all possible.

Thanks!

--f46d043be272f3b33004bf9b5cb9
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<font style=3D"font-family:arial black,sans-serif" size=3D"2"><code><b><a h=
ref=3D"http://accumulo.apache.org/1.4/apidocs/org/apache/accumulo/core/clie=
nt/admin/TableOperations.html#deleteRows%28java.lang.String,%20org.apache.h=
adoop.io.Text,%20org.apache.hadoop.io.Text%29"></a></b></code></font><font =
style=3D"font-family:arial black,sans-serif" size=3D"2">I have a use case t=
hat involves me removing a record from Accumulo based on the Row ID and the=
 Column Family.<br>
<br>In the shell, I noticed the command &quot;deletemany&quot; which allows=
 you to specify column family/column qualifier. Is there an equivalent of t=
his in the Java API?<br><br>In the Java API, I noticed the method:<br>delet=
eRows(String tableName, org.apache.hadoop.io.Text start, org.apache.hadoop.=
io.Text end)<br>
=A0=A0=A0=A0=A0=A0=A0=A0 Delete rows between (start, end]<br><br>However th=
at only seems to work for deleting a range of RowIDs<br><br>I would also im=
agine that deleting rows is costly; is there a better way to approach somet=
hing like this? <br>
The workaround I have for now is to just overwrite the row with an empty st=
ring in the value field and ignore any entries that have that. However this=
 just leaves lingering rows for each &quot;delete&quot; and I&#39;d like to=
 avoid that if at all possible.<br>
<br>Thanks!<br></font>

--f46d043be272f3b33004bf9b5cb9--