How can copy 2 fields data to one field on Solr

Question

I have a document in solr with Lat and Lng fields. I need to add a new field called store containing data taken from both the Lat and Lng. I tried to use copyField field but I got the error:

Field store is not multivalued and destination for multiple copyFields (2)

Here is my configuration:

<fields>
  <field name="lat" type="sdouble" indexed="true" stored="true" required="true" multiValued="false" />
  <field name="lng" type="sdouble" indexed="true" stored="true" required="true" multiValued="false" /> 
  <field name="store" type="text" indexed="true" stored="true"/>
</fields> 

<copyField source="lat" dest="store"/> 
<copyField source="lng" dest="store"/>

Is it possible to copy the content of two fields within the same destination field?

I tried this, and the field `store` does not appear on the record — Yirmiyahu Fischer, May 30 '22 at 13:07

score 7 · Answer 1 · answered Oct 16 '16 at 13:32

Maybe is it outdated but you can use "updateRequestProcessorChain"

<updateRequestProcessorChain name="composite-position">
  <processor class="solr.CloneFieldUpdateProcessorFactory">
    <str name="source">lat</str>
    <str name="source">lng</str>
    <str name="dest">store</str>
  </processor>
  <processor class="solr.ConcatFieldUpdateProcessorFactory">
    <str name="fieldName">store</str>
    <str name="delimiter">;</str>
  </processor>
  <processor class="solr.LogUpdateProcessorFactory" />
  <processor class="solr.RunUpdateProcessorFactory" />
</updateRequestProcessorChain>

score 6 · Answer 2 · answered Jun 22 '12 at 20:39

6

Taking your question without context:

Is it possible to copy the content of two fields within the same destination field?"

The answer is yes, surely. The example schema does this with to copy multiple fields to a common "text" field (multiValued) to make searching by one field simpler.

But looking at more context, what you are actually trying to do is determine if Solr's schema.xml with copyField can take an input pair of fields (lat and lon in your case) and concatenate them with an intermediate comma to a particular field. The answer is no. You'll have to prepare the data this way when giving it to Solr, or use a DIH transformer if you are using the DIH (the DataImportHandler). I hesitate to suggest an alternative, but as a hack, you might try putting lat and lon into store_0_coordinate and store_1_coordinate (or maybe it's the other way around). But really, this isn't a recommended approach even if it might work.

answered Jun 22 '12 at 20:39

David Smiley

4,102
2
19
18

Can i do this with "UpdateRequestProcessor"? – Mirodil Jun 23 '12 at 09:08
You could definitely write an URP to do it. That's a good use of an URP. – David Smiley Jun 25 '12 at 04:32
Thanks you. I'm loading data from *.csv file and there are 3 columns postcode,lat,lng in the *.csv file. Could you please help me with configuration URP? – Mirodil Jun 25 '12 at 06:54
I suggest that you take a look at this http://wiki.apache.org/solr/UpdateRequestProcessor and look at an existing one in Solr's code to see how it configures itself from solrconfig.xml. – David Smiley Jun 25 '12 at 21:14
Can you give me a short example, pls? – Mirodil Jun 29 '12 at 09:27

score 3 · Answer 3 · answered Jun 22 '12 at 10:49

3

You could try to set store as multivalued

<field name="store" type="location" indexed="true" stored="true" multiValued="true" />

answered Jun 22 '12 at 10:49

Stelian Matei

11,553
2
25
29

if i make `store` field multiValued. i got error on indexing. – Mirodil Jun 22 '12 at 12:13
1

I see, so you actually need is a single valued field populated with the concatenation of the other two fields. Is that correct? – Stelian Matei Jun 22 '12 at 12:15
I don't think you can work that out with `copyField` instruction. Maybe this link with help you: http://grokbase.com/t/lucene/solr-user/116fd7a7yx/copying-few-field-using-copyfield-to-non-multivalued-field – Stelian Matei Jun 22 '12 at 12:33
Thanks for link but i have another situation in my case the `store` field is `solr.LatLonType` type and i need set there `lat,lng` as single value. – Mirodil Jun 22 '12 at 12:40

score 0 · Answer 4 · edited May 23 '17 at 10:29

0

You can try something like that:

Two double in one location

if you can use DIH (Data Importer Handler). Hope thet will help!

edited May 23 '17 at 10:29

Community

1
1

answered Jun 25 '12 at 07:05

vuky

583
6
19

How can copy 2 fields data to one field on Solr

4 Answers4

Linked