参考来源
软件下载地址:
winutils.exe http://pan.baidu.com/s/1nver1m5 64n3
hadoop-2.6.0.tar.gz http://pan.baidu.com/s/1bnVyCaz ldfm
hbase-1.1.3-bin.tar.gz http://pan.baidu.com/s/1nuJYHZz a6pa
squirrel-sql-3.7.1-standard.jar http://pan.baidu.com/s/1qXQENiG 9ddd
phoenix-4.7.0-HBase-1.1-bin.tar.gz http://pan.baidu.com/s/1hsay9GK tc8b
1、RowKey分区
Pre-split 这个就是HBase的预分区了,在建phoenix表时,可以精确的指定要根据什么值来做预分区 示例:
CREATE TABLE YUHUIREG (HOST VARCHAR NOT NULL PRIMARY KEY, DESCRIPTION VARCHAR) SPLIT ON ('CS','EU','NA');
2、RowKey SALT_BUCKETS 分区
http://phoenix.apache.org/salted.html
CREATE TABLE SALT_TABLES (a_key VARCHAR PRIMARY KEY, a_col VARCHAR) SALT_BUCKETS = 20;
3、单列族的建表插入查询 :
CREATE TABLE yuhuiTest001 ( id BIGINT not null primary key, date DATE , name VARCHAR)
UPSERT INTO yuhuiTest001 VALUES(11,'2016-05-27','foo');
select * from yuhuiTest001
DROP TABLE yuhuiTest001;
4 、单列族RowKey有多个字段的建表 :
CREATE TABLE yuhuiTest002 (tenant_id VARCHAR not null,event_type varchar,created_date DATE, txn_count bigint CONSTRAINT pk PRIMARY KEY (tenant_id, event_type) )MULTI_TENANT=true
UPSERT INTO yuhuiTest002 (tenant_id,event_type,created_date,txn_count) VALUES('yuhui','event','20160527',4);
5、多列族的建表插入查询 :
CREATE TABLE yuhuiTEST (MYKEY VARCHAR NOT NULL PRIMARY KEY, A.COL1 VARCHAR, A.COL2 VARCHAR, B.COL1 VARCHAR);
UPSERT INTO YUHUITEST VALUES('yuhui','event','20160527''4');
UPSERT INTO YUHUITEST VALUES('yuhui','event','20160527','55');