[Home] [Help] [Dependency Information]
Object Name: | DBA_HIVE_TABLES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
All hive tables in the given database
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) |
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;
|
|
|