By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Number of columns in flat files vs number of columns in a table

0

AWS Redshift If the table to which I am going to copy the data from flat files, has different number of columns than the file, then do we get error? If not why?

Topics
Analytics
Tags
Amazon Redshift
Language
English
Manoj
asked a year ago257 views
1 Answer
1

You will get an error if the table has more/fewer number of columns than the flat-file when using COPY command. If source file has fewer columns than the target table, add the keyword FILLRECORD to your copy statement to fill the additional columns in target table with NULL and load the data

AWS
Anusha_C
answered a year ago
  • Manoj
    a year ago

    Thanks @Anusha What is expected to happen in the other way? That is, when there are less columns in the table and more in the file? I am not getting error in that scenario. Please explain.

  • Anusha_C
    a year ago

    For flat files, you would get an error when there are extra fields. You can create those extra fields in the table to load the data.

  • Manoj
    a year ago

    Exactly! I should get an error here there are extra fields in the file. But I am not getting the error. Is there any parameter to set/unset? I would like to get an error when there are extra fields in the file.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content