You can do what you want either by using two queries or using grouping/field collapsing.
Best, Erick On Fri, Apr 3, 2015 at 8:03 AM, avinash09 <avinash.i...@gmail.com> wrote: > Hi, > > I have a use case search all the name="*test*" from two tables (product and > department) > i need distributed result 5 result from product and 5 from department > > but i am getting first all result from which is 434 and then department as > shared below > > http://localhost:8983/solr/test_core/select?q=name:*test*&wt=json&facet=true&facet.field=table_name > > > { > responseHeader: { > status: 0, > QTime: 19 > }, > response: { > numFound: 569, > start: 0, > docs: [ > { > name: "test 6576", > table_name: "product" > }, > { > name: "test 6578", > table_name: "product" > }, > { > name: "test 65760", > table_name: "product" > }, > { > name: "test 657699", > table_name: "product" > }, > { > name: "test 657699", > table_name: "product" > }, > { > name: "test 657666", > table_name: "product" > }, > { > name: "test 657689", > table_name: "product" > }, > { > name: "test 6576yu", > table_name: "product" > }, > { > name: "test 657607", > table_name: "product" > }, > { > name: "test 657687", > table_name: "product" > } > ] > }, > facet_counts: { > facet_queries: { }, > facet_fields: { > table_name: [ > "product", > 434, > "dealer", > 135 > ] > }, > facet_dates: { }, > facet_ranges: { } > } > } > > please help me > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/distributed-search-on-tables-tp4197456.html > Sent from the Solr - User mailing list archive at Nabble.com.