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달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠