Hive2 installation

Recently installed Hive 2.1.1 on Ubuntu 16.04. Maybe not optimal steps, but it worked for me.


1. Download Hive from, unpack archive to folder /opt/hive

2. Copy /opt/hive/conf/hive-default.xml.template to hive-site.xml

Edit hive-site.xml, replace all occurences of ${}/${} with /tmp/hive

3. Hadoop already exists in /opt/hadoop folder.  Hadoop installation steps are here: Start dfs and yarn if are not started yet:

4. To avoid yarn.resourcemanager errors in log, add into /opt/hive/conf/hive-site.xml

5.Run hive

6. Url localhost:10002 should show hive web UI in browser

7. Or try to start beeline client /opt/hive/beeline -u jdbc:hive2://

8. Try language manual


1. I got metastore exception, fixed it with init derby schema and restarted hive

2. Impersonation exception, my fix was to set hive.server2.enable.doAs to false in hive-site.xml



Leave a Reply

Your email address will not be published.