Re: distributed search on tables

[avinash09]

thanks Erick



--
View this message in context: 
http://lucene.472066.n3.nabble.com/distributed-search-on-tables-tp4197456p4198285.html
Sent from the Solr - User mailing list archive at Nabble.com.

distributed search on tables

[avinash09]

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=jsonfacet=truefacet.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.

Re: distributed search on tables

[Erick Erickson]

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=jsonfacet=truefacet.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.