List true tables only in Athena

I'd like to have a single query which lists all tables in a athena database excluding views.

There is

SHOW TABLES

which returns tables as well as views. I don't want to call the latter followed by a SHOW VIEWS and then separate those in my code but have that same behavior in one single call.

How can i achieve this?

주제: 분석
태그: 아마존 Athena
언어: English

rePost-User-1893981

질문됨 4년 전653회 조회

1개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

Hello,

Instead of SHOW TABLES, how about using the information_schema table?

SELECT * 
FROM information_schema.tables
WHERE table_schema = 'database'

If you want to pull views separately, query the information_schema.views table.

전문가

Chris_G

답변함 4년 전

rePost-User-1893981
4년 전
Hi, thanks for your response. That doesn't work.

The view in my database is listed in information_schema.tables while information_schema.views is empty. How is that possible at all?

List true tables only in Athena

답변 추가

관련 콘텐츠