Add spec tests for Hive

This adds spec tests for Hive, which can help find issues with the cookbook early.