Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-7115

Improve Hive schema show tables performance

    XMLWordPrintableJSON

    Details

      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).

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                IhorHuzenko Igor Guzenko
                Reporter:
                IhorHuzenko Igor Guzenko
                Reviewer:
                Vitalii Diravka
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: