escape caracter in AWS glue

Hi team, I have an AWS glue job that reads data from the CSV file in s3 and injects the data on a table in MySQL RDS Aurora DB.

The issue is all lines in the CSV file with escaped characters are completely ignored by the glue job and they are not inserted on the table.

For example on my CSV file the line containing this string is ignored by glue :

"Return "1" if the number is zero; "0" if the number is non-zero. xxxxxxxxxxxxxx."

how can I configure glue to not ignore those lines that contain escaped double quotes?

Tópicos

Tags

Idioma

English

feita há 2 anos1815 visualizações

1 Resposta

Essas respostas são úteis? Vote a favor da resposta correta para ajudar a comunidade a se beneficiar de seu conhecimento.

Resposta aceita

I found a solution :

In the AWS Glue console => Tables, choose the table and edit Edit table details.

add this detail :

respondido há 2 anos

ESPECIALISTA

avaliado há 2 anos

Fabrizio@AWS ESPECIALISTA
há 2 anos
Hi, you are right, please also see the Glue Documentation Page https://docs.aws.amazon.com/athena/latest/ug/glue-best-practices.html

Conteúdo relevante