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)