A molecular absorption line survey towards the AGN of Hydra-A