phoenix

安装

上传hbase.tar.gz 安装包

解压
tar -zxvf hbase.tar.gz

cd hbase

scp *server.jar /hbase/lib
scp *client.jar /hbase/lib

启动
zkServer.sh start
三台机器

start-all.sh
hadoop

start-hbase.sh

cd /phoenix/bin
./sqlline.py linux01,linux02,linux03:2181

启动phoenix

create table tab1 ( id integer primary key not null ,name varchar);

upsert into tab1 values ( 1, 'aa');

select * from tab1

---------------------------------

public class PhoenixTest {
	
	public static void main(String args[]) throws SQLException{
		Connection conn = DriverManager.getConnection("jdbc:phoenix:linux01,linux02,linux03:2181");
		Statement stat = conn.createStatement();
		ResultSet rs = stat.executeQuery("select * from TAB2");
		while(rs.next()){
			String v = rs.getString("name");
			System.out.println(v);
		}
		rs.close();
		stat.close();
		conn.close();
	}
}

添加 client.jar 至 java project 中，build path




连接工具的使用
jdbc:phoenix:linux01,linux02,linux03:2181