SOLR 8.6.0 date Indexing Issues.

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

SOLR 8.6.0 date Indexing Issues.

Fiz N
Hello Experts,

I am having  issues with indexing Date field in SOLR 8.6.0. I am indexing
from MongoDB. In MongoDB the Format is as follows


* "R_CREATION_DATE" : "12-Jul-18",  "R_MODIFY_DATE" : "30-Apr-19", *

 In my Managed Schema I have the following entries.
 <field name="R_CREATION_DATE" type="rdate" indexed="true" stored="true"/>
 <field name="R_MODIFY_DATE" type="rdate" indexed="true" stored="true"/>


 <fieldType name="rdate" class="solr.DateRangeField"/>.

 I am getting an error in the Solr log.

* org.apache.solr.common.SolrException: ERROR: [doc=mt_100] Error adding
field 'R_MODIFY_DATE'='15-Jul-19' msg=Couldn't parse date because:
Improperly formatted datetime: 15-Jul-19*

 Please let me know how to handle this usecase with Date format
"12-JUL-18". what changes should I do to make it work ?

 Thanks
 Fiz N.
Reply | Threaded
Open this post in threaded view
|

Re: SOLR 8.6.0 date Indexing Issues.

Jörn Franke
Your should format the date according to the ISO Standard:

https://lucene.apache.org/solr/guide/6_6/working-with-dates.html

Eg. 2018-07-12T00:00:00Z

You can either transform the date that you have in Solr or in your client pushing the doc to Solr.
All major programming language have date utilities that allow you do to this transformation easily.


> Am 20.11.2020 um 21:50 schrieb Fiz N <[hidden email]>:
>
> Hello Experts,
>
> I am having  issues with indexing Date field in SOLR 8.6.0. I am indexing
> from MongoDB. In MongoDB the Format is as follows
>
>
> * "R_CREATION_DATE" : "12-Jul-18",  "R_MODIFY_DATE" : "30-Apr-19", *
>
> In my Managed Schema I have the following entries.
> <field name="R_CREATION_DATE" type="rdate" indexed="true" stored="true"/>
> <field name="R_MODIFY_DATE" type="rdate" indexed="true" stored="true"/>
>
>
> <fieldType name="rdate" class="solr.DateRangeField"/>.
>
> I am getting an error in the Solr log.
>
> * org.apache.solr.common.SolrException: ERROR: [doc=mt_100] Error adding
> field 'R_MODIFY_DATE'='15-Jul-19' msg=Couldn't parse date because:
> Improperly formatted datetime: 15-Jul-19*
>
> Please let me know how to handle this usecase with Date format
> "12-JUL-18". what changes should I do to make it work ?
>
> Thanks
> Fiz N.