I just updated to the latest orientdb-community-2.1-rc3 and (this vvv) is
still happening.
Part of some data scrubbing after importing a giant MSSQL database.
CREATE EDGE _Person_Alias
> FROM (SELECT FROM PersonAlias LET $id1 = personId, $id2 = aliasId WHERE
> in('_Person_Alias')[0] is null)
> TO (SELECT FROM Person WHERE personId = $id2) INVERT;
>
I get the following error:
Error: com.orientechnologies.orient.core.sql.OCommandSQLParsingException:
> Error
> on parsing command at position #0: Encountered " <IDENTIFIER> "INVERSE ""
> at lin
> e 1, column 240.
> Was expecting one of:
> <EOF>
> <SELECT> ...
> <FROM> ...
> <SET> ...
> <CONTENT> ...
> <WAIT> ...
> <RETRY> ...
> "(" ...
> ";" ...
>
I need it to be INVERSE because I want all my outs to be Person.
Also let me know if there's a more efficient way to write this.
By the way, I couldn't get this to work as part of the ETL import - was
only able to get ETL to create vertexes so I have this step to build all
the edges.
*And, finally, I'd love to help make OrientDB more stable. I'm seemingly
doing simple stuff but hung or crashed it 4 times day in 4 different ways
with seemingly simple tasks.*
--
---
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.
