Udemy

Big Data Analyst -using Sqoop and Advance Hive (CCA159)

立即報名
  • 5,919 名學生
  • 更新於 7/2021
4.3
(361 個評分)
  • 提示:
  • 透過本站連結購買Udemy課程,本站將獲得推廣佣金,有助未來提供更多實用進修課程資訊給讀者。

課程資料

報名日期*
全年招生
課程級別
學習模式
修業期
4 小時 57 分鐘
教學語言
英語
授課導師
Navdeep Kaur
評分
4.3
(361 個評分)
課程連結
*提示: 以上時間表僅供參考,以機構網站為準。

課程簡介

Big Data Analyst -using Sqoop and Advance Hive (CCA159)

Become Big data Analyst using Hive and Sqoop.Great course for business Analyst,Testers and Sql Developers.CCA159

You will start by learning what is Hadoop & Hadoop distributed file system and most common hadoop commands required to work with Hadoop File system


Then you will be introduced to Sqoop Import

  • Understand lifecycle of sqoop command.

  • Use sqoop import command to migrate data from Mysql to HDFS.

  • Use sqoop import command to migrate data from Mysql to Hive.

  • Use various file formats, compressions, file delimeter,where clause and queries while importing the data.

  • Understand split-by and boundary queries.

  • Use incremental mode to migrate the data from Mysql to HDFS.


Further, you will learn Sqoop Export to migrate data.

  • What is sqoop export

  • Using sqoop export, migrate data from HDFS to Mysql.

  • Using sqoop export, migrate data from Hive to Mysql.


Finally, we will start with Apache Hive [Advance]

  • Hive Intro

  • External & Managed Tables

  • Insert & Multi Insert

  • Data Types & Complex Data Types

  • Collection Function

  • Conditional Function

  • Hive String Functions

  • Hive Date Functions

  • Mathematical Function

  • Hive Analysis

  • Alter Command

  • Joins, Multi Joins & Map Joins

  • Working with Different Files - Parquet,Avro

  • Compressions

  • Partitioning

  • Bucketing

  • Views

  • Lateral Views/Explode

  • Windowing Functions - Rank/Dense Rank/lead/lag/min/max

  • Window Specification

課程章節

  • 10 個章節
  • 55 堂課
  • 第 1 章 Hadoop Introduction
  • 第 2 章 Hive
  • 第 3 章 Hive Data Types
  • 第 4 章 Hive Functions
  • 第 5 章 Hive Join
  • 第 6 章 Working with Different File Formats & Compressions
  • 第 7 章 Advance Hive
  • 第 8 章 Hive Windows Function
  • 第 9 章 Sqoop Import
  • 第 10 章 Sqoop Export

課程內容

  • Students will learn Advance Hive and Sqoop for Big Data Analytics and Ingestion.


評價

  • N
    Narendrula Shravya
    4.5

    Good

  • Z
    Zuly Sara Jurado Purizaca
    3.0

    Talleres paso a paso. Algo rápido, quedo a la espera de un taller donde poder realizar las practicas

  • R
    Rapti Majumdar
    1.0

    I bought this course to get a thorough knowledge on Hive and Sqoop, it costs same as the other big data courses which covers at least 6-8 topics. So I thought this would be at a deeper level. But this is at basic level of hive and spark, nothing advanced. I doesn't clear any concepts as well (hive bucket - it would say it is similar to java bucket and then show some hands-on), just some basic hands-on which you will get in other big data courses as well along with more number of topics.

  • M
    Manash Bora
    5.0

    Limited content but sufficient to start using hive and sqoop in a real project.

立即關注瀏覽更多

本網站使用Cookies來改善您的瀏覽體驗,請確定您同意及接受我們的私隱政策與使用條款才繼續瀏覽。

我已閱讀及同意