Hive is great, but it's noted that like most Hadoop things, it's alot better when you have 100 machines than when you have like, 2.