Oracle 视图 ALL_HIVE_DATABASES 官方解释,作用,如何使用详细说明

本站中文解释

ALL_HIVE_DATABASES视图用于在Oracle中查询Hive数据库的一些信息。与其他查询视图类似,使用ALL_HIVE_DATABASES视图可提供它的相关信息,例如:

所有数据库的名称:SELECT * FROM all_hive_databases;

搜索特定Hive数据库:SELECT * FROM all_hive_databases WHERE upper(database_name) LIKE ‘%DB_NAME%’;

统计Hive数据库数量:SELECT COUNT(*) FROM all_hive_databases;

获取Hive数据库的描述:SELECT description FROM all_hive_databases WHERE upper(database_name) = ‘DB_NAME’;

查询Hive数据库的创建日期:SELECT created_at FROM all_hive_databases WHERE upper(database_name) = ‘DB_NAME’;

查询Hive数据库中有多少表:SELECT COUNT(*) FROM ALL_HIVE_TABLES WHERE upper(database_name) = ‘DB_NAME’;

官方英文解释

ALL_HIVE_DATABASES describes all the Hive schemas accessible to the current user in a Hadoop cluster.

Related Views

  • DBA_HIVE_DATABASES describes all the Hive schemas in a Hadoop cluster.

  • USER_HIVE_DATABASES describes all the Hive schemas owned by the current user in a Hadoop cluster.

Column Datatype NULL Description

CLUSTER_ID

VARCHAR2(4000)

Hadoop cluster name

DATABASE_NAME

VARCHAR2(4000)

Name of the Hive database

DESCRIPTION

VARCHAR2(4000)

Description of the Hive database

DB_LOCATION

VARCHAR2(4000)

Physical location of the Hive database

HIVE_URI

VARCHAR2(4000)

The connection string (URI and port number) for the metastore database

See Also:

  • “DBA_HIVE_DATABASES”

  • “USER_HIVE_DATABASES”


数据运维技术 » Oracle 视图 ALL_HIVE_DATABASES 官方解释,作用,如何使用详细说明