Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Apache Hive Basic to advance all in one 2024
Rating: 4.1 out of 5(31 ratings)
178 students

Apache Hive Basic to advance all in one 2024

Become Expert in Big data Hive for projects and Interview
Created byAnshul Jain
Last updated 8/2025
English

What you'll learn

  • Good Hands on Apache Hive with all latest functionality covered
  • Working, Querying , Analyzing on big data stored in distributed environment
  • Crack interview on Big data , where Hive is asked
  • Advance Hive techniques / Performance Boost tips right here only , no where else
  • Project Web analysis : Decision on live web activities , a real life use case project
  • Partitioning, Bucketing, Join , Query Performance Improvement etc...

Course content

2 sections • 17 lectures • 4h 12m total length

  • Introduction Hive & Course1:46

    Hive Introduction

    Hive Installation

    Hive Setup : database setup  /schema setup / thrift server setup

  • Hive Architecture & Installation Steps of Hive with Mysql24:57

    How hive works ?

    Create Hive Schema  in Mysql database / Hive warehouse on Hadoop

    Configure Thrift server

    Start Hive shell and create a database

  • Basic Hive QL for CRUD Operation20:16

    Managed / External Table

    Load data files in Hive Table from local or hdfs file system

    Drop table / DB

  • Data Ingestion ways in Hive4:23
  • Different File Format in hive20:08

    Table Properties

    Read type of files : csv, text , parquet , avro , json

    Write hive table with Format using serde : parquet / avro / csv / avro

  • Serdes in Hive14:31

    Serde library usage to read json /csv/ xml files in Hive and dump into table

Requirements

  • basic knowledge of SQL
  • Hadoop 2.x installed on your system

Description

Apache Hive is a data processing tool on Hadoop. It is a querying tool for HDFS and the syntax of it's queries is almost similar to our old SQL. Hive is an open source-software that lets programmers analyze large data sets on Hadoop.

Benefits of this course:

Enroll into this course and get end to end knowledge of Basic + ADVANCE Hive + Interview asked Use cases. This course is very rare of its kind and includes even very thin details of Hive which are not available anywhere online.

In this course you will get to understand a step by step learning of very Basic Hive to Advance Hive (which is actually used in Real-time projects) like with latest Hive version 3.x

Hive Setup , All file formats of Hive , Partition , Bucketing , Joins , Hive Code Review like Experts : all demo / interactive sessions

HQL Clauses : Distribute by , order by , clustered by , sort by

Window functions like rank , row_number , dense_rank : all demo / interactive sessions

Materialized View : A new advanced feature of Hive

ACID properties : update , delete , merge records in Hive table

CRUD operation in Hive : Different ways to create / insert data in hive table

Exchange of Partition between Tables and much more...

Performance Technique that big companies use to query fast on data.

This course is a full package explaining even rarely used commands and concepts in Hive. After completing this course you won't find any topic left in Hive. This course is made keeping in mind the Real Implementation of Hive in Live Projects..

Additionally ,You can download the Step Step Installation Guide (doc) to Install Hadoop and Apache Hive

Who this course is for:

  • Students who want to learn Hive from basic to complete master in it easily
  • IT professional who are working on big data projects
  • Big data engineer working on ETL , projects involved large data sets
  • Job aspirants who want to clear big data interview where Hive is must
  • Middle-ware support Engineer / Developer / Big Data Engineer / Tester / Production Support / Students

Report abuse