I had not heard about Pycharm before last week.
It's free, just download the community version. For the likes of us it has everything we need.
Second, I am also seeking to change my career path in middle age.
Yes, need must.. I have to do something about it. @steddyman has been badgering me to do it for a while.
So, thank you for sharing and I definitely will benefit a lot from your future sharing.
Get the BEEM library installed, there's a lot of HIVE stuff you can do with that.