AWS Athena column values mismatch

0

I have uploaded two separate csv files (just to check the query results) with the tables in the right order and values in S3, but everytime I run the crawler and view the individual table data in Athena, I get query results with the values of column A showing up in Column B or other columns, while some columns are empty.

asked a year ago481 views
1 Answer
1
Accepted Answer

I have tested your instance by uploading the query results csv files to S3 and run crawler it to create a table, then I am able to query the table and see the values in the right columns. Please feel free to let me know if I did not understand your use case correctly.

Could you try to change the non string data type column to String and change the SerDe to OpenCSVSerDe ? You can do this by going to Glue console,

  1. choose the tables => select the created table => Actions => Edit table => org.apache.hadoop.hive.serde2.OpenCSVSerde in Serialization lib.
  2. choose the tables => select the created table => Actions => Edit schema => Edit the column with non string data type to string.
  3. Please make sure that the table location does not have any other files than your csv files

Please try the above steps. If the issue persists, we require details that are non-public information, so please open a support case with AWS using the following link.

AWS
answered a year ago
profile picture
EXPERT
reviewed 10 months ago
  • Great, it worked thank you.

    Now that I changed all columns to string, how do I query the columns that were 'date' and 'bigint' data type in Athena?

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