En utilisant AWS re:Post, vous acceptez les AWS re:Post Conditions d’utilisation
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?

Sujets
Analytique
Balises
Amazon Redshift
Langue
English
Manoj
demandé il y a un an265 vues
1 réponse
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
répondu il y a un an
  • Manoj
    il y a un an

    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
    il y a un an

    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
    il y a un an

    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.

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions

Contenus pertinents