您可以在Amazon Athena中创建视图吗？ [英] Can you create views in Amazon Athena?

问题描述

是否可以在Amazon Athena中创建视图？

Is it possible to create views in Amazon Athena?

由于外部表本质上是存储在S3上文件中的数据的元数据，因此不涉及任何转换。因此，您将无法处理数据不一致的情况。通常，这可能导致表中定义了许多字符串字段。

Since an External table is essentially metadata for data stored in files on S3, there's no transformation involved. Therefore, you can't handle data inconsistencies. Quite often, this can result in tables being defined with lots of string fields.

您能否在外部表的顶部创建一个可以包含转换逻辑的视图，允许用户查询数据的清理视图？

Can you create a view over the top of the External table that can contain the transformation logic, allowing users to query a "cleansed" view of the data?

推荐答案

虽然这是您正在寻找的一个不错的功能，

While that is a nice feature that you are looking for,

AWS Athena不支持创建任何视图。

AWS Athena does not support creating any view.

参考支持的DDL的文档：

Reference Documentation of supported DDL's:

http：// docs.aws.amazon.com/athena/latest/ug/language-reference.html

希望它会有所帮助。

这篇关于您可以在Amazon Athena中创建视图吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！