----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/30336/ -----------------------------------------------------------
(Updated Jan. 27, 2015, 11:05 p.m.) Review request for hive. Repository: hive-git Description (updated) ------- 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. https://issues.apache.org/jira/browse/HIVE-9456 Diffs ----- metastore/scripts/upgrade/mssql/006-HIVE-9456.mssql.sql PRE-CREATION metastore/scripts/upgrade/mssql/hive-schema-0.15.0.mssql.sql 7ca9b24 metastore/scripts/upgrade/mssql/upgrade-0.14.0-to-0.15.0.mssql.sql 36a5210 Diff: https://reviews.apache.org/r/30336/diff/ Testing ------- 1. New empty metastore's created with 0.14 schema. 2. upgrade-0.14.0-to-0.15.0.mssql.sql is run manually to get 0.14 metastore upgraded to 0.15. 3. Double check it to make sure every orginal varchar column changed to nvarchar. Thanks, XIAOBING ZHOU
