Did you get any answers? I rarely ask as there's general no response!

There are only a select few that know how to do all this.

My script is written in Python but I do use a single call to HIVE-SQL for one function, the rest are resolved using the Condenser API and just one I think BEEM... as I can't figure it out any other way.

Chat is useful to some degree, but as HIVE is hardly popular it fails to get a lot of routines and if it does.. doesn't do it very well. I have used it, but need to tinker with the code to get it to work.