Igor Guzenko created DRILL-7115: ----------------------------------- Summary: Improve Hive schema show tables performance Key: DRILL-7115 URL: https://issues.apache.org/jira/browse/DRILL-7115 Project: Apache Drill Issue Type: Improvement Components: Storage - Hive, Storage - Information Schema Reporter: Igor Guzenko Assignee: Igor Guzenko
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). -- This message was sent by Atlassian JIRA (v7.6.3#76005)