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)
