Return-Path: 
 <general-return-3649-apmail-lucene-general-archive=lucene.apache.org@lucene.apache.org>
X-Original-To: apmail-lucene-general-archive@www.apache.org
Delivered-To: apmail-lucene-general-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 70BC07887
	for <apmail-lucene-general-archive@www.apache.org>;
 Thu, 24 Nov 2011 01:32:13 +0000 (UTC)
Received: (qmail 79081 invoked by uid 500); 24 Nov 2011 01:32:13 -0000
Delivered-To: apmail-lucene-general-archive@lucene.apache.org
Received: (qmail 79027 invoked by uid 500); 24 Nov 2011 01:32:12 -0000
Mailing-List: contact general-help@lucene.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:general-help@lucene.apache.org>
List-Unsubscribe: <mailto:general-unsubscribe@lucene.apache.org>
List-Post: <mailto:general@lucene.apache.org>
List-Id: <general.lucene.apache.org>
Reply-To: general@lucene.apache.org
Delivered-To: mailing list general@lucene.apache.org
Received: (qmail 79019 invoked by uid 99); 24 Nov 2011 01:32:12 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 24 Nov 2011 01:32:12 +0000
X-ASF-Spam-Status: No, hits=-0.0 required=5.0
	tests=RCVD_IN_DNSWL_LOW,SPF_NEUTRAL
X-Spam-Check-By: apache.org
Received-SPF: neutral (nike.apache.org: local policy)
Received: from [209.85.213.48] (HELO mail-yw0-f48.google.com) (209.85.213.48)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 24 Nov 2011 01:32:03 +0000
Received: by ywp31 with SMTP id 31so2152078ywp.35
        for <general@lucene.apache.org>; Wed, 23 Nov 2011 17:31:42 -0800 (PST)
Received: by 10.182.44.35 with SMTP id b3mr8850620obm.26.1322098302829;
        Wed, 23 Nov 2011 17:31:42 -0800 (PST)
Received: from bester.local ([65.78.136.75])
        by mx.google.com with ESMTPS id bn4sm29021obb.6.2011.11.23.17.31.40
        (version=SSLv3 cipher=OTHER);
        Wed, 23 Nov 2011 17:31:41 -0800 (PST)
Date: Wed, 23 Nov 2011 17:31:39 -0800 (PST)
From: Chris Hostetter <hossman_lucene@fucit.org>
To: general@lucene.apache.org
Subject: Re: Create index on two unrelated table in Solr
In-Reply-To: <1321609859061-3518202.post@n3.nabble.com>
Message-ID: <alpine.DEB.2.00.1111231727420.11793@bester>
References: <1321609859061-3518202.post@n3.nabble.com>
User-Agent: Alpine 2.00 (DEB 1167 2008-08-23)
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Checked: Checked by ClamAV on apache.org


: I want to create index between two tables, stock and auction. Basically I am
: working on a product site. So I have to create index on both tables. and
: they are not related at all.
: 
: In data-config.xml, that I created to create index, I wrote the following
: code

If you check your logs, you should see quite a few errors...

:     <field name="stock_ST_StockCode" type="string" indexed="true"
: stored="true" required="true"/>

you've made many other "stock_*" fields required, but none of your 
"auction" documents have those field, so they will all be rejected.

:     <field name="auction_iauctionid" type="string" indexed="true"
: stored="true" required="true"/>

you've made several "auction_*" fields required, but none of your "stock" 
documents have those field, so they will all be rejected.

:  <uniqueKey>stock_ST_StockID</uniqueKey>

Since stock_ST_StockID is the uniqueKey field, all "auction" documents 
will still be rejected for not having the uniqueKey field even if you 
modify it's <field/> declaration to no longer be required.

FWIW: Future questions about Solr should be sent to the solr-user@lucene 
mailing list (which has more subscribers and is more likeley to generate 
responses).  general@lucene is for discussions about the broader Lucene 
project as a whole.




-Hoss