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 <[email protected]> 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 >
