eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.DBA_HIVE_DATABASES

Object Details

Object Name:	DBA_HIVE_DATABASES
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

All hive schemas in the given hadoop cluster

[View Source]

Columns

Name	Datatype	Length	Comments
CLUSTER_ID	VARCHAR2	(4000)	User supplied identifier for this hive metastore
DATABASE_NAME	VARCHAR2	(4000)	Hive database
DESCRIPTION	VARCHAR2	(4000)	Description of hive database
DB_LOCATION	VARCHAR2	(4000)	Physical location of hive database
HIVE_URI	VARCHAR2	(4000)	The connection string (URI and port no) for metastore db

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CLUSTER_ID
,      DATABASE_NAME
,      DESCRIPTION
,      DB_LOCATION
,      HIVE_URI
FROM SYS.DBA_HIVE_DATABASES;

Dependencies

[top of page]

SYS.DBA_HIVE_DATABASES references the following:

SYS: DBA_DIRECTORIES; DBMS_HADOOP_INTERNAL - show dependent code; DUAL; HIVETYPESET

SYS.DBA_HIVE_DATABASES is referenced by following:

PUBLIC: DBA_HIVE_DATABASES
SYS: USER_HIVE_DATABASES