Chapter 4: Missing data column and unable to import CSV
Closed this issue · 0 comments
lmchugh17 commented
Hello,
I downloaded the CSV file of census data but am having trouble importing into the table.
When trying to copy the document using the sql syntax, the following error occurs:
ERROR: missing data for column "county_fips"
CONTEXT: COPY us_counties_pop_est_2019, line 2: ""01,001,3,Alabama,Autauga County,1539602137,25706961,+32.5322367,-086.6464395,55533,55869,624,541,-1..."
SQL state: 22P04
Additionally when attempting to import the data it supplies a 'columns' error. Please advise, thanks!