Mailing-List: contact solr-user-help@lucene.apache.org; run by ezmlm
Precedence: bulk
Reply-To: solr-user@lucene.apache.org
Received-SPF: pass (athena.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding;
  b=56LOaQBCGFZzkfeSGbDBAPy5DXcanlfWq+cGJ2ueUcURmPw0w5FRdVUtSseCguWNBksvprf5uHFZbRdyu+epELBn2DK3xNyEmHQFhugxSmKvnaznNghP4hmVKqc52nABzdNmAbTFnFY4v4GkGuIze/CqXlYum1d4jNO1ZhCiBJo=;
References: <000b01ceff90$95473b50$bfd5b1f0$@nrifintech.com>
Message-ID: <1387811699.5507.YahooMailNeo@web125305.mail.ne1.yahoo.com>
Date: Mon, 23 Dec 2013 07:14:59 -0800 (PST)
From: Ahmet Arslan <iorixxx@yahoo.com>
Reply-To: Ahmet Arslan <iorixxx@yahoo.com>
Subject: Re: Importing from Multiple tables using Solr DIH
To: "solr-user@lucene.apache.org" <solr-user@lucene.apache.org>
In-Reply-To: <000b01ceff90$95473b50$bfd5b1f0$@nrifintech.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi=0A=0AThere are several ways to do it. One way is to create to two entiti=
es at the same level. Use its name to call it.=A0=0A=0ARequest : command=3D=
full-import&entity=3Dmessages_test=0A=0A<document>=0A=0A=A0 <entity=A0name=
=3D"messages_test" query=3D"select * from BLOB_TEST"=0A=0A=A0 =A0...=0A=A0 =
</entity>=0A=A0=A0=0A=A0 <entity=A0name=3D"messages_test1"=A0query=3D"selec=
t * from BLOB_TEST1"=0A=A0 =A0....=0A=A0 </entity>=0A</document>=0A=0A=A0=
=0A=0AOther way : Make table name variable in data-config.xml. =A0And chang=
e/set it=A0(BLOB_TEST or BLOB_TEST1)=A0from request parameters.=0A=0A<entit=
y=A0name=3D"messages_test"=A0query=3D"select * from=A0'${dataimporter.reque=
st.myTableName}'"=0A=0A=0ARequest : command=3Dfull-import&myTableName=3DBLO=
B_TEST1=0A=0A=0Ahttp://wiki.apache.org/solr/DataImportHandler#Accessing_req=
uest_parameters=0A=0A=0A=0A=0A=0AOn Monday, December 23, 2013 5:40 AM, Souv=
ik Chakraborty <souvikc@nrifintech.com> wrote:=0AHi all,=0A=0A=0A=0AI have =
the below configuration which is working absolutely fine.=0A=0A=0A=0A=0A=0A=
Data-config.xml:=0A=0A=0A=0A<?xml version=3D"1.0" encoding=3D"UTF-8" ?>=0A=
=0A<dataConfig>=0A=0A<dataSource name=3D"db" driver=3D"oracle.jdbc.driver.O=
racleDriver"=0Aurl=3D"jdbc:oracle:thin:@//172.16.29.92:1521/d11gr21" user=
=3D"eig_nbl_dev"=0Apassword=3D"eig_nbl_dev"/>=0A=0A<dataSource name=3D"dast=
ream" type=3D"FieldStreamDataSource" />=0A=0A<document>=0A=0A=A0 <entity =
=0A=0A=A0 =A0 =A0 name=3D"messages" pk=3D"BLOB_PK" transformer=3D'DateForma=
tTransformer'=0A=0A=A0 =A0 =A0 query=3D"select * from BLOB_TEST"=0A=0A=A0 =
=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 deltaQuery=3D"select BLOB_PK from BLOB_TEST=
 where=0Ato_char(last_modified,'YYYY-MM-DD HH24:MI:SS') &gt;=0A'${dataimpor=
ter.last_index_time}' "=0A=0A=A0 =A0 =A0 dataSource=3D"db">=0A=0A=A0 =A0 =
=A0 =A0 =A0 =A0 =A0 =A0 <field column =3D"BLOB_PK" name =3D"id" />=0A=0A=A0=
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 <field column=3D"last_modified"=A0 dateTimeFor=
mat=3D"YYYY-MM-DD=0AHH24:MI:SS" locale=3D"en" />=0A=0A=A0 =A0 <entity =0A=
=0A=A0 =A0 =A0 =A0 name=3D"message" =0A=0A=A0 =A0 =A0 =A0 dataSource=3D"das=
tream"=0A=0A=A0 =A0 =A0 =A0 processor=3D"TikaEntityProcessor"=0A=0A=A0 =A0 =
=A0 =A0 url=3D"message"=0A=0A=A0 =A0 =A0 =A0 dataField=3D"messages.MESSAGE"=
=0A=0A=A0 =A0 =A0 =A0 format=3D"text">=0A=0A=A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =0A=0A=A0 =A0 =A0 =A0 <field column=3D"tex=
t" name=3D"mxMsg" blob=3D"true" />=0A=0A=A0 =A0 =A0 </entity>=0A=0A=A0 =A0 =
</entity> =0A=0A</document>=0A=0A</dataConfig>=0A=0A=0A=0ANow my requiremen=
t is that I have a similar table BLOB_TEST1 and have the=0Asame fields as t=
hat of BLOB_TEST.=0A=0AI wish to index it the same way as I have done it fo=
r BLOB_TEST.=0A=0ACan't figure out how to accomplish that.=0A=0AAny help wo=
uld be highly appreciated.=0A=0A=0A=0A-Souvik