Return-Path: 
 <dev-return-110865-apmail-hive-dev-archive=hive.apache.org@hive.apache.org>
X-Original-To: apmail-hive-dev-archive@www.apache.org
Delivered-To: apmail-hive-dev-archive@www.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id CC84217EFC
	for <apmail-hive-dev-archive@www.apache.org>;
 Tue, 28 Oct 2014 23:25:26 +0000 (UTC)
Received: (qmail 85858 invoked by uid 500); 28 Oct 2014 23:25:26 -0000
Delivered-To: apmail-hive-dev-archive@hive.apache.org
Received: (qmail 85788 invoked by uid 500); 28 Oct 2014 23:25:26 -0000
Mailing-List: contact dev-help@hive.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@hive.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@hive.apache.org>
List-Post: <mailto:dev@hive.apache.org>
List-Id: <dev.hive.apache.org>
Reply-To: dev@hive.apache.org
Delivered-To: mailing list dev@hive.apache.org
Received: (qmail 85775 invoked by uid 99); 28 Oct 2014 23:25:25 -0000
Received: from reviews-vm.apache.org (HELO reviews.apache.org) (140.211.11.40)
    by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 28 Oct 2014 23:25:25 +0000
Received: from reviews.apache.org (localhost [127.0.0.1])
	by reviews.apache.org (Postfix) with ESMTP id 5D5D81DF874;
	Tue, 28 Oct 2014 23:25:30 +0000 (UTC)
Content-Type: multipart/alternative;
 boundary="===============0313967219588392822=="
MIME-Version: 1.0
Subject: Re: Review Request 27313: Hive cannot load data into partitioned
 table with Unicode key
From: "XIAOBING ZHOU" <xzhou40@gmail.com>
To: "XIAOBING ZHOU" <xzhou40@gmail.com>, "hive" <dev@hive.apache.org>
Date: Tue, 28 Oct 2014 23:25:30 -0000
Message-ID: <20141028232530.7137.75220@reviews.apache.org>
X-ReviewBoard-URL: https://reviews.apache.org
Auto-Submitted: auto-generated
Sender: "XIAOBING ZHOU" <noreply@reviews.apache.org>
X-ReviewGroup: hive
X-ReviewRequest-URL: https://reviews.apache.org/r/27313/
X-Sender: "XIAOBING ZHOU" <noreply@reviews.apache.org>
References: <20141028232511.7143.98455@reviews.apache.org>
In-Reply-To: <20141028232511.7143.98455@reviews.apache.org>
Reply-To: "XIAOBING ZHOU" <xzhou40@gmail.com>
X-ReviewRequest-Repository: hive-git

--===============0313967219588392822==
MIME-Version: 1.0
Content-Type: text/plain; charset="utf-8"
Content-Transfer-Encoding: 8bit


-----------------------------------------------------------
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


--===============0313967219588392822==--