When I installed Hive using Homebrew it installed the latest version (0.12.0 by the time), but when I work with Amazon EMR, their AMI comes with Hive 0.11.x. So I had to downgrade the Hive on my local computer.

Sometimes the dataset I had to handle just wasn’t that big nor the original data was available at any other medium but MySQL/RDS. In order to link Hive to other storages its necessary a StorageHandler.

A collection of problems (and solutions) that we’ve faced to implement DynamoDB and Hive.

Useful Hive interactive configuration. Add as file ~/.hiverc: