HIVE_UNKNOWN_ERROR: Path missing in file system location: s3://...

Hello, Did you crawl the data to Glue data catalog? If yes, can you see the database and tables listed on Athena?

Based on the additional details you provided, a few more things to check that could be causing the "path missing" error when querying Parquet data in Athena:

• Verify that the Parquet files were successfully written to the S3 location and exist there. Use the AWS S3 console or AWS CLI to confirm the files are present.
• Before you run your first query, you need to set up a query result location in Amazon S3.
• Check the table information by following this - Show Table Information
• Check that the table DDL statement in Athena is pointing to the correct S3 location with the Parquet files.
• Check that the DDL specifies the Parquet format. For example: STORED AS PARQUET - Querying Data Stored as Parquet
• Make sure the data types in the DDL match what is in the Parquet file schema. Mismatches can cause issues reading the file.

If your data is already in S3, then a glue crawler should suffice. It will have the tables created in your glue catalog that you can query directly in Athena. You don't need Lambda here unless you're using it for some other processing. Crawler-Tutorial

After you have created a table in Athena, its name displays in the Tables list on the left. To show information about the table and manage it, choose the vertical three dots next to the table name in the Athena console.

Preview table – Shows the first 10 rows of all columns by running the SELECT * FROM "database_name"."table_name" LIMIT 10 statement in the Athena query editor. If this works fine, then you should be able to query your data.

Also, could you share what are you trying to do with the Lambda function? You don't need to share the code, just what are you using it for.

Also if you want to update the s3 location in an existing table then you can use Alter table command.

ALTER TABLE tablename SET LOCATION 's3://test-bucket/testdata/