**
如果,hive中数据库表的中文变为?,可进行以下操作
**
1、vi /etc/my.cnf将配置改为以下内容
[client]
port=3306
socket=/var/lib/mysql/mysql.sock
default-character-set=utf8
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0
character-set-server=utf8
[mysql]
no-auto-rehash
default-character-set=utf8
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
2、永久配置虚拟机字符集
vi /etc/profile
source /etc/profile 激活配置
加一项配置
export LANG=zh_CN.UTF-8