Does the CSV file work? Just not when in MaprDB? If so try varchar before to date.
--Andries > On Feb 13, 2015, at 8:06 AM, Sudhakar Thota <[email protected]>h wrote: > > Andries, > > The order date looks good I think as per the format. > >> | 3421989 | Clerk#000000601 | O | 1996-01-10 | >> | 3422915 | Clerk#000000058 | O | 1996-01-11 | >> | 3423106 | Clerk#000000266 | O | 1996-01-11 | > > If you look at the output, it pulls the records for some and fails later with > that error. I verified the dataset for that 00 in month, I dint find it. I > think it is missed some where in translation and transit. > > Thanks > Sudhakar Thota > > > > On Feb 12, 2015, at 10:21 PM, Andries Engelbrecht <[email protected]> > wrote: > >>> | 3421989 | Clerk#000000601 | O | 1996-01-10 | >>> | 3422915 | Clerk#000000058 | O | 1996-01-11 | >>> | 3423106 | Clerk#000000266 | O | 1996-01-11 | >
