From dev-return-20018-archive-asf-public=cust-asf.ponee.io@accumulo.apache.org Fri Feb 15 11:25:05 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id AA533180651 for ; Fri, 15 Feb 2019 12:25:04 +0100 (CET) Received: (qmail 16177 invoked by uid 500); 15 Feb 2019 11:25:03 -0000 Mailing-List: contact dev-help@accumulo.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@accumulo.apache.org Delivered-To: mailing list dev@accumulo.apache.org Received: (qmail 16153 invoked by uid 99); 15 Feb 2019 11:25:03 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 15 Feb 2019 11:25:03 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id B0D28C0349 for ; Fri, 15 Feb 2019 11:25:02 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.285 X-Spam-Level: ** X-Spam-Status: No, score=2.285 tagged_above=-999 required=6.31 tests=[RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_PASS=-0.001, SPF_SOFTFAIL=0.972, URIBL_BLOCKED=0.001, URI_HEX=1.313] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id lhYY_22KDKv8 for ; Fri, 15 Feb 2019 11:24:59 +0000 (UTC) Received: from n5.nabble.com (n5.nabble.com [162.253.133.81]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTP id E6B6F5FCD9 for ; Fri, 15 Feb 2019 11:24:58 +0000 (UTC) Received: from n5.nabble.com (localhost [127.0.0.1]) by n5.nabble.com (Postfix) with ESMTP id 7B9FBBACBC58 for ; Fri, 15 Feb 2019 04:21:32 -0700 (MST) Date: Fri, 15 Feb 2019 04:21:32 -0700 (MST) From: Krzysztof Martyn To: dev@accumulo.apache.org Message-ID: <1550229692504-0.post@n5.nabble.com> In-Reply-To: <2eb0b9ae-151e-25bf-416f-26265eaab17b@ccri.com> References: <1550131031334-0.post@n5.nabble.com> <2eb0b9ae-151e-25bf-416f-26265eaab17b@ccri.com> Subject: Re: Delete a range of tablets MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I am actually do that. I am able to calculate which tablets are to be removed and I am doing range major compact, which results in a major compact being run on each tablet server which is caused by balance of the tablet. "deleteRows" API for me works terrible becouse when I delete rows I cann't do ingests neither scans, because they are all queued. Is there any posibility to delete rfile without major compact? Andrew Hulbert-2 wrote > We do this on large tables by setting our own iterator to age things off > based on our key structure but then use compact range to delete specific > days with a cron. > > https://accumulo.apache.org/1.7/apidocs/org/apache/accumulo/core/client/admin/TableOperations.html#compact-java.lang.String-org.apache.hadoop.io.Text-org.apache.hadoop.io.Text-boolean-boolean- > > However, the tables in question have keys that that can be computed from > a date range which is why it works. Then it only compacts (deletes) that > specific date range. > > Since you have the time of arrival in the key you could likely do the > same thing. > > Andrew > > On 2/14/19 2:57 AM, Krzysztof Martyn wrote: >> Hi Accumulo, >> >> I want to make a system that will store data for a certain period of >> time, >> say 2 days, after that time the data should be deleted. >> All time there are ingestion with big amount of new data. >> The key is the time of arrival, and splits are generated every 1s so that >> data from 1s have a separate tablet. >> Is there any possibility to remove a range of tablets without having to >> run >> major compact and merge? >> >> I have tested AgeOffFilter, however, it requires manual launch of the >> major >> compact which almost makes it impossible to scan the database. >> I also have tested BatchDeleter, and deleteRows from tableOperations, >> however, they are even worse than AgeOffFilter. >> >> Krzysztof >> >> >> >> -- >> Sent from: >> http://apache-accumulo.1065345.n5.nabble.com/Developers-f3.html -- Sent from: http://apache-accumulo.1065345.n5.nabble.com/Developers-f3.html