Moving Data from MySQL to Hadoop with Sqoop培訓

課程代碼

sqoop

課程時長

14 時間: 同常來說包括休息是 2天

最低要求

  • An understanding of big data concepts (HDFS, Hive, etc.)
  • An understanding of relational databases (MySQL, etc.)
  • Experience with the Linux command line

概觀

Sqoop是一個開源軟件工具,用於在Hadoop和關係數據庫或大型機之間傳輸數據。它可用於將數據從關係數據庫管理系統(RDBMS)(如My SQLOracle或大型機)導入Hadoop分佈式文件系統(HDFS)。此後,可以在Hadoop MapReduce中轉換數據,然後將其重新導出回RDBMS。

在這個由講師指導的實時培訓中,參與者將學習如何使用Sqoop將數據從傳統的關係數據庫導入Hadoop存儲,如HDFS或Hive ,反之亦然。

在培訓結束時,參與者將能夠:

  • 安裝並配置Sqoop
  • 將數據從My SQL導入HDFS和Hive
  • 將數據從HDFS和Hive導入My SQL

聽眾

  • 系統管理員
  • 數據工程師

課程 格式

  • 部分講座,部分討論,練習和繁重的實踐練習

注意

  • 要申請本課程的定制培訓,請聯繫我們安排。

Machine Translated

課程簡介

Introduction

  • Moving data from legacy data stores to Hadoop

Installing and Configuring Sqoop

Overview of Sqoop Features and Architecture

Importing Data from MySQL to HDFS

Importing Data from MySQL to Hive

Transforming Data in Hadoop

Importing Data from HDFS to MySQL

Importing Data from Hive to MySQL

Importing Incrementally with Sqoop Jobs

Troubleshooting

Summary and Conclusion

客戶評論

★★★★★
★★★★★

課程分類

促銷課程

訂閱促銷課程

為尊重您的隱私,我公司不會把您的郵箱地址提供給任何人。您可以享有優先權和隨時取消訂閱的權利。

我們的客戶

is growing fast!

We are looking to expand our presence in Taiwan!

As a Business Development Manager you will:

  • expand business in Taiwan
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!