How do we remove analytics data from database for a specific time period?
All Supported API Portal versions.
MySQL query to delete analytics records more than 90 days from druid database.
mysql> update portal-druid.druid_segments set used=0 where DATE(end) < DATE(NOW() - INTERVAL 90 DAY);