Solr dates are very specific, and your parsing exception is expected. See: http://lucene.apache.org/solr/api/org/apache/solr/schema/DateField.html
Best Erick On Thu, Sep 22, 2011 at 6:28 AM, mechravi25 <mechrav...@yahoo.co.in> wrote: > Hi, > > Thanks for the suggestions. This is the option I tried. > > I changed the data type in my source to date and then indexed the field once > again. > > for the particular field , in my query in dataimport file, I gave the > following condition IFNULL(startdate,NULL). > > The document was indexed sucessfully. But the field startdate was not > present in the document. > > I have few other records in my source where in there is a value present in > the startdate but when I index that I am getting this exception > > org.apache.solr.common.SolrException: Invalid Date String:'2011-09-21 > 18:28:32.733' > at org.apache.solr.schema.DateField.parseMath(DateField.java:163) > at > org.apache.solr.schema.TrieDateField.createField(TrieDateField.java:171) > at org.apache.solr.schema.SchemaField.createField(SchemaField.java:95) > at > org.apache.solr.update.DocumentBuilder.addField(DocumentBuilder.java:204) > at > org.apache.solr.update.DocumentBuilder.toDocument(DocumentBuilder.java:277) > at > org.apache.solr.update.processor.RunUpdateProcessor.processAdd(RunUpdateProcessorFactory.java:60) > at > org.apache.solr.handler.dataimport.SolrWriter.upload(SolrWriter.java:75) > at > org.apache.solr.handler.dataimport.DataImportHandler$1.upload(DataImportHandler.java:292) > at > org.apache.solr.handler.dataimport.DocBuilder.buildDocument(DocBuilder.java:618) > at > org.apache.solr.handler.dataimport.DocBuilder.doFullDump(DocBuilder.java:261) > at > org.apache.solr.handler.dataimport.DocBuilder.execute(DocBuilder.java:185) > at > org.apache.solr.handler.dataimport.DataImporter.doFullImport(DataImporter.java:333) > at > org.apache.solr.handler.dataimport.DataImporter.runCmd(DataImporter.java:391) > at > org.apache.solr.handler.dataimport.DataImporter$1.run(DataImporter.java:372) > > > Please help. > > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Solr-Indexing-Null-Values-in-date-field-tp3355068p3358752.html > Sent from the Solr - User mailing list archive at Nabble.com. >
