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

Reply via email to