Due to its versatility, Sqoop transfers data from a variety of relational database systems, such as Oracle, MySQL, PostgreSQL, and Microsoft SQL Server, as well as from enterprise data warehouses, such as Netezza and Teradata. While working with these database systems, you may encounter issues specific to a system vendor. This chapter guides you through common installation, connection, and syntax issues.
PostgreSQL direct imports
boolean values as
FALSE strings. If your subsequent processing expects different values, you need to override those defaults.
Specify the extra parameters
--boolean-false-string to override the default value to a different string. For example, to use
true, you could use the following Sqoop command:
The PostgreSQL direct connector uses the
COPY (SELECT QUERY) TO STDOUT clause for retrieving data from your database that will by default use the string constants
FALSE when importing data from
Bit columns. The PostgreSQL direct connector only supports import and delegates the export to the nondirect JDBC connector. Therefore, both parameters,