How to install Hive on Windows Operating System?

0 votes
Please help me in installing Hive on Windows. Please mention the steps for the installation.
Feb 26 in Big Data Hadoop by Ritu
1,860 views

1 answer to this question.

0 votes

First, download Hive from the following link:

http://www.apache.org/dyn/closer.cgi/hive/

Next, extract the files. Open command prompt, go to the folder where you have download Hive and run the following command:

$ tar -xvf apache-hive-3.1.1-bin.tar.gz

The file name in the above command might change depending on which version you have downloaded.

Next step is to add Hive path to the environment variable. Open the environment variable window by searching it in the start menu. Next, refer to the following pictures to add path:

image

image

Next step is the configure hive. Go to the hive folder and open the conf folder in it. Now copy the file hive-default.xml.template and paste it and rename the new file to hive-site.xml

Open the hive-site.xml file and find the property

<name>hive.metastore.uris</name>

And make the following changes:

<property>


 <name>hive.metastore.uris</name>


 <value>thrift://<IP address of your host>:9083</value>


 <description>Thrift URI for the remote metastore. Used by metastore client to connect to remote metastore.</description>


  </property>

Replace <IP address of your host> to your IP address.

Done. Hive is installed. To verify the installation, open the command prompt and run the following:

$ hive –help

This command print all the options that can be used with hive. 

answered Feb 26 by Kirti

Related Questions In Big Data Hadoop

0 votes
1 answer

How to install Hadoop on Windows system?

First you need to download Hadoop files. ...READ MORE

answered Feb 20 in Big Data Hadoop by Omkar
• 67,480 points
193 views
+1 vote
1 answer

How to install Kafka on Windows System?

These are the steps to install Kafka ...READ MORE

answered Feb 25 in Big Data Hadoop by Ramya
103 views
0 votes
1 answer

How to install Hadoop on Ubuntu?

You can refer to this blog by ...READ MORE

answered Mar 21, 2018 in Big Data Hadoop by nitinrawat895
• 10,670 points
336 views
0 votes
1 answer

I want to install snappy on Hadoop 1.2.1. How do I do that?

As per Cloudera, if you install hadoop ...READ MORE

answered Dec 11, 2018 in Big Data Hadoop by Frankie
• 9,810 points
71 views
0 votes
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,670 points
2,739 views
0 votes
1 answer

hadoop.mapred vs hadoop.mapreduce?

org.apache.hadoop.mapred is the Old API  org.apache.hadoop.mapreduce is the ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,670 points
289 views
0 votes
10 answers

hadoop fs -put command?

put syntax: put <localSrc> <dest> copy syntax: copyFr ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Aditya
13,573 views
0 votes
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,240 points
995 views
0 votes
1 answer

How to install HBase on Linux?

To install Hbase, you first need the ...READ MORE

answered Feb 27 in Big Data Hadoop by Tanisha
290 views
+2 votes
5 answers

How to transpose/pivot data in hive?

Below is also a way for Pivot SELECT ...READ MORE

answered Oct 12, 2018 in Big Data Hadoop by Rahul
4,722 views