hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jason Dere (JIRA)" <>
Subject [jira] [Commented] (HIVE-8550) Hive cannot load data into partitioned table with Unicode key
Date Tue, 28 Oct 2014 23:54:34 GMT


Jason Dere commented on HIVE-8550:

- So you change the type of PART_NAME in package.jdo to be of type NVARCHAR. A potential issue
here is, package.jdo is used for the schema and object-relational mapping for all databases,
but it looks like the point of this issue is to change the column for SQLServer. What is the
effect on the other DBMSs when this field is set to NVARCHAR, but the column in the table
is still set as VARCHAR? Is there a way to specify that it only should be NVARCHAR in the
case of SQLServer?
- Can you also update metastore/scripts/upgrade/mssql/hive-schema-0.15.0.mssql.sql with the
same changes?
- metastore/scripts/upgrade/mssql/004-HIVE-8550.mssql.sql: What is the line with "GO"? Sorry
I don't really know sql server.
- metastore/src/model/package.jdo: Is the nesting of the first <column> element in the
diff correct?

> Hive cannot load data into partitioned table with Unicode key
> -------------------------------------------------------------
>                 Key: HIVE-8550
>                 URL:
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 0.14.0
>         Environment: Windows
>            Reporter: Xiaobing Zhou
>            Assignee: Xiaobing Zhou
>            Priority: Critical
>         Attachments: CreatePartitionedTable.hql, HIVE-8550.1.patch, HIVE-8550.2.patch,
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

View raw message