[DRILL-7115] Improve Hive schema show tables performance

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.15.0
• Fix Version/s: 1.16.0
• Component/s: Storage - Hive, Storage - Information Schema
• Labels: ready-to-commit
• Assignee: Igor Guzenko
• Reporter: Igor Guzenko
• Reviewer: Vitalii Diravka
• Created: 19/Mar/19 11:49
• Updated: 08/Jul/19 17:10
• Resolved: 05/Apr/19 23:10

Description

In Sqlline(Drill), "show tables" on a Hive schema is taking nearly 15mins to 20mins. The schema has nearly ~8000 tables.
Whereas the same in beeline(Hive) is throwing the result in a split second(~ 0.2 secs).

I tested the same in my test cluster by creating 6000 tables(empty!) in Hive and then doing "show tables" in Drill. It took more than 2 mins(~140 secs).

Issue Links

• links to: GitHub Pull Request #1706