sqoop-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Suraj Nayak <snay...@gmail.com>
Subject Sqoop + HCatalog + Oracle escape new line character from column data
Date Wed, 21 Jan 2015 20:32:45 GMT
Hi All,

Sqoop while used with HCatalog import not able to remove new line (\n) from
column data even after using --hive-drop-import-delims option in the
command when running Apache Sqoop with Oracle.

Sqoop Query:

    sqoop import --connect jdbc:oracle:thin:@ORA_IP:ORA_PORT:ORA_SID
\--username user123 --password passwd123 -table SCHEMA.TBL_2 \
--hcatalog-table tbl2 --hcatalog-database testdb --num-mappers 1 \
--split-by SOME_ID --columns col1,col2,col3,col4
--hive-drop-import-delims \--outdir /tmp/temp_table_loc --class-name
"Sqoop with HCAT" \--null-string ""

Data in Oracle Column *col4* as below: (Data has control characters such as
^M)

<li>Details:^M
    <ul>^M
        <li>

Does Control character causing this problem?

Am I missing anything ? Is there any workaround or solution for this
problem?


Stackoverflow Link:-
http://stackoverflow.com/questions/28076200/hive-drop-import-delims-not-removing-newline-while-using-hcatalog-in-sqoop

-- 
Thanks
Suraj Nayak M

Mime
View raw message