Return-Path: 
 <solr-commits-return-5007-apmail-lucene-solr-commits-archive=lucene.apache.org@lucene.apache.org>
Delivered-To: apmail-lucene-solr-commits-archive@minotaur.apache.org
Received: (qmail 30673 invoked from network); 8 Jul 2009 07:16:55 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3)
  by minotaur.apache.org with SMTP; 8 Jul 2009 07:16:55 -0000
Received: (qmail 26519 invoked by uid 500); 8 Jul 2009 07:17:05 -0000
Delivered-To: apmail-lucene-solr-commits-archive@lucene.apache.org
Received: (qmail 26458 invoked by uid 500); 8 Jul 2009 07:17:05 -0000
Mailing-List: contact solr-commits-help@lucene.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:solr-commits-help@lucene.apache.org>
List-Unsubscribe: <mailto:solr-commits-unsubscribe@lucene.apache.org>
List-Post: <mailto:solr-commits@lucene.apache.org>
List-Id: <solr-commits.lucene.apache.org>
Reply-To: solr-dev@lucene.apache.org
Delivered-To: mailing list solr-commits@lucene.apache.org
Received: (qmail 26449 invoked by uid 99); 8 Jul 2009 07:17:05 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 Jul 2009 07:17:05 +0000
X-ASF-Spam-Status: No, hits=-2000.0 required=10.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.130] (HELO eos.apache.org) (140.211.11.130)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 08 Jul 2009 07:17:03 +0000
Received: from eos.apache.org (localhost [127.0.0.1])
	by eos.apache.org (Postfix) with ESMTP id AB01A1112E
	for <solr-commits@lucene.apache.org>; Wed,  8 Jul 2009 07:16:42 +0000 (GMT)
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
From: Apache Wiki <wikidiffs@apache.org>
To: solr-commits@lucene.apache.org
Date: Wed, 08 Jul 2009 07:16:42 -0000
Message-ID: <20090708071642.5212.23391@eos.apache.org>
Subject: [Solr Wiki] Update of "DIHQuickStart" by NoblePaul
X-Virus-Checked: Checked by ClamAV on apache.org

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Solr Wiki" for change notification.

The following page has been changed by NoblePaul:
http://wiki.apache.org/solr/DIHQuickStart

The comment on the change is:
table joins

------------------------------------------------------------------------------
  
  ensure that your solr schema (schema.xml) has the fields 'id' , 'name' , 'desc' . Change the appropriate details in the dataconfig.xml
  
- Step 3 : Run the command http://solr-host:port/dataimpor?command=full-import
+ Step 3 : Run the command http://solr-host:port/dataimpor?command=full-import . keep in mind that everytime full-import is executed the index is cleaned up. If you do not wish that to happen add clean=false . eg : http://solr-host:port/dataimpor?command=full-import&clean=false
  
  == Index the fields in different names ==
- Step: 1Change the data-config as follows : 
+ Step: 1 Change the data-config as follows : 
  {{{
  <dataConfig>
    <dataSource type="JdbcDataSource" 
@@ -55, +55 @@

  Step 2 : This time the fields will be writtten to the solr fields 'solr_id' , 'solr_name' , solr_desc' . You must have these fields in the schema.xml.
  Step 3 : Run the command http://solr-host:port/dataimpor?command=full-import
  
+ = Index data from multiple tables into Solr =
+ Step: 1 Change the data-config as follows : 
+ {{{
+ <dataConfig>
+   <dataSource type="JdbcDataSource" 
+               driver="com.mysql.jdbc.Driver"
+               url="jdbc:mysql://localhost/dbname" 
+               user="user-name" 
+               password="password"/>
+   <document>
+     <entity name="outer" 
+             query="select id,name,desc from mytable">
+        <field column="id" name="solr_id"/>
+        <field column="name" name="solr_name"/>
+        <field column="desc" name="solr_desc"/>
+        <entity name="inner"
+                query="select details from another_table where id ='${outer.id}'">
+               <field column="details" name="solr_details"/> 
+        </entity>
+     </entity>
+   </document>
+ </dataConfig>
+ }}}
+ 
+ Step 2: The schema.xml should have the solr_details field
+ Step : 3: Run the full-import command
+