hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject Re: Review Request 27313: Hive cannot load data into partitioned table with Unicode key
Date Tue, 28 Oct 2014 23:25:30 GMT

This is an automatically generated e-mail. To reply, visit:

(Updated Oct. 28, 2014, 11:25 p.m.)

Review request for hive.

Repository: hive-git


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


  metastore/scripts/upgrade/mssql/004-HIVE-8550.mssql.sql PRE-CREATION 
  metastore/scripts/upgrade/mssql/hive-schema-0.14.0.mssql.sql 174ed39 
  metastore/scripts/upgrade/mssql/upgrade-0.13.0-to-0.14.0.mssql.sql 1bda6d5 
  metastore/src/model/package.jdo f8936dc 


Testing (updated)

Legacy system upgrading:
1. stop all services
2. drop HIVE DB
3. manually create HIVE DB
4. enable datanucleus.autoCreateSchema
5. start all services
6. all tables are created by autoCreateSchema
7. run 004-HIVE-8550.mssql.sql to do upgrade

Fresh install:
1. stop all services
2. drop HIVE DB
3. manually create HIVE DB
4. run hive-schema-0.14.0.mssql.sql to create all tables
5. disable datanucleus.autoCreateSchema
6. start all services

It fixed the issue.



  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message