canaladapter 全量同步到es where参数无效问题解决

不一样的烟火@

已于 2022-04-24 15:52:10 修改

阅读量1.7k

点赞数

分类专栏： SpringBoot 文章标签：后端

于 2022-04-24 14:54:52 首次发布

本文链接：https://blog.csdn.net/wzgbgz/article/details/124382812

版权

SpringBoot 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

mytest_user.yml:

dataSourceKey: defaultDS
destination: DX_tj_SEND_MYSQL_LOG_MSG
groupId: g1
esMapping:
  _index: wx_cp_user_contact_rel_all
  _id: id
#  upsert: true
#  pk: id
  sql: "select
      	CONCAT(a.external_userid, '*', a.follow_user_id) as id,
      	a.external_userid as externalUserid,
      	a.follow_user_id as followUserId,
      	a.follow_user_remark as followUserRemark,
      	a.follow_user_description as followUserDescription,
      	date_format( a.follow_user_createtime, '%Y-%m-%d %H:%I:%S') as followUserCreatetime,
      	a.follow_user_tags_group_name as followUserTagsGroupName,
      	a.follow_user_tags_tag_name as followUserTagsTagName,
      	a.follow_user_tags_type as followUserTagsType,
      	a.follow_user_remark_corp_name as followUserRemarkCorpName,
      	a.address,
      	a.corp_id as corpId,
      	a.follow_user_remark_mobiles as followUserRemarkMobiles,
      	a.follow_user_state as followUserState ,
      	a.status ,
      	a. birthday,
      	date_format( a.link_time, '%Y-%m-%d %H:%I:%S') as linkTime,
      	date_format( a.create_time, '%Y-%m-%d %H:%I:%S') as createTime,
      	b.name,
      	b.avatar,
      	b.type,
      	b.gender,
      	b.unionid,
      	b.position,
      	b.corp_name as corpName,
      	b.corp_full_name as corpFullName,
      	b.external_profile as externalProfile,
      	b.phone
      from
      	wx_cp_user_contact_rel a
      left join  wx_cp_user_contact b on
      	a.external_userid = b.external_userid"
#  objFields:
#    _labels: array:;
  etlCondition: "where a.corp_id ={}"
  commitBatch: 3000

看了源码才知道 where 条件后面的参数是需要在访问的时候传入例如：

源码：