phoenix学习路线环境搭建

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();
    }
}