Sample Header Ad - 728x90

How is the information_schema table in trino updated?

1 vote
1 answer
3696 views
We use Trino (https://trino.io/) to connect to HDFS. I discovered that the data in the information_schema tables, for example: select * from information_schema.columns clz where clz.table_catalog = ‘hive’ and clz.table_schema = ‘’ and clz.table_name = ‘’ doesn’t always match up with what I get if I run show tables from [schema] show columns in [schema].[table] etc. It seems that the *show tables*/*show columns* commands pretty much always match up with what I see if I run the hadoop command (hadoop fs -ls ...) to show the contents of the hdfs folder. So I’m trying to figure out: - why the information_schema doesn’t give the same results as show tables/show columns/etc. - if there is a way to refresh/update information_schema to make it current Thank you.
Asked by raphael75 (244 rep)
May 3, 2022, 03:38 PM
Last activity: Nov 10, 2022, 10:00 AM