csv - 当csv文件有cr和lf时如何加载到hive

Question

我在将数据加载到 Hive 表时遇到问题。CSV 文件如下所示

"1","2019-11-00","0","0","0","F","","2019-08-12","2019-11-01","2019-10-30","2019-08-12 18:19:52.0","1","0","0","0","0","","0","0","0","000520000400000","3","2019-11-01 11:28:41.0","\
\
cancelled","Ma"

这应该只是 1 行。但是 Hive 为以下内容创建了 2 个额外的行：

\
cancelled","Ma"

检查记事本++，在第一行的末尾有一个 CR，在接下来的 2 行的末尾有一个 LF。

标签： csvhadoophivebigdatahiveql