Hive improvements

* performance options for hive quries
* removed superfluous hive conf parameters.
* external hive tables.
* end to end hive testing
so any thermometer spec tests should run sequentially? can we enforce that in thermometer spec?