使用AWS re:Post即您表示您同意 AWS re:Post 使用条款
AWS re:Postre:Post

escape caracter in AWS glue

0

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?

主题
分析迁移与现代化数据库存储
标签
分析Amazon Relational Database ServiceAWS Glue数据湖提取变换和加载数据
语言
English
Jess
已提问 2 年前1815 查看次数
1 回答
0
已接受的回答

I found a solution :

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

add this detail :

  • escapeChar, enter a backslash ().
Jess
已回答 2 年前
AWS
专家
Fabrizio@AWS
已审核 2 年前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈，并能促进提问者的职业发展。

回答问题的准则

相关内容