[SQOOP-1047] where i import data from oracle to hdfs useing the --fields-terminated-by '\001' sqoop use null split the data.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: no-release

Environment

Sqoop 1.4.2 oracle

• Assignee: Jarek Jarcec Cecho
• Reporter: sutao bian
• Created: 15/May/13 08:14
• Updated: 08/Jun/13 17:13
• Resolved: 08/Jun/13 17:13

Description

i got this data split by null not by \001

/home/hadoop/sqoop-1.4.2.bin__hadoop-0.20/bin/sqoop import --verbose --fields-terminated-by '\001' --connect jdbc:oracle:thin:@192.168.2.226:1521:db --username
USERETL --password pass --as-textfile --split-by SMIN_INFOID --table USERETL.TBL_SMSINFO --target-dir /tmp/bbb

)5.0ARSnullnullnull27nullnull20011nullnullnullnullnull722nullnullMopaynullnullnullSPACEnullnull
90921314004netqin20408,20416,204031nullnull1.5nullnullnullMopay NL(荷兰)1.5EURnullnullnull3nullnull20010nullnullnullnullnull204nullnullMopaynullnullnullSPACEnullnull
916539106610797M46000,46002,460072null中国5null*手机安全攻略*null中国移动-手机安全攻略5元包月nullnullnull1106610797QXAQGL20010testtestnullnullnull460nullnull中国移动手机安全攻略nullM_nullnull
9432068109276NQMS51011,510211null印尼5500nullnullnullCentili印尼短号MS5500盾9276XLnullnullnull10nullnull20010nullnull0nullnull510nullnullCentili XLnullnullnullSPACEnullnull
97620521035960BSTNGMTNMTCM026621301null尼日利亚100nullnullnull黑鲨-尼日利亚100N(MTN)nullnullnull42nullnull20011nullnull0nullnull621nullnull黑鲨nullnullnullSPACEnullnull