Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: solr-user@lucene.apache.org
From: Matthias Fischer <Matthias.Fischer@doubleslash.de>
To: "'solr-user@lucene.apache.org'" <solr-user@lucene.apache.org>
Subject: Nested entities not imported / do not show up in search?
Thread-Topic: Nested entities not imported / do not show up in search?
Thread-Index: AdEIBGZV0a6fqU+mQ8aSoJWAaQ1+VQ==
Date: Fri, 16 Oct 2015 11:40:04 +0000
Message-ID: <57f5cf63d8674baba45c15a86aaa9f2d@FDHMSX01.doubleslash.org>
Accept-Language: de-DE, en-US
Content-Language: de-DE
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

Hello everybody,

I am trying to import from an Oracle DB 11g2 via DIH using SOLR 5.3.1.=20
In my relational DB there are company addresses (table tb_firmen_adressen) =
and branches (table tb_branchen). They have an n:m relationship using the j=
oin table tb_firmen_branchen.=20
Now I would like to find companies by their name and in each company result=
 I would like to see the associated branches.
However I only get the companies without the nested entries. As a newbie I'=
d highly appreciate some help as there are no errors or warnings in the log=
 file and I could not find any helpful hints in the documentation or elsewh=
ere in the internet concerning my problem.=20

Here is my data config:

    <dataConfig>
        <dataSource name=3D"jdbc" driver=3D"oracle.jdbc.driver.OracleDriver=
" url=3D"jdbc:oracle:thin:@//xxxxx.xxxxxxx:1521/pde11" user=3D"myuser" pass=
word=3D"mysecret"/>
    <document>
        <entity name=3D"firma" pk=3D"fa.EBI_NR" query=3D"
            SELECT fa.EBI_NR, fa.NAMENSZEILE_1, fa.NAMENSZEILE_2, fa.NAMENS=
ZEILE_3
            FROM tb_firmen_adressen fa=20
            WHERE rownum &lt; 10000
        ">
                                           =20
            <field name=3D"firma_ebi_nr"        	 	column=3D"EBI_NR" />
            <field name=3D"firma_namenszeile_1" 	column=3D"NAMENSZEILE_1" /=
>
            <field name=3D"firma_namenszeile_2" 	column=3D"NAMENSZEILE_2" /=
>
            <field name=3D"firma_namenszeile_3" 	column=3D"NAMENSZEILE_3" /=
>
                   =20
            <entity name=3D"firma_branche" child=3D"true" query=3D"
                SELECT b.EBC_CODE AS EBC_CODE
                FROM=20
                    tb_firmen_branchen fb=20
                        JOIN tb_branchen b ON fb.EBC_CODE =3D b.EBC_CODE=20
                WHERE fb.EBI_NR=3D'${firma.firma_ebi_nr}'
            ">
                <field name=3D"branche_ebc_code" column=3D"EBC_CODE" />
                <!-- I would like to add more fields later here once I get =
it to work -->
            </entity>
     =20
        </entity>
    </document>
    </dataConfig>


And here are the relevant lines from my schema file:

    <uniqueKey>firma_ebi_nr</uniqueKey>

     <field name=3D"firma_ebi_nr" 		type=3D"long" 		required=3D"true" 	inde=
xed=3D"true" 	stored=3D"true"/>
     <field name=3D"firma_namenszeile_1" 	type=3D"text_general" 				indexed=
=3D"true" 	stored=3D"true"/>
     <field name=3D"firma_namenszeile_2" 	type=3D"text_general" 				indexed=
=3D"true" 	stored=3D"true"/>
     <field name=3D"firma_namenszeile_3" 	type=3D"text_general" 				indexed=
=3D"true" 	stored=3D"true"/>
     <field name=3D"branche_ebc_code" 		type=3D"long" 					indexed=3D"true"=
 	stored=3D"true"/>
    =20


After restarting solr and calling http://localhost:8983/solr/jcg/dataimport=
?command=3Dfull-import I get "Indexing completed. Added/Updated: 9999 docum=
ents. Deleted 0 documents."
So basically it seams to work, but my search results look like this:

{
  "responseHeader":{
    "status":0,
    "QTime":71,
    "params":{
      "q":"Der Bunte",
      "defType":"edismax",
      "indent":"true",
      "qf":"firma_namenszeile_1",
      "wt":"json"}},
  "response":{"numFound":85,"start":0,"docs":[
      {
        "firma_ebi_nr":123123123,
        "firma_namenszeile_1":"Der Bunte Laden",
        "_version_":1515185579421073408},
      {
     ...
}

Why are there no company branches inside the company records? What's wrong =
with my configuration? Any help is appreciated!

Kind regards
Matthias Fischer