关于Phoenix创建的表在hbase shell的显示问题及hue中不能查询的问题

建表语句

create table schema_test1 
(                                                                    
keys varchar not null primary key,                                   
f.f1 varchar,                                                        
f.f2 varchar,                                                        
s.s1 varchar,                                                        
s.s2 varchar                                                         
);
upsert into schema_test1 values('key1','f1','f2','f3','f4');

create table schema_test2 
(                                                                    
keys varchar not null primary key,                                   
f.f1 varchar,                                                        
f.f2 varchar,                                                        
s.s1 varchar,                                                        
s.s2 varchar                                                         
) COLUMN_ENCODED_BYTES= 0;
upsert into schema_test2 values('key1','f1','f2','f3','f4');

create table schema_test3 
(                                                                    
keys varchar not null primary key,                                   
f.f1 varchar,                                                        
f.f2 varchar,                                                        
s.s1 varchar,                                                        
s.s2 varchar                                                         
) COLUMN_ENCODED_BYTES='NONE';                                       
upsert into schema_test3 values('key1','f1','f2','f3','f4');

Phoenix中查看

0: jdbc:phoenix:node00:2181> create table schema_test1 
. . . . . . . . . . . . . . . . . .> (                                                                    
. . . . . . . . . . . . . . . . . .> keys varchar not null primary key,                                   
. . . . . . . . . . . . . . . . . .> f.f1 varchar,                                                        
. . . . . . . . . . . . . . . . . .> f.f2 varchar,                                                        
. . . . . . . . . . . . . . . . . .> s.s1 varchar,                                                        
. . . . . . . . . . . . . . . . . .> s.s2 varchar                                                         
. . . . . . . . . . . . . . . . . .> );
No rows affected (1.258 seconds)
0: jdbc:phoenix:node00:2181> upsert into schema_test1 values('key1','f1','f2','f3','f4');
1 row affected (0.015 seconds)
0: jdbc:phoenix:node00:2181> 
0: jdbc:phoenix:node00:2181> create table schema_test2 
. . . . . . . . . . . . . . . . . .> (                                                                    
. . . . . . . . . . . . . . . . . .> keys varchar not null primary key,                                   
. . . . . . . . . . . . . . . . . .> f.f1 varchar,                                                        
. . . . . . . . . . . . . . . . . .> f.f2 varchar,                                                        
. . . . . . . . . . . . . . . . . .> s.s1 varchar,                                                        
. . . . . . . . . . . . . . . . . .> s.s2 varchar                                                         
. . . . . . . . . . . . . . . . . .> ) COLUMN_ENCODED_BYTES= 0;
No rows affected (1.258 seconds)
0: jdbc:phoenix:node00:2181> upsert into schema_test2 values('key1','f1','f2','f3','f4');
1 row affected (0.015 seconds)
0: jdbc:phoenix:node00:2181> 
0: jdbc:phoenix:node00:2181> create table schema_test3 
. . . . . . . . . . . . . . . . . .> (                                                                    
. . . . . . . . . . . . . . . . . .> keys varchar not null primary key,                                   
. . . . . . . . . . . . . . . . . .> f.f1 varchar,                                                        
. . . . . . . . . . . . . . . . . .> f.f2 varchar,                                                        
. . . . . . . . . . . . . . . . . .> s.s1 varchar,                                                        
. . . . . . . . . . . . . . . . . .> s.s2 varchar                                                         
. . . . . . . . . . . . . . . . . .> ) COLUMN_ENCODED_BYTES='NONE';                                       
No rows affected (1.24 seconds)
0: jdbc:phoenix:node00:2181> upsert into schema_test3 values('key1','f1','f2','f3','f4');
1 row affected (0.007 seconds)
0: jdbc:phoenix:node00:2181> select * from schema_test1;
+-------+-----+-----+-----+-----+
| KEYS  | F1  | F2  | S1  | S2  |
+-------+-----+-----+-----+-----+
| key1  | f1  | f2  | f3  | f4  |
+-------+-----+-----+-----+-----+
1 row selected (0.036 seconds)
0: jdbc:phoenix:node00:2181> select * from schema_test2;
+-------+-----+-----+-----+-----+
| KEYS  | F1  | F2  | S1  | S2  |
+-------+-----+-----+-----+-----+
| key1  | f1  | f2  | f3  | f4  |
+-------+-----+-----+-----+-----+
1 row selected (0.039 seconds)
0: jdbc:phoenix:node00:2181> select * from schema_test3;
+-------+-----+-----+-----+-----+
| KEYS  | F1  | F2  | S1  | S2  |
+-------+-----+-----+-----+-----+
| key1  | f1  | f2  | f3  | f4  |
+-------+-----+-----+-----+-----+
1 row selected (0.038 seconds)
0: jdbc:phoenix:node00:2181> 

hbase shell中查看

hbase(main):006:0> scan 'MY_SCHEMA:SCHEMA_TEST1'
ROW                                              COLUMN+CELL                                                                                                                                 
 key1                                            column=F:\x00\x00\x00\x00, timestamp=1555656712077, value=x                                                                                 
 key1                                            column=F:\x80\x0B, timestamp=1555656712077, value=f1                                                                                        
 key1                                            column=F:\x80\x0C, timestamp=1555656712077, value=f2                                                                                        
 key1                                            column=S:\x80\x0D, timestamp=1555656712077, value=f3                                                                                        
 key1                                            column=S:\x80\x0E, timestamp=1555656712077, value=f4                                                                                        
1 row(s) in 0.3350 seconds

hbase(main):007:0> scan 'MY_SCHEMA:SCHEMA_TEST2'
ROW                                              COLUMN+CELL                                                                                                                                 
 key1                                            column=F:F1, timestamp=1555656713398, value=f1                                                                                              
 key1                                            column=F:F2, timestamp=1555656713398, value=f2                                                                                              
 key1                                            column=F:_0, timestamp=1555656713398, value=x                                                                                               
 key1                                            column=S:S1, timestamp=1555656713398, value=f3                                                                                              
 key1                                            column=S:S2, timestamp=1555656713398, value=f4                                                                                              
1 row(s) in 0.0120 seconds

hbase(main):008:0> scan 'MY_SCHEMA:SCHEMA_TEST3'
ROW                                              COLUMN+CELL                                                                                                                                 
 key1                                            column=F:F1, timestamp=1555656716711, value=f1                                                                                              
 key1                                            column=F:F2, timestamp=1555656716711, value=f2                                                                                              
 key1                                            column=F:_0, timestamp=1555656716711, value=x                                                                                               
 key1                                            column=S:S1, timestamp=1555656716711, value=f3                                                                                              
 key1                                            column=S:S2, timestamp=1555656716711, value=f4                                                                                              
1 row(s) in 0.0120 seconds

hbase(main):009:0> 

结论:
由上可见，SCHEMA_TEST1表创建时没设置COLUMN_ENCODED_BYTES属性值，导致列名会被编码，从而导致hbase shell中列名显示乱码，hue也无法查看hbase表信息。

了解更多请参看 https://phoenix.apache.org/columnencoding.html

全局设置方法：

HBase --> 配置 --> 高级 --> 搜索 hbase-site.xml。
在客户端添加下面配置后重启服务：

<property>
	<name>phoenix.default.column.encoded.bytes.attrib</name>
	<value>0</value>
</property>