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
|