You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by lash20 <la...@hotmail.com> on 2013/11/18 19:51:36 UTC
Problem using splitBy to populate a multi valued field
Hi there,
I'm having trouble using the splitBy functionality to populate a multi
valued field from a pipe delimited datasource. My implementation seems to
partially work for one of the field and does not the work for the the other
field. An example of my implementation below.
I have a db view with following data:
recordId relist dbaName
1 PA21|MD29 The Hong Kong Dragon|The Peeled Apple
My config:
<dataConfig>
<dataSource name="jdbc" driver="oracle.jdbc.driver.OracleDriver"
url="jdbc:oracle:thin:@myserver:1521:XE" user="MyUser"
password="MyPassword"/>
<document>
<entity name="mentity" query="select * from MySampleView"
transformer="RegexTransformer" >
<field sourceColName="relist" column="relist" splitBy="\|" />
<field sourceColName="dbaName" column="dbaName" splitBy="\|" />
<field column="recordId" name="recordId" />
</entity>
</document>
</dataConfig>
My schema.xml snippet:
<fields>
<field name="relist" type="string" indexed="true" stored="true"
multiValued="true" />
<field name="dbaName" type="string" indexed="true" stored="true"
multiValued="true" />
<field name="recordId" type="string" indexed="true"
stored="true" multiValued="false" />
</fields>
<uniqueKey>recordId</uniqueKey>
My expectation is that when the data is split and stored, that the document
would look something like this:
"docs": [
{
"relist": [
"PA21",
"MD29"
],
"recordId": "1",
"dbaName": [
"The Hong Kong Dragon",
"The Peeled Apple"
]
}
]
However, this is what I get:
"docs": [
{
"relist": [
"PA21",
"MD29",
"PA21|MD29"
],
"recordId": "1",
"dbaName": [
"The Hong Kong Dragon|The Peeled Apple"
]
}
]
My issue:
1) relist is being split but it also includes the original delimited value
in the list
2) dbaName is not being split at all
Any help would be appreciated.
Thanks
--
View this message in context: http://lucene.472066.n3.nabble.com/Problem-using-splitBy-to-populate-a-multi-valued-field-tp4101770.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: Problem using splitBy to populate a multi valued field
Posted by saravanan1980 <sa...@nbcuni.com>.
Hi, Is that the below issue resolved for you? I am also having the same
problem. Please let me know, how did you resolve this issue? Thanks
--
View this message in context: http://lucene.472066.n3.nabble.com/Problem-using-splitBy-to-populate-a-multi-valued-field-tp4101770p4260276.html
Sent from the Solr - User mailing list archive at Nabble.com.
Re: Problem using splitBy to populate a multi valued field
Posted by saravanan1980 <sa...@nbcuni.com>.
Hi,
Is that the below issue resolved for you?
I am also having the same problem.
Please let me know, how did you resolve this issue?
Thanks
--
View this message in context: http://lucene.472066.n3.nabble.com/Problem-using-splitBy-to-populate-a-multi-valued-field-tp4101770p4260275.html
Sent from the Solr - User mailing list archive at Nabble.com.