Re: ODBC Calls Extremely Slow

Thanks for the replies - we are using Derby for the metastore and there is a large number of tables so this may be part of the issue. Our assumption is that the issue is with the driver because queries against the database run without issue - even queries such as 'show tables'. I do believe part

Re: ODBC Calls Extremely Slow

On 15 Aug 2014, at 22:21, Stephen Sprague wrote: 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? I had the same sort of issue, related to the fact previ

Re: ODBC Calls Extremely Slow

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 wrote: > Try an eval of our commercial ODBC driver for Hiv

Re: ODBC Calls Extremely Slow

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 mailto:charlesyo...@gmail.com>> Reply-To: "user@hive.apache.org" mailto:u