sutao bian created SQOOP-1047:
---------------------------------
Summary: where i import data from oracle to hdfs useing the
--fields-terminated-by '\001' sqoop use null split the data.
Key: SQOOP-1047
URL: https://issues.apache.org/jira/browse/SQOOP-1047
Project: Sqoop
Issue Type: Bug
Environment: Sqoop 1.4.2 oracle
Reporter: sutao bian
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
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira