如何处理Athena中的一般性内部错误 [英] How to handle a generic internal error in Athena

问题描述

我在Athena的一个数据集中使用了以下查询。

I have the following query used on one of my datasets in Athena.

CREATE TABLE clean_table
WITH (format='Parquet', external_location='s3://test123data') AS
SELECT npi,
         provider_last_name,
         provider_first_name,

    CASE
    WHEN REPLACE(num_entitlement_medicare_medicaid,',', '') ='' THEN
    null
    ELSE CAST(REPLACE(num_entitlement_medicare_medicaid,',', '') AS DECIMAL)
    END AS medicare_medicaid_entitlement,
    CASE
    WHEN REPLACE(total_submitted_charge_amount,',', '') ='' THEN
    null
    ELSE CAST(REPLACE(num_entitlement_medicare_medicaid,',', '') AS DECIMAL)
    END AS total_submitted_charge_amount
FROM cmsaggregatepayment2017

不幸的是，在运行此查询后，我得到了错误如下：

Unfortunately after I run this query I get an error as below:

GENERIC_INTERNAL_ERROR：路径不是绝对的：s3：// test123data。您可能需要在位置's3：// aws-athena-query-results-785609744360-us-east-1 / Unsaved / 2019/12/15 / tables / 03d3cedf-0101-43cb-91fd-cc8070db0e37处手动清除数据，然后重试。雅典娜（Athena）不会删除您帐户中的数据。

GENERIC_INTERNAL_ERROR: Path is not absolute: s3://test123data. You may need to manually clean the data at location 's3://aws-athena-query-results-785609744360-us-east-1/Unsaved/2019/12/15/tables/03d3cedf-0101-43cb-91fd-cc8070db0e37' before retrying. Athena will not delete data in your account.

有人可以指导我如何处理吗？由于该存储桶为空，我该怎么办？

Can someone walk me through how to handle this? What do I have to do on the bucket since it is empty

推荐答案

该消息似乎是指查询结果位置，雅典娜会自动在其中存储查询的输出。

It appears that this message is referring to the Query result location in which Athena automatically stores the output of your queries.

此功能对于对查询结果运行查询或仅包含一个查询输出的副本。

This is useful for running queries on the results of queries, or for simply having a copy of the query output.

请参阅：使用查询结果，输出文件和查询历史记录-Amazon Athena

您可以通过以下方式指定新的输出位置： Athena控制台中的设置链接，然后提供查询结果位置路径，例如： s3：// my-bucket / athena-output /

You can specify a new output location by clicking the settings link in the Athena console and then providing a Query result location path, such as: s3://my-bucket/athena-output/

我不确定是什么导致了您的特定错误，但请确保在结尾加上 / 到该位置。您可能还想为该输出创建一个新的存储桶。

I'm not sure what is causing your specific error, but make sure you append a trailing / to the location. You might also want to create a new bucket for that output.

这篇关于如何处理Athena中的一般性内部错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！