How to search based on RID, let's say we have 10 Million Documents in one database in one class, I want to search and filter 1 Million Documents based on RID, How should we pass the 1 M RID string to limit search in entire 10 M records class... and than aggregate on result...
On Wednesday, January 7, 2015 11:44:18 AM UTC-5, Lvc@ wrote: > > Hi Mihai, > You're right: typo in docs. Fixed now. > > Thanks, > Lvc@ > > > On 7 January 2015 at 16:32, Mihai Dinca <[email protected] <javascript:>> > wrote: > >> I found the problem. The select specified in documentation is wrong ( >> http://www.orientechnologies.com/docs/last/orientdb.wiki/SQL.html#having) >> >> It should be >> >> SELECT *FROM* ( >> SELECT city, SUM(salary) AS salary >> FROM Employee >> GROUP BY city >> ) WHERE salary > 1000 >> >> >> Without FROM in first select, nothing will be return, no error is thrown. >> >> >> -- >> >> --- >> 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. >> > > -- *Notice of Confidentiality* *This email message and its attachments (if any) are intended solely for the use of the addressees hereof. In addition, this message and any attachments may contain information that is confidential, privileged and exempt from disclosure under applicable law. If you are not the intended recipient of this message, you are prohibited from reading, disclosing, reproducing, distributing, disseminating or otherwise using this transmission. Delivery of this message to any person other than the intended recipient is not intended to waive any right or privilege. If you have received this message in error, please promptly notify the sender by reply email and immediately delete this message from your system.* -- --- 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.
