{"id":340,"date":"2016-07-01T17:42:37","date_gmt":"2016-07-01T17:42:37","guid":{"rendered":"http:\/\/data-flair.training\/blogs\/?p=340"},"modified":"2021-05-16T20:33:09","modified_gmt":"2021-05-16T15:03:09","slug":"apache-hive-installation","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/apache-hive-installation\/","title":{"rendered":"Apache Hive Installation – Install Hive on Ubuntu in 5 Minutes"},"content":{"rendered":"

This DataFlair article provides a complete package to Install Hive on Ubuntu\u00a0along with the screenshots.<\/strong><\/p>\n

Hive is a data warehousing infrastructure tool built on the top of Hadoop. This article helps you to start quickly with the Hive by providing guidance about downloading Hive, setting and configuring Hive and launching HiveServer2, and the Beeline Command shell to interact with Hive.<\/p>\n

This article enlists the steps to be followed for Hive 3.1.2 installation on Hadoop 3.1.2 on Ubuntu.<\/p>\n

What is Apache Hive?<\/h3>\n

Apache Hive is a warehouse infrastructure designed on top of Hadoop for providing information summarization, query, and ad-hoc analysis. Hence, in order to get your Hive running successfully, Java and Hadoop ought to be pre-installed and should be functioning well\u00a0on your Linux OS.<\/p>\n

Before installing the Hive, we require dedicated Hadoop installation, up and running with all the Hadoop daemons.<\/p>\n

So, let’s start the Apache Hive Installation Tutorial.<\/p>\n

Apache Hive Installation on Ubuntu<\/h2>\n

Now in order to get Apache Hive installation\u00a0successfully on your Ubuntu system, please follow the below steps and execute them on your Linux OS.<\/p>\n

Here are the steps to be followed for installing Hive 3.1.2 on Ubuntu.<\/p>\n

 <\/p>\n

1. Download Hive<\/h3>\n

Step 1:<\/strong> First, download the Hive 3.1.2 from this link<\/strong>.<\/a><\/p>\n

Step 2:<\/strong> Locate the apache-hive-3.1.2-bin.tar.gz file in your system.<\/p>\n

\"locat<\/a><\/p>\n

Step 3:<\/strong> Extract this tar file using the below command:<\/p>\n

tar -xzf apache-hive-3.1.2-bin.tar.gz<\/pre>\n
\"extract<\/a><\/p>\n
\"extracting<\/a><\/p>\n
2. Configuring Hive files<\/h3>\n
Step 4:<\/strong> Now, we have to place the Hive PATH in .bashrc file. For this, open .bashrc<\/strong> file in the nano editor and add the following in the .bashrc file.<\/p>\n
export HIVE_HOME= \u201chome\/dataflair\/apache-hive-3.1.2-bin\u201d\r\nexport PATH=$PATH:$HIVE_HOME\/bin<\/pre>\n
\"open.bashrcfile<\/a><\/p>\n
\"bashrcfileinstall<\/a><\/p>\n
Note:<\/strong> Here enter the correct name & version of your hive and correct path of your Hive File \u201chome\/dataflair\/apache-hive-3.1.2-bin\u201d this is the path of my Hive File and \u201capache-hive-3.1.2-bin\u201d is the name of my hive file.<\/p>\n
So please enter the correct path and name of your Hive file. After adding save this file.<\/p>\n
Press CTRL+O<\/strong> and enter to save changes. Then press CTRL+D<\/strong> to exit the editor.<\/p>\n
Step 5:<\/strong> Open the core-site.xml<\/strong> file in the nano editor. The file is located in home\/hadoop-3.1.2\/etc\/hadoop\/<\/strong> (Hadoop Configuration Directory).<\/p>\n
Add the following configuration property in the core-site.xml file.<\/p>\n
<configuration>\r\n<property>\r\n<name>hadoop.proxyuser.dataflair.groups<\/name>\r\n<value>*<\/value>\r\n<\/property>\r\n<property>\r\n<name>hadoop.proxyuser.dataflair.hosts<\/name>\r\n<value>*<\/value>\r\n<\/property>\r\n<property>\r\n<name>hadoop.proxyuser.server.hosts<\/name>\r\n<value>*<\/value>\r\n<\/property>\r\n<property>\r\n<name>hadoop.proxyuser.server.groups<\/name>\r\n<value>*<\/value>\r\n<\/property>\r\n<\/configuration><\/pre>\n
\"opencore-site.xmlfile<\/a><\/p>\n
\"core-site.xmlfileinstall<\/a><\/p>\n
Press CTRL+O<\/strong> and enter to save changes. Then press CTRL+D<\/strong> to exit the editor.<\/p>\n
Step 6:<\/strong> Make a directory \u2018tmp\u2019 in HDFS using the below command:<\/p>\n
hadoop fs -mkdir \/tmp<\/pre>\n
\"mkdirtemp<\/a><\/p>\n
Step 6:<\/strong> Use the below commands to create a directory \u2018warehouse\u2019 inside \u2018hive\u2019 directory, which resides in \u2018user\u2019 directory. The warehouse is the location to store data or tables related to Hive.<\/p>\n
hadoop fs -mkdir \/user\r\nhadoop fs -mkdir \/user\/hive\r\nhadoop fs -mkdir \/user\/hive\/warehouse<\/pre>\n
\"mkdirwarehouse<\/a><\/p>\n
\"listinghadoopfiles<\/a><\/p>\n
Step 7:<\/strong> Give the write permission to the members of the \u2018tmp\u2019 file group using command:<\/p>\n
hadoop fs -chmod g+w \/tmp<\/pre>\n
\"givingwritepermissiontotempfile<\/a><\/p>\n
\"listinghadoopfiles<\/a><\/p>\n
Step 8:<\/strong> Now give write permission to the warehouse directory using the command:<\/p>\n
hadoop fs -chmod g+w \/user\/hive\/warehouse<\/pre>\n
\"givingwritepermisiiontowarehousedirectory<\/a><\/p>\n
\"listingHadoopfiles<\/a><\/p>\n
3. Initialize Derby database<\/h3>\n
Step 9:<\/strong> Hive by default uses Derby database<\/strong>. Use the below command to initialize the Derby database.<\/p>\n
bin\/schematool -dbType derby -initSchema<\/pre>\n
\"initializeDerbyDatabase<\/a><\/p>\n
\"Derbyinitializationcomplete<\/a><\/p>\n
4. Launching Hive<\/h3>\n
Step 10:<\/strong> Now start the HiveServer2 using the below command:<\/p>\n
bin\/hiveserver2<\/pre>\n
[For this first move to the ~\/apache-hive-3.1.2-bin\/]<\/p>\n
\"commandtointializehiveserver2<\/a>
\n\"initializinghiveserver2<\/a><\/p>\n
Step 11:<\/strong> On the different tab<\/strong>, type the below command to launch the beeline command shell.<\/p>\n
bin\/beeline -n dataflair -u jdbc:hive2:\/\/localhost:10000<\/pre>\n
\"commandtolaunchbeeline<\/a>
\n\"beelinecommandshell<\/a><\/p>\n
Congratulations!!<\/strong> We have successfully installed Hive 3.1.2 on Ubuntu.<\/p>\n
Now, you can type SQL queries in the Beeline command shell to interact with the Hive system.<\/p>\n
5. Verifying Hive Installation<\/h3>\n
For example<\/strong>, in the below image, I am using show databases<\/strong> query to list out the database in the Hive warehouse.<\/p>\n
\"querytolistdatabases<\/a><\/p>\n
\"listingDatabases<\/a><\/p>\n
We have successfully installed Apache Hive 3.1.2 on Hadoop 3.1.2 on Ubuntu.<\/p>\n
Conclusion<\/h2>\n
Hence, in this Hive installation tutorial, we discussed the process to install Hive on Ubuntu.<\/p>\n
Hive installation Done? <\/strong>Now, master Hive from our article in the left sidebar.<\/p>\n
Still, if you have any confusion related to Hive Installation, ask in the comment tab.<\/p>\n
Keep Learning!!
This DataFlair article provides a complete package to Install Hive on Ubuntu\u00a0along with the screenshots. Hive is a data warehousing infrastructure tool built on the top of Hadoop. This article helps you to start...<\/p>\n","protected":false},"author":7,"featured_media":76603,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26],"tags":[807,5725,22039,22043,16662,22040,22042,22041,22038],"class_list":["post-340","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-hive","tag-apache-hive-installation","tag-hive-installation","tag-hive-installation-on-ubuntu","tag-hive-installation-steps-in-ubuntu","tag-hive-setup","tag-install-apache-hive-on-ubuntu","tag-install-hive-on-hadoop","tag-install-hive-on-hadoop-cluster","tag-install-hive-on-ubuntu"],"yoast_head":"\nApache Hive Installation - Install Hive on Ubuntu in 5 Minutes - DataFlair<\/title>\n<meta name=\"description\" content=\"Apache Hive installation - Learn how to install Hive on Ubuntu, steps to set up Hive, configure Hive, and launch Hive installation on Ubuntu in 5 minutes.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/apache-hive-installation\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Apache Hive Installation - Install Hive on Ubuntu in 5 Minutes - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Apache Hive installation - Learn how to install Hive on Ubuntu, steps to set up Hive, configure Hive, and launch Hive installation on Ubuntu in 5 minutes.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/apache-hive-installation\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-07-01T17:42:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-16T15:03:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Hive-installation.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"802\" \/>\n\t<meta property=\"og:image:height\" content=\"420\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Apache Hive Installation - Install Hive on Ubuntu in 5 Minutes - DataFlair","description":"Apache Hive installation - Learn how to install Hive on Ubuntu, steps to set up Hive, configure Hive, and launch Hive installation on Ubuntu in 5 minutes.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/apache-hive-installation\/","og_locale":"en_US","og_type":"article","og_title":"Apache Hive Installation - Install Hive on Ubuntu in 5 Minutes - DataFlair","og_description":"Apache Hive installation - Learn how to install Hive on Ubuntu, steps to set up Hive, configure Hive, and launch Hive installation on Ubuntu in 5 minutes.","og_url":"https:\/\/data-flair.training\/blogs\/apache-hive-installation\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2016-07-01T17:42:37+00:00","article_modified_time":"2021-05-16T15:03:09+00:00","og_image":[{"width":802,"height":420,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Hive-installation.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/apache-hive-installation\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/apache-hive-installation\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/beb0cab24b7aa54423a3b50e669a9dcd"},"headline":"Apache Hive Installation – Install Hive on Ubuntu in 5 Minutes","datePublished":"2016-07-01T17:42:37+00:00","dateModified":"2021-05-16T15:03:09+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/apache-hive-installation\/"},"wordCount":613,"commentCount":19,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/apache-hive-installation\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Hive-installation.jpg","keywords":["Apache Hive Installation","Hive Installation","Hive installation on Ubuntu","Hive installation steps in Ubuntu","Hive Setup","install Apache Hive on Ubuntu","install Hive on Hadoop","install Hive on Hadoop cluster","install Hive on Ubuntu"],"articleSection":["Hive Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/apache-hive-installation\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/apache-hive-installation\/","url":"https:\/\/data-flair.training\/blogs\/apache-hive-installation\/","name":"Apache Hive Installation - Install Hive on Ubuntu in 5 Minutes - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/apache-hive-installation\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/apache-hive-installation\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Hive-installation.jpg","datePublished":"2016-07-01T17:42:37+00:00","dateModified":"2021-05-16T15:03:09+00:00","description":"Apache Hive installation - Learn how to install Hive on Ubuntu, steps to set up Hive, configure Hive, and launch Hive installation on Ubuntu in 5 minutes.","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/apache-hive-installation\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/apache-hive-installation\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/apache-hive-installation\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Hive-installation.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Hive-installation.jpg","width":802,"height":420,"caption":"Hive installation"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/apache-hive-installation\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Hive Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/hive\/"},{"@type":"ListItem","position":3,"name":"Apache Hive Installation – Install Hive on Ubuntu in 5 Minutes"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/beb0cab24b7aa54423a3b50e669a9dcd","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c322416204232f4dd97ef3901b0a499a5d34d7ba7fe333f4bfe53a907873d293?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c322416204232f4dd97ef3901b0a499a5d34d7ba7fe333f4bfe53a907873d293?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322416204232f4dd97ef3901b0a499a5d34d7ba7fe333f4bfe53a907873d293?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"DataFlair Team specializes in creating clear, actionable content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Backed by industry expertise, we make learning easy and career-oriented for beginners and pros alike.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam3\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/340","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=340"}],"version-history":[{"count":2,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/340\/revisions"}],"predecessor-version":[{"id":95525,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/340\/revisions\/95525"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/76603"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=340"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}