HIVE 注释出现乱码???

素颜马尾好姑娘i 2023-01-11 09:11 161阅读 0赞

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk_size_16_color_FFFFFF_t_70][]

# hive-site.xml #

![202101261614011.png][]

# 登录mysql #

# 使用hive配置的数据库(见上图) #

# select \* from COLUMNS\_V2; #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk_size_16_color_FFFFFF_t_70 1][]

# 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\_KEYS modify column PKEY\_COMMENT varchar(4000) character set utf8; #

# 我没有索引，所以索引注解没有使用 #

# alter table INDEX\_PARAMS modify column PARAM\_VALUE varchar(4000) character set utf8; #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk_size_16_color_FFFFFF_t_70 2][]

# drop 掉表，重新创建 #

# 我是外连接，用语句重新加载数据 #

# msck repair table xxx #

# 重新登录hive即可 #

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk_size_16_color_FFFFFF_t_70 3][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk_size_16_color_FFFFFF_t_70]: /images/20221119/03cfe7b9277f44aba271abe2cf0a112b.png
[202101261614011.png]: /images/20221119/ce181116bc9c48dcb50e43c2ac1d81c7.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk_size_16_color_FFFFFF_t_70 1]: /images/20221119/6283ae52faee4d548a1ce070d4c9e986.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk_size_16_color_FFFFFF_t_70 2]: /images/20221119/f4d1c6404968425d9ccad8530bef3dba.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dhbHlreXk_size_16_color_FFFFFF_t_70 3]: /images/20221119/235481def4d2490db0ba4edc4ff07664.png