Fields can be multi-valued. Put multiple phone numbers in a field and match all of them.
wunder On Mar 10, 2012, at 4:58 PM, Angelina Bola wrote: > Does "Solr" support a 3-way join? i.e. > http://wiki.apache.org/solr/Join (I have the 2-way join working) > > For example, I am pulling 3 different tables from a RDBMS into one Solr core: > > Table#1: Customers (parent table) > Table#2: Addresses (child table with foreign key to customers) > Table#3: Phones (child table with foreign key to customers) > > with a ONE to MANY relationship between: > > Customers and Addresses > Customers and Phones > > When I pull them into Solr I cannot denormalize the relationships as a > given customers can have many addresses and many phones. > > When they come into the my single core (customerInfo), each document > gets a customerInfo_type and a uid corresponding to that type, for > example: > > Customer Document > customerInfo_type='customer' > customer_id > > Address Document > customerInfo_type='address' > fk_address_customer_id > > Phone Document > customerInfo_type='phone' > fk_phone_customer_id > > Logically, I need to query in Solr for Customers who: > > - Have an address in a given state > - Have a phone in a given area code > - Are a given gender > > Syntactically, it would think it would look like: > > - http://localhost:8983/solr/customerInfo/select/? > q={!join from=fk_address_customer_id to=customer_id}address_State:Maine& > fq={!join from=customer_id to=fk_phone_customer_id}phone_area_code:212& > fq=customer_gender:female > > But that does not work for me. > > Appreciate any thoughts, > > Angelyna -- Walter Underwood wun...@wunderwood.org
