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.