Install Hive 2.1.1 and Configure Mysql metastore for Hive
Install Hive 2.1.1 and Configure Mysql metastore for Hive Step 1:- Download Hive 2.1.1 Step 2:- Extract it Step 3:- Download mysql-connector-java-5.1.30 extract it and copy mysql-connector-java-5.1.30- bin.jar to lib directory in Hive step 4:- Delete log4j-slf4j-impl-2.4.1.jar jar file from lib directory which is under apache-hive-2.1.1-bin directory Step 5:- Start Hadoop and create HDFS directories $start-dfs.sh $start-yarn.sh $hdfs dfs -mkdir -p /user/hive/warehouse $hdfs dfs -mkdir -p /tmp/hive Step 6:- Change Dirctory Permissions $hdfs dfs -chmod 777 /tmp/ $hdfs dfs -chmod 777 /user/hive/warehouse $hdfs dfs -chmod 777 /tmp/hive Step 7:- Install mysql $sudo apt-get install mysql-server Step 8:- Create Database Metastore $ mysql -u root -p Enter password: mysql> CREATE DATABASE metastore_db; mysql> USE