Was there any follow up to this issue I found? Is this a legitimate bug with the time of day changing?
I could try to solve this by executing same xpath statement twice. <field column="original_air_date_d" xpath="/add/doc/fie...@name='original_air_date_d']" /> <field column="temp_original_air_date_s" xpath="/add/doc/fie...@name='original_air_date_d']" /> However, when I do that, the first field original_air_date_d does not make it into the index. Is seems that you cannot have two identical xpath statements in the data input config file. Is this by design? On 4/1/09 7:45 AM, "Small, Wesley" <wesley.sm...@mtvstaff.com> wrote: > I have noticed that setting a dynamic date field from source column changes > the time within the date. Can anyone confirm this? > > For example, the document I import has the following xml field. > > <field name="original_air_date_d">2002-12-18T00:00:00Z</field> > > > In my data-inport-config file I define the following instructions: > > <field column="temp_original_air_date_s" > xpath="/add/doc/fie...@name='original_air_date_d']" /> > > <field column="original_air_year_s" > sourceColName="temp_original_air_date_s" regex="([0-9][0-9][0-9][0-9])[- > /.][0-9][0-9][- /.][0- > 9][0-9][T][0-9][0-9][:][0-9][0-9][:][0-9][0-9][Z]" replaceWith="$1" /> > > <field column="original_air_date_d" sourceColName="temp_original_air_date_s" > dateTimeFormat="yyyy-MM-dd'T'HH:mm:ss'Z'"/> > > > What is set in my index is is the following: > > <arr name="temp_original_air_date_s"> > <str>2002-12-18T00:00:00Z</str> > </arr> > > <arr name="original_air_year_s"> > <str>2002</str> > </arr> > > <arr name="original_air_date_d"> > <date>2002-12-18T05:00:00Z</date> > </arr> > > You'll notice that the hour (HH) in original_air_date_d changes is set to > 05. It should still be 00. I have noticed that it changes to either 04 or > 05 in all cases within my index. > > In my schema the dynamic field "*_d" > <dynamicField name="*_d" type="date" indexed="true" stored="true"/> > > Thanks, > Wesley. > >
