sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jarek Jarcec Cecho (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (SQOOP-1047) where i import data from oracle to hdfs useing the --fields-terminated-by '\001' sqoop use null split the data.
Date Tue, 21 May 2013 10:03:15 GMT

     [ https://issues.apache.org/jira/browse/SQOOP-1047?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Jarek Jarcec Cecho resolved SQOOP-1047.
---------------------------------------

       Resolution: Not A Problem
    Fix Version/s: no-release
         Assignee: Jarek Jarcec Cecho

I'm glad to see it working for you. I'm resolving this JIRA for now, however please do not
hesitate and reopen it if needed.
                
> 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
>            Assignee: Jarek Jarcec Cecho
>             Fix For: no-release
>
>
> 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

Mime
View raw message