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

Question

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: com.amazonaws.services.lakeformation.model.InvalidInputException: 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?...

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](https://docs.aws.amazon.com/athena/latest/ug/glue-athena.html).

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](https://aws.amazon.com/blogs/big-data/query-any-data-source-with-amazon-athenas-new-federated-query/).

hope this helps

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

相關內容