Problem with loading data

[alejortizp]

Hi,

I have a problem loading data. I have 2 million records with some rows totally blank, my file weighs 3GB but at the time of the extraction it is only loading 500,000 records and I do not know how to tell it to take the 2 million records.

Thanks for the attention.

[vamsee · Accepted solution]

1. Remove DISTINCT keyword if you have any and try.
2. Also, see if you have any column which creates 2M records and you are omitting it.
3. Try using RowNo() as RowNumber.

               LOAD *, RowNo() as RowNumber from Source;