When exporting CSV files using HUE we sometimes get the following error:
It is probably related to a field that is custom filled by the users, so weird characters are possible. However, there are no problems with any of such weird characters in Hive or any of the other databases. Additionally, the export straight to Excel (on HUE) works without issues too.
It seems the problem is specifically with the CSV exporter used by HUE.
Is there a quick fix for that? While researching the issue, plenty of various fixes are suggested, however it’s not clear for me exactly where the issue arises here in HUE.