Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 1) Extract Hadoop as hadoop-2.9.1
- 2) Extract Hive inside Hadoop Directory
- 3) Set JAVA_HOME to JDK installation folder
- 4) Set HADOOP_HOME to hadoop extracted directory
- 5) Set HIVE_HOME to hive extracted directory
- 6) Add $HIVE_HOME/bin to PATH env var
- 7) Verify MySQL installation
- 8) Create hive-site.xml inside $HIVE_HOME/conf directory and put contents as given below
- <?xml version="1.0" encoding="UTF-8" standalone="no"?>
- <?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
- <configuration>
- <property>
- <name>javax.jdo.option.ConnectionURL</name>
- <value>jdbc:mysql://localhost/metastore?useSSL=false</value>
- </property>
- <property>
- <name>javax.jdo.option.ConnectionDriverName</name>
- <value>com.mysql.jdbc.Driver</value>
- </property>
- <property>
- <name>javax.jdo.option.ConnectionUserName</name>
- <value>root</value>
- </property>
- <property>
- <name>javax.jdo.option.ConnectionPassword</name>
- <value>2010ottawa</value>
- </property>
- <property>
- <name>datanucleus.autoCreateSchema</name>
- <value>true</value>
- </property>
- <property>
- <name>datanucleus.fixedDatastore</name>
- <value>true</value>
- </property>
- <property>
- <name>datanucleus.autoCreateTables</name>
- <value>True</value>
- </property>
- 9) Change properties inside $HIVE_HOME/conf/hive-site.xml as required
- 10) $HIVE_HOME/bin/schematool -initSchema -dbType mysql
Add Comment
Please, Sign In to add comment