Error: COLUMN_NOT_FOUND: line 1:8: SELECT * not allowed from relation that has no columns

0

Hello, I have an Excel file stored in S3 bucket. After running a crawler and creating a table I'm trying to see the table in Athena and getting this error: COLUMN_NOT_FOUND: line 1:8: SELECT * not allowed from relation that has no columns.

How can I solve it?

主题

标签

语言

English

rePost-User-2540619

已提问 2 个月前311 查看次数

2 回答

最新
投票最多
评论最多

1

It seems like the user does not have sufficient permissions.

Are you using Lake Formation? If so, please check if SELECT access has been granted on the table level and 'Describe' has been granted at the database level.

Ananth Tirumanur

已回答 2 个月前

0

You can also refer this re:post answer:

https://repost.aws/questions/QUQ712jy2XTX247bNBBU6WDg/athena-query-does-not-see-any-columns

支持工程师

已回答 2 个月前

相关内容

[[ERROR] ClientError: An error occurred (AccessDenied) when calling the PutObjectTagging operation: Access Denied
专家
rePost Polyglot
已提问 5 个月前
The ciphertext refers to a customer master key that does not exist, does not exist in this region, or you are not allowed to access (Query Id: b2c74c7e-21ed-4375-8712-cd1579eab9a7)
专家
rePost Polyglot
已提问 5 个月前
AWS Connect error - Application has not been enabled for your directory
专家
rePost Polyglot
已提问 2 年前
复制Rekognition自定义标签模型时出错：“Cross account access not allowed”。
专家
rePost Polyglot
已提问 8 个月前
我从 Amazon S3 桶下载或复制对象时，为什么会出现错误“The ciphertext refers to a customer master key that does not exist, does not exist in this region, or you are not allowed to access”（加密文字指的是不存在、此区域不存在或者您无权访问的客户主密钥）？
AWS 官方已更新 1 年前
如何解决在 Athena 中读取 AWS Config 中的文件时出现的“HIVE_CURSOR_ERROR: Row is not a valid JSON Object - JSONException: Duplicate key”错误？
AWS 官方已更新 1 年前
如何解决错误“ERROR: 1023 DETAIL: Serializable isolation violation on table in Redshift”？
AWS 官方已更新 2 年前
我该如何解决 Amazon Athena 中的“SYNTAX_ERROR: line 1:8: SELECT * not allowed in queries without FROM clause”（SYNTAX_ERROR：行 1:8：无 FROM 子句的查询不允许 SELECT *）错误？
AWS 官方已更新 1 年前
保留不健康的 Auto Scaling 实例 -- 分离不健康的 ASG 实例而不是终止
支持工程师
Tim
已发布 7 天前
通过自定义终止策略，让AWS自动伸缩组（ASG）始终终止最旧的实例
支持工程师
Tim
已发布 7 天前