先看问题kittle没报错但数据没有同步到hive,表中字段无数据
解决方法:首先要确保连接mysql的数据是可以正常预览
在字段选择中尤其要注意字段类型是date类型
hdfs输出就要把date改成出utf8
在这里插入图片描述
然后在修复分区数据库中的表
msck repair table itcast_ods.itcast_orders;
msck repair table itcast_ods.itcast_goods;
msck repair table itcast_ods.itcast_order_goods;
msck repair table itcast_ods.itcast_ods;
msck repair table itcast_ods.itcast_goods_cats;
msck repair table itcast_ods.itcast_org;
msck repair table itcast_ods.itcast_order_refunds;
msck repair table itcast_ods.itcast_users;
msck repair table itcast_ods.itcast_user_address;
msck repair table itcast_ods.itcast_payments;
最后在确认mysql日期数据类型
注意字段选择输出
在查看表数据就可以正常显示