drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Zelaine Fong <zf...@maprtech.com>
Subject Re: show tables taking long time on hive plugin
Date Thu, 18 Aug 2016 14:49:10 GMT
Have you tried tweaking Drill's Hive metastore cache parameters?  See
https://drill.apache.org/docs/hive-metadata-caching/.

-- Zelaine

On Wed, Aug 17, 2016 at 10:02 PM, Sungwook Yoon <syoon@maprtech.com> wrote:

> 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