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
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-
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.
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 o
: 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 ver
