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?

主題

分析

標籤

Amazon Athena

語言

English

rePost-User-1893981

已提問 2 年前檢視次數 312 次

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

已回答 2 年前

rePost-User-1893981
2 年前
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

相關內容