purge

Removes the data records within the specified date range from the table. Administrative privileges are required to execute this command.

Note
This command is only available if you add the -Daraqne.logdb.purge=enabled switch as a Logpresso boot option.

Syntax

purge from=yyyyMMdd to=yyyyMMdd TABLE, ...
Required Parameters
from=yyyyMMdd
Start date of the first record to be discarded in the form of yyyyMMdd. The command discards all the records within the specified period including the start date.
to=yyyyMMdd
End date of the last record to be discarded in the form of yyyyMMdd. The command discards all the records within the specified period including the end date.
TABLE, ...
Tables for which data is to be discarded, separated by a comma (,). This is used when you want to discard old data and provide new data each time you execute a query.

Usage

Discard sample table data on September 10, 2014, and September 11, 2014

purge from=20140910 to=20140911 sample