Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
Sqoop, mail # user - Problems Sqoop importing columns with NULLs

Copy link to this message
Problems Sqoop importing columns with NULLs
Krishna Rao 2012-12-04, 17:04
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

Jarek Jarcec Cecho 2012-12-04, 17:20
Krishna Rao 2012-12-04, 18:03