Phoenix全局索引

[root@master soft]# mv DIANXIN.csv /usr/local/soft/data
[root@master soft]# ls
0??           hive-1.2.1      redis        show
A??           jars            redis-6.2.6  test.txt
data          jdk1.8.0_171    scripts      zookeeper-3.4.6
hadoop-2.7.6  packages        shell
hbase-1.4.6   phoenix-4.15.0  shell01
[root@master soft]# cd data/
[root@master data]# ls
data_skew.txt  scoreStruct               testArray2.txt
deal_tb.txt    score.txt                 testLieToLine.txt
dept.txt       students_dt.txt           theZenOfPython.txt
DIANXIN.csv    student.sql               theZen.txt
emp.txt        students.txt              udtfData.txt
new_db.sql     students_year_month.txt   wordcount
new_score.txt  subject.txt               words.txt
scoreMap       ${system:java.io.tmpdir}
score.sql      testArray
[root@master data]# vim DIANXIN.sql

CREATE TABLE IF NOT EXISTS DIANXIN (
     mdn VARCHAR ,
     start_date VARCHAR ,
     end_date VARCHAR ,
     county VARCHAR,
     x DOUBLE ,
     y  DOUBLE,
     bsid VARCHAR,
     grid_id  VARCHAR,
     biz_type VARCHAR, 
     event_type VARCHAR , 
     data_source VARCHAR ,
     CONSTRAINT PK PRIMARY KEY (mdn,start_date)
) column_encoded_bytes=0;

[root@master data]# psql.py master,node1,node2 DIANXIN.sql DIANXIN.csv
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/usr/local/soft/phoenix-4.15.0/phoenix-4.15.0-HBase-1.4-client.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/usr/local/soft/hadoop-2.7.6/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
22/04/15 20:51:00 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
no rows upserted
Time: 2.466 sec(s)

csv columns from database.
CSV Upsert complete. 515751 rows upserted
Time: 70.143 sec(s)

hbase(main):003:0> create 'test','name','company' 
0 row(s) in 2.3100 seconds

=> Hbase::Table - test
hbase(main):004:0> list 'test'
TABLE                                                           
test                                                            
1 row(s) in 0.0160 seconds

=> ["test"]
hbase(main):005:0> desc 'test'
Table test is ENABLED                                           
test                                                            
COLUMN FAMILIES DESCRIPTION                                     
{NAME => 'company', BLOOMFILTER => 'ROW', VERSIONS => '1', IN_ME
MORY => 'false', KEEP_DELETED_CELLS => 'FALSE', DATA_BLOCK_ENCOD
ING => 'NONE', TTL => 'FOREVER', COMPRESSION => 'NONE', MIN_VERS
IONS => '0', BLOCKCACHE => 'true', BLOCKSIZE => '65536', REPLICA
TION_SCOPE => '0'}                                              
{NAME => 'name', BLOOMFILTER => 'ROW', VERSIONS => '1', IN_MEMOR
Y => 'false', KEEP_DELETED_CELLS => 'FALSE', DATA_BLOCK_ENCODING
 => 'NONE', TTL => 'FOREVER', COMPRESSION => 'NONE', MIN_VERSION
S => '0', BLOCKCACHE => 'true', BLOCKSIZE => '65536', REPLICATIO
N_SCOPE => '0'}                                                 
2 row(s) in 0.0310 seconds

hbase(main):006:0> put 'test','001','name:firstname','zhangsan1'
0 row(s) in 0.0900 seconds

hbase(main):007:0> put 'test','001','name:lastname','zhangsan2'
0 row(s) in 0.0080 seconds

hbase(main):008:0> put 'test','001','company:name','数加'
0 row(s) in 0.0170 seconds

hbase(main):009:0> put 'test','001','company:address','合肥'
0 row(s) in 0.0110 seconds