hive_notifs and hive_notification_cache are duplicates ?
hive_notification_cache is the table actually used for queries, hive_notifs is still used for some processes and has data in it but is not on par with hive_notifcation_cache, we should delete hive_notifs.
for context, hive_notifs has 280 561 rows (containing mostly errors, that don't make their way back to the user), hive_notification_cache has 6 665 411.
(We could also consider renaming hive_notification_cache to hive_notifications to make it clearer that it's not a temporary table)