Thanks Mikhail, i tried changing conf but that did not help <dataConfig> <dataSource type="JdbcDataSource" name="ds-1" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/test" user="root" password="" session.group_concat_max_len = '70000' /> <document> <entity name="parent" datasource="ds-1" pk="id" transformer="RegexTransformer" query="SELECT id,name FROM emp"> <field column="id" name="id" /> <field column="name" name="name" /> <entity name="child" query="select id as childpk,dept from emp_details where emp_id = '${parent.id}'"> <field column="dept" name="dept" /> <field column="childpk" name="childpk" /> </entity> </entity>
</document> </dataConfig> -- Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html