Re: Solr 4.3.0 DIH problem with MySQL datetime being imported with time as 00:00:00

2013-06-29 Thread Bill Au
https://issues.apache.org/jira/browse/SOLR-4978 On Sat, Jun 29, 2013 at 2:33 PM, Shalin Shekhar Mangar < shalinman...@gmail.com> wrote: > Yes we need to use getTimestamp instead of getDate. Please create an issue. > > On Sat, Jun 29, 2013 at 11:48 PM, Bill Au wrote: > > So disabling convertType

Re: Solr 4.3.0 DIH problem with MySQL datetime being imported with time as 00:00:00

2013-06-29 Thread Shalin Shekhar Mangar
Yes we need to use getTimestamp instead of getDate. Please create an issue. On Sat, Jun 29, 2013 at 11:48 PM, Bill Au wrote: > So disabling convertType does provide a workaround for my problem with > datetime column. But the problem still exists when convertType is enabled > because DIH is not d

Re: Solr 4.3.0 DIH problem with MySQL datetime being imported with time as 00:00:00

2013-06-29 Thread Bill Au
So disabling convertType does provide a workaround for my problem with datetime column. But the problem still exists when convertType is enabled because DIH is not doing the conversion correctly for a solr date field. Solr date field does have a time portion but java.sql.Date does not. So DIH sh

Re: Solr 4.3.0 DIH problem with MySQL datetime being imported with time as 00:00:00

2013-06-29 Thread Bill Au
Setting convertType=false does solve the datetime issue. But there are now other columns that were working before but not working now. Since I have already done some research into the datetime to date issue and not been able to find a solution, I think I will have to keep convertType set to false

Re: Solr 4.3.0 DIH problem with MySQL datetime being imported with time as 00:00:00

2013-06-29 Thread Bill Au
I just double check my config. We are using convertType=true. Someone else came up with the config so I am not sure why we are using it. I will try with it set to false to see if something else will break. Thanks for pointing that out. This is my first time using DIH. I really like what I hav

Re: Solr 4.3.0 DIH problem with MySQL datetime being imported with time as 00:00:00

2013-06-28 Thread Shalin Shekhar Mangar
The default in JdbcDataSource is to use ResultSet.getObject which returns the underlying database's type. The type specific methods in ResultSet are not invoked unless you are using convertType="true". Is MySQL actually returning java.sql.Timestamp objects? On Sat, Jun 29, 2013 at 5:22 AM, Bill A

Solr 4.3.0 DIH problem with MySQL datetime being imported with time as 00:00:00

2013-06-28 Thread Bill Au
I am running Solr 4.3.0, using DIH to import data from MySQL. I am running into a very strange problem where data from a datetime column being imported with the right date but the time is 00:00:00. I tried using SQL DATE_FORMAT() and also DIH DateFormatTransformer but nothing works. The raw debu