Connect AWS Athena to an existing Hive Metastore

Question

I want to integrate AWS Athena service with an exists Hive Metastore (not AWS Glue).

Can you please let me know how to do it?

Answer 1

Athena works only with its own metastore or the related AWS Glue metastore.

It will not work with an external metastore.

However, you can set up multiple tables or databases on the same underlying S3 storage. So if you wrote data to S3 using an external metastore, you could query those files with Athena, after setting up an appropriate database and table definition in Athena's metastore.