The below error clearly says that you have declared a unique id but that
unique id is missing for some documents.
org.apache.solr.common.SolrException: [doc=null] missing required field:
nameid
This is mainly because you are just trying to import 2 tables in to a
document without any relationship between the data of 2 tables.
table 1 has the nameid (unique key) but table 2 has to be joined with table
1 to form a relationship between the 2 tables. You can't just dump the value
since table 2 might have more values than table1 (but table1 has the unique
id).
I am not sure of your table structure, I am assuming that there is a key
(ex: nameid in title table) that can be used to join name and title table.
Try something like this..
<document>
<entity name="name" query="SELECT id, name FROM name LIMIT 10">
<field column="id" name="nameid" />
<field column="name" name="name" />
</entity>
* <entity name="title" query="SELECT id, title FROM title where
nameid=${name.id}">
* <field column="id" name="titleid" />
<field column="title" name="title" />
</entity>
</document>
</dataConfig>
--
View this message in context:
http://lucene.472066.n3.nabble.com/data-import-problem-tp4068345p4068636.html
Sent from the Solr - User mailing list archive at Nabble.com.
