Hmmm, this *looks* like you've changed your schema without re-indexing all your data so you're getting old (string?) values in that field, but that's just a guess. If this is really happening on a clean index it's a problem.
I'm also going to guess that you're not really deleting the documents you think. Are you committing after the deletes? Best Erick On Wed, May 4, 2011 at 2:18 AM, Viswa S <svis...@hotmail.com> wrote: > > Hello, > > The terms query for a date field seems to get populated with some weird > dates, many of these dates (1970,2009,2011-04-23) are not present in the > indexed data. Please see sample data below > > I also notice that a delete and optimize does not remove the relevant terms > for date fields, the string fields seems work fine. > > Thanks > Viswa > > Results from Terms component: > > > <int name="2011-05-04T02:01:32.928Z">3479</int> > > <int name="2011-05-04T02:00:19.2Z">3479</int> > > <int name="2011-05-03T22:34:58.432Z">3479</int> > > <int name="2011-04-23T01:36:14.336Z">3479</int> > > <int name="2009-03-13T13:23:01.248Z">3479</int> > > <int name="1970-01-01T00:00:00Z">3479</int> > > <int name="1970-01-01T00:00:00Z">3479</int> > > <int name="1970-01-01T00:00:00Z">3479</int> > > <int name="1970-01-01T00:00:00Z">3479</int> > > <int name="2011-05-04T02:01:34.592Z">265</int> > > > Result from facet component, rounded by seconds.: > > <lst name="InsertTime"> > <int name="2011-05-04T02:01:32Z">1</int> > > <int name="2011-05-04T02:01:33Z">1148</int> > > <int name="2011-05-04T02:01:34Z">2333</int> > > <str name="gap">+1SECOND</str> > > <date name="start">2011-05-03T06:14:14Z</date> > > <date name="end">2011-05-04T06:14:14Z</date></lst> >
