Chapter 1 Getting Started
Downloading and Installing Sqoop
Installing JDBC Drivers
Installing Specialized Connectors
Starting Sqoop
Getting Help with Sqoop
Chapter 2 Importing Data
Transferring an Entire Table
Specifying a Target Directory
Importing Only a Subset of Data
Protecting Your Password
Using a File Format Other Than CSV
Compressing Imported Data
Speeding Up Transfers
Overriding Type Mapping
Controlling Parallelism
Encoding NULL Values
Importing All Your Tables
Chapter 3 Incremental Import
Importing Only New Data
Incrementally Importing Mutable Data
Preserving the Last Imported Value
Storing Passwords in the Metastore
Overriding the Arguments to a Saved Job
Sharing the Metastore Between Sqoop Clients
Chapter 4 Free-Form Query Import
Importing Data from Two Tables
Using Custom Boundary Queries
Renaming Sqoop Job Instances
Importing Queries with Duplicated Columns
Chapter 5 Export
Transferring Data from Hadoop
Inserting Data in Batches
Exporting with All-or-Nothing Semantics
Updating an Existing Data Set
Updating or Inserting at the Same Time
Using Stored Procedures
Exporting into a Subset of Columns
Encoding the NULL Value Differently
Exporting Corrupted Data
Chapter 6 Hadoop Ecosystem Integration
Scheduling Sqoop Jobs with Oozie
Specifying Commands in Oozie
Using Property Parameters in Oozie
Installing JDBC Drivers in Oozie
Importing Data Directly into Hive
Using Partitioned Hive Tables
Replacing Special Delimiters During Hive Import
Using the Correct NULL String in Hive
Importing Data into HBase
Importing All Rows into HBase
Improving Performance When Importing into HBase
Chapter 7 Specialized Connectors
Overriding Imported boolean Values in PostgreSQL Direct Import
Importing a Table Stored in Custom Schema in PostgreSQL
Exporting into PostgreSQL Using pg_bulkload
Connecting to MySQL
Using Direct MySQL Import into Hive
Using the upsert Feature When Exporting into MySQL
Importing from Oracle
Using Synonyms in Oracle
Faster Transfers with Oracle
Importing into Avro with OraOop
Choosing the Proper Connector for Oracle
Exporting into Teradata
Using the Cloudera Teradata Connector
Using Long Column Names in Teradata
Colophon
· · · · · · (收起)