I'm afraid that this is known limitation of current PostgreSQL direct connector. We already have a JIRA to address this - SQOOP-654 .
Currently suggested workaround is to use JDBC based import by dropping the "--direct" argument.
On Tue, Dec 04, 2012 at 05:04:56PM +0000, Krishna Rao wrote:
> Hi all,
> I'm haivng trouble transfering NULLs in a VARCHAR column in a table in
> PostgresQL into Hive. A null value ends up as an empty value in Hive,
> rather than NULL.
> I'm running the following command:
> sqoop import --username <username> -P --hive-import --hive-overwrite
> --null-string='\\N' --null-non-string '\\N' --direct --compression-codec
> I'm using Sqoop version 1.4.1 & Hive 0.9.0