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] <javascript:>> > : > >> 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] <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.
