athena query error

0

Hi Team,

When iam run querry facing error, Kindly support anyone please

SELECT * not allowed from relation that has no columns This query ran against the "penguin-landing-data" database, unless qualified by the query

已提问 8 个月前314 查看次数
1 回答
3
已接受的回答

Hi Karthik,

Is this for Lakeformation, if so then make sure your user has at least the Describe and Select permissions on that database and the table. I understand error message is not self explanatory but try adding these permissions to your role/user for respective database and table and see how it goes.

Also, did you try selecting any specific column, you can try that too and see how it responds. If it gives the error then I'd first add these permissions to my user/role and then will see the behavior. Refer Managing Lake Formation and Athena user permissions for more details.

Hope it helps.

Comment here if you have additional questions, happy to help.

Abhishek

profile pictureAWS
专家
已回答 8 个月前
profile pictureAWS
专家
iBehr
已审核 8 个月前
profile picture
专家
已审核 8 个月前

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则

相关内容