1 Answer
- Newest
- Most votes
- Most comments
1
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,
- choose the tables => select the created table => Actions => Edit table => org.apache.hadoop.hive.serde2.OpenCSVSerde in Serialization lib.
- choose the tables => select the created table => Actions => Edit schema => Edit the column with non string data type to string.
- 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.
answered a year ago
Relevant content
- Accepted Answerasked 4 years ago
- AWS OFFICIALUpdated 8 months ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 3 months ago
- AWS OFFICIALUpdated 3 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?