Yes, but... It has not much to do with taking 2mins reading tables compared to 1 second from beeline... Beeline is not fast due to caching..
Sungwook On Thu, Aug 18, 2016 at 7:49 AM, Zelaine Fong <[email protected]> wrote: > 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 > > >
