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

Unicode insert issue

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.2.0
    • Fix Version/s: None
    • Component/s: HiveServer2
    • Labels:
      None
    • Environment:

      failed in beeline and in odbc

      Description

      Unicode characters in UTF-8 on wire: ¿=C2 BF «=C2 AB é=C3 A9
      Characters inserted using INSERT SELECT format stores the values correctly
      Characters inserted using INSERT VALUES format stores the values incorrectly. Below was what I did in beeline:

      DROP TABLE testch3;
      CREATE TABLE testch3(col0 int, col1 CHAR(10), col2 VARCHAR(10), col3 string);
      Insert into table testch3 select 1,'¿','«','é' from (select count from testch3) qaz;
      Insert into table testch3 values (2,'¿','«','é');
      select * from testch3;

      ------------------------------------------------------+

      testch3.col0 testch3.col1 testch3.col2 testch3.col3

      ------------------------------------------------------+

      1 ¿ « é
      2 � � �

      ------------------------------------------------------+
      2 rows selected (0.251 seconds)

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              eugenel eugene liu
            • Votes:
              2 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: