drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sungwook Yoon <sy...@maprtech.com>
Subject show tables taking long time on hive plugin
Date Thu, 18 Aug 2016 05:02:13 GMT 
Hi,

Drill 1.6.0
MapR 3.1.1
Hive 0.13
HS2 SQL Authorization
Hive Meta storage authorization

Hive Default database has 1400 tables.

I see significant slow down in "show tables" when Hive database is bigger
than 500 tables.
It takes 3 minutes to get the resultset.
There is no obvious logs on drillbit or zookeeper to help diagnose the
situation.

Beeline is snappy, returns 1400 tables in a second or so.

Why Drill "show tables" on Hive plugin takes this long?

Thanks,

Sungwook
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message