union functionality?

[Tang Minzhi]

Hey everyone,

I'm newbie to solr.

I have a question below:
Assume that I have the fields 'item_name' and 'category_name', like
item_name | category_name
apple             fruit
orange          fruit
rice                grain
corn              grain
strawberry    fruit
beef              meat
....

I want to fetch the result set of "top 2 item of each categories I specified (might be 2 of them 'fruit', 'grain')" at one time, instead of fetch them through several requests, is it possible with solr?

It seems that in mysql database, there's union functionality which can combine several request queries together, so how about solr?

Thanks.

Best regards,
--------------------------------
Minzhi Tang
Skype: minzhitang
MSN: tminzhi@...

[hossman]

http://people.apache.org/~hossman/#solr-dev
Please Use "solr-user@lucene" Not "solr-dev@lucene"

Your question is better suited for the solr-user@lucene mailing list ...
not the solr-dev@lucene list.  solr-dev is for discussing development of
the internals of the Solr application ... it is *not* the appropriate
place to ask questions about how to use Solr (or write Solr plugins)
when developing your own applications.  Please resend your message to
the solr-user mailing list, where you are likely to get more/better
responses since that list also has a larger number of subscribers.



: Date: Fri, 6 Nov 2009 13:03:03 +0800
: From: Tang Minzhi <MinzhiTang@...>
: Reply-To: solr-dev@...
: To: "solr-dev@..." <solr-dev@...>
: Subject: union functionality?
:
: Hey everyone,
:
: I'm newbie to solr.
:
: I have a question below:
: Assume that I have the fields 'item_name' and 'category_name', like
: item_name | category_name
: apple             fruit
: orange          fruit
: rice                grain
: corn              grain
: strawberry    fruit
: beef              meat
: ....
:
: I want to fetch the result set of "top 2 item of each categories I specified (might be 2 of them 'fruit', 'grain')" at one time, instead of fetch them through several requests, is it possible with solr?
:
: It seems that in mysql database, there's union functionality which can combine several request queries together, so how about solr?
:
: Thanks.
:
: Best regards,
: --------------------------------
: Minzhi Tang
: Skype: minzhitang
: MSN: tminzhi@...



-Hoss