A Solr index does not need a unique key, but almost all indexes use one. http://wiki.apache.org/solr/UniqueKey
Try the below query passing id as id instead of titleid.. <document> <entity name="title" query="SELECT id, title FROM name"></entity> </document> A proper dataimport config will look like, <entity name="relationship_entity" query="select id,name,value from table"> <field column="id" name="idSchemaFieldName"/> <field column="name" name="nameSchemaFieldName"/> <field column="value" name="valueSchemaFieldName" /> </entity> -- View this message in context: http://lucene.472066.n3.nabble.com/data-import-problem-tp4068345p4068447.html Sent from the Solr - User mailing list archive at Nabble.com.