DELETE with limit generate an error

[tigran-m-dev]

When doing delete in cycle for example something like this

do{
    DELETE FROM index LIMIT 100
}
while(stopcondition)

got an error version_conflict_engine_exception version conflict, current version [2] is different than the one provided [1]

In original elastic _update_by_query they have a param conflicts=proceed
Can we pass parameter like this or do we have an alternate solution for this?

[shi-yuan]

conflicts hint is needed, like this:

DELETE /*! CONFLICTS(proceed) */ FROM index LIMIT 100

[tigran-m-dev]

Have the following error, when running

DELETE /*! CONFLICTS(proceed) */ FROM index LIMIT 100 

query or trying to run explain

{
    "error": {
        "root_cause": [
            {
                "type": "parser_exception",
                "reason": "syntax error"
            }
        ],
        "type": "parser_exception",
        "reason": "syntax error"
    },
    "status": 500
}

[shi-yuan]

because this hint not supported now

[tigran-m-dev]

Is this hint support will be implemented nearest future?

[shi-yuan]

Of course