Kettle Extract MongoDB max number

Extract the largest numbered simple instance of a specified date from MongoDB

Extracting configuration using MongoDB input

1. Database Connection Configuration

2. Configure the database and data set, the configured user name password does not have the front line to get the list of databases, use get DBS to retrieve the database list, directly fill in the database name to be linked, then get collections can fetch to the dataset, and then use SELECT query table.

3. Configure the query statement, because MONGODB query a data to use $limit, you must use the aggregate function, so you need to check the query is aggregation pipeline option, detailed aggregate function in the MongoDB API is provided.

4. Configure the field to get and name it, where path is the field in MongoDB to use $. To get.

5. Previewing data

Kettle Extract MongoDB max number