solr - Returning only specific rows (eg. every 10th: #1, #11, #21...) from query -


I need to bring only specific ones (like "inline rows") from the Solar Index. For example, if the full results are in 10000 rows, then I want to get only the first and last line of every 100 items bucket.

Item 1 and 100 items 101 and 200 items 201 and 300 ...

This group is dynamic and depends on the number of results. Therefore, if there are only 5000 total result rows, the bucket size is 50 instead of 100. I can calculate the actual indexes, but the problem is how they can be brought from solar.

No index can be used directly as query parameters. In practice, I am doing a search "starting with the name" (or some other letter) and I want to get the first item starting from A, starting from A, starting from A, 101 Th item ...

The query parameters are "rows" and "start" but these items can not be skipped, so I will need to get each item with a different query which is disabled. I was also thinking about implementing a filter query which could only filter items 2 ... 99, 199 ... 1 99 but I do not know how to apply it.

I do not know an easy way to do this, but this will reduce the amount of data, And will have to pass back: Tell a regular query to Solr to return the normal start and rows parameters, but only the ID field of each document In your client code, Store the ID of the first and last documents, and the next for start Repeat the query with the sector value. After reaching the end of the search results, you have a list of the document ID that you want. Run a new query and give it a list of the document ID that you want to return, and this time you get the whole document.

Comments

Post a Comment

Popular posts from this blog

Python SQLAlchemy：AttributeError: Neither 'Column' object nor 'Comparator' object has an attribute 'schema' -

I tried to create a new database in my project, but when I run the script, I get this error, I have another project, this type of definition worked before, but now it gets a single error. I am using Python 2.7.8 and the version of SQLAlchemy module is 0.9.8. By the way, using a project flask- SQLAlchemy, it works well, I'm confused. Traceback information is as follows: Traceback (most recent call final): File "D: / Projects / IOM / db_create.py", line 4, & lt; Module & gt; From the models the base file "D: \ Projects \ OO-IM \ models.py", in line 15, in the & lt; Module & gt; Column ( 'followed_id', int (), ForeignKey ( 'user.id')) file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ schema.py", line 369, __new__ schema = metadata. Schema file "C: \ Python27 \ lib \ site-packages \ SQLAlchemy \ SQL \ elements.py", line 662, AttributeError in __getattr__ key): Neither 'column' object nor ...
Read more

java - How not to audit a join table and related entities using Hibernate Envers? -

I use Eners to be hibernate to audit my institutions. I have an audit entity, Foo , which includes a list & lt; Bars & gt; However, I do not want to audit the bar institutions, in the form of properties, I have written that: @inti @edicated public class Foo {@JoinTable (name = "T_FOO_BAR", joinColumns = @JoinColumn (name = "FOO_ID"), inverseJoinColumns = @JoinColumn (Name = "BAR_ID")) @ManyToMany (Cascade = Persist) @ Indited (targetAuditMode = RelationTargetAuditMode.NOT_AUDITED ) Public listing & lt; Bars & gt; GetBars () {Return bars; }} Now, I want to retrieve an amendment of foo : AuditReader reader = AuditReaderFactory.get (GetEntityManager ()); FU modification = (FU) reader.CreativeTeA () .entensEtrevision (Foo Class, 42) .getSingleResult (); Unfortunately, when I want to retrieve all the data (i.e. when it loads lazy times ), error me ORA-00942: table or view is not present , because Tried to query this: Sel...
Read more

mongodb - CakePHP paginator ignoring order, but only for certain values -

While pagging my user model in kppp, I can sort with some values, but not others. For example, I can order results from created or email , for example, but username or reputation seems to come back order by arbitrary command for example with a list of users: $ this-> paginate = array ('condition' => array ( 'User.is_active' = & gt; true), 'border' => 24, 'order' => array ('User.created' => DESC)); Works as expected, but $ this - & gt; Paged = array ('conditions' = & gt; array (' user.isIactive '= & gt; true),' border '= & gt; 24,' command '= & gt; array (' user repeats' = ' & Gt; DESC ')); No, no. I first thought that this could be a database issue, but when I search the database directly, sorted as expected. Note: I am using Mangodebi with the Mongo DB plugin of Ichikawa for the KPPHP; Pagnetizing users are used to work properl...
Read more