5/10/2013

#Hadoop #SQOOP Training

In today's Cloudera training, we covered SQOOP or SQL for Hadoop.

It's a language created by Cloudera to ingest data into HDFS.

So the first step was to log into MySQL.

Then poke around and view some table structures.

mysql> DESCRIBE movierating;

And then import the a MySQL table into HDFS using the Import command:


We imported over 1 million rows in about 21 seconds...
 
 
Once ingested, we can view the contents from within HDFS:
 

Once in Hadoop HDFS, we can now run Map Reduce jobs.

Awesome!

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.