I am using similar db-data config as below for indexing this parent-child
data. solr version 6.6.2
SELECT id as emp_id, name FROM emp;
+--------+--------+
| emp_id | name |
+--------+--------+
| 1 | omkar |
| 2 | ashwin |
+--------+--------+
2 rows in set (0.00 sec)
select * from emp_details ;
+------+--------+-------+
| id | emp_id | dept |
+------+--------+-------+
| 1 | 1 | IT |
| 2 | 1 | Data |
| 3 | 2 | ITI |
| 4 | 2 | Entry |
+------+--------+-------+
4 rows in set (0.00 sec)
<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,dept
from emp_details where
emp_id = '${parent.id}'">
<field column="dept"
name="dept" />
</entity>
</entity>
</document>
</dataConfig>
{
"responseHeader":{
"status":0,
"QTime":0,
"params":{
"q":"*:*",
"indent":"on",
"wt":"json",
"_":"1533325469162"}},
"response":{"numFound":2,"start":0,"docs":[
{
"name":"omkar",
"id":"1",
"dept":"IT",
"_version_":1607809693975052288},
{
"name":"ashwin",
"id":"2",
"dept":"ITI",
"_version_":1607809693978198016}]
}}
I am expecting multi child documents. so i added child=true
<entity name='child' child='true' query="select id,dept from emp_details
where emp_id = '${parent.id}'">
but output of indexing is as below and it does not process any doucment
Indexing completed. Added/Updated: 0 documents. Deleted 0 documents.
Requests: 3 , Fetched: 6 , Skipped: 0 , Processed: 0
Started: less than a minute ago
can you helping me if there is any issue with db or solr config
--
Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html
