Athena query results returning all data in one column

0

i have a table in data catalog and when i query the table, all the data in that table are return in one column separated by commas. It's like its returning the CSV file exactly as it is without separating the file

CYN
asked 5 months ago178 views
1 Answer
0

Follow these steps to identify the issue and perform the fix.

1- Do a DESCRIBE TABLE . read details here https://docs.aws.amazon.com/athena/latest/ug/describe-table.html

2- Verify the ROW FORMAT SERDE . Read this link to learn how to setup a SERDE for CSV files . https://docs.aws.amazon.com/athena/latest/ug/csv-serde.html

AWS
EXPERT
answered 5 months 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