title: how to import tables into hive with columns having new line characters with sqoop?
body: <p>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?</p>