RE: Slow queries after massive deletions. Is it due to compaction?

2018-11-26 Thread Sergejs Andrejevs
Got it, thanks a lot for the links. We’ll go with the upgrade option. Kind Regards, Sergejs Andrejevs From: William Berkeley [mailto:wdberke...@cloudera.com] Sent: Monday, November 26, 2018 8:13 AM To: user@kudu.apache.org Subject: Re: Slow queries after massive deletions. Is it due

Re: Slow queries after massive deletions. Is it due to compaction?

2018-11-25 Thread William Berkeley
Hi Sergejs. You are correct. Kudu tracks deletes as a past data plus a "redo" that contains delete operations. The base data and the redos are stored on disk separately and are logically reconciled on scan. Brock is right that this situation is improved greatly for certain deletion patterns with

Slow queries after massive deletions. Is it due to compaction?

2018-11-22 Thread Sergejs Andrejevs
Hi, Is there a way to call of MajorDeltaCompactionOp for a table/tablet/rowset? We've faced with an issue: 0. Kudu table is created 1. Data is inserted there 2. Run select query - it goes fast (matter of a few seconds) 3. Delete all data from the table (but not