Syntax for refresh metadata

Dremio University
1

Hi all,

I have a question regarding the syntax for refreshing metadata.
I’m using this command to attempt to refresh the metadata, but i keep getting an error

ALTER TABLE “INFO-HDFS.b.p.3529.fi.latest” REFRESH METADATA;

Error:
SQL Error: VALIDATION ERROR: Tried to access non-existent source [INFO-HDFS.b.p.3529.fi.latest].

query on the info schema tables…

TABLE_CATALOG TABLE_SCHEMA TABLE_NAME TABLE_TYPE
DREMIO INFO-HDFS.b.p.3529.fi latest TABLE

What am i doing wrong?

version: 20.1.0-202202061055110045-36733c65

2

When you added the double quotes, the whole string was treated as the source name. I think you just need to double quote INFO-HDFS.

You can also use the SQL Editor and click the “Add to SQL Editor” next to the dataset name to get the fully qualified table name.

3

Hi @aki0086 , IMHO @Benny_Chow is right, you should try this :

“INFO-HDFS".“b”.“p”.“3529”.fi"."latest”

instead.

Best regards,