[ https://issues.apache.org/jira/browse/HIVE-8550?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14179350#comment-14179350 ]
Xiaobing Zhou commented on HIVE-8550: ------------------------------------- If MSSQL is metastore and unicode chars support is expected, for a fresh installation or legacy system that doesn't involve multi-bytes support, varchar-to-nvarchar upgrade works fine, however, the upgrade seems impossible for on-going Hive system, because MSSQL doesn't allow schema change on varchar typed primary key or index, which is typical Hive use case. Any thoughts on how to do this upgrade? Thanks! > Hive cannot load data into partitioned table with Unicode key > ------------------------------------------------------------- > > Key: HIVE-8550 > URL: https://issues.apache.org/jira/browse/HIVE-8550 > Project: Hive > Issue Type: Bug > Environment: Windows > Reporter: Xiaobing Zhou > Priority: Critical > Attachments: CreatePartitionedTable.hql, > LoadIntoPartitionedTable.hql, partitioned.txt > > > 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 -- This message was sent by Atlassian JIRA (v6.3.4#6332)