updated hive cleaning queries