Hi all I am a bit new to AWS Glue and would like to ask the following. I have a set of data (TableName: “Flights”) from AWS Glue with schema as follows. I used dynamic frame to create the content.
Schema
Table
I have been working on notebook to extract the number, and I have checked on the exported CSV that Column “PathNo” has values. But after I have queried the table on AWS Athena, the PathNo becomes null. Any chance I can export the PathNo as Text”(?! – as i know string is the only substitute) in Athena? Many thanks for the help in advance.
I am looking for a series of codes, or possibly another solutions can help with extracting the column’s value. Many thanks
Harris Yale is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.