Call +60 3-2711 7241 Email:

HRDF Approved Training Provider in Malaysia - Modular Fast Track Skill-Based Trainings

Big Data Analysis with Apache Hive

Apache Hive is a tool of choice for many data scientists because it allows them to work with SQL, a familiar syntax, to derive insights from Hadoop, reflecting the information that businesses seek to plan effectively.This course shows how to use Hive to process data, structure and optimize your data. The course will also show how to use  HUE, the Hadoop user interface, to leverage HiveQL when analyzing data..

Topics include:

  • Defining data structures in Hive
  • Selecting data
  • Joining tables
  • Manipulating data
  • Filtering results
  • Aggregating data
  • Using built-in aggregate functions
  • Mastering built-in table-generating functions
  • Using CUBE and ROLLUP
  • Using clauses: WHERE and HAVING
  • Using LIKE, JOIN, and SEMI JOIN
  • Using functions: String, math, date, and conditional

HRDF SBL Claimable for Employers Registered with HRDF

HRDF claimable

Course Code: M400

Course Booking

MYR880.00 (GST-exclusive)

Course Date

Course Time

* Required Fields

Course Cancellation/Reschedule Policy

We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.
Note the venue of the training is subject to changes due to class size and availability of the classroom.
Note the minimal class size to start a class is 3 Pax.

Course Details

Module 1: Get Started on Apache Hive

  • Why Hive?
  • Hive Concepts and Setup
  • Setting Up Demo Environment

Module 2: Manipulating Data in Hive

  • Understanding Data Structures in Hive
  • Ceating Tables in Hive
  • Handling CSV files in Hive
  • Partitioning Tables

Module 3: Getting Data from Hive

  • Getting data with SELECT
  • Retrieving Data from Complex Structures

Module 4: Aggregating Data with Hive

  • Simple Aggregations
  • Grouping Sets
  • Using CUBE and ROLLUP

Module 5: Filtering Reults with Hive

  • Simple filter with WHERE
  • Filtering aggregates with HAVING
  • Finding similar values with LIKE

Module 6: Joining Tables 

  • Comibining tables with JOIN
  • Where to use SEMI JOIN
  • Joining multiple tables together

Module 7: Manipulating Data

  • Data Manipulating Functions
  • String Functions
  • Math Functions
  • Date Functions
  • Conditonal Functions

Who Should Attend

  • Data Scientists
  • Data Analysts
  • Big Data Analysts




Hadoop Big Data TrainerHassan Keshavarz is a Ph. D Candidate in MJIIT. He is Microsoft certification holder in IT sector and member of IEEE Association as well. Currently, he is working in Xchanging Malaysia, a DXC-YTL Joint Venture as Technical Lead in EDW Team as Big Data Administrator/Developer and Hadoop architecture. Hassan has 3+ years experience in installing, configuring and utilizing Hadoop eco-system in Enterprise Data Warehouse, Reporting and Analytic domains. He is an expert at: Apache Hadoop, Apache Hive, Sqoop, Flume, preparing study narratives documents and case reviews, Perform the tasks of reviewing studies performed by the staff, Strong written and verbal communication skill, Invited reviewers of journals and conferences.

Hadoop Big Data TrainerSwamy Gurram is a Cloudera Certified Developer for Apache Hadoop (CCDH). He has a lot hands on experience with Hadoop technologies (HDFS, MapReduce, Hive, Pig, HBase, Sqoop, flume, Impala, Knox etc) and Hadoop cluster installations, administration along with virtual server installations . He has 10+ years of experience in Technical Architecture, Onsite Relationship Management and Automotive Business Analyst. He also has experience in Hadoop, Mainframe Technologies, Visual Basics, Mainframe Migration Tools. He is expertise in system life cycle skills comprising of analysis, technical design, testing, implementation and documentation

Hadoop Big Data trainerSyed Muhammad Farrukh Akhtar has more than 15 years of experience analysis, designing, developing, integrating and managing large applications for diverse industries. He has experience working in Dubai, Pakistan, Germany and Malaysia, a strong hands-on experience of software design, development and integration on different platform like IBM J2EE, Oracle and Microsoft .Net, Big data, Hadoop, Spark, HBase, Hive, Sqoop, Flume and NoSQL. He also has expertise in Machine Learning/ Deep Learning with Tensor Flow, Keras and Python, excellent skills in React, Ionic 2, Angular 2, Mobile Apps with React Native and Node.js. He is highly knowledgeable in object oriented software development, requirements analysis, and database design. Possess deep understanding of Open Source technologies’ applicability in emerging business areas. He possesses excellent knowledge in Rational Unified Process (RUP); Rational Software Architect; data modeling and mapping; and extensible system design using the UML and Visio. Professional experience on J2EE, JMS, Web Sphere, Oracle, Spring, Hibernate, Struts and 3-Tier Web-based Applications Development.

Write Your Own Review

You're reviewing: Big Data Analysis with Apache Hive

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
  • Reload captcha


Use spaces to separate Subjects. Use single quotes (') for phrases.

You May Be Interested In These Courses

Hadoop Data Analysis Training

Hadoop Data Analysis Training

1 Review(s)
MYR880.00 (GST-exclusive)
Apache Solr Search Platform Training

Apache Solr Search Platform Training

MYR880.00 (GST-exclusive)
Apache Hbase Training

Apache Hbase Training

MYR880.00 (GST-exclusive)
Apache Spark Essential Training

Apache Spark Essential Training

MYR880.00 (GST-exclusive)
Machine Learning with Apache Spark

Machine Learning with Apache Spark

MYR880.00 (GST-exclusive)