t oo created HIVE-19919:
---------------------------
Summary: HiveServer2 - expose queryable data dictionary (ie
Oracles' ALL_TAB_COLUMNS)
Key: HIVE-19919
URL: https://issues.apache.org/jira/browse/HIVE-19919
Project: Hive
Issue Type: New Feature
Components: SQL
Affects Versions: 2.3.2, 3.0.0
Reporter: t oo
All major db vendors have a table like information_schema.columns,
all_tab_columns or syscolumns containing table_name,column_name, data_type,
col_order. Adding this feature to HiveServer2 would be very convenient for
users.
This information is currently only available in the mysql metastore ie TBLS,
COLS but should be exposed up into the HiveServer2 10000 port connection. Thus
saving users from having 2 connections (1 to see data, 1 to see metadata). For
security reason too, mysql can be firewalled from end-users.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
