lucene-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bill Au (JIRA)" <>
Subject [jira] [Commented] (SOLR-4978) Time is stripped from datetime column when imported into Solr date field
Date Fri, 05 Jul 2013 21:19:48 GMT


Bill Au commented on SOLR-4978:

This will only have an effect if convertType is enabled and will only affect date field type.
 convertType is disabled by default.  I guess most people use the default setting, which is
probably why no one has noticed this bug before.  The current behavior for date field type
is incorrect when converType is enabled.  Making the change will fix the bug.  So date fields
indexed by DIH when convertType is enabled will actually have a time portion.
> Time is stripped from datetime column when imported into Solr date field
> ------------------------------------------------------------------------
>                 Key: SOLR-4978
>                 URL:
>             Project: Solr
>          Issue Type: Bug
>          Components: contrib - DataImportHandler
>            Reporter: Bill Au
> I discovered that all dates I imported into a Solr date field from a MySQL datetime column
have the time stripped (ie time portion is always 00:00:00).
> After double checking my DIH config and trying different things, I decided to take a
look at the DIH code.
> When I looked at the source code of DIH JdbcDataSource class, I discovered that it is
using java.sql.ResultSet and its getDate() method to handle date field. The getDate() method
returns java.sql.Date. The java api doc for java.sql.Date
> states that:
> "To conform with the definition of SQL DATE, the millisecond values wrapped by a java.sql.Date
instance must be 'normalized' by setting the hours, minutes, seconds, and milliseconds to
zero in the particular time zone with which the instance is associated."
> I am so surprise at my finding that I think I may not be right.  What am I doing wrong
here?  This is such a big hole in DIH, how could it be possible that no one has noticed this
until now?
> Has anyone successfully imported a datetime column into a Solr date field using DIH?

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message