Data Repository with Sqoop
Apache Hadoop
| Intermediate
- 16 videos | 1h 11m 10s
- Earns a Badge
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
-
2m 49sUpon completion of this video, you will be able to describe MySQL. FREE ACCESS
-
5m 58sIn this video, you will learn how to install MySQL. FREE ACCESS
-
3. Creating a Database4m 1sIn this video, you will learn how to create a database in MySQL. FREE ACCESS
-
4. Loading Data into MySQL Tables3m 20sFind out how to create MySQL tables and load data. FREE ACCESS
-
5. Overviewing Sqoop1m 39sAfter completing this video, you will be able to describe Sqoop. FREE ACCESS
-
6. Architecture of Sqoop2m 13sUpon completion of this video, you will be able to describe Sqoop's architecture. FREE ACCESS
-
7. Overview of Sqoop Configuration37sUpon completion of this video, you will be able to recall the dependencies for Sqoop installation. FREE ACCESS
-
8. Installing Sqoop5m 49sFind out how to install Sqoop. FREE ACCESS
-
9. Overview of Importing with Sqoop6m 1sUpon completion of this video, you will be able to recall why it is important for the primary key to be numeric. FREE ACCESS
-
10. Performing a Sqoop Import5m 45sIn this video, you will perform a Sqoop import from MySQL into Hadoop Distributed File System. FREE ACCESS
-
11. Overview of Exporting with Sqoop2m 58sAfter completing this video, you will be able to recall what the developers should be aware of. FREE ACCESS
-
12. Performing a Sqoop Export5m 59sIn this video, you will learn how to perform a Sqoop export from MySQL into HDFS. FREE ACCESS
-
13. Sqoop and HBase4m 53sAfter completing this video, you will be able to recall that you must execute a Sqoop import statement for each data element. FREE ACCESS
-
14. Exporting into HBase6m 31sIn this video, learn how to perform a Sqoop import from MySQL into HBase. FREE ACCESS
-
15. Sqoop Troubleshooting4m 59sUpon completion of this video, you will be able to recall how to use chain troubleshooting to resolve Sqoop issues. FREE ACCESS
-
16. Correcting a Database Connect Failure7m 37sIn this video, you will learn how to use log files to identify common Sqoop errors and their resolutions. FREE ACCESS
EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE
Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
