Author: gunther Date: Fri Oct 31 01:39:54 2014 New Revision: 1635653 URL: http://svn.apache.org/r1635653 Log: HIVE-8550: Hive cannot load data into partitioned table with Unicode key (Xiaobing Zhou, reviewed by Jason Dere)
Added: hive/branches/branch-0.14/metastore/scripts/upgrade/mssql/004-HIVE-8550.mssql.sql Modified: hive/branches/branch-0.14/metastore/scripts/upgrade/mssql/hive-schema-0.14.0.mssql.sql hive/branches/branch-0.14/metastore/scripts/upgrade/mssql/upgrade-0.13.0-to-0.14.0.mssql.sql Added: hive/branches/branch-0.14/metastore/scripts/upgrade/mssql/004-HIVE-8550.mssql.sql URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/metastore/scripts/upgrade/mssql/004-HIVE-8550.mssql.sql?rev=1635653&view=auto ============================================================================== --- hive/branches/branch-0.14/metastore/scripts/upgrade/mssql/004-HIVE-8550.mssql.sql (added) +++ hive/branches/branch-0.14/metastore/scripts/upgrade/mssql/004-HIVE-8550.mssql.sql Fri Oct 31 01:39:54 2014 @@ -0,0 +1,13 @@ +--ALTER PARTITIONS.PART_NAME from varchar to nvarchar +DROP INDEX PARTITIONS.UNIQUEPARTITION; +ALTER TABLE PARTITIONS ALTER COLUMN PART_NAME NVARCHAR(767) NULL; +CREATE UNIQUE INDEX UNIQUEPARTITION ON PARTITIONS (PART_NAME,TBL_ID); +GO + +--ALTER SDS.LOCATION from varchar to nvarchar +ALTER TABLE SDS ALTER COLUMN LOCATION NVARCHAR(4000) NULL; +GO + +--ALTER PARTITION_KEY_VALS.PART_KEY_VAL from varchar to nvarchar +ALTER TABLE PARTITION_KEY_VALS ALTER COLUMN PART_KEY_VAL NVARCHAR(255) NULL; +GO \ No newline at end of file Modified: hive/branches/branch-0.14/metastore/scripts/upgrade/mssql/hive-schema-0.14.0.mssql.sql URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/metastore/scripts/upgrade/mssql/hive-schema-0.14.0.mssql.sql?rev=1635653&r1=1635652&r2=1635653&view=diff ============================================================================== --- hive/branches/branch-0.14/metastore/scripts/upgrade/mssql/hive-schema-0.14.0.mssql.sql (original) +++ hive/branches/branch-0.14/metastore/scripts/upgrade/mssql/hive-schema-0.14.0.mssql.sql Fri Oct 31 01:39:54 2014 @@ -140,7 +140,7 @@ CREATE TABLE PARTITIONS PART_ID bigint NOT NULL, CREATE_TIME int NOT NULL, LAST_ACCESS_TIME int NOT NULL, - PART_NAME varchar(767) NULL, + PART_NAME nvarchar(767) NULL, SD_ID bigint NULL, TBL_ID bigint NULL ); @@ -371,7 +371,7 @@ CREATE TABLE SDS INPUT_FORMAT varchar(4000) NULL, IS_COMPRESSED bit NOT NULL, IS_STOREDASSUBDIRECTORIES bit NOT NULL, - LOCATION varchar(4000) NULL, + LOCATION nvarchar(4000) NULL, NUM_BUCKETS int NOT NULL, OUTPUT_FORMAT varchar(4000) NULL, SERDE_ID bigint NULL @@ -437,7 +437,7 @@ ALTER TABLE SKEWED_STRING_LIST_VALUES AD CREATE TABLE PARTITION_KEY_VALS ( PART_ID bigint NOT NULL, - PART_KEY_VAL varchar(255) NULL, + PART_KEY_VAL nvarchar(255) NULL, INTEGER_IDX int NOT NULL ); Modified: hive/branches/branch-0.14/metastore/scripts/upgrade/mssql/upgrade-0.13.0-to-0.14.0.mssql.sql URL: http://svn.apache.org/viewvc/hive/branches/branch-0.14/metastore/scripts/upgrade/mssql/upgrade-0.13.0-to-0.14.0.mssql.sql?rev=1635653&r1=1635652&r2=1635653&view=diff ============================================================================== --- hive/branches/branch-0.14/metastore/scripts/upgrade/mssql/upgrade-0.13.0-to-0.14.0.mssql.sql (original) +++ hive/branches/branch-0.14/metastore/scripts/upgrade/mssql/upgrade-0.13.0-to-0.14.0.mssql.sql Fri Oct 31 01:39:54 2014 @@ -2,6 +2,7 @@ SELECT 'Upgrading MetaStore schema from :r 002-HIVE-7784.mssql.sql; :r 003-HIVE-8239.mssql.sql; +:r 004-HIVE-8550.mssql.sql; UPDATE VERSION SET SCHEMA_VERSION='0.14.0', VERSION_COMMENT='Hive release version 0.14.0' where VER_ID=1; SELECT 'Finished upgrading MetaStore schema from 0.13.0 to 0.14.0' AS MESSAGE;