lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From manju16832003 <manju16832...@gmail.com>
Subject Re: Storing MYSQL DATETIME field in solr as String
Date Mon, 06 Jan 2014 09:20:27 GMT
I found a way to store MySQL DateTime as a string in Solr

Here is the way

in data-config.xml in the SQL query we could convert the date directly to
char

CAST(l.creation_date as char) as creation_date,
CAST(l.modification_date as char) as modification_date,

in schema.xml
<field name="creation_date" type="string" indexed="true" stored="true" 
multiValued="false" default="" />
<field name="modification_date" type="string" indexed="true" stored="true" 
multiValued="false" default="" />


Output would be 
 <str name="creation_date">2013-11-13 10:26:32</str>
 <str name="modification_date">2013-11-13 10:26:32</str>

This is exactly what I was looking for.

If you guys have any other wise please free to share. :-).

Happy Solr!!!





--
View this message in context: http://lucene.472066.n3.nabble.com/Storing-MYSQL-DATETIME-field-in-solr-as-String-tp4106836p4109720.html
Sent from the Solr - User mailing list archive at Nabble.com.

Mime
View raw message