Impala 4、Impala JDBC
来源:互联网 发布:单片机时序图 编辑:程序博客网 时间:2024/05/18 01:24
配置:
– impala.driver=org.apache.hive.jdbc.HiveDriver
– impala.url=jdbc:hive2://node2:21050/;auth=noSasl
– impala.username=
– impala.password=
• 尽量使用PreparedStatement执行SQL语句:
– 1.性能上PreparedStatement要好于Statement
– 2.Statement存在查询不出数据的情况
下面是Java的测试代码:
首先是引入Impala所需要的类库
然后是测试代码:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
import
java.sql.Connection;
import
java.sql.DriverManager;
import
java.sql.PreparedStatement;
import
java.sql.ResultSet;
import
java.sql.SQLException;
import
org.junit.Test;
public
class
demo {
public
static
Connection getConnection()
throws
ClassNotFoundException, SQLException{
String driver =
"org.apache.hive.jdbc.HiveDriver"
;
String url =
"jdbc:hive2://node23:21050/;auth=noSasl"
;
String username =
""
;
String password =
""
;
Connection conn =
null
;
Class.forName(driver);
conn = (Connection) DriverManager.getConnection(url,username,password);
return
conn;
}
@Test
public
void
select()
throws
ClassNotFoundException, SQLException{
Connection conn = getConnection();
String sql =
"select * from t_stu;"
;
PreparedStatement ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
int
col = rs.getMetaData().getColumnCount();
System.out.println(
"====================================="
);
while
(rs.next()){
for
(
int
i=
1
;i<=col;i++){
System.out.print(rs.getString(i)+
"\t"
);
}
System.out.print(
"\n"
);
}
System.out.println(
"====================================="
);
}
}
最后是测试结果:
阅读全文
0 0
- Impala 4、Impala JDBC
- impala
- IMPALA
- impala
- Impala
- Impala
- Impala
- impala
- Impala
- Impala
- impala jdbc -example
- impala-jdbc-example-run
- impala-jdbc-example-pom
- jdbc连接impala
- 用JDBC连接Impala
- java通过jdbc连接impala
- Impala006-impala 数据处理&impala 和 HBase整合&JDBC方式访问Impala
- Impala学习--Impala概述
- windows核心编程之DLL注入例子分析
- Impala 3、Impala、Hbase整合
- 装饰器模式
- c++里的线程相关创建
- 单机Redis的安装以及基本操作简介
- Impala 4、Impala JDBC
- poj 1065 Wooden Sticks
- 事件分发和滑动冲突知识点总结
- POJ 1185 炮兵阵地(状压DP)
- Python —— 深拷贝 VS 浅拷贝
- Impala 5、Impala 性能优化
- JAVA环境的配置与安装
- HDU 6070 Dirt Ratio
- HDU-6078 Wavel Sequence(dp+树状数组)