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

non-ascii characters shows improper with "insert into"

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.1.0, 1.2.1, 2.0.0
    • Fix Version/s: 2.0.0
    • Component/s: Database/Schema
    • Labels:
      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-branch-1.patch
          4 kB
          Aleksei Statkevich
        2. HIVE-11721.patch
          4 kB
          Aleksei Statkevich
        3. HIVE-11721.1.patch
          4 kB
          Aleksei Statkevich

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: