Data Repository with Sqoop

Apache Hadoop 2.0    |    Intermediate
  • 16 Videos | 1h 11m 10s
  • Earns a Badge
Likes 9 Likes 9
Sqoop is a tool for transferring structured data between Hadoop and a RDBMS. Explore the architecture and installation of Sqoop, how to perform imports and exports, Hive SQL statements, and more.

WHAT YOU WILL LEARN

  • describe MySQL
    install MySQL
    create a database in MySQL
    create MySQL tables and load data
    describe Sqoop
    describe Sqoop's architecture
    recall the dependencies for Sqoop installation
    install Sqoop
  • recall why it's important for the primary key to be numeric
    perform a Sqoop import from MySQL into HDFS
    recall what concerns the developers should be aware of
    perform a Sqoop export from HDFS into MySQL
    recall that you must execute a Sqoop import statement for each data element
    perform a Sqoop import from MySQL into HBase
    recall how to use chain troubleshooting to resolve Sqoop issues
    use the log files to identify common Sqoop errors and their resolutions

IN THIS COURSE

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 193 Likes 193  
Likes 83 Likes 83  
Likes 41 Likes 41