[HIVE-2905] Desc table can't show non-ascii comments

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.7.0, 0.10.0
• Fix Version/s: 0.12.0
• Component/s: CLI
• Labels: patch

Environment

hive 0.7.0, mysql 5.1.45
hive 0.10.0, mysql 5.5.30

• Tags: hadoop hive mysql
• Assignee: Navis Ryu
• Reporter: Sheng Zhou
• Created: 26/Mar/12 04:35
• Updated: 29/Oct/13 13:34
• Resolved: 27/Jul/13 15:02

Description

When desc a table with command line or hive jdbc way, the table's comment can't be read.
1. I have updated javax.jdo.option.ConnectionURL parameter in hive-site.xml file.
jdbc:mysql://...:3306/hive?characterEncoding=UTF-8
2. In mysql database, the comment field of COLUMNS table can be read normally.

Issue Links

• duplicates: HIVE-3914 use Chinese in hive column comment and table comment
• is related to: HIVE-5682 can not display the table's comment in chinese