Data Repository with Sqoop
Apache Hadoop 2.0
| 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 MySQLinstall MySQLcreate a database in MySQLcreate MySQL tables and load datadescribe Sqoopdescribe Sqoop's architecturerecall the dependencies for Sqoop installationinstall Sqoop
-
recall why it's important for the primary key to be numericperform a Sqoop import from MySQL into HDFSrecall what concerns the developers should be aware ofperform a Sqoop export from HDFS into MySQLrecall that you must execute a Sqoop import statement for each data elementperform a Sqoop import from MySQL into HBaserecall how to use chain troubleshooting to resolve Sqoop issuesuse the log files to identify common Sqoop errors and their resolutions
IN THIS COURSE
-
1.Overviewing MySQL2m 49sUP NEXT
-
2.Installing MySQL5m 58s
-
3.Creating a Database4m 1s
-
4.Loading Data into MySQL Tables3m 20s
-
5.Overviewing Sqoop1m 39s
-
6.Architecture of Sqoop2m 13s
-
7.Overview of Sqoop Configuration37s
-
8.Installing Sqoop5m 49s
-
9.Overview of Importing with Sqoop6m 1s
-
10.Performing a Sqoop Import5m 45s
-
11.Overview of Exporting with Sqoop2m 58s
-
12.Performing a Sqoop Export5m 59s
-
13.Sqoop and HBase4m 53s
-
14.Exporting into HBase6m 31s
-
15.Sqoop Troubleshooting4m 59s
-
16.Correcting a Database Connect Failure7m 37s
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.