Re: query though hive jdbc cause chinese character become unrecognizable characters

Yep, looks like is not jdbc driver issue, but hive-server2 itself. Setting platform's lang to utf8 might be a requirement for Hive-server2 in this scenario, as I am not aware of any hive-specific properties to control character encodings. Not sure if anyone else has any insight? Thanks, Szehon

Re: query though hive jdbc cause chinese character become unrecognizable characters

hi,i add the following code into /etc/init.d/hive-server2 script ,now the character can be show normally,but i hope it can be handle with out any change of the hive file export LANG="zh_CN.UTF-8" On Sat, Dec 7, 2013 at 1:07 PM, Szehon Ho wrote: > I took a closer look. I tried the new JDBC Dri

Re: query though hive jdbc cause chinese character become unrecognizable characters

I took a closer look. I tried the new JDBC Driver (org.apache.hive.jdbc.HiveDriver) against Hive-Server2, and it displays Japanese characters properly without any special configurations. Can you take a look at HIVE-3245 for details, and see if that

Re: query though hive jdbc cause chinese character become unrecognizable characters

Looks like the issue is tracked from HIVE-3245. I think we need to support adding encoding parameter as part of jdbc url similar to mysql jdbc's useUnicode/characterEncoding flags. I can take a look at it if nobody else has. For now, I think you can manually encode the result value from jdbc. T

query though hive jdbc cause chinese character become unrecognizable characters

hi,maillist: we use hive to store UTF8 chinese character ,but query through hive jdbc ,it become some unreadable characters,it's normal to use hive shell.why? it's a bug in hive jdbc?how can i solve this?