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 |
---|---|---|---|
|
|
Hadoop cluster name |
|
|
|
Name of the Hive database |
|
|
|
Description of the Hive database |
|
|
|
Physical location of the Hive database |
|
|
|
The connection string (URI and port number) for the metastore database |
See Also:
-
“DBA_HIVE_DATABASES”
-
“USER_HIVE_DATABASES”