Learn everything about Analytics

Accessing Hadoop Data Using Hive – Version 1 – Big Data University

Big Data University
0-6 Month Online
Beginner Any Time
Online Big Data
Online Self Paced 1569


[su_tab title = “Description”]

Writing map/reduce programs to analyze your Big Data can get complex. Hive can help make querying your data much easier. Apache Hive, first created at Facebook, is a data warehouse system for Hadoop that facilitates easy data summarization, ad-hoc queries, and the analysis of large datasets stored in Hadoop compatible file systems. Hive provides a mechanism to project structure onto this data and query the data using a SQL-like language called HiveQL.


[su_tab title = “Program Structure”]

Course Syllabus:
  • Understand what Apache Hive is, the Hive architecture, and Hive use cases.
  • Make basic configuration changes in a Hive installation.
  • Use DDL to create new Hive databases and tables with a variety of different data types.
  • Create partitioned tables that are optimized for hadoop.
  • Create and run a variety of useful DML queries against Hive.
  • Use built in Hive operators and functions to get work done.
  • Create your own user defined functions in Hive.
  • Use a variety of different file formats and records formats with Hive.




5 hours

Part Time/Full Time:

Part Time


[su_tab title = “Eligibility”]

  • Basic understanding of Apache Hadoop and BigData.
  • Working knowledge of SQL
  • Basic Linux Operating System knowledge
  • Hadoop Fundamentals I Version 2


[su_tab title =”Tools”]

  • Hive
  • Hadoop
  • SQL
  • Apache Hadoop
  • MapReduce


[su_tab title = “Contact”]

Name :
Email :
Contact Number :
Message :
Code :



This article is quite old and you might not get a prompt response from the author. We request you to post this comment on Analytics Vidhya's Discussion portal to get your queries resolved