Removes the data records within the specified date range from the table. Administrative privileges are required to execute this command.
This command is only available if you add the -Daraqne.logdb.purge=enabled switch as a Logpresso boot option.
purge from=yyyyMMdd to=yyyyMMdd TABLE, ...
- 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.
- 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.
- 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.
Discard sample table data on September 10, 2014, and September 11, 2014
purge from=20140910 to=20140911 sample