HIVE unknown error when running Athena query on crawler-generated catalog data


I ran basic sql in Athena to view the catalog table which was created by the glue-crawler (crawler job ended successfully and created the "metadata" catalog table in the "hw-db" db) : SELECT * FROM "AwsDataCatalog"."hw-db"."metadata" limit 10; and got the following error:

HIVE_UNKNOWN_ERROR: Unsupported vendor for Glue supported principal: arn:aws:iam::{...}:root (Service: AWSLakeFormation; Status Code: 400; Error Code: InvalidInputException; Request ID: {...}; Proxy: null)
This query ran against the "hw-db" database, unless qualified by the query. 

any ideas?...

asked 4 months ago104 views
1 Answer

Hi, could you please specify the source you catalogued with the crawler?

Athena uses the AWS Glue Data Catalog to store and retrieve table metadata for the Amazon S3 data in your Amazon Web Services account. The table metadata lets the Athena query engine know how to find, read, and process the data that you want to query. As described here.

If you have catalogued a JDBC database (i.e. mysql, oracle or others) those tables will not be readable by Athena.

Crawling a JDBC source, currently only support accessing the data via Glue ETL. If you need to read data in a remote DB with Athena you may want to consider Athena Federated queries, to read about this feature you can look at this blog post.

hope this helps

answered 4 months ago
  • The crawler's catalog was created based on jsons in my s3, so athena is expected to have access to the db

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions