Incremental ingestion of data using the API not accepting upserting of duplicates #5511

Hi,

totally new to arcadia DB, I wan to try it to improve features and inference of an existing database. As the DB is reasonably big, I want to have an incremental ingestion system that will incrementally filll the arcadia db to keep it in sync with the sql DB.

I have tried 2 things :
-batch import, but it fails as soon as I have duplicates.

• sql upserts, but query working in the http interface fail with "query is not idempotent" error.

I guess I must be doing something wrong, or I missed something in the documentation that would explain this and indicate how to fix it.

To give more info, I want to start small with 2 tables T1 & T2 and 1 Link linking T1 to T2 at a given date.
The simple approach I intended to use was :

1. Get the list of new links from the sql DB
2. Extract the list of unique objects from both T1 & T2 from this list
3. Upsert the list of vertexes in T1 & T2
4. insert the new links

However this fails as soon as an object has already been imported.