Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id B0CAC200BA7 for ; Fri, 21 Oct 2016 22:23:07 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id AF295160AE8; Fri, 21 Oct 2016 20:23:07 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 00254160ADE for ; Fri, 21 Oct 2016 22:23:06 +0200 (CEST) Received: (qmail 60844 invoked by uid 500); 21 Oct 2016 20:23:05 -0000 Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: solr-user@lucene.apache.org Delivered-To: mailing list solr-user@lucene.apache.org Received: (qmail 60832 invoked by uid 99); 21 Oct 2016 20:23:05 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 21 Oct 2016 20:23:05 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id 9E43C1A0257 for ; Fri, 21 Oct 2016 20:23:04 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -2.19 X-Spam-Level: X-Spam-Status: No, score=-2.19 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, RCVD_IN_DNSWL_MED=-2.3, T_DKIM_INVALID=0.01] autolearn=disabled Authentication-Results: spamd2-us-west.apache.org (amavisd-new); dkim=fail (1024-bit key) reason="fail (message has been altered)" header.d=ingramcontent.onmicrosoft.com Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id ys1axXL-Zbf0 for ; Fri, 21 Oct 2016 20:23:02 +0000 (UTC) Received: from us-smtp-delivery-147.mimecast.com (us-smtp-delivery-147.mimecast.com [216.205.24.147]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 4EF9A5F1C2 for ; Fri, 21 Oct 2016 20:23:01 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=IngramContent.onmicrosoft.com; s=selector1-ingramcontent-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=RPZDnTAJJNWCrJfnEyaXQzvu74Ex8Cfz1mICTQ73AmQ=; b=NbSvGsDtRPffYwT49r6yNIfPv2HQD1+QwMx3C9w3I+ELW/ocF8WecpTGl5g9L60Ua+vNYB0Y+vHKPCFn5z6konamHmZocrpMADclo0SPtc1OujAiSZyo4zE9lAjMYX1YdeRwEBpPoDyN7nzKYJ//9bty7WXRjmNnaqI1Vc5/r9c= Received: from NAM03-BY2-obe.outbound.protection.outlook.com (mail-by2nam03lp0053.outbound.protection.outlook.com [216.32.180.53]) (Using TLS) by us-smtp-1.mimecast.com with ESMTP id us-mta-21-OwhlNWF6NW2nqkY6DGi26g-1; Fri, 21 Oct 2016 16:22:57 -0400 Received: from BN6PR12MB1345.namprd12.prod.outlook.com (10.168.228.15) by BN6PR12MB1346.namprd12.prod.outlook.com (10.168.228.16) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.679.12; Fri, 21 Oct 2016 20:22:55 +0000 Received: from BN6PR12MB1345.namprd12.prod.outlook.com ([10.168.228.15]) by BN6PR12MB1345.namprd12.prod.outlook.com ([10.168.228.15]) with mapi id 15.01.0669.018; Fri, 21 Oct 2016 20:22:56 +0000 From: "Dyer, James" To: "solr-user@lucene.apache.org" Subject: RE: CachedSqlEntityProcessor with delta-import Thread-Topic: CachedSqlEntityProcessor with delta-import Thread-Index: AdIpUQh4NhS6B3/5Q6qgsI3+gM7RXAChp/KQ Date: Fri, 21 Oct 2016 20:22:55 +0000 Message-ID: References: <9f7ba9c9ed2a451790ce473e7aded451@VNUCITEX02.ICFI.icfconsulting.com> In-Reply-To: <9f7ba9c9ed2a451790ce473e7aded451@VNUCITEX02.ICFI.icfconsulting.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: x-originating-ip: [198.183.167.143] x-ms-office365-filtering-correlation-id: 2ae21d7f-7001-4164-c13e-08d3f9f00aed x-microsoft-exchange-diagnostics: 1;BN6PR12MB1346;7:f7WPCx80VLKpxj0PsU40HSfqxqnsUZdA0ywLM4b/4XyQbHJAI6Mceq5qJ6ZFoekZefiFxxcxl9H4LtDmr5FJR/8ygckfmTtI/+e73tpAxrnSCXTR5l0xE9f2VPXDQBR3dgFsgzJWqW3t2AgpC1RqJrP8Czf/5zyX+b8RIlBGPs9KuSEPEKURJgNbAZExiRcv0eAjYYEbTSDBKCFfdX/x9eFCWBizVGW+xwrIGIsAGtH4iSErI+OEiWdYD7HviMLjX2D7vA0dYqbieQECmkOVIrubaV8CKM1Z9VDPSQ7Ei4jsFFJwP+Mi/unNAvwD2t9C34O7uNV3w1ODb0TipUoE9f7A1hOmKaqbQvLhDBgbn+E= x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:;SRVR:BN6PR12MB1346; x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:(263907834895145); x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(6040176)(601004)(2401047)(8121501046)(5005006)(10201501046)(3002001)(6043046)(6042046);SRVR:BN6PR12MB1346;BCL:0;PCL:0;RULEID:;SRVR:BN6PR12MB1346; x-forefront-prvs: 01026E1310 x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(6009001)(7916002)(13464003)(199003)(377454003)(189002)(77096005)(102836003)(586003)(92566002)(6116002)(101416001)(3846002)(15975445007)(2900100001)(122556002)(9686002)(86362001)(50986999)(5002640100001)(54356999)(76176999)(3280700002)(68736007)(99286002)(2351001)(3660700001)(105586002)(76576001)(2950100002)(6916009)(110136003)(33656002)(10400500002)(450100001)(81166006)(8676002)(81156014)(66066001)(74316002)(106356001)(5660300001)(19580405001)(19580395003)(7736002)(7846002)(7696004)(2501003)(87936001)(107886002)(2906002)(8936002)(97736004)(305945005)(189998001);DIR:OUT;SFP:1102;SCL:1;SRVR:BN6PR12MB1346;H:BN6PR12MB1345.namprd12.prod.outlook.com;FPR:;SPF:None;PTR:InfoNoRecords;A:1;MX:1;LANG:en; spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM MIME-Version: 1.0 X-OriginatorOrg: ingramcontent.com X-MS-Exchange-CrossTenant-originalarrivaltime: 21 Oct 2016 20:22:55.8341 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: b0c8355a-fd2f-4918-88f7-8571e0070826 X-MS-Exchange-Transport-CrossTenantHeadersStamped: BN6PR12MB1346 X-MC-Unique: OwhlNWF6NW2nqkY6DGi26g-1 Content-Type: text/plain; charset=WINDOWS-1252 Content-Transfer-Encoding: quoted-printable archived-at: Fri, 21 Oct 2016 20:23:07 -0000 Sowmya, My memory is that the cache feature does not work with Delta Imports. In f= act, I believe that nearly all DIH features except straight JDBC imports do= not work with Delta Imports. My advice is to not use the Delta Import fea= ture at all as the same result can (often more-efficiently) be accomplished= following the approach outlined here: https://wiki.apache.org/solr/DataImp= ortHandlerDeltaQueryViaFullImport James Dyer Ingram Content Group -----Original Message----- From: Mohan, Sowmya [mailto:Sowmya.Mohan@icf.com]=20 Sent: Tuesday, October 18, 2016 10:07 AM To: solr-user@lucene.apache.org Subject: CachedSqlEntityProcessor with delta-import Good morning, Can CachedSqlEntityProcessor be used with delta-import? In my setup when ru= nning a delta-import with CachedSqlEntityProcessor, the child entity values= are not correctly updated for the parent record. I am on Solr 4.3. Has any= one experienced this and if so how to resolve it? Thanks, Sowmya.