impala-java 案例

package cn.com.cennavi.test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class ImpalaUtil {
	// here is an example query based on one of the Hue Beeswax sample tables 
		private static final String SQL_STATEMENT = "select count(*) from tsi_road_900300_20140407";
	 
		// set the impalad host
		private static final String IMPALAD_HOST = "10.80.80.13";
	 
		// port 21050 is the default impalad JDBC port 
		private static final String IMPALAD_JDBC_PORT = "21050";
	 
		private static final String CONNECTION_URL = "jdbc:hive2://" + IMPALAD_HOST + ':' + IMPALAD_JDBC_PORT + "/;auth=noSasl";
	 
		private static final String JDBC_DRIVER_NAME = "org.apache.hive.jdbc.HiveDriver";
	 
		public static void main(String[] args) {
	 
			System.out.println("\n=============================================");
			System.out.println("Cloudera Impala JDBC Example");
			System.out.println("Using Connection URL: " + CONNECTION_URL);
			System.out.println("Running Query: " + SQL_STATEMENT);
	 
			Connection con = null;
	 
			try {
	 
				Class.forName(JDBC_DRIVER_NAME);
	 
				con = DriverManager.getConnection(CONNECTION_URL);
	 
				Statement stmt = con.createStatement();
	 
				ResultSet rs = stmt.executeQuery(SQL_STATEMENT);
	 
				System.out.println("\n== Begin Query Results ======================");
	 
				// print the results to the console
				while (rs.next()) {
					// the example query returns one String column
					System.out.println(rs.getString(1));
				}
	 
				System.out.println("== End Query Results =======================\n\n");
	 
			} catch (SQLException e) {
				e.printStackTrace();
			} catch (Exception e) {
				e.printStackTrace();
			} finally {
				try {
					con.close();
				} catch (Exception e) {
					// swallow
				}
			}
		}
}

所用包：

hive-service-0.10.0-cdh4.5.0.jar

hive-metastore-0.10.0-cdh4.5.0.jar

hive-jdbc-0.10.0-cdh4.5.0.jar

可以直接在Eclipse上远程调用linux上impala，进行数据库操作。