I successfully executed the Python query to convert the JSON format to Parquet format. The conversion was completed without any issues, and I can confirm the presence of the Parquet file and its columns. However, when attempting to execute the query using Athena, I encountered the following problem:
HIVE_UNKNOWN_ERROR: The path is not absolute: s3://dataeng-on-yt-cleansed-us-east1-dev-1. This query was executed against the "db_youtube_cleaned" database unless explicitly specified in the query.
Although the location and the Parquet file appear to be correct, the reason behind the issue is currently unknown.