结论:字段类型不一致,关联时将key转为double,导致精度丢失
示例:select cast(186994576061124660 as double) 和select cast(186994576061124559 as double)结果都是1.86994576061124672E17 导致最终mapping结果重复
解决方法:需要将id转为string,修改后执行计划见图2
结论:字段类型不一致,关联时将key转为double,导致精度丢失
示例:select cast(186994576061124660 as double) 和select cast(186994576061124559 as double)结果都是1.86994576061124672E17 导致最终mapping结果重复
解决方法:需要将id转为string,修改后执行计划见图2