Return-Path: 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 653941869F for ; Wed, 2 Sep 2015 20:38:49 +0000 (UTC) Received: (qmail 47925 invoked by uid 500); 2 Sep 2015 20:38:46 -0000 Delivered-To: apmail-hive-dev-archive@hive.apache.org Received: (qmail 47834 invoked by uid 500); 2 Sep 2015 20:38:46 -0000 Mailing-List: contact dev-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list dev@hive.apache.org Received: (qmail 47819 invoked by uid 99); 2 Sep 2015 20:38:45 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 02 Sep 2015 20:38:45 +0000 Date: Wed, 2 Sep 2015 20:38:45 +0000 (UTC) From: "Jun Yin (JIRA)" To: dev@hive.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (HIVE-11721) noascii characters shows improper MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 Jun Yin created HIVE-11721: ------------------------------ Summary: noascii characters shows improper Key: HIVE-11721 URL: https://issues.apache.org/jira/browse/HIVE-11721 Project: Hive Issue Type: Bug Components: Database/Schema Affects Versions: 1.1.0 Reporter: Jun Yin Hive: 1.1.0 hive> create table char_255_noascii as select cast("Gar=C3=A7u =E8=B0=A2=E8= =B0=A2 K=C3=B4kaku =E3=81=82=E3=82=8A=E3=81=8C=E3=81=A8=E3=81=86=E3=81=94= =E3=81=96=E3=81=84=E3=81=BE=E3=81=99kid=C3=B4tai=ED=95=9C=EA=B5=AD=EC=96=B4= " as char(255)); hive> select * from char_255_noascii; OK Gar=C3=A7u =E8=B0=A2=E8=B0=A2 K=C3=B4kaku =E3=81=82=E3=82=8A=E3=81=8C=E3=81= =A8=E3=81=86=E3=81=94=E3=81=96=E3=81=84=E3=81=BE=E3=81=99kid=C3=B4tai>=ED= =95=9C=EA=B5=AD=EC=96=B4 it shows correct, and also it works good with "LOAD DATA"=20 but when I try another way to insert data as bellow: hive> create table nonascii(t1 char(255)); OK Time taken: 0.125 seconds hive> insert into nonascii values("Gar=C3=A7u =E8=B0=A2=E8=B0=A2 K=C3=B4kak= u =E3=81=82=E3=82=8A=E3=81=8C=E3=81=A8=E3=81=86=E3=81=94=E3=81=96=E3=81=84= =E3=81=BE=E3=81=99kid=C3=B4tai=ED=95=9C=EA=B5=AD=EC=96=B4"); hive> select * from nonascii; OK Gar=EF=BF=BDu "" K=EF=BF=BDkaku B=EF=BF=BDLhFTVD~Ykid=EF=BF=BDtai\m=EF=BF= =BD=20 -- This message was sent by Atlassian JIRA (v6.3.4#6332)