$ tar zxvf mysql-connector-java-5.1.35.tar.gz $ sudo cp mysql-connector-java-5.1.35/mysql-connector-java-5.1.35-bin.jar /usr/local/Cellar/hive/2.7.1/libexec/lib/
Setup MySQL database
1 2 3 4 5
$ mysql mysql> CREATE DATABASE metastore; mysql> USE metastore; mysql> CREATE USER 'hiveuser'@'localhost' IDENTIFIED BY 'password'; mysql> GRANT SELECT,INSERT,UPDATE,DELETE,ALTER,CREATE ON metastore.* TO 'hiveuser'@'localhost';
Copy hive-default-xml to hive-site.xml
1 2
$ cd /usr/local/Cellar/hive/2.7.1/libexec/conf $ cp hive-default.xml.template hive-site.xml