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)
|