Skip to Content
author's profile photo Former Member
Former Member

Load table problem - Non-space text found after ending quote character for an enclosed field

Hi folks,

I am getting the error "Non-space text found after ending quote character for an enclosed field" when I attempt to load data into a table using the statement below. Any ideas how to resolve this issue?

load table FACTS_29_4d29401c_b16e_4914_adfd_2f5ca94bbe7b(id_1 null(ZEROS), id_2 null(ZEROS), id_3 null(ZEROS), id_4 null(ZEROS), id_5 null(ZEROS), id_6 null(ZEROS), id_7 null(ZEROS), id_8 null(ZEROS), id_9 null(ZEROS), id_10 null(ZEROS), id_11 null(ZEROS), id_12 null(ZEROS), id_13 null(ZEROS), id_14 null(ZEROS), id_15 null(ZEROS), id_16 null(ZEROS), id_17 null(ZEROS), id_52 null(ZEROS))

from 'C:\\test2.csv' escapes off

The file I am loading is attached (test2.csv). It contains the following data:

'1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','52'

Note, there is a new line after the '52' (so the file contains two lines - the one above and a blank line). The load works when there is no new line after the '52'.

The schema of the table I am loading it into is:

Column,Type,Nullable,Primary Key

'id_1','integer',1,0

'id_2','varchar(14)',1,0

'id_3','varchar(10)',1,0

'id_4','varchar(11)',1,0

'id_5','varchar(5)',1,0

'id_6','integer',1,0

'id_7','varchar(5)',1,0

'id_8','varchar(5)',1,0

'id_9','varchar(11)',1,0

'id_10','integer',1,0

'id_11','varchar(5)',1,0

'id_12','integer',1,0

'id_13','integer',1,0

'id_14','integer',1,0

'id_15','integer',1,0

'id_16','varchar(9)',1,0

'id_17','varchar(5)',1,0

'id_52','integer',1,0

Cheers,

Máirtín

error.jpg (57.7 kB)
test2.csv.zip (182 B)
Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    Posted on Oct 20, 2014 at 12:40 PM

    Hi Mairtin,

    Add a comma character after the last value 52 in csv file : ...., '16','17','52',

    and test again.

    Regards,

    Tayeb.


    Add comment
    10|10000 characters needed characters exceeded