java 调用spark sqlserver_SparkSQL使用之JDBC代码访问Thrift JDBC Server

启动ThriftJDBCServer:

cd $SPARK_HOME/sbin

start-thriftserver.sh &

使用jdbc访问ThriftJDBCServer代码段：

package com.luogankun.spark.sql

import java.sql.DriverManager

import java.sql.Connection

import java.sql.PreparedStatement

/**

* JDBC代码访问Thrift JDBC Server

* @author luogankun

*/

object JdbcThriftServer {

def main(args: Array[String]) {

Class.forName("org.apache.hive.jdbc.HiveDriver")

val conn = DriverManager.getConnection("jdbc:hive2://Hadoop000:10000/default", "hadoop", "")

val pstat = conn.prepareStatement("SELECT track_time, url, session_id, referer, ip, end_user_id, city_id FROM page_views WHERE city_id = -1000 limit 10")

val rs = pstat.executeQuery()

while (rs.next()) {

println("track_time: " + rs.getString("track_time")

+ ", url: " + rs.getString("url")

+ ", session_id: " + rs.getString("session_id")

+ ", referer: " + rs.getString("referer")

+ ", ip: " + rs.getString("ip")

+ ", end_user_id: " + rs.getString("end_user_id")

+ ", city_id: " + rs.getString("city_id"))

}

rs.close()

pstat.close()

conn.close()

}

}