Hi Zhan,
Ideally there must be some 'hive.cli.print.charset' property in config xml
files somewhere which gets picked up by CliDriver (in say
HiveConf.ConfVars.HIVE_CLI_PRINT_CHARSET), but I don't see it.
There is one in hive-site.xml to specify character set, but I am not sure if it
is picked by CliDriver.But try?
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://<your-db>:3306/hive?characterEncoding=UTF-8</value>
</property>
Thanks
Rekha
From: NamasAmitabha <[email protected]<mailto:[email protected]>>
Reply-To: <[email protected]<mailto:[email protected]>>
Date: Wed, 22 Aug 2012 10:14:07 +0800
To: <[email protected]<mailto:[email protected]>>
Subject: hive comment in Chinese
Hi, all
I tried to use Chinese in hive column comment and table comment,and the
metadata in Mysql is regular,the charset of 'COMMENT' column in 'columns_v2'
table and 'PARAM_VALUE' column in 'table_params' table both are 'utf8'.
When I exec 'select * from columns_v2' with mysql client,the Chinese
comments display normally. But when I execute 'describe table' with hive
cli,the Chinese words are garbled.Why is it so? Please help me out.
Thanks & Regards
Zhan
