Hi , I am testing retention period in realtime as well as offline table , with “retentionTimeValue”: 1 and “retentionTimeUnit”: “HOURS”. In that case , data should be deleted after 1 hour from this table . But I can see the data still after 2 hours

pinot retention manager kicks off by default 6 hours I think you can config it in controller: See here : https://docs.pinot.apache.org/configuration-reference/controller#periodic-tasks-configuration

Thanks Xiang