phoenix创建hbase表映射_轩子小姐姐_column_encoded_bytes

大大的周 02-07 7345

hbase创建表

在phoneix创建关联表

在phoneix创建视图

hbase创建表

foo命名空间表名student

hbase(main):003:0> create 'foo:student','info' Created table foo:student Took 1.2910 seconds => Hbase::Table - foo:student hbase(main):004:0> put 'foo:student','1001','info:sex','male' put 'foo:student','1002','info:sex','female' put 'foo:student','1002','info:age','20'Took 0.1689 seconds hbase(main):005:0> put 'foo:student','1001','info:age','18' Took 0.0082 seconds hbase(main):006:0> put 'foo:student','1002','info:name','Janna' Took 0.0031 seconds hbase(main):007:0> put 'foo:student','1002','info:sex','female' Took 0.0086 seconds hbase(main):008:0> put 'foo:student','1002','info:age','20' Took 0.0095 seconds hbase(main):009:0> scan 'foo:student' ROW COLUMN+CELL 1001 column=info:age, timestamp=1651218568515, value=18 1001 column=info:sex, timestamp=1651218568490, value=male 1002 column=info:age, timestamp=1651218569899, value=20 1002 column=info:name, timestamp=1651218568550, value=Janna 1002 column=info:sex, timestamp=1651218568587, value=female 2 row(s) Took 0.0301 seconds 在phoneix创建关联表

create table "foo"."student"(id varchar primary key,name varchar,sex varchar,age varchar);

可以看到没有数据，经查看是没有写列族

0: jdbc:phoenix:thin:url=http://hb-bp1ya00iwt> create table "foo"."student"(id varchar primary key,name varchar,sex varchar,age varchar); No rows affected (6.192 seconds) 0: jdbc:phoenix:thin:url=http://hb-bp1ya00iwt> select * from "foo"."student"; +-----+-------+------+------+ | ID | NAME | SEX | AGE | +-----+-------+------+------+ +-----+-------+------+------+ No rows selected (0.019 seconds)

create table "foo"."student"("id" varchar primary key,"info"."name" varchar,"info"."sex" varchar,"info"."age" varchar);

还是没数据

0: jdbc:phoenix:thin:url=http://hb-bp1ya00iwt> create table "foo"."student"("id" varchar primary key,"info"."name" varchar,"info"."sex" varchar,"info"."age" varchar); No rows affected (1.267 seconds) 0: jdbc:phoenix:thin:url=http://hb-bp1ya00iwt> select * from "foo"."student"; +-----+-------+------+------+ | id | name | sex | age | +-----+-------+------+------+ +-----+-------+------+------+ No rows selected (0.028 seconds)

create table "foo"."student"("id" varchar primary key,"info"."name" varchar,"info"."sex" varchar,"info"."age" varchar)column_encoded_bytes=0;

注意：在phoneix将表drop掉之后，别忘记在hbase重新维护一下表，4.10版本之后phoenix默认会对字段值进行编码，在创建表中加入column_encoded_bytes=0属性，结果有数据

0: jdbc:phoenix:thin:url=http://hb-bp1ya00iwt> create table "foo"."student"("id" varchar primary key,"info"."name" varchar,"info"."sex" varchar,"info"."age" varchar)column_encoded_bytes=0; No rows affected (0.768 seconds) 0: jdbc:phoenix:thin:url=http://hb-bp1ya00iwt> select * from "foo"."student"; +-------+-------+------+------+ | id | name | sex | age | +-------+-------+------+------+ | 1001 | Nick | | | +-------+-------+------+------+ 1 row selected (0.03 seconds) 在phoneix创建视图

create view "foo"."student"("id" varchar primary key,"info"."name" varchar,"info"."sex" varchar,"info"."age" varchar);