CODEWITHSUNDEEP
prestoamazon-athena
Laurent Cesaro
Laurent Cesaro

Reputation: 341

Athena Presto list empty tables

I would like to list all empty tables in my database Athena.

I tried : 

select table_schema, table_name from information_schema.tables
where table_schema = 'database'

But like this I list only table name with database name. Thanks for your help.

Upvotes: 0

Views: 508

Answers (1)

kokosing
kokosing

Reputation: 5601

I do not think it is possible within a single query. Your query gives you a list of tables. Having that I think you could now iterate over that from the external tool.

Upvotes: 2

Related Questions