I've been working on a pretty simple problem in HIVE for a week or so now and I feel like I am no closer now than I was when I started. It seems like every time I think I have it figured out, something new pops up.