Connecting to Hive using JDBC client

I wanted to try out connecting to Hive using a JDBC driver, so i followed these steps. You can download the Maven project from this location

1. First start the HiveServer by executing hive --service hiveserver command
   
3. Make sure that Hive is running by executing netstat --tnlp | grep 10000
   
4. Now use the following Java code for connecting and executing simple select query on Hive

   	package com.spnotes.hive;
   	import java.sql.Connection;
   	import java.sql.DriverManager;
   	import java.sql.ResultSet;
   	/**
   	* Created by gpzpati on 4/26/14.
   	*/
   	public class HelloHiveJDBC {
   	private static String driverName = "org.apache.hadoop.hive.jdbc.HiveDriver";
   	public static void main(String[] argv) throws Exception{
   	try {
   	Class.forName(driverName);
   	} catch (ClassNotFoundException e) {
   	// TODO Auto-generated catch block
   	e.printStackTrace();
   	System.exit(1);
   	}
   	Connection connection = null;
   	try {
   	connection= DriverManager.getConnection("jdbc:hive://172.16.225.188:10000/default", "", "");
   	ResultSet resultSet = connection.createStatement().executeQuery("select * from records");
   	while (resultSet.next()) {
   	System.out.println(resultSet.getObject("year") + " " + resultSet.getObject("temperature"));
   	}
   	}finally{
   	connection.close();
   	}
   	}
   	}

   view raw HelloHiveJDBC.java hosted with ❤ by GitHub