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.USER_HIVE_COLUMNS

Object Details

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

All hive columns in the given database

[View Source]

Columns

Name	Datatype	Length	Comments
CLUSTER_ID	VARCHAR2	(4000)	User supplied identifier for this hive metastore
DATABASE_NAME	VARCHAR2	(4000)	Database where owning hive table resides
TABLE_NAME	VARCHAR2	(4000)	Hive table name where the column belongs to
COLUMN_NAME	VARCHAR2	(4000)	Hive column name
HIVE_COLUMN_TYPE	VARCHAR2	(4000)	Data type of the hive column
ORACLE_COLUMN_TYPE	VARCHAR2	(4000)	Equivalent Oracle data type of the hive column
LOCATION	VARCHAR2	(4000)	Physical location of the hive table
OWNER	VARCHAR2	(4000)	Owner of hive table
CREATION_TIME	DATE
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
,      TABLE_NAME
,      COLUMN_NAME
,      HIVE_COLUMN_TYPE
,      ORACLE_COLUMN_TYPE
,      LOCATION
,      OWNER
,      CREATION_TIME
,      HIVE_URI
FROM SYS.USER_HIVE_COLUMNS;

Dependencies

[top of page]

SYS.USER_HIVE_COLUMNS references the following:

SYS: ALL_TAB_PRIVS; DBA_HIVE_COLUMNS; DBMS_HADOOP_INTERNAL - show dependent code; HIVETYPESET; USER$

SYS.USER_HIVE_COLUMNS is referenced by following:

PUBLIC: USER_HIVE_COLUMNS
SYS: ALL_HIVE_COLUMNS