Return-Path: 
 <solr-user-return-106722-apmail-lucene-solr-user-archive=lucene.apache.org@lucene.apache.org>
X-Original-To: apmail-lucene-solr-user-archive@minotaur.apache.org
Delivered-To: apmail-lucene-solr-user-archive@minotaur.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id CD42C10AA4
	for <apmail-lucene-solr-user-archive@minotaur.apache.org>;
 Fri, 12 Dec 2014 21:41:13 +0000 (UTC)
Received: (qmail 1597 invoked by uid 500); 12 Dec 2014 21:41:10 -0000
Delivered-To: apmail-lucene-solr-user-archive@lucene.apache.org
Received: (qmail 1529 invoked by uid 500); 12 Dec 2014 21:41:10 -0000
Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:solr-user-help@lucene.apache.org>
List-Unsubscribe: <mailto:solr-user-unsubscribe@lucene.apache.org>
List-Post: <mailto:solr-user@lucene.apache.org>
List-Id: <solr-user.lucene.apache.org>
Reply-To: solr-user@lucene.apache.org
Delivered-To: mailing list solr-user@lucene.apache.org
Received: (qmail 1517 invoked by uid 99); 12 Dec 2014 21:41:09 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 12 Dec 2014 21:41:09 +0000
X-ASF-Spam-Status: No, hits=-0.7 required=5.0
	tests=RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of arafalov@gmail.com designates
 209.85.192.179 as permitted sender)
Received: from [209.85.192.179] (HELO mail-pd0-f179.google.com)
 (209.85.192.179)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 12 Dec 2014 21:40:44 +0000
Received: by mail-pd0-f179.google.com with SMTP id fp1so7943557pdb.10
        for <solr-user@lucene.apache.org>;
 Fri, 12 Dec 2014 13:40:43 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to
         :content-type;
        bh=EMoY13X9tg3JWuB5+RzT5Bd2CO3BFb4qg4LL8fQiXHE=;
        b=zpVuf9DgjTgByh/Ac3ltQRIaSkIN+h7m5u4BkE/dbQKct18pL3Hf8fHqmGbscnoogN
         U8GGIuDgNXoepOjf3/EfU8X8gEGuzRe7imXtJfQ0CqvPJ2tz3WdbZom2gfJZCcNcbYpy
         YfKuq2P2e2hp04pqZ4pnGcnaw23gn7UBCjSzz3iFM0tdmYDLurK/pTCWaOZmZDOSOdiz
         sgUX9R5ahFBvBDuI/xiB8LvqGldAUNlL9hNCA6T4MqqaW9vaPoMTHudWmmKFGW2iW+/H
         CHz8ML0QOlF+u7sm9YZ4EgYLcXSuL/30FPVy8+CG8pbhoDIpU8yFzoNhgcSk9FsafuFQ
         MlAw==
X-Received: by 10.70.102.193 with SMTP id fq1mr30554350pdb.19.1418420443092;
 Fri, 12 Dec 2014 13:40:43 -0800 (PST)
MIME-Version: 1.0
Received: by 10.66.220.133 with HTTP; Fri, 12 Dec 2014 13:40:02 -0800 (PST)
In-Reply-To: <548B4784.80400@gmx.ch>
References: <548B22A7.1020003@gmx.ch>
 <CAEFAe-FLWn98odAXMb8mmenBmdD7r3eYWn++-0V1vM=QEf5cqw@mail.gmail.com>
 <548B4784.80400@gmx.ch>
From: Alexandre Rafalovitch <arafalov@gmail.com>
Date: Fri, 12 Dec 2014 16:40:02 -0500
Message-ID: 
 <CAEFAe-HcGEfF0eUkUjLBtUcEbdbnctoxuHf-J3uUe6kBXp+_wA@mail.gmail.com>
Subject: Re: Use a constant entity in all imported documents of DIH
To: solr-user <solr-user@lucene.apache.org>
Content-Type: text/plain; charset=UTF-8
X-Virus-Checked: Checked by ClamAV on apache.org

Have a look at the documentation for the rootEntity attribute.
https://wiki.apache.org/solr/DataImportHandler

If you set it on the outer entity, I think it should give you what you
want with the nested entity structure. Then the outside entity will
load from the constant table and the inside from body_shops.

Regards,
   Alex.
Personal: http://www.outerthoughts.com/ and @arafalov
Solr resources and newsletter: http://www.solr-start.com/ and @solrstart
Solr popularizers community: https://www.linkedin.com/groups?gid=6713853


On 12 December 2014 at 14:52, Per Newgro <per.newgro@gmx.ch> wrote:
> Do you mean with inner entity something like
>     <document>
>         <entity name="bodyshop" query="select id , customer_number
> body_shops where state = 1>
>             <field name="id" column="ID" />
>             <field name="customer_number" column="CUSTOMER_NUMBER" />
>             <entity name="facility" query="select name from facilities where
> body_shop_id=${bodyshop.ID}">
>                 <field name="name" column="name" />
>             </entity>
>        </entity>
>     </document>
>
> Yes that i could use. But i would use always the same entity in the where
> clause of the sub-entity.
> I would like to do something like
>
>     <!-- load a constant entity>
>     <entity name = "constant" query="select attr from constants where state
> = 1">
>     </entity>
>     <document>
>         <entity name="bodyshop" query="select id , customer_number from
> body_shops where state = 1>
>             <field name="id" column="ID" />
>             <field name="customer_number" column="CUSTOMER_NUMBER" />
>             <!-- use data of constant entity here -->
>             <entity name="facility" query="select name from facilities where
> body_shop_id=${bodyshop.ID} and constant_attr = ${constant.attr}">
>                 <field name="name" column="name" />
>             </entity>
>        </entity>
>     </document>
>
> I would like to avoid that repeating join that is required with the above
> "inner entity" method above.
>
> Thanks for your support
> Per
>
>
> Am 12.12.2014 um 18:22 schrieb Alexandre Rafalovitch:
>
>> Sounds like a case for nested entity definitions with the inner entity
>> being the one that's actually indexed? Just need to remember that all
>> the parent mapping is also applicable to all children.
>>
>> Have you tried that?
>>
>> Regards,
>>     Alex.
>>
>>
>> Personal: http://www.outerthoughts.com/ and @arafalov
>> Solr resources and newsletter: http://www.solr-start.com/ and @solrstart
>> Solr popularizers community: https://www.linkedin.com/groups?gid=6713853
>>
>>
>> On 12 December 2014 at 12:15, Per Newgro <per.newgro@gmx.ch> wrote:
>>>
>>> Hello,
>>>
>>> i would like to load an entity before document import in DIH starts.
>>> I want to use the entity id for a sub-select in the document entity.
>>>
>>> Can i achieve something like that?
>>>
>>> Thanks for helping me
>>> Per
>
>