Thanks for the prompt reply Jack. Could you point me towards any code
examples of that technique?
On Fri, Aug 24, 2012 at 4:31 PM, Jack Krupansky <j...@basetechnology.com> wrote:
> The general rule in Solr is simple: denormalize your data.
>
> If you have some maps (or tables) and a set of keys (columns) for each map
> (table), define fields with names like <map-name>_<key-name>, such as
> "map1_name", "map2_name", "map1_field1", "map2_field1". Solr has dynamic
> fields, so you can define "<map-name>_*" to have a desired type - if all the
> keys have the same type.
>
> -- Jack Krupansky
>
> -----Original Message----- From: Sheldon P
> Sent: Friday, August 24, 2012 3:33 PM
> To: solr-user@lucene.apache.org
> Subject: How do I represent a group of customer key/value pairs
>
>
> I've just started to learn Solr and I have a question about modeling data
> in the schema.xml.
>
> I'm using SolrJ to interact with my Solr server. It's easy for me to store
> key/value paris where the key is known. For example, if I have:
>
> title="Some book title"
> author="The authors name"
>
>
> I can represent that data in the schema.xml file like this:
>
> <field name="title" type="text_general" indexed="true"
> stored="true"/>
> <field name="author" type="text_general" indexed="true"
> stored="true"/>
>
> I also have data that is stored as a Java HashMap, where the keys are
> unknown:
>
> Map<String, String> map = new HashMap<String, String>();
> map.put("some unknown key", "some unknown data");
> map.put("another unknown key", "more unknown data");
>
>
> I would prefer to store that data in Solr without losing its hierarchy.
> For example:
>
> <field name="map" type="maptype" indexed="true" stored="true"/>
>
> <field name="some unknown key" type="text_general" indexed="true"
> stored="true"/>
>
> <field name="another unknown key" type="text_general" indexed="true"
> stored="true"/>
>
> </field>
>
>
> Then I could search for "some unknown key", and receive "some unknown data".
>
> Is this possible in Solr? What is the best way to store this kind of data?
