Optimization of Hive