Hi, Sorry but INVERT and INVERSE was never part of CREATE EDGE command! Best Regards,
Luca Garulli CEO at Orient Technologies LTD the Company behind OrientDB <http://orientdb.com> On 4 June 2015 at 20:47, MV-dev1 <[email protected]> wrote: > 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. > -- --- 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.
