Errata

Apache Sqoop Cookbook

Errata for Apache Sqoop Cookbook

Submit your own errata for this product.

The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted By Date submitted Date corrected
PDF
Page 14
End of page - Unix commands

hadoop dfs -chown 400 /user/$USER/sqoop.password should be hadoop dfs -chmod 400 /user/$USER/sqoop.password

Note from the Author or Editor:
Thank you very much for taking your time to read our book and reporting this errata. Indeed the command should be -chmod and not -chown, we will fix that for next release.

 Elvin Smith  Jul 23, 2013 
Printed
Page 40
2nd paragraph

At the end of the second paragraph on page 40 it states that you can export data to your database iteratively as long as there are no constraint violations when performing the INSERT statements, then it says in brackets:

"(for example you can twice export the same value for any primary or unique key)"

I think this should be changed from "can" to "cannot" and maybe extended a little to clarify that it would violate the key constraints to do so:

"(for example you cannot twice export the same value for any primary or unique key, as doing so would violate the primary or unique key constraints in the database)"

Note from the Author or Editor:
Fixed in the repository.

 Hari Sekhon  Sep 13, 2013 
Printed
Page 65
1st paragraph problem section

The problem section has awkward/strange wording that doesn't really make sense, it's clearly trying to offer up a solution but isn't quite defining the problem properly:

"You are using the pg_bulkload utility to load data to your PostgreSQL server. Since Sqoop utilizes mysqlimport for MySQL, can Sqoop also utilize pg_bulkload for PostgreSQL?"

Perhaps consider rewording this to something like:

"You are using the pg_bulkload utility to load data to your PostgreSQL server and want Sqoop to also use pg_bulkload for better performance"

Note from the Author or Editor:
I've updated the particular paragraph in question to be more descriptive.

 Hari Sekhon  Sep 13, 2013