phoenix创建hbase表映射

目录

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);

0: jdbc:phoenix:thin:url=http://hb-bp1ya00iwt> create view "foo"."student"("id" varchar primary key,"info"."name" varchar,"info"."sex" varchar,"info"."age" varchar);
No rows affected (6.119 seconds)
0: jdbc:phoenix:thin:url=http://hb-bp1ya00iwt> !table
+------------+--------------+------------------------+---------------+----------+------------+----------------------------+-----------------+--------------+-----------------+---------------+---------------+----+
| TABLE_CAT  | TABLE_SCHEM  |       TABLE_NAME       |  TABLE_TYPE   | REMARKS  | TYPE_NAME  | SELF_REFERENCING_COL_NAME  | REF_GENERATION  | INDEX_STATE  | IMMUTABLE_ROWS  | SALT_BUCKETS  | MULTI_TENANT  | VI |
+------------+--------------+------------------------+---------------+----------+------------+----------------------------+-----------------+--------------+-----------------+---------------+---------------+----+
|            | METADATA     | SCH_IDX                | INDEX         |          |            |                            |                 | ACTIVE       | false           | null          | false         |    |
|            | SYSTEM       | CATALOG                | SYSTEM TABLE  |          |            |                            |                 |              | false           | null          | false         |    |
|            | SYSTEM       | CHILD_LINK             | SYSTEM TABLE  |          |            |                            |                 |              | false           | null          | false         |    |
|            | SYSTEM       | FUNCTION               | SYSTEM TABLE  |          |            |                            |                 |              | false           | null          | false         |    |
|            | SYSTEM       | LOG                    | SYSTEM TABLE  |          |            |                            |                 |              | true            | 32            | false         |    |
|            | SYSTEM       | MUTEX                  | SYSTEM TABLE  |          |            |                            |                 |              | true            | null          | false         |    |
|            | SYSTEM       | SEQUENCE               | SYSTEM TABLE  |          |            |                            |                 |              | false           | null          | false         |    |
|            | SYSTEM       | STATS                  | SYSTEM TABLE  |          |            |                            |                 |              | false           | null          | false         |    |
|            | SYSTEM       | TASK                   | SYSTEM TABLE  |          |            |                            |                 |              | false           | null          | false         |    |
|            |              | STUDENT                | TABLE         |          |            |                            |                 |              | false           | null          | false         |    |
|            |              | T                      | TABLE         |          |            |                            |                 |              | false           | null          | false         |    |
|            |              | US_POPULATION          | TABLE         |          |            |                            |                 |              | false           | null          | false         |    |
|            | ITEM         | LOGISTICS_DETAIL_COLD  | TABLE         |          |            |                            |                 |              | false           | null          | false         |    |
|            | ITEM         | MYSQL_CONNECTION       | TABLE         |          |            |                            |                 |              | false           | null          | false         |    |
|            | METADATA     | KAFKA_METASTORE        | TABLE         |          |            |                            |                 |              | false           | null          | false         |    |
|            | METADATA     | MYSQL_CONNECTION       | TABLE         |          |            |                            |                 |              | false           | null          | false         |    |
|            | METADATA     | MYSQL_METASTORE        | TABLE         |          |            |                            |                 |              | false           | null          | false         |    |
|            | tag_user     | TAG_USER_FEATURES      | TABLE         |          |            |                            |                 |              | false           | null          | false         |    |
|            |              | tag_result_b           | VIEW          |          |            |                            |                 |              | false           | null          | false         |    |
|            |              | tag_result_c           | VIEW          |          |            |                            |                 |              | false           | null          | false         |    |
|            | foo          | student                | VIEW          |          |            |                            |                 |              | false           | null          | false         |    |
+------------+--------------+------------------------+---------------+----------+------------+----------------------------+-----------------+--------------+-----------------+---------------+---------------+----+
0: jdbc:phoenix:thin:url=http://hb-bp1ya00iwt> select * from "foo"."student";
+-------+--------+---------+------+
|  id   |  name  |   sex   | age  |
+-------+--------+---------+------+
| 1001  |        | male    | 18   |
| 1002  | Janna  | female  | 20   |
+-------+--------+---------+------+
2 rows selected (0.035 seconds)