hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jun Yin (JIRA)" <>
Subject [jira] [Created] (HIVE-11721) noascii characters shows improper
Date Wed, 02 Sep 2015 20:38:45 GMT
Jun Yin created HIVE-11721:

             Summary: noascii characters shows improper
                 Key: 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çu 谢谢 Kôkaku ありがとうございますkidôtai한국어"
as char(255));
hive> select * from char_255_noascii;
Garçu 谢谢 Kôkaku ありがとうございますkidôtai>한국어

it shows correct, and also it works good with "LOAD DATA" 
but when I try another way to insert data as bellow:

hive> create table nonascii(t1 char(255));
Time taken: 0.125 seconds
hive> insert into nonascii values("Garçu 谢谢 Kôkaku ありがとうございますkidôtai한국어");
hive> select * from nonascii;
Gar�u "" K�kaku B�LhFTVD~Ykid�tai\m� 

This message was sent by Atlassian JIRA

View raw message