AWS Athena column values mismatch

Question

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.

AWS-User-2215871 · 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](https://console.aws.amazon.com/support/home#/case/create).

AWS Athena column values mismatch

相關內容