之前的从hive查询数据保存为文件再读取文件插入到mysql一直是全表插入的,这次因为要插入mysql数据库里面某几列,在执行任务的时候遇到了一点小问题。
如何通过LOAD DATAlocal INFILE myfile.txt插入到mysql的某几列中:
标准形式如下:
LOAD DATA local INFILE myfile.txt
Character set utf8
FIELDS TERMINATED BY ‘\t’
(column1, column2, …);
我在运行中出现错误的原因是将字符集和分隔符设置放在列选择位置后面了,所以一直报错。
报错内容为:
ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; checkthe manual that corresponds to your MariaDB server version for the right syntaxto use near 'character set utf8
FIELDS TERMINATED BY '\t'' at line 2