Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-11721

non-ascii characters shows improper with "insert into"

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.1.0, 1.2.1, 2.0.0
    • 2.0.0
    • Database/Schema
    • None

    Description

      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;
      OK
      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 below:

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

      Attachments

        1. HIVE-11721.1.patch
          4 kB
          Aleksei Statkevich
        2. HIVE-11721.patch
          4 kB
          Aleksei Statkevich
        3. HIVE-11721-branch-1.patch
          4 kB
          Aleksei Statkevich

        Activity

          People

            Aleksei Aleksei Statkevich
            Jun_Yin Jun Yin
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: