Query remote Hive server2 using Spring hangs
There is a problem with HiveDriver(org.apache.hadoop.hive.jdbc.HiveDriver), change it to [org.apache.hive.jdbc.HiveDriver;]
Refer example below
package org.springframework.samples.hadoop.hive;import org.apache.hive.jdbc.HiveDriver;import org.springframework.jdbc.core.JdbcTemplate;import org.springframework.jdbc.datasource.SimpleDriverDataSource;public class TestHive { private static String driverName = "org.apache.hive.jdbc.HiveDriver"; public static void main(String args[]){ java.sql.Driver driver = new HiveDriver(); SimpleDriverDataSource ds = new SimpleDriverDataSource(driver, "jdbc:hive2://$host/$DB:10000"); JdbcTemplate hiveTemplate = new JdbcTemplate(ds); System.out.println(hiveTemplate.queryForList("show tables")); System.out.println("Done"); }}