You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by XIAOBING ZHOU <xz...@gmail.com> on 2014/10/28 23:16:10 UTC
Review Request 27313: Hive cannot load data into partitioned table
with Unicode key
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/27313/
-----------------------------------------------------------
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/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
-------
1. stop all services
2. drop HIVE DB
2. enable datanucleus.autoCreateSchema
3. start all services
4. run 004-HIVE-8550.mssql.sql
It fixed the issue.
Thanks,
XIAOBING ZHOU
Re: Review Request 27313: Hive cannot load data into partitioned
table with Unicode key
Posted by XIAOBING ZHOU <xz...@gmail.com>.
-----------------------------------------------------------
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
Re: Review Request 27313: Hive cannot load data into partitioned
table with Unicode key
Posted by XIAOBING ZHOU <xz...@gmail.com>.
-----------------------------------------------------------
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
Re: Review Request 27313: Hive cannot load data into partitioned
table with Unicode key
Posted by XIAOBING ZHOU <xz...@gmail.com>.
-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/27313/
-----------------------------------------------------------
(Updated Oct. 28, 2014, 10:27 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 (updated)
-----
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
-------
1. stop all services
2. drop HIVE DB
2. enable datanucleus.autoCreateSchema
3. start all services
4. run 004-HIVE-8550.mssql.sql
It fixed the issue.
Thanks,
XIAOBING ZHOU