Sometimes data produced by Sqoop Import may contain New Line Character. This may result failure to correctly read the data.
To resolve same follow either of below solution:
- Specify following options with Sqoop:
- --map-column-java <Column name that contains New Line>=String
- --hive-drop-import-delims
- Or, Update Sqoop SQL and select the column with regex replacement, like:
- regexp_replace(<Column name that contains New Line>, '[[:space:]]+', ' ')
Comments
Post a Comment