what container are you using for your metastore? Derby, mysql or postgres? for a large set of tables don't use Derby.
So you've confirmed its the ODBC driver and not the metastore itself? On Fri, Aug 15, 2014 at 8:54 AM, Bradley Wright <bradley.wri...@progress.com > wrote: > Try an eval of our commercial ODBC driver for Hive: > > > http://www.progress.com/products/datadirect-connect/odbc-drivers/data-sources/hadoop-apache-hive > > It will perform better! > > From: Charles Yorek <charlesyo...@gmail.com> > Reply-To: "user@hive.apache.org" <user@hive.apache.org> > Date: Friday, August 15, 2014 9:54 AM > To: "user@hive.apache.org" <user@hive.apache.org> > Subject: ODBC Calls Extremely Slow > > Hello All, > > I am trying to use the ODBC driver but making ODBC Calls to fetch a list > of tables from Hive is extremely slow on a HiveServer2. The cluster has a > large number of tables but it takes in excess of 1 hour to extract a list > of tables via ODBC Calls. > > Are there any known workarounds for this issue? > > Thanks >
