[HIVE-9456] Make Hive support unicode with MSSQL as Metastore backend

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.14.0
• Fix Version/s: 1.2.0
• Component/s: Metastore
• Assignee: Xiaobing Zhou
• Reporter: Xiaobing Zhou
• Created: 24/Jan/15 00:59
• Updated: 01/Oct/19 22:07
• Resolved: 06/May/15 18:21

Description

There are significant issues when Hive uses MSSQL as metastore backend to support unicode, since MSSQL handles varchar and nvarchar datatypes differently. Hive 0.14 metastore mssql script DDL was using varchar as datatype, which can't handle multi-bytes/unicode characters, e.g., Chinese chars. This JIRA is going to track implementation of unicode support in that case.

Issue Links

• is related to: HIVE-11975 mssql scripts contains invalid 'GO' statement
• relates to: HIVE-9208 MetaStore DB schema inconsistent for MS SQL Server in use of varchar/nvarchar
• relates to: HIVE-9554 Rename 0.15 upgrade scripts to 1.1
• links to: REVIEW BOARD