Usando AWS re:Post, accetti AWS re:Post Termini di utilizzo
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?

Argomenti
Analisi
Tag
Amazon Redshift
Lingua
English
Manoj
posta un anno fa265 visualizzazioni
1 Risposta
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
con risposta un anno fa
  • Manoj
    un anno fa

    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
    un anno fa

    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
    un anno fa

    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.

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande

Contenuto pertinente