事由
读取log日志文件,存储到csv 格式,再load到hive表,发现所有的csv列均存储到hive表的首个字段钟,hive建表语句
CREATE TABLE test.dbl_20clw_base (
sbbh STRING,
spn STRING,
spnname STRING,
fmi STRING,
fminame STRING,
gzsj STRING,
exchangecode STRING
)
PARTITIONED BY (
pdate STRING
)
解决办法
查看成功事例,发现是未指定hive表的行分隔符和列分隔符