1、使用Phoenix通过sql语句更新操作hbase数据(例子):
http://segmentfault.com/a/1190000002936080
2、官网:http://phoenix.apache.org/
可以查看phoenix字段类型和构建索引
3、phoenix客户端连接器:squirrel
执行命令:java -jar squirrel-sql-3.7-standard.jar到安装界面,安装完成后将 phoenix-4.5.2-HBase-1.0-client.jar 拷贝到安装目录的lib包下面
1)配置drivers:
点击“drivers按钮”->“+”
填写配置信息:
选型 | 填写 | 说明 |
---|---|---|
url | jdbc:phoenix:master245 | master245:172.168.101.245 |
jar包选择 | D:\Program Files\squirrel-sql-3.7\lib\phoenix-4.5.2-HBase-1.0-client.jar | |
class name | org.apache.phoenix.jdbc.PhoenixDriver |
2)链接
点击aliases->’+’,设置属性,账号密码暂时为空
4、java代码执行,将phoenix-4.5.2-HBase-1.0-client.jar添加到运行环境
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.PreparedStatement;
import java.sql.Statement;
public class test {
public static void main(String[] args) throws SQLException {
Statement stmt = null;
ResultSet rset = null;
Connection con = DriverManager.getConnection("jdbc:phoenix:[zookeeper]");
stmt = con.createStatement();
stmt.executeUpdate("create table test (mykey integer not null primary key, mycolumn varchar)");
stmt.executeUpdate("upsert into test values (1,'Hello')");
stmt.executeUpdate("upsert into test values (2,'World!')");
con.commit();
PreparedStatement statement = con.prepareStatement("select * from test");
rset = statement.executeQuery();
while (rset.next()) {
System.out.println(rset.getString("mycolumn"));
}
statement.close();
con.close();
}
}