[
https://issues.apache.org/jira/browse/TRAFODION-2363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15685122#comment-15685122
]
Anoop Sharma commented on TRAFODION-2363:
-----------------------------------------
Hive MD info is returned in relational format through the use of traf virtual
tables.
Syntax:
TABLE(HIVEMD(TABLES)) for table related info
TABLE(HIVEMD(COLUMNS)) for columns related info
This is similar to:
"_MD_".TABLES_VIEW and "_MD_".COLUMNS_VIEW to access metadata info for traf
tables.
Query example:
select * from table(hivemd(tables));
select * from table(hivemd(columns));
Data returned from table(hivemd(tables)):
>>invoke table(hivemd(tables));
CATALOG_NAME CHAR(256 BYTES) CHARACTER SET UTF8
-- catalog name of the object. set to "HIVE"
SCHEMA_NAME CHAR(256 BYTES) CHARACTER SET UTF8
-- database name of hive object.
TABLE_NAME CHAR(256 BYTES) CHARACTER SET UTF8
-- table name of hive object
FILE_FORMAT CHAR(24) CHARACTER SET ISO88591
-- "TEXTFILE", "SEQUENCE", "ORC"
CREATE_TIME LARGEINT
-- juliantimestamp when table was created
NUM_COLS INT
-- total number of columns (regular + partition)
NUM_PART_COLS INT
-- number of partition columns
NUM_BUCKET_COLS INT
-- number of bucketing columns
NUM_SORT_COLS INT
-- number of sort columns
HIVE_OWNER CHAR(256 BYTES) CHARACTER SET UTF8
-- owner of underlying hive/hdfs object
FIELD_DELIMITER SMALLINT
-- delimiter between fields for text files
RECORD_TERMINATOR SMALLINT
-- record terminator
NULL_FORMAT CHAR(8) CHARACTER SET ISO88591
-- format of null specifier
LOCATION CHAR(1024 BYTES) CHARACTER SET UTF8
-- hdfs location of root
HIVE_TABLE_TYPE CHAR(128 BYTES) CHARACTER SET UTF8
-- "EXTERNAL_TABLE", "MANAGED_TABLE"
Data returned from table(hivemd(columns)):
CATALOG_NAME CHAR(256 BYTES) CHARACTER SET UTF8
SCHEMA_NAME CHAR(256 BYTES) CHARACTER SET UTF8
TABLE_NAME CHAR(256 BYTES) CHARACTER SET UTF8
COLUMN_NAME CHAR(256 BYTES) CHARACTER SET UTF8
SQL_DATA_TYPE CHAR(32) CHARACTER SET ISO88591
FS_DATA_TYPE INT
HIVE_DATA_TYPE CHAR(32) CHARACTER SET ISO88591
COLUMN_SIZE INT
CHARACTER_SET CHAR(40) CHARACTER SET ISO88591
COLUMN_PRECISION INT
COLUMN_SCALE INT
DT_CODE INT
NULLABLE INT
COLUMN_NUMBER INT
PART_COL_NUMBER INT
BUCKET_COL_NUMBER INT
SORT_COL_NUMBER INT
DATETIME_QUALIFIER CHAR(28) CHARACTER SET ISO88591
DATETIME_START_FIELD INT
DATETIME_END_FIELD INT
DEFAULT_VALUE CHAR(240 BYTES) CHARACTER SET UTF8
> Add support to return metadata info about hive tables in relational format
> --------------------------------------------------------------------------
>
> Key: TRAFODION-2363
> URL: https://issues.apache.org/jira/browse/TRAFODION-2363
> Project: Apache Trafodion
> Issue Type: Improvement
> Reporter: Anoop Sharma
> Assignee: Anoop Sharma
> Priority: Minor
>
> Metadata info about trafodion tables and columns can be retrieved by
> running sql queries against traf metadata tables/views from "_MD_" schema.
> This jira is for an enhancement to return metadata info about hive
> tables/columns in relational format using traf queries.
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
