If the AtScale administrator deactivates an aggregate, the aggregate will still be shown in the AtScale Hive database.
This is the expected behavior because if the end-user runs an active query using an aggregate, the aggregate should be available so the question does not fail. For this reason, aggregates will be dropped from the database 48 hours after deactivation.
To check the timeout value from 48 hours to something, we need to update the parameter aggregates.invalid.removalAge and restart the engine.
1. Log into Design Center as an Admin user
2. Navigate to SETTINGS => Engine => Overview
3. Add the parameters and click on save.
4. Restart the engine:
$ /opt/atscale/bin/atscale_service_control restart engine engine: stopped engine: started
5. We can verify the changes by downloading the support bundle and checking the file with config-custom.yaml inside the folder host/<host_name>/engine/config-custom.yaml.