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)
>
>
> driver="com.mysql.jdbc.Driver"
> url="jdbc:mysql://localhost:3306/test"
> user="root"
> password=""
> session.group_concat_max_len = '7'
> />
>
>
>
> transformer="RegexTransformer"
> query=" SELECT id, name FROM emp">
>
>
>
>
>
> name="dept" />
>
>
>
>
>
>
>
>
>
>
> {
> "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
>
>
>
> 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