Andries, Good thinking.
It works on csv file but not with MapR-DB table. Here is the file showing that.
Thanks Sudhakar Thota On Feb 13, 2015, at 8:14 AM, Andries Engelbrecht <[email protected]> wrote: > 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 | >>
