phoenix-4.7.0建表分区

参考来源

http://outofmemory.cn/code-snippet/tagged/phoenix

软件下载地址：
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');