Check the ID for that latest record and try to query it in Solr.
One way you can get multiple records in an RDBMS query is via join. In that
case, each of the records could have the same value in the column(s) that
you are using for your unique key field in Solr.
-- Jack Krupansky
-----Original Message-----
From: Swetha Shenoy
Sent: Wednesday, June 13, 2012 7:21 PM
To: solr-user@lucene.apache.org
Subject: Re: Regarding number of documents
That makes sense. But I added a new entry that showed up in the MySQL
results and not in the Solr search results. The count of documents also did
not increase after the addition. How can a new entry show up in MySQL
results and not as a new document?
On Wed, Jun 13, 2012 at 6:26 PM, Afroz Ahmad <ahmad....@gmail.com> wrote:
Could it be that you are getting records that are not unique. If so then
SOLR would just overwrite the non unique documents.
Thanks
Afroz
On Wed, Jun 13, 2012 at 4:50 PM, Swetha Shenoy <sshe...@gmail.com> wrote:
> Note: I don't see any errors in the logs when I run the index.
>
> On Wed, Jun 13, 2012 at 5:48 PM, Swetha Shenoy <sshe...@gmail.com>
wrote:
>
> > Hi,
> >
> > I have a data config file that contains the data import query. If I
just
> > run the import query against MySQL, I get a certain number of results.
I
> > assume that if I run the full-import, I should get the same number of
> > documents added to the index, but I see that it's not the case and the
> > number of documents added to the index are less than what I see from
the
> > MySQL query result. Can any one tell me if my assumption is correct
> > and
> why
> > the number of documents would be off?
> >
> > Thanks,
> > Swetha
> >
>
