Book Image

Hadoop Beginner's Guide

Book Image

Hadoop Beginner's Guide

Overview of this book

Data is arriving faster than you can process it and the overall volumes keep growing at a rate that keeps you awake at night. Hadoop can help you tame the data beast. Effective use of Hadoop however requires a mixture of programming, design, and system administration skills."Hadoop Beginner's Guide" removes the mystery from Hadoop, presenting Hadoop and related technologies with a focus on building working systems and getting the job done, using cloud services to do so when it makes sense. From basic concepts and initial setup through developing applications and keeping the system running as the data grows, the book gives the understanding needed to effectively use Hadoop to solve real world problems.Starting with the basics of installing and configuring Hadoop, the book explains how to develop applications, maintain the system, and how to use additional products to integrate with other systems.While learning different ways to develop applications to run on Hadoop the book also covers tools such as Hive, Sqoop, and Flume that show how Hadoop can be integrated with relational databases and log collection.In addition to examples on Hadoop clusters on Ubuntu uses of cloud services such as Amazon, EC2 and Elastic MapReduce are covered.
Table of Contents (19 chapters)
Hadoop Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Time for action – exporting data from MySQL to HDFS


We'll use a straightforward example here, where we just pull all the data from a single MySQL table and write it to a single file on HDFS.

  1. Run Sqoop to export data from MySQL onto HDFS:

    $ sqoop import --connect jdbc:mysql://10.0.0.100/hadooptest 
    --username hadoopuser \ > --password password --table employees
    
  2. Examine the output directory:

    $ hadoop fs -ls employees
    

    You will receive the following response:

    Found 6 items
    -rw-r--r--   3 hadoop supergroup          0 2012-05-21 04:10 /user/hadoop/employees/_SUCCESS
    drwxr-xr-x   - hadoop supergroup          0 2012-05-21 04:10 /user/hadoop/employees/_logs
    -rw-r--r--   3 … /user/hadoop/employees/part-m-00000
    -rw-r--r--   3 … /user/hadoop/employees/part-m-00001
    -rw-r--r--   3 … /user/hadoop/employees/part-m-00002
    -rw-r--r--   3 … /user/hadoop/employees/part-m-00003
    
  3. Display one of the result files:

    $ hadoop fs -cat /user/hadoop/employees/part-m-00001
    

    You will see the following output:

    Bob,Sales...