question 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. in Archives of Support Questions (Read Only) https://community.cloudera.com/t5/Archives-of-Support-Questions/One-of-the-Oracle-table-has-data-that-has-new-line-char-in/m-p/100311#M13276 Tue, 22 Dec 2015 04:17:05 GMT MNarasimha 2015-12-22T04:17:05Z 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. https://community.cloudera.com/t5/Archives-of-Support-Questions/One-of-the-Oracle-table-has-data-that-has-new-line-char-in/m-p/100311#M13276 Tue, 22 Dec 2015 04:17:05 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/One-of-the-Oracle-table-has-data-that-has-new-line-char-in/m-p/100311#M13276 MNarasimha 2015-12-22T04:17:05Z Re: 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. https://community.cloudera.com/t5/Archives-of-Support-Questions/One-of-the-Oracle-table-has-data-that-has-new-line-char-in/m-p/100312#M13277 <P><A rel="user" href="https://community.cloudera.com/users/1681/mnarasimha.html" nodeid="1681">@narasimha meruva</A> Can you past out of errors? HDP version?</P> Tue, 22 Dec 2015 04:18:19 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/One-of-the-Oracle-table-has-data-that-has-new-line-char-in/m-p/100312#M13277 nsabharwal 2015-12-22T04:18:19Z Re: 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. https://community.cloudera.com/t5/Archives-of-Support-Questions/One-of-the-Oracle-table-has-data-that-has-new-line-char-in/m-p/100313#M13278 <A rel="user" href="https://community.cloudera.com/users/1681/mnarasimha.html" nodeid="1681">@narasimha meruva</A><P>check this <A href="http://stackoverflow.com/questions/28076200/hive-drop-import-delims-not-removing-newline-while-using-hcatalog-in-sqoop">http://stackoverflow.com/questions/28076200/hive-d...</A></P><P>Use <CODE>--map-column-java</CODE> option to explicitly state the column is of type <CODE>String</CODE>. Then <CODE>--hive-drop-import-delims</CODE> works as expected (to remove <CODE>\n</CODE> from data).</P> Tue, 22 Dec 2015 04:28:32 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/One-of-the-Oracle-table-has-data-that-has-new-line-char-in/m-p/100313#M13278 nsabharwal 2015-12-22T04:28:32Z Re: 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. https://community.cloudera.com/t5/Archives-of-Support-Questions/One-of-the-Oracle-table-has-data-that-has-new-line-char-in/m-p/100314#M13279 <P>Thank you !!! It did work .</P> Tue, 22 Dec 2015 08:13:52 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/One-of-the-Oracle-table-has-data-that-has-new-line-char-in/m-p/100314#M13279 MNarasimha 2015-12-22T08:13:52Z Re: 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. https://community.cloudera.com/t5/Archives-of-Support-Questions/One-of-the-Oracle-table-has-data-that-has-new-line-char-in/m-p/100315#M13280 <P><A rel="user" href="https://community.cloudera.com/users/1681/mnarasimha.html" nodeid="1681">@narasimha meruva</A> Cool! Please close the thread by accepting the answer "best practice" </P> Tue, 22 Dec 2015 08:58:19 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/One-of-the-Oracle-table-has-data-that-has-new-line-char-in/m-p/100315#M13280 nsabharwal 2015-12-22T08:58:19Z Re: 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. https://community.cloudera.com/t5/Archives-of-Support-Questions/One-of-the-Oracle-table-has-data-that-has-new-line-char-in/m-p/100316#M13281 <P>I want to remove '/n' while sqoop the data into hdfs. Is there any sqoop cmd? </P> Fri, 15 Jun 2018 12:45:53 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/One-of-the-Oracle-table-has-data-that-has-new-line-char-in/m-p/100316#M13281 anjali_shevadka 2018-06-15T12:45:53Z