Thanks Jarek. Good to hear it's at least a known issue.
On 4 December 2012 17:20, Jarek Jarcec Cecho jar...@apache.org wrote:
Hi Krishna,
I'm afraid that this is known limitation of current PostgreSQL direct
connector. We already have a JIRA to address this - SQOOP-654 [1].
Currently suggested workaround is to use JDBC based import by dropping the
--direct argument.
Links:
1: https://issues.apache.org/jira/browse/SQOOP-654
On Tue, Dec 04, 2012 at 05:04:56PM +, 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
org.apache.hadoop.io.compress.SnappyCodec
I'm using Sqoop version 1.4.1 Hive 0.9.0
Cheers