I'm using OrientDB 2.1.0 on Windows
I'm trying to delete all vertexes of a certain class (the new BATCH option
looks helpful), but the DELETE VERTEX command doesn't do anything without
WHERE.
E.g., when I run:
DELETE VERTEX MyVertex
I just get:
{
"result": [
{
"@type": "d",
"@version": 0,
"value": 20
}
],
"notification": "Query executed in 0.055 sec. Returned 1 record(s)"
}
The same thing happens when I run "DELETE VERTEX MyVertex BATCH 100".
The query does run if I use:
DELETE VERTEX MyVertex WHERE @rid is not null
...but I get a GC memory error if I'm trying any more memory-intensive
WHERE statement.
Unfortunately I also get an error when I try and append BATCH here:
DELETE VERTEX MyVertex WHERE OtherProperty is not null BATCH 100
Error:
com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error on
parsing command at position #0: Encountered " <BATCH> "BATCH "" at line 1,
column 53. Was expecting one of: <EOF> <AND> ... <OR> ... <ORDER> ...
<GROUP> ... <LIMIT> ... <SKIP2> ... <OFFSET> ... <TIMEOUT> ... <FETCHPLAN>
... <LOCK> ... <NOCACHE> ... <PARALLEL> ... <UNWIND> ... ";" ... <AND> ...
<OR> ... <GROUP> ... <ORDER> ... <UNWIND> ... <SKIP2> ... <OFFSET> ...
<LIMIT> ... <FETCHPLAN> ... <TIMEOUT> ... <LOCK> ... <PARALLEL> ...
<NOCACHE> ...
Thanks,
Ben
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
