Install hive on Mac with Homebrew

file2.txt

$ tar zxvf mysql-connector-java-5.1.44.tar.gz
$ sudo cp mysql-connector-java-5.1.44/mysql-connector-java-5.1.44-bin.jar /usr/local/Cellar/hive/2.1.1/libexec/lib/

Step 1

$ brew update
$ brew install hadoop
$ brew install hive
$ brew install mysql

Step 2.txt

# ~/.bashrc
export HADOOP_HOME=/usr/local/Cellar/hadoop/2.8.1
export HIVE_HOME=/usr/local/Cellar/hive/2.1.1/libexec

Step 4.txt

$ cd /usr/local/Cellar/hive/4.1.1/libexec/conf
$ cp hive-default.xml.template hive-site.xml

Step 5.txt

<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:mysql://localhost/metastore</value>
</property>
<property>
  <name>javax.jdo.option.ConnectionDriverName</name>
  <value>com.mysql.jdbc.Driver</value>
</property>
<property>
  <name>javax.jdo.option.ConnectionUserName</name>
  <value>hiveuser</value>
</property>
<property>
  <name>javax.jdo.option.ConnectionPassword</name>
  <value>password</value>
</property>
<property>
  <name>datanucleus.fixedDatastore</name>
  <value>false</value>
</property>
<property>
    <name>hive.exec.local.scratchdir</name>
    <value>/tmp/hive</value>
    <description>Local scratch space for Hive jobs</description>
</property>
<property>
    <name>hive.downloaded.resources.dir</name>
    <value>/tmp/hive</value>
    <description>Temporary local directory for added resources in the remote file system.</description>
</property>
<property>
    <name>hive.querylog.location</name>
    <value>/tmp/hive</value>
    <description>Location of Hive run time structured log file</description>
</property>
<property>
    `<name>hive.metastore.schema.verification</name>`
    <value>false</value>
    <description>Some Description</description>
</property>

Step 6.txt

run the schematool so that hive will use mysql

./schematool -initSchema -dbType mysql 

$hive
hive > show tables;

Step3.txt

start My sql with below command:
  brew services start mysql
$ mysql
mysql> CREATE DATABASE metastore;
mysql> USE metastore;
mysql> CREATE USER 'hiveuser'@'localhost' IDENTIFIED BY 'password';
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,ALTER,CREATE, REFERENCES, INDEX ON metastore.* TO 'hiveuser'@'localhost';

I had to also set the mysql server timezone to UTC via logging into mysql and running SET @@global.time_zone='+00:00';