You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Mikhail Khludnev <mk...@apache.org> on 2016/08/04 14:27:10 UTC
Re: Why Nested document 'child' entity query (iterative
count)repeatedly executing?
It seems like debug reporting issue. It deserves a minor Jira.
On Thu, Jul 14, 2016 at 2:38 PM, Rajendran, Prabaharan <Ra...@dnb.com>
wrote:
> Hi All,
>
> I am trying to index nested document. While start full data-import (from
> UI) following options selected Verbose, Commit, Debug & Debug-Mode.
>
> Raw Debug-Response shows that "child" entity query execute repeatedly.
> Kindly help me to understand this, how can I resolve this, am I missed
> anything?
>
> Sample data-config.xml
> <document name="companies">
> <entity name="company"
> transformer="RegexTransformer" rootEntity="true"
> query="SELECT * FROM COMPANY">
> <field column="ID"
> name="c_id"/>
> <field column="DEPARTMENT"
> name="c_department"/>
>
> <entity name="employee"
> child="true"
> query="SELECT * FROM
> EMPLOYEE
> WHERE com_employee_id =
> '${company.ID}'">
> <field
> column="NAME" name="e_name"/>
> <field
> column="EXPERIENCE" name="e_experience"/>
> </entity>
> </entity>
> </document>
>
> ------------------------------------------------------------------------------------------------------------------------------------
> Raw Debug-Response:
>
> "entity:company",
> [
> "document#1",
> [
> "query",
> "SELECT * FROM COMPANY",
>
> "----------------------------------------",
> "transformer:RegexTransformer",
> [
> "entity:employee",
> [
> "query",
> "SELECT * FROM EMPLOYEE WHERE com_employee_id = '1924'",
> ]
> ]
> ],
> "document#2",
> [
> "transformer:RegexTransformer",
> [
> "entity:employee",
> [
> "query",
> "SELECT * FROM EMPLOYEE WHERE com_employee_id = '1924'",
> "query",
> "SELECT * FROM EMPLOYEE WHERE com_employee_id = '1924'",
> ]
> ]
> ]
> ]
>
> "document#3"
> "entity:employee",
> "query",
> "SELECT * FROM EMPLOYEE WHERE com_employee_id = '1924'",
> "query",
> "SELECT * FROM EMPLOYEE WHERE com_employee_id = '1924'",
> "query",
> "SELECT * FROM EMPLOYEE WHERE com_employee_id = '1924'"
>
>
> Thanks,
> Prabaharan
>
--
Sincerely yours
Mikhail Khludnev