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

VIEW: SYS.DBA_HIVE_TABLES

Object Details
Object Name: DBA_HIVE_TABLES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

All hive tables in the given database

[View Source]

Columns
Name Datatype Length Mandatory Comments
CLUSTER_ID VARCHAR2 (4000)
Hadoop cluster name
DATABASE_NAME VARCHAR2 (4000)
Database where hive table resides
TABLE_NAME VARCHAR2 (4000)
Hive table name
LOCATION VARCHAR2 (4000)
Physical location of the hive table
NO_OF_COLS NUMBER

Number of columns in the hive table
CREATION_TIME DATE

Creation time of the hive table
LAST_ACCESSED_TIME DATE

Last accessed time of hive table
OWNER VARCHAR2 (4000)
Owner of hive table
TABLE_TYPE VARCHAR2 (4000)
Type of hive table
PARTITIONED VARCHAR2 (4000)
Is this hive table partitioned?
NO_OF_PART_KEYS NUMBER

No of partition keys in hive table
INPUT_FORMAT VARCHAR2 (4000)
Hive table input format
OUTPUT_FORMAT VARCHAR2 (4000)
Hive table output format
SERIALIZATION VARCHAR2 (4000)
Hive table serialization
COMPRESSED NUMBER

Is this hive table compressed?
HIVE_URI VARCHAR2 (4000)
Query Text

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


SELECT CLUSTER_ID
,      DATABASE_NAME
,      TABLE_NAME
,      LOCATION
,      NO_OF_COLS
,      CREATION_TIME
,      LAST_ACCESSED_TIME
,      OWNER
,      TABLE_TYPE
,      PARTITIONED
,      NO_OF_PART_KEYS
,      INPUT_FORMAT
,      OUTPUT_FORMAT
,      SERIALIZATION
,      COMPRESSED
,      HIVE_URI
FROM SYS.DBA_HIVE_TABLES;

Dependencies

[top of page]

SYS.DBA_HIVE_TABLES references the following:

SchemaSYS
ViewDBA_DIRECTORIES
PL/SQL PackageDBMS_HADOOP_INTERNAL - show dependent code
TableDUAL
TYPEHIVETYPESET
SYS.DBA_HIVE_TABLES is referenced by following:

SchemaPUBLIC
SynonymDBA_HIVE_TABLES
SchemaSYS
ViewUSER_HIVE_TABLES