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

How to escape a comma in a csv file in AWS Glue?

0

Customer is using Glue to parse a CSV file.

The issue happens when trying to load a CSV file and one of its text column EQUIPMENT_DESCRIPTION has “,” (Comma) value in it. This column value is identified with text qualifier (double quotes). But the way we currently have our crawler/glue configured, we are not able to parse the column with the text qualifier to ignore comma values in it.

This is causing all the other columns following EQUIPMENT_DESCRIPTION, to be filled with incorrect data including the DATE_COLLECTED column.

How do you configure Glue to ignore this comma?

Topics
Analytics
Tags
AWS Glue
Language
English
AWS
MODERATOR
AWS-User-4245468
asked 5 years ago2938 views
1 Answer
0
Accepted Answer

You should confirm that the quote character is configured appropriately in the SerDe properties of the table?

Have a look at Working with CSV Files in Best Practices When Using Athena With AWS Glue.

AWS
EXPERT
JDB
answered 5 years ago
profile picture
EXPERT
Giovanni Lauria
reviewed 24 days ago

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