Solr Index Handlers with Multivalue Field

Question

I want to import a CSV into solr via Index Handlers like described in the docs: https://solr.apache.org/guide/7_1/uploading-data-with-index-handlers.html#csv-update-parameters

I have a CSV with the following structure:

ID    |    Name    |    Property    |
1     |    Tee     |     Sweet      |
1     |    Tee     |     Fluid      |
1     |    Tee     |      Hot       |
2     |   Bread    |     Salty      |
3     |    Milk    |     Fluid      |

The first values are always equal if the ID is the same, only the property varies. Now I want to import the property as a multivalue Field to solr.

Is there any way to achieve this with a Index Handler. If not, how else?

Hector Correa · Accepted Answer · 2021-09-16 17:33:43Z

1

I will write a program to scan through the CSV data and produce the JSON objects that you can ingest into Solr. This will require you to scan all rows in the CSV file so that you can aggregate properties for rows with the same ID that way you will end up with a JSON like this:

[
{id: 1, name: "Tree", properties: ["Sweet", "Fluid", "Hot"]},
{id: 2, name: "Bread", properties: ["Salty"]},
{id: 3, name: "Milk", properties: ["Fluid"]}
]

You will want to use field names that match your schema or your dynamic field definitions so that they are indexed properly too.

edited Sep 16, 2021 at 17:33

answered Sep 16, 2021 at 13:58

Hector Correa

26.7k8 gold badges61 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Tim Dreier Over a year ago

I hoped to avoid that, but that's the way I made it work, thanks!

Collectives™ on Stack Overflow

Solr Index Handlers with Multivalue Field

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related