How to show tables in schema like "xx.yy"

I can query data of table in schema "xx.yy" successfully by quoting the schema:
SELECT * FROM "xx.yy"."testtable" limit 10;

But I can not show tables in this schema by running:
show tables in xx.yy
Error: Catalog 'xx' does not exist

or show tables in "xx.yy"
Error: mismatched input '"xx.yy"' expecting {'SELECT', 'FROM'.......

Could you please help to provide me the sql to show tables in schema "xx.yy"?

主題

分析

標籤

Amazon Athena

語言

English

Jinlei

已提問 10 個月前檢視次數 225 次

1 個回答

最新
最多得票
最多評論

已接受的答案

In order to get all the tables in schema "xx.yy", please write the query in following manner: SELECT table_name, table_schema, table_type FROM information_schema.tables where table_schema="xx.yy"

This should help you in getting the desired information.

Dheeraj Kumar

已回答 10 個月前

Jinlei
10 個月前
yes, i can get tables use single quote: SELECT table_name, table_schema, table_type FROM information_schema.tables where table_schema='xx.yy'

How to show tables in schema like "xx.yy"

相關內容