CODEWITHSUNDEEP
amazon-web-servicesaws-glueamazon-athena
user2862073
user2862073

Reputation: 254

AWS Athena query error: Hive File Not Found:partition location does not exist

I created one table in glue database using crawler job. Table created successfully.

However, when I am trying to access that table in athena query editor its giving me below error when i am try to select the data from table:

Query: select * from DB1.data_tbl;

Output: Hive File Not Found: Partition location does not exist

I haven't found the partition location define.

Please assist.

Upvotes: 0

Views: 927

Answers (1)

Marcin
Marcin

Reputation: 238995

Athena, by default, can read only data in S3. It will not read your postgresql databases. To connect to anything other than S3, you have to setup and use Amazon Athena Federated Query.

Alternatively, setup a Glue Job to copy all data from your Postegresql into S3, and then use Athena to query the data from S3.

Upvotes: 1

Related Questions