Hi,
I'm using v2.0.12.
I noticed that when I go like this it's working:
$conv =
outE("HasPhoneNumber").inV().inE("WrittenAbout").outV("Conversation").asSet(),
but when I apply the asSet() on another variable, it doesn't. e.g.:
$conv =
outE("HasPhoneNumber").inV().inE("WrittenAbout").outV("Conversation"),
$unique = $conv.asSet(),
On Wednesday, July 15, 2015 at 8:40:34 AM UTC+3, Luigi Dell'Aquila wrote:
>
> Hi Ran,
>
> which OrientDB version? I think I fixed a similar issue (LET with
> .asSet()) recently in develop branch
>
> Thanks
>
> Luigi
>
>
> 2015-07-14 21:12 GMT+02:00 Riccardo Tasso <[email protected]
> <javascript:>>:
>
>> Try with:
>> $unique = set($conv)
>>
>> Riccardo
>>
>> 2015-07-14 20:45 GMT+02:00 Ran Mizrachi <[email protected] <javascript:>
>> >:
>>
>>> I already found this answer on google, but it didn't work.
>>>
>>> I get the following error:
>>> com.orientechnologies.orient.core.sql.OCommandSQLParsingException: Error
>>> on parsing command at position #0: No function with name 'asset', available
>>> names are :
>>> [date,encode,distance,document,distinct,dijkstra,traversedelement,sum,decode,bothv,uuid,out,mode,sysdate,avg,min,shortestpath,traversededge,ifnull,symmetricdifference,traversedvertex,stddev,outv,if,map,bothe,unionall,ine,set,oute,intersect,last,max,in,coalesce,count,format,label,list,both,inv,gremlin,eval,percentile,median,variance,difference,first]
>>>
>>> What am I doing wrong?
>>>
>>>
>>> On Tuesday, July 14, 2015 at 9:41:32 PM UTC+3, Riccardo Tasso wrote:
>>>>
>>>> Hi,
>>>> have you tried: $unique = $conv.asSet() ?
>>>>
>>>> Cheers,
>>>> Riccardo
>>>>
>>>> 2015-07-14 20:24 GMT+02:00 Ran Mizrachi <[email protected]>:
>>>>
>>>>> Hi All,
>>>>>
>>>>> I'm trying to get distinct set in a query results but can't make it
>>>>> work.
>>>>> I would appreciate your assistance.
>>>>>
>>>>> My query:
>>>>>
>>>>> select uid, name, $conv, $unique
>>>>> from (select expand(outE("HasCard").inV()) from #12:1310)
>>>>> let
>>>>> $conv = inV().inE().outV("Conversation"), // I'm getting list of @rid
>>>>> -> [#13:23, #13:23, #13:55]
>>>>> $unique = distinct($conv) // trying to get [#13:23, #13:55]
>>>>>
>>>>> I also tried to change the last line to:
>>>>> $unique = (select @rid from Conversation where @rid in $conv)
>>>>> but it didn't work too.
>>>>>
>>>>> Thank you very much for helping!
>>>>>
>>>>> --
>>>>>
>>>>> ---
>>>>> 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] <javascript:>.
>>> 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] <javascript:>.
>> 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.
