how to import tables into hive with columns having new line characters with sqoop?

Viewed 1205

I am trying to hive-import a mysql table using sqoop which has a column that stores json data containing new line chars. For handling hive default delimiters, I tried to change the line delimiter using sqoop's --lines-terminated-by '\u002' option. Sqoop gave error saying --lines-terminated-by takes only '\n'. --hive-drop-import-delim option allows to import data by dropping new line characters. Is there a way to import data intact into hive as text file?

0 Answers
Related