-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/30336/
-----------------------------------------------------------

Review request for hive.


Repository: hive-git


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.


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

Reply via email to