> >> 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]
&
=@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
>
> 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
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 "
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