Hive improvements

* performance options for hive quries
* removed superfluous hive conf parameters.
* external hive tables.
* end to end hive testing
why is this necessary?