CODEWITHSUNDEEP
amazon-web-servicesamazon-athenaaws-glue
Wouter de Winter
Wouter de Winter

Reputation: 721

HIVE_UNKNOWN_ERROR when running AWS Athena query on Glue table (RDS)

I'm getting an error when running an Athena query against a Glue table created from an RDS database:

HIVE_UNKNOWN_ERROR: Unable to create input format

The tables are created using a crawler. The tables show up correctly in the Glue interface:

Glue interface

However, they do not show up in the Athena interface under the database. It says: "The selected database has no tables"

enter image description here

I do not see this behaviour when using a database created using an S3 file. Maybe this is related to the error. Does anybody have an idea?

Upvotes: 5

Views: 5296

Answers (1)

sziep
sziep

Reputation: 136

I had the same problem. This is the answer that I have got from AWS Support:

I understand that you set up a Glue crawler to crawl our RDS postresql database but the tables are not visible in Athena.

Athena service is designed to query tables that point to S3 as data-source. It cannot read data from non-S3 resources as of today.

So, unfortunately not possible at the moment.

Upvotes: 12

Related Questions