Hi Rekha,
I’ve set the JDBC ConnectionURL like this “?useUnicode=true&characterEncoding=UTF-8”,but it doesn’t work. And if my table content contains Chinese words, hive can display normally when I exec select query, only table comments and column comments are garbled when I tried to exec “desc table”. So I don’t know where is the problem. I even tried to modify some hive source code in org.apache.hadoop.hive.jdbc to convert comment string to “UTF-8” charset, but it still doesn’t work. But thanks all the same. Thanks & Regards Zhan 发件人: Joshi, Rekha [mailto:[email protected]] 发送时间: 2012年8月23日 19:42 收件人: [email protected]; [email protected] 主题: Re: hive comment in Chinese 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]> Reply-To: <[email protected]> Date: Wed, 22 Aug 2012 10:14:07 +0800 To: <[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
