Return-Path: 
 <solr-user-return-117159-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 C3AB718B85
	for <apmail-lucene-solr-user-archive@minotaur.apache.org>;
 Thu, 22 Oct 2015 04:35:27 +0000 (UTC)
Received: (qmail 77746 invoked by uid 500); 22 Oct 2015 04:35:24 -0000
Delivered-To: apmail-lucene-solr-user-archive@lucene.apache.org
Received: (qmail 77685 invoked by uid 500); 22 Oct 2015 04:35:24 -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
Delivered-To: moderator for solr-user@lucene.apache.org
Received: (qmail 63844 invoked by uid 99); 22 Oct 2015 04:25:57 -0000
X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org
X-Spam-Flag: NO
X-Spam-Score: 3.737
X-Spam-Level: ***
X-Spam-Status: No, score=3.737 tagged_above=-999 required=6.31
	tests=[DKIM_ADSP_CUSTOM_MED=0.001, FREEMAIL_ENVFROM_END_DIGIT=0.25,
	NML_ADSP_CUSTOM_MED=1.2, SPF_SOFTFAIL=0.972, URIBL_BLOCKED=0.001,
	URI_HEX=1.313] autolearn=disabled
Date: Wed, 21 Oct 2015 21:25:47 -0700 (MST)
From: anurupborah2001 <anurupborah2001@gmail.com>
To: solr-user@lucene.apache.org
Message-ID: <1445487947348-4235810.post@n3.nabble.com>
Subject: Index Multiple entity in one collection core
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

HI,
    I am having difficulty in indexing multiple entity in one
collection..When i try to index only the entity defined at last gets
index..Please help to assist as I am getting hard time to solve it.
The below are the config :
------------------------------
data-config.xml
----------------------
<?xml version="1.0" encoding="UTF-8" ?>
<dataConfig>
<propertyWriter dateFormat="yyyy-MM-dd HH:mm:ss"
type="SimplePropertiesWriter" filename="demo.properties" />

  <dataSource type="JdbcDataSource"
			  zeroDateTimeBehavior="convertToNull"
			  name="ds-1"
              driver="com.mysql.jdbc.Driver"
              url="jdbc:mysql://127.0.0.1/demo" 
			  batchSize="-1" 
              user="root" 
			  autoCommit="true"
              password="password" />
<document name="demo_doc">
    <entity name="table1" 
			pk="table1_id" 
			dataSource="ds-1"  
		
transformer="HTMLStripTransformer,RegexTransformer,TemplateTransformer,DateFormatTransformer,script:GenerateId,LogTransformer"
			logTemplate="The demo is ${table1.table1_id}" logLevel="info"
			query="select
table1_id,table1_desc,table1_flag,DATE_FORMAT(table1_date_updated,'%Y-%m-%dT%TZ')
from table1 Where table1_flag=1 AND '${dih.request.clean}' != 'false' OR
table1_date_updated &gt; '${dih.table1.last_index_time}'"
			>
			<field column="doc_id" name="singlekey" />
            <field column="doc_type" template="TABLE1" name="doc_type" />
            <field column="table1_desc" name="solr_table1_desc_en"
stripHTML="true"/>
			<field column="table1_date_updated" name="solr_table1_date_updated_dt"
dateTimeFormat="yyyy-MM-dd'T'HH:mm:ss" locale="en" />
	</entity>
	<entity name="table2"
		pk="table2_id" 
		dataSource="ds-1"
	
transformer="HTMLStripTransformer,RegexTransformer,TemplateTransformer,DateFormatTransformer,script:GenerateId,LogTransformer"
		logTemplate="The table2 is ${table2.table2_id}" logLevel="info"
		query="select
table2_id,table2_name,table2_flag,DATE_FORMAT(table2_date_updated,'%Y-%m-%dT%TZ')
from table2 Where table2_flag=1 AND '${dih.request.clean}' != 'false' OR
table2_date_updated &gt; '${dih.table2.last_index_time}'"
		>
		<field column="doc_id" name="singlekey" />
        <field column="doc_type" template="TABLE2" name="doc_type" />
        <field column="table2_name" name="solr_table2_name" />
			<entity name="table3" 
					pk="table3_id,table3_frid" 
				
transformer="HTMLStripTransformer,RegexTransformer,DateFormatTransformer,script:GenerateId,LogTransformer"
					logTemplate="The table3 is ${table3.table3_id}" logLevel="info"
					query="select
table3_id,table3_frid,table3_name,table3_desc,table3_subdesc,table3_keyword,table3_flag,DATE_FORMAT(table3_date_updated,'%Y-%m-%dT%TZ')
from table3 Where  table3_frid=$table1.table1_id} AND table3_flag=1"
					>
				<field column="table3_name" name="solr_table3_name"/>
				<field column="table3_desc" name="solr_table3_desc" stripHTML="true"/>
				<field column="table3_subdesc" name="solr_table3_subdesc"
stripHTML="true"/>
				<field column="table3_keyword" name="solr_table3_keyword"/>
				<field column="table3_date_updated" name="solr_table3_date_updated_dt"
dateTimeFormat="yyyy-MM-dd'T'HH:mm:ss" locale="en"/>
			</entity>
</entity>
	
	
</document>
</dataConfig>


schema.xml
--------------------------
 <field name="singlekey" type="string" required="true" multiValued="false"
/> 
    <field name="doc_type" type="string"  multiValued="false" />

<uniqueKey>singlekey</uniqueKey>
   


<field name="table1_desc_en"  type="text_auto" indexed="true" stored="true" 
multiValued="false"  />
<field name="table1_date_updated_dt" type="date" indexed="true"
stored="true"  multiValued="false"  />


<field name="table2_name" type="text_ws" indexed="true" stored="true" />
<field name="table3_name" type="text_ws" indexed="true" stored="true"
multiValued="true" />
<field name="table3_desc"   type="text_en_splitting" indexed="true"
stored="true" multiValued="true" />
<field name="table3_subdesc" type="text_en" indexed="true" stored="true"
multiValued="true" />
<field name="table3_keyword" type="text_en" indexed="true" stored="true"
multiValued="true" />
<field name="table3_date_updated_dt" type="date" indexed="true"
multiValued="false" stored="true" />



Please kindly help me in this...I am not able to index the table 1, instead
the table 2 and table 3 (which are 1 to many relationship tables) are
getting indexed but table1 not getting indexed..

Thanks for help in advance
Regards
Anurup






--
View this message in context: http://lucene.472066.n3.nabble.com/Index-Multiple-entity-in-one-collection-core-tp4235810.html
Sent from the Solr - User mailing list archive at Nabble.com.