1. Database Reference
  2. Static Data Dictionary Views
  3. Static Data Dictionary Views: ALL_ALL_TABLES to ALL_OUTLINES
  4. ALL_HIVE_DATABASES

2.166 ALL_HIVE_DATABASES

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: