Hi, Omkar.
Could it happen that child docs as well as parents are assigned same "id"
field values implicitly and removed due to uniqueKey collision?
On Sat, Aug 4, 2018 at 10:12 PM omkar.pra...@gmail.com <
omkar.pra...@gmail.com> wrote:
> 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
>
--
Sincerely yours
Mikhail Khludnev
