[HIVE-15690] Speed up WebHCat DDL Response Time by Using JDBC

• Type: Improvement
• Status: Patch Available
• Priority: Minor
• Resolution: Unresolved
• Component/s: WebHCat
• Labels: easyfix patch performance pull-request-available security

Release Note

This change is already implemented and heavily used at www.datarepublic.io powering our REST based product console.

PR is raised against our Hive clone back to Apache: https://github.com/apache/hive/pull/133

• Assignee: Amin Abbaspour
• Reporter: Amin Abbaspour
• Created: 21/Jan/17 06:01
• Updated: 24/Jun/20 00:28

Description

WebHCat launches new hcat scripts for each DDL call which makes it unsuitable for interactive REST environments.

This change to speed up /ddl query calls by running them over JDBC connection to Hive thrift server.

Also being JDBC connection, this is secure and compatible with all access policies define in Hive server2. User does not have metadata visibility over other databases (which is the case in hcat mode.)

Issue Links

• links to: GitHub Pull Request #133