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]>: > Try with: > $unique = set($conv) > > Riccardo > > 2015-07-14 20:45 GMT+02:00 Ran Mizrachi <[email protected]>: > >> 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]. >> 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. > -- --- 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.
