Books & Videos

Table of Contents

  1. Chapter 1 Getting Started

    1. Downloading and Installing Sqoop

    2. Installing JDBC Drivers

    3. Installing Specialized Connectors

    4. Starting Sqoop

    5. Getting Help with Sqoop

  2. Chapter 2 Importing Data

    1. Transferring an Entire Table

    2. Specifying a Target Directory

    3. Importing Only a Subset of Data

    4. Protecting Your Password

    5. Using a File Format Other Than CSV

    6. Compressing Imported Data

    7. Speeding Up Transfers

    8. Overriding Type Mapping

    9. Controlling Parallelism

    10. Encoding NULL Values

    11. Importing All Your Tables

  3. Chapter 3 Incremental Import

    1. Importing Only New Data

    2. Incrementally Importing Mutable Data

    3. Preserving the Last Imported Value

    4. Storing Passwords in the Metastore

    5. Overriding the Arguments to a Saved Job

    6. Sharing the Metastore Between Sqoop Clients

  4. Chapter 4 Free-Form Query Import

    1. Importing Data from Two Tables

    2. Using Custom Boundary Queries

    3. Renaming Sqoop Job Instances

    4. Importing Queries with Duplicated Columns

  5. Chapter 5 Export

    1. Transferring Data from Hadoop

    2. Inserting Data in Batches

    3. Exporting with All-or-Nothing Semantics

    4. Updating an Existing Data Set

    5. Updating or Inserting at the Same Time

    6. Using Stored Procedures

    7. Exporting into a Subset of Columns

    8. Encoding the NULL Value Differently

    9. Exporting Corrupted Data

  6. Chapter 6 Hadoop Ecosystem Integration

    1. Scheduling Sqoop Jobs with Oozie

    2. Specifying Commands in Oozie

    3. Using Property Parameters in Oozie

    4. Installing JDBC Drivers in Oozie

    5. Importing Data Directly into Hive

    6. Using Partitioned Hive Tables

    7. Replacing Special Delimiters During Hive Import

    8. Using the Correct NULL String in Hive

    9. Importing Data into HBase

    10. Importing All Rows into HBase

    11. Improving Performance When Importing into HBase

  7. Chapter 7 Specialized Connectors

    1. Overriding Imported boolean Values in PostgreSQL Direct Import

    2. Importing a Table Stored in Custom Schema in PostgreSQL

    3. Exporting into PostgreSQL Using pg_bulkload

    4. Connecting to MySQL

    5. Using Direct MySQL Import into Hive

    6. Using the upsert Feature When Exporting into MySQL

    7. Importing from Oracle

    8. Using Synonyms in Oracle

    9. Faster Transfers with Oracle

    10. Importing into Avro with OraOop

    11. Choosing the Proper Connector for Oracle

    12. Exporting into Teradata

    13. Using the Cloudera Teradata Connector

    14. Using Long Column Names in Teradata

  1. Colophon