One of the Oracle table has data that has new line char in it. After importing the data using sqoop, I am not able to represent that data in Hive. The row that has new line char is getting split into two rows.

[#1]

@narasimha meruva Can you past out of errors? HDP version?

[#2 · Accepted solution]

@narasimha meruva

check this http://stackoverflow.com/questions/28076200/hive-d...

Use --map-column-java option to explicitly state the column is of type String. Then --hive-drop-import-delims works as expected (to remove \n from data).

[#3]

Thank you !!! It did work .

[#4]

@narasimha meruva Cool! Please close the thread by accepting the answer "best practice"

[#5]

I want to remove '/n' while sqoop the data into hdfs. Is there any sqoop cmd?