Sure we do this a lot for smaller indexes.
Create a string field. Not text. Store it. Then it will come out when you do a
simple select query.
<field name="address_xml" type="string" indexed="false" stored="true"
omitNorms="true" />
Sent from my Mobile device
720-256-8076
On Mar 11, 2012, at 11:09 AM, Angelyna Bola <angelyna.b...@gmail.com> wrote:
> William,
>
> :: You can also use external fields, or store formatted info into a
> String field in json or xml format.
>
> Thank you for the idea . . .
>
> I have tried to load xml formatted data into Solr (not to be confused
> with the Solr XML load format), but not had any luck. Could you please
> point me to an example of how to load and take advatage of xml format
> in a solr core?
>
> I can see it being straight forward to load json format into a solr
> core, but I do not see how I can leverage it for this problem? Could
> you please point me to an example?
>
> External fields are new to me. From what I'm reading I am not seeing
> how I can use them to help with this problem. Could you explain?
>
> Respectfully,
>
> Angelyna
>
>
>
> On Sat, Mar 10, 2012 at 7:58 PM, Angelina Bola <angelyna.b...@gmail.com>
> 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
