1、编写脚本mysql-to-hive.json{"job": {"setting": {"speed": {"channel": 3},"errorLimit": {"record": 0,"percentage": 0.02}},"c

1、hive建表create table nf_meat_ods.emp_wide (empno int,ename string,job string,mgr int,hiredate date,sal int,comm int,deptno int,dname string,loc string)ROW format delimited fields terminated BY “,” STO

1、查看secure_file_privshow global variables like ‘%secure_file_priv%’;必须先将csv文件放在MySQL的files文件夹内才能导入：/var/lib/mysql-files/或vi my.cnfsecure_file_priv=2、MySQL插入参数insert ignore当出现主键或唯一索引重复之后，插入会失败，但不会报错，会忽