Presto中SHOW CREATE SCHEMA等效语句查询及location字段查看需求

Hey there! Unfortunately, Presto doesn’t have a direct SHOW CREATE SCHEMA command like some other SQL engines, but there are two straightforward ways to grab the location value you need.

1. Use the DESCRIBE SCHEMA Command #

This is the most universal method across most Presto connectors. Run this query to pull up schema metadata, including the location:

DESCRIBE SCHEMA your_target_schema;

The output will be a two-column table. Look for the row where the Column name is Location — the corresponding Value entry is exactly the file path you’re after.

2. Query Connector-Specific System Tables #

If you’re using a connector like Hive or Iceberg, you can directly query their dedicated information schema tables to fetch the location:

• For Hive connectors:

  SELECT schema_location
  FROM hive.information_schema.schemata
  WHERE schema_name = 'your_target_schema';
  

• For Iceberg connectors:

  SELECT schema_location
  FROM iceberg.information_schema.schemata
  WHERE schema_name = 'your_target_schema';
  

This approach is great if you need to retrieve locations for multiple schemas at once or integrate the data into a larger analysis query.

内容的提问来源于stack exchange，提问作者ʞɔıu