Very interesting Steven! I executed the query "SELECT g_0.code, g_0.description, g_0.total_emp, g_0.salary FROM sample_07 AS g_0" from the web app and its taking the same 20 seconds to return. I run the same query from a standalone JDBC project and the delay is the same : 20+ second.

Whats your guess about what is happening ?

So it safe to assume that the culprit is somewhere in the jars ?

Hive 0.13.1 JDBC jars makes queries run slow -------------------------------------------- Key: TEIID-3580 URL: https://issues.jboss.org/browse/TEIID-3580 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.7.3 Reporter: Debbie Steigner Assignee: Steven Hawkins Attachments: threaddump-1437508266001.tdump When using the JDBC jars for Hive 0.13.1 running on HDP 2.1, queries executed against table 'default.sample_07' takes approximately 20-30 seconds to return. The Hive JDBC jars for version 0.13.1 can be found here : https://github.com/vchintal/hive-jdbc-jars-archive Alternatively a ready-to-go modules can be downloaded from here for testing: https://drive.google.com/file/d/0BxJhoZ1V34QHSmgzTlBRVktZaGM/ Use the following driver snippet when using the above mentioned module: <driver name="hive" module="org.apache.hadoop.hive:0.13.1"> <driver-class>org.apache.hive.jdbc.HiveDriver</driver-class> </driver>