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 China!

As a Business Development Manager you will:

  • expand business in China
  • 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!