Have you talked to Ray with BRO? I'm not sure what he uses, but it's managed to avoid all of the HiveSQL and other issues.