[HIVE-11332] Unicode table comments do not work

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 0.13.1, 1.1.0, 2.0.0
• Assignee: Unassigned
• Reporter: Sergey Shelukhin
• Created: 21/Jul/15 23:06
• Updated: 16/Sep/15 18:38
• Resolved: 16/Sep/15 18:38

Description

Noticed by accident.

select '😾 ', count(*) from moo;
Query ID = sershe_20150721190413_979e1b6f-86d6-436f-b8e6-d6785b9d3b83
Total jobs = 1
Launching Job 1 out of 1

[snip]
OK
😾 	0
Time taken: 13.347 seconds, Fetched: 1 row(s)
hive> ALTER TABLE moo SET TBLPROPERTIES ('comment' = '😾 ');
OK
Time taken: 0.292 seconds
hive> desc extended moo;
OK
i                   	int                 	                    
	 	 
Detailed Table Information	Table(tableName:moo, dbName:default, owner:sershe, createTime:1437519787, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:i, type:int, comment:null)], location:hdfs://cn108-10.l42scl.hortonworks.com:8020/apps/hive/warehouse/moo, inputFormat:org.apache.hadoop.mapred.TextInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, parameters:{serialization.format=1}), bucketCols:[], sortCols:[], parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[], skewedColValueLocationMaps:{}), storedAsSubDirectories:false), partitionKeys:[], parameters:{last_modified_time=1437519883, totalSize=0, numRows=-1, rawDataSize=-1, COLUMN_STATS_ACCURATE=false, numFiles=0, transient_lastDdlTime=1437519883, comment=?? , last_modified_by=sershe}, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)	
Time taken: 0.347 seconds, Fetched: 3 row(s)

Issue Links

• duplicates: HIVE-11837 comments do not support unicode characters well.