在胶水表（RDS）上运行AWS Athena查询时出现HIVE_UNKNOWN_ERROR [英] HIVE_UNKNOWN_ERROR when running AWS Athena query on Glue table (RDS)

问题描述

对从RDS数据库创建的Glue表运行Athena查询时出现错误：

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

HIVE_UNKNOWN_ERROR：无法执行创建输入格式

HIVE_UNKNOWN_ERROR: Unable to create input format

表是使用搜寻器创建的。表格正确显示在Glue界面中：

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

但是，它们不会显示在数据库下的Athena界面中。它说：所选数据库没有表

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

使用使用S3文件创建的数据库时，我看不到此行为。也许这与错误有关。有人有想法吗？

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?

推荐答案

我遇到了同样的问题。这是我从AWS支持部门获得的答案：

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

我了解您设置了一个Glue搜寻器来搜寻我们的RDS postresql数据库，但是这些表在Athena中不可见。

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

Athena服务旨在查询指向S3作为数据源的表。到目前为止，它不能从非S3资源中读取数据。

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.

因此，目前无法实现。

这篇关于在胶水表（RDS）上运行AWS Athena查询时出现HIVE_UNKNOWN_ERROR的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！