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
Last activity: Nov 10, 2022, 10:00 AM