Re: Commit different database rows to solr with same "id" value?

2013-07-11 Thread Jason Huang
> >> select @rownum:=@rownum+1 rowid, t.* from (main select query) t, (select > >> @rownum:=0) s > >> > >> Regards, > >> > >> DQ > >> > >> -Original Message- > >> From: Jason Huang [mailto:jason.hu...@icare.com] &

Re: Commit different database rows to solr with same "id" value?

2013-07-11 Thread Erick Erickson
=@rownum+1 rowid, t.* from (main select query) t, (select >> @rownum:=0) s >> >> Regards, >> >> DQ >> >> -----Original Message----- >> From: Jason Huang [mailto:jason.hu...@icare.com] >> Sent: 10 July 2013 15:50 >> To: solr-user@lucene.apach

Re: Commit different database rows to solr with same "id" value?

2013-07-10 Thread Jason Huang
> > Regards, > > DQ > > -Original Message- > From: Jason Huang [mailto:jason.hu...@icare.com] > Sent: 10 July 2013 15:50 > To: solr-user@lucene.apache.org > Subject: Commit different database rows to solr with same "id" value? > > Hello, > > I

RE: Commit different database rows to solr with same "id" value?

2013-07-10 Thread David Quarterman
ect @rownum:=@rownum+1 rowid, t.* from (main select query) t, (select @rownum:=0) s Regards, DQ -Original Message- From: Jason Huang [mailto:jason.hu...@icare.com] Sent: 10 July 2013 15:50 To: solr-user@lucene.apache.org Subject: Commit different database rows to solr with same "

Commit different database rows to solr with same "id" value?

2013-07-10 Thread Jason Huang
Hello, I am trying to use Solr to store fields from two different database tables, where the primary keys are in the format of "1, 2, 3, " In Java, we build different POJO classes for these two database tables: table1.java @SolrIndex(name="id") private String idTable1 table2.java