USE CATALOG

适用于:勾选“是” Databricks SQL 勾选“是” Databricks Runtime 10.4 LTS 及更高版本 勾选“是” 仅 Unity Catalog

注释

本页介绍 USE CATALOG 了SQL命令,该命令用于设置会话当前的目录。 关于 USE CATALOG 用户需要与目录中对象交互的Unity Catalog权限,请参见 USE CATALOG。

设置当前目录。 设置当前目录后,将从当前目录解析由 SQL 引用的部分和非限定标识符,例如表、函数和视图。

设置目录还会将当前架构重置为 default。

语法

{ USE | SET } CATALOG [ catalog_name | ' catalog_name ' ]

参数

示例

-- Use the 'hive_metastore' which exists.
> USE CATALOG hive_metastore;

> USE CATALOG 'hive_metastore';

-- Use a catalog given as a string variable
> DECLARE mycat = 'main';
> USE CATALOG IDENTIFIER(mycat);

-- Use the 'some_catalog' which doesn't exist
> USE CATALOG `some_catalog`;
  Error: NO_SUCH_CATALOG_EXCEPTION

-- Setting the catalog resets the schema to `default`
> USE CATALOG some_cat;
> SELECT current_catalog(), current_schema();
  some_cat default

-- Setting the schema in the current catalog
> USE SCHEMA some_schema;
> SELECT current_catalog(), current_schema();
  some_cat some_schema

-- Resetting both catalog and schema
> USE SCHEMA main.my_schema;
> SELECT current_catalog(), current_schema();
  main my_schema

-- Setting the catalog resets the schema to `default` again
> USE CATALOG some_cat;
> SELECT current_catalog(), current_schema();
  some_cat default