lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Erick Erickson <erickerick...@gmail.com>
Subject Re: Solr Indexing My SQL Timestamp or Date Time field
Date Mon, 15 Apr 2013 11:16:56 GMT
Solr requires precise date formats, see:
http://lucene.apache.org/solr/api-4_0_0-BETA/org/apache/solr/schema/DateField.html

Best
Erick

On Sun, Apr 14, 2013 at 11:43 AM, ursswakesh@gmail.com
<ursswakesh@gmail.com> wrote:
> Hi,
>
> To index Date in Solr, Date should be in ISO format.
> Can we index MySQL Timestamp or Date Time feild with out modifying SQL
> Select Statement ?
>
> I have used
>
> <fieldType name="tdate" class="solr.TrieDateField" omitNorms="true"
> precisionStep="6" positionIncrementGap="0"/>
>
>  <field name="CreatedDate" type="tdate" indexed="true" stored="true" />
>
> CreatedDate is of Type Date Time in MySQL
>
> I am getting following exception
>
> 11:23:39,117 WARN
> [org.apache.solr.handler.dataimport.DateFormatTransformer] (Thread-72) Could
> not parse a Date field : java.text.ParseException: Unparseable date:
> "2013-04-14 11:22:48.0"
>
>
> Any help in fixing this Issue is really appreciated
>
>
>
> --
> View this message in context: http://lucene.472066.n3.nabble.com/Solr-Indexing-My-SQL-Timestamp-or-Date-Time-field-tp4055894.html
> Sent from the Solr - User mailing list archive at Nabble.com.

Mime
View raw message