Rohit,
The solr server using TrieDateField must receive values in the format
2011-01-07T17:00:30Z
This should be a UTC-based datetime. The offset can be applied once you get
your results back from solr
SimpleDateFormat df = new SimpleDateFormat(format);
df.setTimeZone(TimeZone.getTimeZone("IST"));
java.util.Date dateunix = df.parse(datetime);
-Craig
-----Original Message-----
From: Rohit [mailto:ro...@in-rev.com]
Sent: Friday, 6 May 2011 2:31 AM
To: solr-user@lucene.apache.org
Subject: Solr: org.apache.solr.common.SolrException: Invalid Date String:
Hi,
I am new to solr and this is my first attempt at indexing solr data, I am
getting the following exception while indexing,
org.apache.solr.common.SolrException: Invalid Date String:'2011-01-07' at
org.apache.solr.schema.DateField.parseMath(DateField.java:165) at
org.apache.solr.schema.TrieDateField.createField(TrieDateField.java:169) at
org.apache.solr.schema.SchemaField.createField(SchemaField.java:98) at
org.apache.solr.update.DocumentBuilder.addField(DocumentBuilder.java:204) at
org.apache.solr.update.DocumentBuilder.toDocument(DocumentBuilder.java:277)
I understand from reading some articles that Solr stores time only in UTC,
this is the query i am trying to index,
Select id,text,'language',links,tweetType,source,location,
bio,url,utcOffset,timeZone,frenCnt,createdAt,createdOnGMT,createdOnServerTim
e,follCnt,favCnt,totStatusCnt,usrCrtDate,humanSentiment,replied,replyMsg,cla
ssified,locationDetail,
geonameid,country,continent,placeLongitude,placeLatitude,listedCnt,hashtag,m
entions,senderInfScr,
createdOnGMTDate,DATE_FORMAT(CONVERT_TZ(createdOnGMTDate,'+00:00','+05:30'),
'%Y-%m-%d') as
IST,DATE_FORMAT(CONVERT_TZ(createdOnGMTDate,'+00:00','+01:00'),'%Y-%m-%d')
as
ECT,DATE_FORMAT(CONVERT_TZ(createdOnGMTDate,'+00:00','+02:00'),'%Y-%m-%d')
as
EET,DATE_FORMAT(CONVERT_TZ(createdOnGMTDate,'+00:00','+03:30'),'%Y-%m-%d')
as MET,sign(classified) as sentiment from
Why i am doing this timezone conversion is because i need to group results
by the user timezone. How can i achieve this?
Regards, Rohit
