Re: indexing mysql dateTime/timestamp into solr date field
It turn out you don't need to use dateFormatTransformer at all. The reason why the timestamp mysql column fail to be inserted to solr is because in schema.xml i mistakenly set "index=false, stored=false". Of course that won't make it come to index at all. No wonder schema browser always show no term for that field. DataImportHanlder just take care of using jdbc to read timestamp/datetime column, and format it into solr format out of box. There is no need to use any transformer on top it. I am guessing that the DateFormatTransformer is only needed for string value (somevalue from a xml source, rather than for database column value) to convert it to solr date type. -- View this message in context: http://lucene.472066.n3.nabble.com/indexing-mysql-dateTime-timestamp-into-solr-date-field-tp2608327p2611865.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: indexing mysql dateTime/timestamp into solr date field
Bill, I did try to use the way you suggested above. Unfortunately it does not work either. It is pretty much the same as my last reply, except the dateTimeFormat="-MM-dd'T'hh:mm:ss" Thanks, cyang -- View this message in context: http://lucene.472066.n3.nabble.com/indexing-mysql-dateTime-timestamp-into-solr-date-field-tp2608327p2609053.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: indexing mysql dateTime/timestamp into solr date field
Did you convert the date to standard GMT format as above in DIH? Also add transformer="DateFormatTransformer,..." http://lucene.apache.org/solr/api/org/apache/solr/schema/DateField.html On Tue, Mar 1, 2011 at 7:54 PM, cyang2010 wrote: > Yes, I am pretty sure every row has a modified field. I did my testing > before posting question. > > I tried with adding DateFormatTransformer, still not help. > > > query="select ID, title_full as TITLE_NAME, YEAR, > COUNTRY_OF_ORIGIN, modified as RELEASE_DATE from title limit 10" > > > transformer="RegexTransformer,DateFormatTransformer,TemplateTransformer"> > > > > > > > > > dateTimeFormat="-MM-dd"/> > > I assume it is ok to just get the date part of the information out of a > datetime field? > > Any thought on this? > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/indexing-mysql-dateTime-timestamp-into-solr-date-field-tp2608327p2608452.html > Sent from the Solr - User mailing list archive at Nabble.com. >
Re: indexing mysql dateTime/timestamp into solr date field
Yes, I am pretty sure every row has a modified field. I did my testing before posting question. I tried with adding DateFormatTransformer, still not help. I assume it is ok to just get the date part of the information out of a datetime field? Any thought on this? -- View this message in context: http://lucene.472066.n3.nabble.com/indexing-mysql-dateTime-timestamp-into-solr-date-field-tp2608327p2608452.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: indexing mysql dateTime/timestamp into solr date field
: query="select ID, title_full as TITLE_NAME, YEAR, : COUNTRY_OF_ORIGIN, modified as RELEASE_DATE from title limit 10"> Are you certian that the first 10 results returned (you have "limit 10") all have a value in the "modified" field? if modified is nullable you could very easily just happen to be getting 10 docs that don't have values in that field. -Hoss
indexing mysql dateTime/timestamp into solr date field
Hi, I can't seem to be able to index to a solr date field from a query result using DataImportHandler. Anyone else know how to resoleve the problem? When i check the solr document, there is no term populated for release_date field. All other fields are populated with terms. The field, "release_date" is a solr date type field. Appreciate your help. -- View this message in context: http://lucene.472066.n3.nabble.com/indexing-mysql-dateTime-timestamp-into-solr-date-field-tp2608327p2608327.html Sent from the Solr - User mailing list archive at Nabble.com.