If you specify n as the line break imported by sqoop, if the value of a string field in mysql contains n, sqoop imports an additional line of records. There is an option-hive-drop-import-delimsDropsn, r, and1fromstringfieldswhenimportingtoHive.
If you specify \ n as the line break for sqoop import, if the value of a string field in mysql contains \ n, it will lead to an additional line of records for sqoop import. There is an option-hive-drop-import-delims Drops \ n, \ r, and \ 01 from string fields when importing to Hive.
If you specify \ n as the line break for sqoop import, if the value of a string field in mysql contains \ n, it will lead to an additional line of records for sqoop import.
There is an option
-Hive-drop-import-delims Drops \ n, \ r, and \ 01 from string fields when importing to Hive.
In this way, both \ n \ r and \ 01 are automatically deleted and will not cause any confusion.