accumulo-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aru Sahni <arusa...@gmail.com>
Subject Re: Deleting many rows that match a given criterion
Date Tue, 22 Oct 2013 15:50:47 GMT
You could use a RegEx filter to get the rowids, and then pass them to the
RowDeletingIterator .

~A


On Tue, Oct 22, 2013 at 11:45 AM, Mike Drob <mdrob@mdrob.com> wrote:

> I'm attempting to delete all rows from a table that contain a specific
> word in the value of a specified column. My current process looks like:
>
> accumulo shell -e 'egrep .*EXPRESSION.* -np -t tab -c col' | awk 'BEGIN
> {print "table tab"}; {print "deletemany -f -np -r" $1}; END {print "exit"}'
> > rows.out
> accumulo shell -f rows.out
>
> I tried playing around with scan iterators and various options on
> deletemany and deleterows but wasn't able to find a more straightforward
> way to do this. Does anybody have any suggestions?
>
> Mike
>

Mime
View raw message