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ヶ月前316ビュー
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ヶ月前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ