sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sasikumar Devan (JIRA)" <j...@apache.org>
Subject [jira] [Created] (SQOOP-2862) Sqoop export : --null-string not working for character field in Netezza
Date Wed, 02 Mar 2016 15:01:18 GMT
Sasikumar Devan created SQOOP-2862:
--------------------------------------

             Summary: Sqoop export : --null-string not working for character field in Netezza
                 Key: SQOOP-2862
                 URL: https://issues.apache.org/jira/browse/SQOOP-2862
             Project: Sqoop
          Issue Type: Bug
          Components: sqoop2-api
    Affects Versions: 1.4.5
         Environment: DEV
            Reporter: Sasikumar Devan
            Priority: Critical


We are sqoop'ing data from HDFS to Netezza and input-null-string is not working if the target
is character field.

when we changed the DDL to character varying its working correctly.Its populating null to
the target field.

Below is our sqoop template.

v_SqoopUid=user
v_SqoopPwd= pwd
v_ExportDir="/user/sample"
v_StagingTable="test1"
v_FieldDelimiter="\\037"
v_RecordDelimiter="\n"
v_SqoopJdbcConnection=
sqoop export --connect ${v_SqoopJdbcConnection} \
--username ${v_SqoopUid} \
--password ${v_SqoopPwd} \
--direct \
--export-dir ${v_ExportDir} \
--table ${v_StagingTable} \
--num-mappers 8 \
--input-fields-terminated-by "${v_FieldDelimiter}" \
--input-lines-terminated-by "${v_RecordDelimiter}" \
--null-string ''\''\\N'\'''  \
--null-non-string ''\''\\N'\'''  



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message