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
--- 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
Re: 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/ --- (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