Data analysis using Hive script

Dear Viewers,

This post will help you to run hive script on hive table. Hive script is made for below given title.

Hive script can be saved with the extension '.hql' or '.sql' . Copy paste the below code in a file "HiveScript.hql". In hive script, single line comment is given by '--'.

Hive installation and configuration

Dear Viewers,

This post will help you to setup and configure hive on Hadoop and Fedora 17


Introduction:
Apache Hive is a data warehouse architecture which is built on top of Hadoop. Many people refers Hive as Hadoop ecosystem. Hive is useful to perform data summerization and data analysis. Hive supports SQL like language which is called as Hive Query Language (HQL).

Basic Hive Queries

Dear Viewers,

This post will help you to execute basic queries on Hive.

Operations performed are:
1. Create database
2. Create tables
3. Alter table
4. Drop table
5. Drop database

First Hive script on Hadoop cluster

Dear Viewers,

This post will help you to write and execute your first Hive script from Linux terminal. Before we go ahead, you have to start hadoop. You can start it by calling start-all.sh file available in hadoop directory. To run Hive script, you must have Hive directory available on your system.

In my case I have hadoop available at /usr/local/hadoop-2.6.0 and Hive at /usr/local/hive-0.11.0