Athena query results returning all data in one column


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

asked 5 months ago178 views
1 Answer

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

1- Do a DESCRIBE TABLE . read details here

2- Verify the ROW FORMAT SERDE . Read this link to learn how to setup a SERDE for CSV files .

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