Hive JDBC 连接
来源:互联网 发布:淘宝买药提交需求 编辑:程序博客网 时间:2024/05/01 12:53
package com.mycompany.app.my_simple_app;
import java.sql.DriverManager;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
public class HiveTest {
private static Logger log = LoggerFactory.getLogger(HiveTest.class);
private static void getQueryLogFromHive()
throws Exception {
// private static String driverName =
// String sql="select * from usr_q limit 10";
String sql="select * from wx_recmdresult_1 limit 10";
// String sql = "select guid, user_id, in_keyword, cur_req_url "
// + "from da.fn_track_info where user_id<>\"\" and regexp(user_id,'^FN_[0-9]+') "
//+ "and cur_req_url<>\"\" and regexp(cur_req_url,'^http://search.feiniu') limit 30";
java.sql.Statement stmt=null;
java.sql.Connection conn=null;
// ResultSet rscount=null;
try {
//
Class.forName("org.apache.hive.jdbc.HiveDriver");
log.info("start connect hive server2+++++");
conn = DriverManager.getConnection("jdbc:hive2://10.200.42.1:10000/default",
"hadoop", "hadoop");
stmt = conn.createStatement();
log.info("start execute");
java.sql.ResultSet res=stmt.executeQuery(sql);
while(res.next()){
String name=res.getString(1);
String dt=res.getString(2);
System.out.println("name:"+name);
System.out.println("dt:"+dt);
}
log.info(" insert data to HIVE table success!");
}finally{
if(stmt!=null){
stmt.close();
}
if(conn!=null){
conn.close();
}
}
}
public static void main(String[] args) throws Exception{
getQueryLogFromHive();
}
}
import java.sql.DriverManager;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
public class HiveTest {
private static Logger log = LoggerFactory.getLogger(HiveTest.class);
private static void getQueryLogFromHive()
throws Exception {
// private static String driverName =
// String sql="select * from usr_q limit 10";
String sql="select * from wx_recmdresult_1 limit 10";
// String sql = "select guid, user_id, in_keyword, cur_req_url "
// + "from da.fn_track_info where user_id<>\"\" and regexp(user_id,'^FN_[0-9]+') "
//+ "and cur_req_url<>\"\" and regexp(cur_req_url,'^http://search.feiniu') limit 30";
java.sql.Statement stmt=null;
java.sql.Connection conn=null;
// ResultSet rscount=null;
try {
//
Class.forName("org.apache.hive.jdbc.HiveDriver");
log.info("start connect hive server2+++++");
conn = DriverManager.getConnection("jdbc:hive2://10.200.42.1:10000/default",
"hadoop", "hadoop");
stmt = conn.createStatement();
log.info("start execute");
java.sql.ResultSet res=stmt.executeQuery(sql);
while(res.next()){
String name=res.getString(1);
String dt=res.getString(2);
System.out.println("name:"+name);
System.out.println("dt:"+dt);
}
log.info(" insert data to HIVE table success!");
}finally{
if(stmt!=null){
stmt.close();
}
if(conn!=null){
conn.close();
}
}
}
public static void main(String[] args) throws Exception{
getQueryLogFromHive();
}
}
0 0
- Hive的JDBC连接
- Hive使用JDBC连接
- hive jdbc 连接 注意事项
- Jdbc连接Hive
- 通过JDBC连接hive
- Hive JDBC 连接
- hive JDBC连接示例
- HIVE JDBC连接详解
- JDBC连接Hive
- hive jdbc连接
- java jdbc 连接hive
- Jdbc连接Hive数据库
- JDBC连接Hive
- Java HIVE 使用Jdbc连接Hive
- Hive的JDBC连接方法
- eclipse通过jdbc连接hive
- 如何用jdbc连接hive
- Java通过JDBC连接Hive
- 关于逗号运算符
- 【Android 开发】:数据存储之File文件存储 [即SD卡的写入与读取]
- 设备的兼容性(Device Compatibility)
- JAVA获取中文名字的首字母,如:"阿鲁卓玛",获取的首字母是"alzm"
- 模板
- Hive JDBC 连接
- Intentservice is way better than service
- centos 如何改主机名
- Java三个版本介绍
- 使用iis配置ftp服务器详解
- c++的异常处理
- 【Android 开发】:数据存储之 SQLite 数据库操作(一)
- java中各种集合的用法和比较
- Servlet & JSP 基础5(定制标记开发)