Apache Hive Installation on Ubuntu

Apache Hive Installation on Ubuntu
In this blog, we will learn about Apache Hive and Hive installation on Ubuntu.
What is Apache Hive?
Apache Hive is a data warehouse infrastructure that facilitates querying and managing large data sets which resides in distributed storage system. It is built on top of Hadoop and developed by Facebook. Hive provides a way to query the data using a SQL-like query language called HiveQL(Hive query Language).
Internally, a compiler translates HiveQL statements into MapReduce jobs, which are then submitted toHadoop framework for execution.
Difference between Hive and SQL:
Hive looks very much similar like traditional database with SQL access. However, because Hive is based onHadoop and MapReduce operations, there are several key differences:
As Hadoop is intended for long sequential scans and Hive is based on Hadoop, you would expect queries to have a very high latency. Itmeans that Hive would not be appropriate for those applications that need very fast response times, as you can expect with a traditional RDBMS database.
Finally, Hive is read-based and therefore not appropriate for transaction processing that typically involves a high percentage of write operations.
Hive Installation on Ubuntu:
Please follow the below steps to install Apache Hive on Ubuntu:
Step 1:  Download Hive tar.
Command: wget

Step 2:  Extract the tar file.
Command: tar -xzf apache-hive-2.1.0-bin.tar.gz
Command: ls

Step 3: Edit the “.bashrc” file to update the environment variables for user.
Command:  sudo gedit .bashrc
Add the following at the end of the file:
export HIVE_HOME=/home/dsac/apache-hive-2.1.0-bin
export PATH=$PATH:/home/dsac/apache-hive-2.1.0-bin/bin

Also, make sure that hadoop path is also set.
Run below command to make the changes work in same terminal.
Command: source .bashrc
Step 4: Check hive version.
Step 5:  Create Hive directories within HDFS. The directory ‘warehouse’ is the location to store the table or data related to hive.
  • hdfs dfs -mkdir -p /user/hive/warehouse
  • hdfs dfs -mkdir /tmp
Step 6: Set read/write permissions for table.
In this command, we are giving write permission to the group:
  • hdfs dfs -chmod g+w /user/hive/warehouse

  • hdfs dfs -chmod g+w /tmp
Step 7:  Set Hadoop path in
Command: cd apache-hive-2.1.0-bin/
Command: gedit conf/
Set the parameters as shown in the below snapshot.
Step 8: Edit hive-site.xml
Command: gedit conf/hive-site.xml
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?><!--
Licensed to the Apache Software Foundation (ASF) under one or more
contributor license agreements. See the NOTICE file distributed with
this work for additional information regarding copyright ownership.
The ASF licenses this file to You under the Apache License, Version 2.0
(the "License"); you may not use this file except in compliance with
the License. You may obtain a copy of the License at

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
See the License for the specific language governing permissions and
limitations under the License.
JDBC connect string for a JDBC metastore.
To use SSL to encrypt/authenticate the connection, provide database-specific SSL flag in the connection URL.
For example, jdbc:postgresql://myhost/db?ssl=true for postgres database.
<description>location of default database for the warehouse</description>
<description>Thrift URI for the remote metastore. Used by metastore client to connect to remote metastore.</description>
<description>Driver class name for a JDBC metastore</description>
<description>class implementing the jdo persistence</description>
Step 9: By default, Hive uses Derby database. Initialize Derby database.
Command: bin/schematool -initSchema -dbType derby
Step 10: Launch Hive.
Command: hive
Step 11: Run few queries in Hive shell.
Command: show databases;
Command: create table employee (id string, name string, dept string) row format delimited fields terminated by ‘\t’ stored as textfile;
Command: show tables;

Step 12: To exit from Hive:
Command: exit; / quit;

1 comment: