Delimiter not seen at offset issue
Posted: Wed Aug 07, 2013 12:23 am
We are facing an issue while loading a delimited file into sql server database.
The metadata is defined in schema file as mentioned below.
record
{record_delim='\n', delim='|',final_delim=none, quote=NONE}
(
Col1:nullable string[1] {null_field=''};
Col2:nullable string[5] {null_field=''};
Col3:nullable string[10] {null_field=''};
Col4:nullable string[10] {null_field=''};
Col5:nullable string[10] {null_field=''};
Col6:nullable string[10] {null_field=''};
)
The table definition also same as the schema file.
but we are getting an error saying that, Field "Col2" delimiter not seen, at offset: 7
The metadata is defined in schema file as mentioned below.
record
{record_delim='\n', delim='|',final_delim=none, quote=NONE}
(
Col1:nullable string[1] {null_field=''};
Col2:nullable string[5] {null_field=''};
Col3:nullable string[10] {null_field=''};
Col4:nullable string[10] {null_field=''};
Col5:nullable string[10] {null_field=''};
Col6:nullable string[10] {null_field=''};
)
The table definition also same as the schema file.
but we are getting an error saying that, Field "Col2" delimiter not seen, at offset: 7