alibaba / alibaba/DataX

求助:mogodb怎么使用datax实现增量同步,query条件怎么写?

Open
#1,040 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
Java
Stars
17.4k
Forks
5.7k
PR merge metrics
No merged PRs in 30d

Description

"column": [
{
"index":0,
"name": "_id",
"type": "string"
},
{
"index":1,
"name": "uid",
"type": "String"
},
{
"index":2,
"name": "taskCode",
"type": "string"
},
{
"index":3,
"name": "taskName",
"type": "string"
},
{
"index":4,
"name": "rewardType",
"type": "Int"
},
{
"index":5,
"name": "rewardContentId",
"type": "string"
},
{
"index":6,
"name": "terminal",
"type": "Int"
},
{
"index":7,
"name": "desc",
"type": "string"
},
{
"index":8,
"name": "createTime",
"type": "Date"
}
],
"query":"{createTime:{ $gte: ${t1}, $lte: ${t2} }}"
}
query这样写,但是一条数据都没有查出来,mogodb是ISOdate格式,${t1}取得的值是1622995200101,我t1的变量这样直接用时间戳可以吗,还是跟mogodb一样,使用ISODate,两种格式都用过,但现在一条数据也没有查到...求助~

Contributor guide

No contributing guide indexed for this repository

Research direction

Begin with the MongoDB query shown in the issue and the ${t1}/${t2} parameter values; compare the configured createTime type with the values sent to MongoDB. The payload names no source file or test. Done means identifying a reproducible cause and specifying the supported query or parameter format, or confirming that a product change is required.

Written by the indexing model from the issue text.

Assessment

Tech stack
java, mongodb
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.