Enter code here...
Hi Guilia,
First things first - thank you so much!!!
Here's my progress so far:
1. I see sub-queries being executed as expected, for example I can get the
vertices required using
select from (select expand(in('AuthorOf')) from (select expand(out()) from
Author where name="author2"))
in the Graph Editor.
2. However, when I try to run the full set of queries that you gave me, the
following happens:
Functions tab writes to log:
2015-06-19 12:52:37:240 SEVERE Internal server error:
com.orientechnologies.orient.core.command.OCommandExecutorNotFoundException:
Cannot find a command executor for the command request: sql.(select from
(select expand(in('AuthorOf')) from (select expand(out()) from Author where
name="author2"))), [ONetworkProtocolHttpDb]
Graph tab writes to log:
2015-06-19 13:10:21:009 SEVERE Internal server error:
com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error on
parsing command at position #142: Found unexpected keyword '$B' while it
was expected '[=]'. Use SELECT [<Projections>] FROM <Target> [LET
<Assignment>*] [WHERE <Condition>*] [ORDER BY <Fields>* [ASC|DESC]*] [LIMIT
<MaxRecords>] [TIMEOUT <TimeoutInMs>] [LOCK none|record] [NOCACHE]
Command: select expand($c)
let $a = (select from (select expand(in('AuthorOf')) from (select
expand(out()) from Author where name="author2"))),
$b = (select from (select expand(out()) from (select from (select
expand(in('AuthorOf')) from (select expand(out()) from Author where
name="author2"))))),
$c = unionAll($a, $b)
------------------------------------------------------------------------------------------------------------------------------------------------------^
[ONetworkProtocolHttpDb]
I'm running OrientDB v.2.1, but also tried on v2.1-rc4 with the same result.
Thoughts?
Thank you!
Dennis
--
---
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.
