Sequential file read problem with a timestamp
Posted: Mon May 11, 2009 3:17 am
Hi,
I have a seq file having columns
d1 Name d2 d3
--------------------------------------------------------------
2009-05-11 11:39:27|as|2009-05-11 11:39:27|
with pipe as delimitter. In this case when i havnt given a value for d3 column which is a timestamp type , its giving error . when value is supplied as below it working
2009-05-11 11:39:27|as|2009-05-11 11:39:27|2009-05-11 11:39:27
In former case i have put property of the column as nullable still i am getting same error
The error is as follows
##W IIS-DSEE-TFIG-00176 14:37:05(000) <Sequential_File_0,0> Input buffer overrun at field "d3", at offset: 43
##W IIS-DSEE-TOIX-00154 14:37:05(001) <Sequential_File_0,0> Import warning at record 0.
##W IIS-DSEE-TOIX-00018 14:37:05(002) <Sequential_File_0,0> Import unsuccessful at record 0.
>##E IIS-DSEE-TFDA-00036 14:37:05(003) <APT_CombinedOperatorController,0> Data string '
>' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': an integer was expected to match tag %yyyy.
##W IIS-DSEE-TFIG-00198 14:37:05(004) <Sequential_File_0,0> Field "d" delimiter not seen, at offset: 19
##W IIS-DSEE-TFIG-00190 14:37:05(005) <Sequential_File_0,0> Input buffer overrun at field "d"
##W IIS-DSEE-TOIX-00154 14:37:05(006) <Sequential_File_0,0> Import warning at record 1.
##W IIS-DSEE-TOIX-00018 14:37:05(007) <Sequential_File_0,0> Import unsuccessful at record 1.
##I IIS-DSEE-TOIX-00163 14:37:05(008) <Sequential_File_0,0> Import complete; 0 records imported successfully, 2 rejected.
**VIEWDATA ROW LIMITER HIT**
>##E IIS-DSEE-TFOR-00089 14:37:05(009) <_ABORT_IDENT_,0> The runLocally() of the operator failed.
##I IIS-DSEE-TFOR-00163 14:37:05(010) <_ABORT_IDENT_,0> Input 0 consumed 0 records.
>##E IIS-DSEE-TFOR-00089 14:37:05(011) <APT_CombinedOperatorController,0> The runLocally() of the operator failed.
Please anyone help me
I have a seq file having columns
d1 Name d2 d3
--------------------------------------------------------------
2009-05-11 11:39:27|as|2009-05-11 11:39:27|
with pipe as delimitter. In this case when i havnt given a value for d3 column which is a timestamp type , its giving error . when value is supplied as below it working
2009-05-11 11:39:27|as|2009-05-11 11:39:27|2009-05-11 11:39:27
In former case i have put property of the column as nullable still i am getting same error
The error is as follows
##W IIS-DSEE-TFIG-00176 14:37:05(000) <Sequential_File_0,0> Input buffer overrun at field "d3", at offset: 43
##W IIS-DSEE-TOIX-00154 14:37:05(001) <Sequential_File_0,0> Import warning at record 0.
##W IIS-DSEE-TOIX-00018 14:37:05(002) <Sequential_File_0,0> Import unsuccessful at record 0.
>##E IIS-DSEE-TFDA-00036 14:37:05(003) <APT_CombinedOperatorController,0> Data string '
>' does not match format '%yyyy-%mm-%dd %hh:%nn:%ss': an integer was expected to match tag %yyyy.
##W IIS-DSEE-TFIG-00198 14:37:05(004) <Sequential_File_0,0> Field "d" delimiter not seen, at offset: 19
##W IIS-DSEE-TFIG-00190 14:37:05(005) <Sequential_File_0,0> Input buffer overrun at field "d"
##W IIS-DSEE-TOIX-00154 14:37:05(006) <Sequential_File_0,0> Import warning at record 1.
##W IIS-DSEE-TOIX-00018 14:37:05(007) <Sequential_File_0,0> Import unsuccessful at record 1.
##I IIS-DSEE-TOIX-00163 14:37:05(008) <Sequential_File_0,0> Import complete; 0 records imported successfully, 2 rejected.
**VIEWDATA ROW LIMITER HIT**
>##E IIS-DSEE-TFOR-00089 14:37:05(009) <_ABORT_IDENT_,0> The runLocally() of the operator failed.
##I IIS-DSEE-TFOR-00163 14:37:05(010) <_ABORT_IDENT_,0> Input 0 consumed 0 records.
>##E IIS-DSEE-TFOR-00089 14:37:05(011) <APT_CombinedOperatorController,0> The runLocally() of the operator failed.
Please anyone help me