Hi, Are your RID random or do you have any big range between them? Lvc@
On 7 January 2015 at 18:30, ATL <[email protected]> wrote: > 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]> 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]. >>> 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. > -- --- 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.
