[HIVE-7575] GetTables thrift call is very slow

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.12.0, 0.13.0
• Fix Version/s: 2.0.0
• Component/s: HiveServer2
• Hadoop Flags: Incompatible change

Release Note

This adds 5 additional columns to the ResultSet of GetTables. This is for compliance with the official JDBC API:

See: http://docs.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getTables(java.lang.String,%20java.lang.String,%20java.lang.String,%20java.lang.String[])

• Assignee: Navis Ryu
• Reporter: Ashu Pachauri
• Created: 31/Jul/14 20:56
• Updated: 12/Apr/17 18:18
• Resolved: 10/Nov/15 20:40

Description

The GetTables thrift call takes a long time when the number of table is large.

With around 5000 tables, the call takes around 80 seconds compared to a "Show Tables" query on the same HiveServer2 instance which takes 3-7 seconds.

Issue Links

• relates to: HIVE-11702 GetSchemas thrift call is slow on scale of 1000+ databases