Hi
Thanks for your quick reply Shalin
I have updated my data-config like:
<entity name="employees"
transformer="TemplateTransformer,DateFormatTransformer" pk="EMP_ID"
query="select EMP_ID, CREATED_DATE, CUST_ID FROM EMP, CUST where EMP.EMP_ID
= CUST.EMP_ID" >
<field column="rowtype" template="employees" />
<field column="EMP_ID" name="EMP_ID" />
<field column="CUST_ID" name="CUST_ID" />
<field column="CREATED_DATE"
sourceColName="CREATED_DATE"
dateTimeFormat="dd-MM-yy HH:mm:ss.S a" />
</entity>
This is an example of the date in my database: 22-10-08 03:57:11.637000000
PM
In the schema.xml I have:
<field name="CREATED_DATE" type="date" indexed="true" stored="true" />
Where the 'date' points to the usual solr.DateField
But I am getting the exception while starting the server itself, SEVERE:
org.apache.solr.common.SolrException: undefined field date.
Is there any thing else to be configured or I missed something.
Thanks in advance
con
Shalin Shekhar Mangar wrote:
>
> Take a look at the DateFormatTransformer. You can find documentation on
> the
> DataImportHandler wiki.
>
> http://wiki.apache.org/solr/DataImportHandler
>
> On Tue, Nov 18, 2008 at 10:41 PM, con <[EMAIL PROTECTED]> wrote:
>
>>
>>
>> Hi Noble,
>> I am using DIH.
>>
>>
>>
>> Noble Paul നോബിള് नोब्ळ् wrote:
>> >
>> > How are you indexing the data ? by posting xml? or using DIH?
>> >
>> >
>> > On Tue, Nov 18, 2008 at 3:53 PM, con <[EMAIL PROTECTED]> wrote:
>> >>
>> >> Hi Guys
>> >> I have timestamp fields in my database in the format,
>> >> ddmmyyhhmmss.Z AM
>> >> eg: 26-05-08 10:45:53.661000000 AM
>> >> But I think the since the solr date format is different, i am unable
>> to
>> >> index the document with the solr.DateField.
>> >> So is there any option by which I can give my timestamp format to solr
>> >> and
>> >> index and search data based on that.
>> >> i have already setup solr and is working fine for other datatypes.
>> >> So is it possible to set this new date format in some config files.
>> >>
>> >> Expecting suggestions/advices
>> >> Thanks in advance
>> >> con
>> >> --
>> >> View this message in context:
>> >>
>> http://www.nabble.com/Error-in-indexing-timestamp-format.-tp20556862p20556862.html
>> >> Sent from the Solr - User mailing list archive at Nabble.com.
>> >>
>> >>
>> >
>> >
>> >
>> > --
>> > --Noble Paul
>> >
>> >
>>
>> --
>> View this message in context:
>> http://www.nabble.com/Error-in-indexing-timestamp-format.-tp20556862p20564005.html
>> Sent from the Solr - User mailing list archive at Nabble.com.
>>
>>
>
>
> --
> Regards,
> Shalin Shekhar Mangar.
>
>
--
View this message in context:
http://www.nabble.com/Error-in-indexing-timestamp-format.-tp20556862p20573758.html
Sent from the Solr - User mailing list archive at Nabble.com.
