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;