I had the same problem, and it turned out to be network related. I had to add a VPC endpoint for Athena and make sure that port 444 was open. That resolved it for me. Turning on debug level error logging was the key that showed me the full error.