impala注释乱码


表现:
+--------------------+--------------+----------------------------------------+ 
| name | type | comment |
+--------------------+--------------+----------------------------------------+
| id | varchar(64) | ?? |
| channel | varchar(30) | ?????? |
| deery_sign | varchar(64) | ??????(???) |
| user_bae_id | varchar(64) | ????id |
| id_typ | varchar(10) | ??????? |
| id_no | varchar(30) | ??????? |
| cust_nme | varchar(60) | ????? |
| goods_no | varchar(30) | ???? |
+--------------------+--------------+----------------------------------------+
解决方式:
use hive; 
alter table COLUMNS_V2 modify column COMMENT varchar(256) character set utf8; 
alter table TABLE_PARAMS modify column PARAM_VALUE varchar(4000) character set utf8; 
alter table PARTITION_PARAMS modify column PARAM_VALUE varchar(4000) character set utf8; 
alter table PARTITION_KEYS modify column PKEY_COMMENT varchar(4000) character set utf8; 
alter table INDEX_PARAMS modify column PARAM_VALUE varchar(4000) character set utf8;
 

相关