Hi!! Knime Experts & Enthusiastic.
Hope you are doing well.
I need your help to convert following query of mongodb to knime mongodb reader query.
MSEG is table name:
Initially if you want to load just 1 million records so below is query for it,
Now if we want to load next 1 million records, below is query, it will skip initially 1 million loaded records and load next 1 million records
Basically, MSEG is having more than 100 million line items, and because of heavy data in knime mongodb reader is not able to load full table at once.So i have decided to break the table into 1 million.
Now issue is how to write/execute above query in knime mongodb reader.