We will use RID or Document ID field as incremental field when we insert the documents in OrientDB and when search we will use RID or Doc ID list to limit the search with in particular set of documents.... from entire database.
Thans -Vishal On Wednesday, January 7, 2015 at 12:41:47 PM UTC-5, Lvc@ wrote: > > 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] > <javascript:>> 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] <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.
