hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "XIAOBING ZHOU" <xzho...@gmail.com>
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:
https://reviews.apache.org/r/27313/
-----------------------------------------------------------

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


Review request for hive.


Repository: hive-git


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


Diffs
-----

  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 

Diff: https://reviews.apache.org/r/27313/diff/


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.


Thanks,

XIAOBING ZHOU


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