[HIVE-19919] HiveServer2 - expose queryable data dictionary (ie Oracles' ALL_TAB_COLUMNS)

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 2.3.2, 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: t oo
• Created: 16/Jun/18 00:14
• Updated: 15/Feb/19 23:33

Description

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.