FAQ-hive中文展示乱码

问题描述/异常栈

hive中文展示为??

解决方案

ALTER TABLE `COLUMNS_V2` MODIFY `COMMENT` varchar(256) CHARACTER SET utf8 DEFAULT NULL;
ALTER TABLE `INDEX_PARAMS` MODIFY `PARAM_VALUE` varchar(4000) CHARACTER SET utf8 DEFAULT NULL;
ALTER TABLE `PARTITION_KEYS` MODIFY `PKEY_COMMENT` varchar(4000) CHARACTER SET utf8 DEFAULT NULL;
ALTER TABLE `PARTITION_PARAMS` MODIFY `PARAM_VALUE` varchar(4000) CHARACTER SET utf8 DEFAULT NULL;
ALTER TABLE `TABLE_PARAMS` MODIFY `PARAM_VALUE` MEDIUMTEXT CHARACTER SET utf8 DEFAULT NULL;
ALTER TABLE TBLS MODIFY COLUMN VIEW_EXPANDED_TEXT mediumtext CHARACTER SET utf8;
ALTER TABLE TBLS MODIFY COLUMN VIEW_ORIGINAL_TEXT mediumtext CHARACTER SET utf8;

问题原因

tbls表存储hive的表,视图,索引信息,metastore tbls表编码默认为latin1

作者:林帅