[HIVE-8550] Hive cannot load data into partitioned table with Unicode key

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 0.14.0
• Fix Version/s: 0.14.0
• Labels: TODOC14

Environment

Windows

• Assignee: Xiaobing Zhou
• Reporter: Xiaobing Zhou
• Created: 21/Oct/14 23:26
• Updated: 12/Jan/15 17:52
• Resolved: 31/Oct/14 01:40

Description

Steps to reproduce:

1) Copy the file partitioned.txt to the root folder of your HDFS root dir. Copy the two hql files to your local directory.

2) Open Hive CLI.

3) Run:

hive> source <path to CreatePartitionedTable.hql>;

4) Run

hive> source <path to LoadIntoPartitionedTable.hql>;

The following error will be shown:

hive> source C:\Scripts\partition\LoadIntoPartitionedTable.hql;
Loading data to table default.mypartitioned partition (tag=䶵)
Failed with exception null
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.MoveTask

Issue Links

• is duplicated by: HIVE-7875 Hive cannot load data into partitioned table with Unicode key
• is related to: HIVE-9208 MetaStore DB schema inconsistent for MS SQL Server in use of varchar/nvarchar
• links to: REVIEW BOARD