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<mailto:charlesyo...@gmail.com>> Reply-To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto:user@hive.apache.org>> Date: Friday, August 15, 2014 9:54 AM To: "user@hive.apache.org<mailto:user@hive.apache.org>" <user@hive.apache.org<mailto: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