I've used @hivesql a lot as it's such an easy way to query Hive. I have various scripts on Github. The performance is pretty good. With my #BritList I was using beem to fetch some details, but I changed it all to HiveSQL and it was many times quicker.