How to Export Certain Strings into Hive


During export into a Hive table, if a CRLF in a string column is encountered, the rest of the records are jumbled. Each new line is treated as an individual record. Since these records don't match the target data structure (table), they are dropped from the export. Learn how to have all records exported into the Hive table.


According HIVE-1898 and HIVE-11785, intermediate tables with LazySimpleSerDe can't handle new lines (NL) and carriage returns (CR) in text. 


You can use any of the following options based on your environment and needs: