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 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
-
1. Overviewing MySQL2m 49s
-
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 on some of our courses, which can be shared on any social network or business platform.
Digital badges are yours to keep, forever.
