Solr indexing, split string field into list

0
votes

In Solr, I want to index string field as list by splitting it.

Below is my indexing query in data_config.xml file.

<document name="Example">
<entity dataSource="example_table" name="Example" 
    query="select id, text from example_table"
    pk="id"
    transformer="RegexTransformer"
>
    <field column="id" name="id" />
    <field column="text" name="text" />
</entity>

Field text is a comma separated string. Example: "A, B, C"

Below is the field definition in schema.xml file

<field name="text" type="string" indexed="true" stored="true" required="false" multiValued="true" />

When I'm querying Solr the output is:

"text":["A, B, C"]

Could someone explain me how can I get the result as below?

"text":["A","B","C"]
1
textindexingsolrtokenize

1 Answers

0
votes

To do it in your DataImportHandler definition (since you've already added the RegexTransformer):

<field column="text" name="text" splitBy=", " />

Or do it in your field definition by using a TextField with a Regular Expression Pattern Tokenizer:

<analyzer>
  <tokenizer class="solr.PatternTokenizerFactory" pattern=","/>
  <filter class="solr.TrimFilterFactory"/>
</analyzer>