Java调用hiveServer2_java – 如何启动hiveserver2作为服务

大家好我已经在我的网络中设置了多节点集群(即5节点),工作正常.

现在我想使用配置单元从集群中插入和检索数据,因此我在主节点上设置了hive最新版本apache-hive-0.14.0-bin.tar.gz(即

here中的0.14.0),如

this文章中所述.

我也编写了一个java客户端类,它将使jdbc连接到hive并使用hive将数据插入HDFS.

HiveJdbcClient.Java

public class HiveJdbcClient {

private static final String DRIVER_NAME = "org.apache.hive.jdbc.HiveDriver";

private static final String HIVE_URL = "jdbc:hive2://x.x.x.x:10000/default";

private static final String HIVE_UNAME = "";

private static final String HIVE_PWD = "";

private static Connection con;

private HiveJdbcClient() {}

public static Connection getConnection() {

try {

if (con == null) {

synchronized (HiveJdbcClient.class) {

if (con == null) {

Class.forName(DRIVER_NAME);

con = DriverManager.getConnection(HIVE_URL,

HIVE_UNAME, HIVE_PWD);

System.out.println("Successfuly Connected to database...!");

}

}// End of synchronized block.

}// End of if block.

} catch (SQLException e) {

System.out.println("Can Not able to connect to database pls check your settings \n" + e);

} catch (ClassNotFoundException e) {

System.out.println("Can Not able to connect to database pls check your settings \n" + e);

}// End of try-catch block.

return con;

}// End of getConnection() Method.

public static ResultSet executeQuery(String sql) {

ResultSet set = null;

try {

if (sql != null) {

set = getConnection().createStatement().executeQuery(sql);

}

} catch (SQLException e) {

System.out.println("Error while executing query " + e);

}// End of try-catch block.

return set;

}// End of executeQuery() Method.

public static void main(String[] args) throws ParseException, SQLException {

ResultSet res = executeQuery("SELECT * FROM mytable");

while (res.next()) {

System.out.println(String.valueOf(res.getString(1)) + '\t'

+ String.valueOf(res.getFloat(2)) + '\t'

+ String.valueOf(res.getString(3)));

}

}

}//End of HiveJdbcClient Class.

当我在终端中运行以下命令时,我的应用程序能够连接到服务器

$HIVE_HOME/bin/hiveserver2

SLF4J: Class path contains multiple SLF4J bindings.

SLF4J: Found binding in [jar:file:/opt/hadoop-2.6.0/share/hadoop/common/lib/slf4j-log4j12-1.7.5.jar!/org/slf4j/impl/StaticLoggerBinder.class]

SLF4J: Found binding in [jar:file:/opt/apache-hive-0.14.0-bin/lib/hive-jdbc-0.14.0-standalone.jar!/org/slf4j/impl/StaticLoggerBinder.class]

SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.

SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory]

OK

但是当我关闭此终端时,我的应用程序会出现以下错误

错误

java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://X.X.X.X:10000/default: java.net.ConnectException: Connection refused

这意味着我必须在我的主节点上运行hiveserver2作为服务.

任何人都可以帮我运行这个hiveserver2作为服务.或任何可以帮助我运行hiveserver2作为服务的链接.