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.
