package org.admln.hive;

 import java.sql.SQLException;

 import java.sql.Connection;

 import java.sql.ResultSet;

 import java.sql.Statement;

 import java.sql.DriverManager;

 public class testHive {

     private static String driverName =

                    "org.apache.hadoop.hive.jdbc.HiveDriver";

     public static void main(String[] args)

                             throws SQLException {

         try {

             Class.forName(driverName);

         } catch (ClassNotFoundException e) {

             e.printStackTrace();

             System.exit(1);

         }

         Connection con = DriverManager.getConnection(

                            "jdbc:hive://192.168.126.133:10000/default", "hive", "hadoop");

         Statement stmt = con.createStatement();

         String tableName = "hellohive";

         stmt.execute("drop table if exists " + tableName);

         stmt.execute("create table " + tableName +

                                      " (key int, value string)");

         System.out.println("Create table success!");

         // show tables

         String sql = "show tables '" + tableName + "'";

         System.out.println("Running: " + sql);

         ResultSet res = stmt.executeQuery(sql);

         if (res.next()) {

             System.out.println(res.getString(1));

         }

         // describe table

         sql = "describe " + tableName;

         System.out.println("Running: " + sql);

         res = stmt.executeQuery(sql);

         while (res.next()) {

             System.out.println(res.getString(1) + "\t" + res.getString(2));

         }

         sql = "select * from " + tableName;

         res = stmt.executeQuery(sql);

         while (res.next()) {

             System.out.println(String.valueOf(res.getInt(1)) + "\t"

                                                + res.getString(2));

         }

         sql = "select count(1) from " + tableName;

         System.out.println("Running: " + sql);

         res = stmt.executeQuery(sql);

         while (res.next()) {

             System.out.println(res.getString(1));

         }

     }

 }

 hadoop-2.2.0/share/hadoop/common/hadoop-common-2.2.0.jar

 $HIVE_HOME/lib/hive-exec-0.11.0.jar

 $HIVE_HOME/lib/hive-jdbc-0.11.0.jar

 $HIVE_HOME/lib/hive-metastore-0.11.0.jar

 $HIVE_HOME/lib/hive-service-0.11.0.jar

 $HIVE_HOME/lib/libfb303-0.9.0.jar

 $HIVE_HOME/lib/commons-logging-1.0.4.jar

 $HIVE_HOME/lib/slf4j-api-1.6.1.jar